Download 08 TB-mapped statements
Your accounting system exports only a trial balance. Map each account to a statement line and get a monthly P&L, balance sheet and cash flow that reconcile.
What is inside the file
The sheet list below is read out of the actual workbook when this page is built, not typed. If the file changes, the list changes with it.
Where to look first
- Start on Mapping: account codes are unique, and every account has a report line, statement type and sign.
- Paste the trial balance as values into TB_Input, with every mapped account in every month, zero balances included.
- Register the months in Periods, then complete Cash_Supplement for every registered month.
- Recalculate, then read Checks first, followed by Statements and Summary.
Read the guide to this report first →
What you need before using it on your own company
- A monthly trial balance with account codes, debits and credits.
- The trial balance for the month before the period, as the opening balance.
- Cash detail a trial balance does not separate, such as cash paid for assets, debt drawn and repaid, equity raised and dividends.
The advanced reports use a new synthetic dataset. It is not a drop-in replacement for the original pack files, so the figures on this page cannot be compared with reports 01–07 even though the company name and currency are the same. This set also uses cash COGS with depreciation below EBITDA, a different cost definition from the core manufacturing model.
Check the file against the original
The SHA-256 values below come from the extension pack’s MANIFEST.json and are re-checked against the real files every time the site is built; a mismatch fails the build. To verify your copy yourself:
certutil -hashfile 08_TB_Mapped_Statements_TH.xlsx SHA256sha256sum 08_TB_Mapped_Statements_TH.xlsx| File | bytes | SHA-256 |
|---|---|---|
| 08_TB_Mapped_Statements_TH.xlsx | 201,642 | f99bb9c3302b4070f02eff243f2877b95bf9402fabe008514c2b6ec5009144a9 |
| 08_TB_Mapped_Statements_EN.xlsx | 199,419 | 9b119d76b05b156a1430e911a3531196754ec3f4c8dab2eb2ffebe4b2fcfcbc5 |
Use it in your work, change it, use it inside your company — no permission needed. The one ask is not to resell it as your own product. The figures are synthetic teaching data, not a real company’s results, and someone responsible for finance should review the formulas and costing policy before you run it on real numbers.
Download the workbook
What will you use this file for?
Optional. No personal details.
Thanks. This helps decide which files to build next.