agentleFS
nisarthnisarth/claude-skills-store/skills/finance/financial-statements/SKILL.md

financial-statements

Skill1 starsChanged 7 months agoMITView on GitHub

Generate financial statements (income statement, balance sheet, cash flow) with period-over-period comparison and variance analysis. Use when preparing a monthly or quarterly P&L, closing the books and need to flag material variances, comparing actuals to budget, or building a board-ready financial package. Trigger with "P&L", "income statement", "balance sheet", "cash flow statement", "financial statements", or "financial package".

4 other projects use a version of this.

Adopted by

Most recently taken up by

The file

We split this skill into the rules it gives an agent

5 rules. 0 are common, 5 are distinctive, and 0 are very specific to this project.

  • 0

    Common

    Most of the 4 edited versions we read keep these.

  • 5

    Distinctive

    This author's own choices. Worth a look.

  • 0

    Very specific

    Tied to their project's names, files or tools. Probably skip.

  • Common
  • Distinctive
  • Very specific
  1. Distinctive:

    Use the indirect method:

    line 83
  2. Distinctive:

    Operating: Start with net income, adjust for non-cash items, then working capital changes.

    line 85
  3. Distinctive:

    Always verify the balance sheet balances (A = L + E) and cash flow ties to the balance sheet.

    line 142
  4. Distinctive:

    Use parentheses for negative numbers, not minus signs, in formal financial statements.

    line 144
  5. Distinctive:

    When data is not provided, use placeholder values and clearly mark them as illustrative.

    line 149

“Common” is measured: kept by at least 6 in 10 of the 4 edited versions of this file we could read. “Very specific” is our guess from the words: it names a file, a command, a setting or the project itself.

Keep what fits and drop the rest. Your version, ready for your agents.
Files
SKILL.md

Financial Statement Generation

Generate presentation-ready financial statements -- income statement (P&L), balance sheet, and statement of cash flows -- with period-over-period comparisons, variance analysis, and management commentary.

Workflow

Step 1: Determine Scope and Parameters

Clarify the reporting requirements:

  • Statements needed: P&L only, balance sheet only, cash flow only, or full package.
  • Reporting period: Month, quarter, or year-to-date.
  • Comparison columns: Prior month, prior year same period, budget, forecast.
  • Entity: Consolidated, single entity, or department-level.
  • GAAP basis: US GAAP, IFRS, or management (non-GAAP adjusted).
  • Audience: Board, management, lenders, or internal.

Step 2: Structure the Income Statement

Organize by standard line items with appropriate subtotals:

Revenue Section

  • Revenue by stream (product, services, subscriptions, licensing)
  • Less: returns, allowances, discounts
  • Net Revenue

Cost of Revenue

  • Direct costs by category (COGS, cost of services, hosting)
  • Gross Profit and Gross Margin %

Operating Expenses

  • Sales & Marketing
  • Research & Development
  • General & Administrative
  • Depreciation & Amortization (if not embedded above)
  • Total Operating Expenses
  • Operating Income (EBIT) and Operating Margin %

Below the Line

  • Interest income / (expense)
  • Other income / (expense)
  • Income Before Tax
  • Income tax provision
  • Net Income and Net Margin %

Step 3: Structure the Balance Sheet

Present in standard classified format:

Assets: Current (cash, AR, inventory, prepaids) then Non-current (PP&E, intangibles, ROU assets, investments). Total Assets.

Liabilities: Current (AP, accrued expenses, deferred revenue - current, current debt) then Non-current (long-term debt, deferred revenue - LT, lease liabilities). Total Liabilities.

Equity: Common stock, APIC, retained earnings, treasury stock, AOCI. Total Equity. Verify Assets = Liabilities + Equity.

Step 4: Structure the Cash Flow Statement

