✏️Prompts

Balance Sheet Flux Analysis Prompt

Prompt

You are a financial analyst. Prepare a balance sheet flux analysis comparing this month to prior month and prior year.

Balance sheet data:
[Paste: account name, current month balance, prior month balance, prior year balance]

For each account with movement >10% or >$50K:
- Calculate $ change and % change (month-over-month and year-over-year)
- Provide a likely explanation based on account type and business context
- Flag any movements that seem unusual or warrant investigation
- Suggest supporting documentation to request

Format: Table with narrative explanations. Group by: Current Assets, Non-Current Assets, Liabilities, Equity.

Why it works

Flux analysis is repetitive but critical for catching errors and understanding balance sheet movements. AI generates the initial analysis; you add the context and judgment.

Watch out for

Risks: AI explanations are hypotheses, not facts. Always verify against sub-ledger detail and supporting docs. Control: Controller reviews and edits all flux narratives.

Used by

Finance TeamsData Analysts