AGENT SKILL

statement-preparation

When the user wants to generate a set of financial statements (Balance Sheet, Income Statement, Cash Flow) from a trial balance. Also use when the user mentions "closing the books," "preparing financials," "producing P&L," "generating balance sheet," or "year-end reporting."

License 许可
MIT
最近更新
2026-11-01
Stars
★ 47
Forks
14

01 前言 Front Matter

name
statement-preparation
metadata
{ "version": "1.0.0" }
description
When the user wants to generate a set of financial statements (Balance Sheet, Income Statement, Cash Flow) from a trial balance. Also use when the user mentions "closing the books," "preparing financials," "producing P&L," "generating balance sheet," or "year-end reporting."

02 资源文件 6

03 SKILL.md 正文

Financial Statement Preparation

You are a Controller. Your goal is to transform a raw Trial Balance into an accurate, compliant set of financial statements.

Initial Assessment

  1. Source Data

    • Do we have the full Trial Balance?
    • Is it balanced (Debits = Credits)?
  2. Reporting Framework

    • IFRS, GAAP, or Tax-basis?
    • What is the reporting period?
  3. Adjustments

    • Have all month-end accruals and deferrals been recorded?
    • Any recent asset disposals or acquisitions?

Preparation Framework

Priority Order

  1. Trial Balance Validation (Checking for balance and classification errors).
  2. Adjusting Journal Entries (Recording depreciation, accruals, prepayments).
  3. Income Statement Generation (Calculating Net Income).
  4. Balance Sheet Generation (Ensuring Assets = Liabilities + Equity).
  5. Cash Flow Statement (Using the indirect method to reconcile cash).

Technical Preparation Steps

1. Mapping the Chart of Accounts

  • Map every account from the Trial Balance to the correct financial statement line item.

2. The Indirect Cash Flow Method

  • Start with Net Income.
  • Add back non-cash expenses (Depreciation/Amortization).
  • Adjust for changes in working capital (Inventory, AR, AP).

3. Equity Reconciliation

  • Ensure that Net Income flows into Retained Earnings on the Balance Sheet.

Output Format

Financial Statement Package

1. Income Statement

  • Revenue, COGS, Expenses, and Net Income for the period.

2. Balance Sheet

  • Snapshot of Assets, Liabilities, and Equity.

3. Statement of Cash Flows

  • Operating, Investing, and Financing activities.

4. Notes to the Statements (Brief)

  • Explanation of major line item variances or unusual items.

Scripts

  • calculate.py: Deterministic functions for this skill's core computations. Run python3 scripts/calculate.py to self-test; import the functions instead of doing mental math.

References


Related Skills

  • financial-analysis: To analyze the statements once they are prepared.
  • audit-checklist: To ensure the preparation process follows internal controls.
  • automated-reconciliation: To ensure the cash balance on the BS matches the bank.

04 同仓库更多 Skills

GAJETOso
GAJETOso/financeskills

working-capital-analysis

When the user wants to analyze or optimize working capital — receivables, payables, inventory, and the cash conversion cycle. Also use when the user mentions "DSO," "DPO," "DIO," "cash conversion cycle," "cash tied up," "AR aging," "payment terms," "working capital peg," or "free up cash."

★ 47
GAJETOso
GAJETOso/financeskills

wacc-computation

When the user wants to calculate the Weighted Average Cost of Capital (WACC) for valuation or capital budgeting. Also use when the user mentions "cost of equity," "cost of debt," "CAPM," "beta unlevering," "risk-free rate," or "equity risk premium."

★ 47
GAJETOso
GAJETOso/financeskills

venture-debt

When the user wants to evaluate or structure debt for high-growth, venture-backed startups. Also use when the user mentions "startup loan," "warrants," "venture lending," "debt covenants for tech," "non-dilutive funding," or "growth capital debt."

★ 47
GAJETOso
GAJETOso/financeskills

variance-analysis

When the user wants to analyze the difference between actual and standard costs in manufacturing. Also use when the user mentions "material price variance," "labor efficiency," "overhead variance," "standard costing," or "production audit."

★ 47
GAJETOso
GAJETOso/financeskills

treasury-management

When the user wants to manage corporate liquidity, investments, or financial risks like FX and interest rates. Also use when the user mentions "cash positioning," "foreign exchange risk," "interest rate hedging," "corporate investment policy," "liquidity planning," or "managing bank relationships."

★ 47
GAJETOso
GAJETOso/financeskills

three-statement-modeling

When the user wants to build an integrated financial model linking income statement, balance sheet, and cash flow. Also use when the user mentions "3-statement model," "integrated model," "balance sheet doesn't balance," "circular reference," "revolver plug," "model drivers," or "financial projections."

★ 47