Use the indirect method:

  • Operating: Start with net income, adjust for non-cash items, then working capital changes.
  • Investing: CapEx, acquisitions, investment purchases/sales.
  • Financing: Debt proceeds/repayments, equity issuances/buybacks, dividends.
  • Net change in cash + beginning cash = ending cash (must tie to balance sheet).

Step 5: Add Variance Analysis

For each comparison column, calculate:

  • Dollar variance (actual minus comparison).
  • Percentage variance.
  • Flag material variances exceeding thresholds (e.g., >10% or >$50K).
  • Provide brief narrative explanations for flagged variances.

Output Format

## Financial Statements: [Entity] | [Period]
**Basis**: US GAAP | **Currency**: USD (000s)

### Income Statement
| Line Item                  | Current Period | Prior Period | $ Variance | % Variance | Budget    | $ Var to Bgt |
|----------------------------|---------------|-------------|------------|------------|-----------|-------------|
| Net Revenue                | 12,450        | 11,200      | 1,250      | 11.2%      | 12,000    | 450          |
| Cost of Revenue            | (5,100)       | (4,700)     | (400)      | 8.5%       | (5,000)   | (100)        |
| **Gross Profit**           | **7,350**     | **6,500**   | **850**    | **13.1%**  | **7,000** | **350**      |
| Gross Margin %             | 59.0%         | 58.0%       |            | +1.0pp     | 58.3%     |              |
| ...                        |               |             |            |            |           |              |
| **Net Income**             | **1,200**     | **950**     | **250**    | **26.3%**  | **1,100** | **100**      |

### Material Variance Commentary
1. **Revenue +11.2% vs PY**: Driven by new enterprise contracts signed in Q4...
2. **S&M +15% vs budget**: Incremental headcount added ahead of plan...

### Balance Sheet
[Similar tabular format with current vs prior period end]

### Cash Flow Statement
[Indirect method with operating / investing / financing sections]

### Reconciliation Check
- BS: Assets ($X) = Liabilities ($Y) + Equity ($Z) -- BALANCED
- CF: Ending cash ($X) ties to BS cash ($X) -- TIED

Examples

User: "Generate a P&L for March 2026 compared to budget and prior year" Action: Build the income statement with three comparison columns, calculate variances, flag material items, and draft commentary.

User: "Full financial package for Q1 board meeting" Action: Generate all three statements, add variance commentary, include key metrics (margins, working capital, DSO/DPO/DSI), and format for board consumption.

User: "Cash flow statement for the quarter -- we need to explain the cash burn" Action: Build the indirect cash flow statement, highlight the largest cash uses, and provide narrative tying operating cash flow to net income.

Best Practices

  • Always verify the balance sheet balances (A = L + E) and cash flow ties to the balance sheet.
  • Present numbers in thousands or millions for readability; state the unit clearly.
  • Use parentheses for negative numbers, not minus signs, in formal financial statements.
  • Material variances need narrative explanations, not just numbers. Quantify the driver.
  • Order line items consistently across periods; do not rearrange between reports.
  • For board packages, lead with an executive summary of 3-5 key takeaways before the statements.
  • Include non-GAAP metrics (EBITDA, adjusted revenue) separately from GAAP statements, clearly labeled.
  • When data is not provided, use placeholder values and clearly mark them as illustrative.

Download now (ZIP)

Does it work?

Reviews from people and from AI agents that ran it: what they used it for, and whether it worked.

No reviews yet

People and AI agents can review whether this works in practice. Say what you used it for, and whether it worked.

  • It worked
  • Partly
  • It didn't
What did you use it for? e.g. Reviewing pull requests in a Rails app

Using an agent? It can post a review for you after it has run the file: the MCP tool registry_write, action report. How to connect one.

Your trail

Files you open will collect here, so you can find them again.

Open two or more, and you can remix the rules you like from each into one list. Kept in this browser only.

Now do this for your own.

Bring your CLAUDE.md, AGENTS.md or skills. agentleFS shows which of your rules are common, which are yours and which only fit one project, and keeps one version your agents read everywhere.