Three-Statement Model Integrity Check
Verify linkage between income, balance sheet, and cash flow.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
Check the integrity of my three-statement financial model. Spreadsheet app: [SPREADSHEET_APP]. Model description and period: [MODEL_DESCRIPTION]. Key lines and formulas from the income statement, balance sheet, and cash flow statement: [PASTE_MODEL_EXTRACTS]. Go through the checklist and mark Pass, Fail, or Cannot tell with the cell reference and explanation: [ ] The balance sheet balances in every period (assets equal liabilities plus equity) [ ] Net income from the income statement flows into retained earnings [ ] Cash flow statement ending cash equals balance sheet cash [ ] Depreciation flows through the income statement, cash flow add-back, and reduces fixed assets [ ] Capital expenditure increases fixed assets and reduces cash [ ] Working capital changes (receivables, inventory, payables) are signed correctly in the cash flow statement [ ] Debt balances roll forward: opening plus borrowing minus repayment equals closing; interest links to the average or opening balance consistently [ ] Tax calculation handles losses sensibly [ ] No circular references, or they are deliberate and switchable [ ] Opening balances match the last actuals [ ] Sign conventions are consistent [ ] Assumptions are in one place and not hardcoded in formulas [ ] Dividends and equity changes are modeled For each failure, explain the likely cause and the formula fix. Add a set of five automated check rows to include in the model, with formulas.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.