report
Generate profit and loss, balance sheet, and cash flow statements from reconciled data
SKILL.mdplugins/bookkeeping/skills/report/SKILL.md
GitHubReport
Generate financial statements for "$ARGUMENTS" from reconciled data. Produce a profit and loss statement, balance sheet, and cash flow statement with trend analysis.
Arguments. $ARGUMENTS may contain the project name and optional flags. Take the first token as <project> and treat --skip-checks as a flag; never include flags in file paths. All paths below use <project>. If --skip-checks is present, skip the prerequisite check and, before writing any artifact, append one line to .metapowers/bookkeeping/<project>/skip-log.md: - <ISO timestamp> — <skill name> skipped prerequisite check for <artifact file> — reason: <reason or "none given">.
Compute with code. Perform every calculation (totals, balances, ratios, variances, projections) with a script — Bash, Python or a spreadsheet formula written to a file — and include the computation alongside the result. Never do arithmetic mentally.
Prerequisites
Read .metapowers/bookkeeping/<project>/03-reconcile.md for reconciled balances and adjusting entries.
Process
Prepare trial balance:
- List all accounts with their reconciled balances
- Verify total debits equal total credits
- Apply any period-end adjustments (accruals, deferrals, depreciation)
Generate Profit & Loss (Income Statement):
- Revenue accounts (4000-series)
- Less: Cost of Goods Sold (5000-series)
- Equals: Gross Profit
- Less: Operating Expenses (6000-series)
- Equals: Operating Income
- Plus/Minus: Other Income/Expenses (7000-series)
- Equals: Net Income
Generate Balance Sheet:
- Assets (1000-series) — current and fixed
- Liabilities (2000-series) — current and long-term
- Equity (3000-series) — including net income from P&L
- Verify: Assets = Liabilities + Equity
Generate Cash Flow Statement:
- Operating Activities — cash from core business
- Investing Activities — asset purchases and sales
- Financing Activities — loans, equity, dividends
- Net change in cash for the period
Analyze and highlight:
- Key ratios (gross margin, net margin, current ratio, quick ratio)
- Period-over-period trends if prior data exists
- Anomalies or areas of concern
- Cash runway estimate
Write the artifact to
.metapowers/bookkeeping/<project>/04-report.mdwith sections:- Trial Balance — all accounts with balances
- Profit & Loss — full income statement
- Balance Sheet — full statement of financial position
- Cash Flow Statement — cash movements by category
- Key Ratios — financial health indicators
- Commentary — narrative on trends and concerns
Output
The financial report written to .metapowers/bookkeeping/<project>/04-report.md. Present a summary highlighting:
- Net income/loss for the period
- Total assets and liabilities
- Cash position and runway
- Key ratios and any concerns
End the artifact with this paragraph, verbatim:
Not financial or tax advice. This artifact is generated analysis for review by a qualified accountant or financial professional before any filing, reporting or decision relies on it.