Agent Skills: Compte de résultat (P&L) from Well

Build a profit & loss statement (compte de résultat / income statement) from a Well workspace. Use when the user asks for a P&L, income statement, compte de résultat, revenue vs expenses, or net result over a period.

UncategorizedID: wellapp-ai/well/compte-de-resultat

Install this agent skill to your local

pnpm dlx add-skill https://github.com/WellApp-ai/Well/tree/HEAD/plugins/well/skills/compte-de-resultat

Skill Files

Browse the full folder contents for compte-de-resultat.

Download Skill

Loading file tree…

plugins/well/skills/compte-de-resultat/SKILL.md

Skill Metadata

Name
compte-de-resultat
Description
Build a profit & loss statement (compte de résultat / income statement) from a Well workspace. Use when the user asks for a P&L, income statement, compte de résultat, revenue vs expenses, or net result over a period.

Compte de résultat (P&L) from Well

A correct income statement comes from the posted accounting ledger, not from raw invoices. Well's sync/posting pipelines post invoices and bank transactions into journal_entries against ledger_accounts; that posted data already handles classification, accruals, and settlement that a raw-invoice sum misses.

Do this

  1. Discover the schema first (see well:querying-well-data):
    • well_get_schema("ledger_accounts") — the chart of accounts. Look for the account code/number and name/type fields; income-statement accounts are the revenue and expense classes (in a French plan comptable, classe 7 = produits, classe 6 = charges).
    • well_get_schema("journal_entries") and well_get_schema("journal_entry_lines") if present — the posted movements with debit/credit amounts and the date you'll filter the period on.
  2. Scope the period with a whereClause on the posting/entry date (e.g. _gte start, _lte end).
  3. Aggregate by account: sum the posted amounts per ledger account, then group revenue accounts and expense accounts.
  4. Net result = total produits (revenue) − total charges (expenses).

Do NOT

  • Do not reconstruct the P&L by summing issued invoices as revenue and received invoices as expenses. That misses postings, non-invoice entries, accruals, and account classification, and double-counts or omits settlement. Use the ledger.
  • Do not hardcode account codes you haven't confirmed from well_get_schema/the data — read the chart of accounts first.

If the ledger is empty

If journal_entries / ledger_accounts return no rows for the workspace, the books may not be posted yet. Say so explicitly, and only then offer an invoice-based approximation — clearly labelled as an estimate, not the compte de résultat — built from invoices (issued = revenue proxy, received = expense proxy) over the period.

Present it

Group the output as: Produits (revenue) lines → total; Charges (expense) lines → total; Résultat net. Note the currency and the period. Offer a month-by-month or category breakdown as a follow-up.