Start with your own figures.
The Excel workbook includes editable amount cells, formula-driven subtotals and ratios, field explanations and source links. All monetary inputs start at zero. Undefined ratios are shown as “Not defined.”
Blank Excel workbookBlank CSV worksheetWork through an example.
A fictional trading business has $123,000 in assets, $70,000 in liabilities and $53,000 in entered equity. See where each amount comes from, then replace the highlighted input cells with consistent records.
Worked Excel exampleWorked example CSVUse the templates in three steps.
- Choose one date and currency. Keep your supporting records together. The workbook does not connect to an account, fetch balances or convert currencies.
- Enter amounts in the butter-coloured input cells. Enter deductions as positive amounts. Retained earnings and accumulated other comprehensive income may be negative. Do not count an item twice.
- Review the equation and every ratio. A difference stays visible. No retained-earnings amount is inserted to make it balance. Check the field notes and classification with your accountant before relying on the result.
Using Google Sheets?
Download the Excel workbook, then use Google Sheets’ File → Import → Upload flow to import your chosen file. This site does not create a Google Drive copy or grant access to your files. Review the imported formulas and formatting before relying on them. Importing a CSV gives you a flat export, not the workbook’s live formulas.
The downloads use standard SUM, IF and ROUND formulas. After importing, try a small amount change that you can independently check. The file has no macros, external data connections or account integration.
What this template does, and where it stops.
The workbook is an educational arithmetic worksheet. Recognition, classification, measurement, disclosure notes, tax return mapping, lender requirements and ASPE or IFRS compliance need separate review. It is not an audit, a valuation, a filed return or a lending decision.
Methodology and sources · Understand the ASPE boundary · Compare two chosen snapshots
