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