Reading guides for the advanced reports
The advanced set builds on the core one. Each guide shows the real workbook, figures read from the Summary sheet, a reading order, the core formulas, the points most often misread, and a worked case.
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.
-
08 / TB-mapped linked statements
With only a trial balance, how do you produce monthly statements that reconcile?
Open the guide → -
09 / Rolling 12-month forecast
Once a new month is closed, what do the next twelve months look like?
Open the guide → -
10 / Department budgets and group consolidation
Once every department submits its budget, what is the group result after internal transactions are removed?
Open the guide →
Which advanced report fits which job
TB-mapped linked statements is for a company that only has a trial balance out of its accounting system and needs a monthly P&L, balance sheet and cash flow that reconcile. Accounts are mapped once on the Mapping sheet; each new month is a fresh trial balance pasted in and recalculated.
Rolling 12-month forecast is for when the annual budget has gone stale and management wants profit and cash for the twelve months after the last close. How it differs from a budget is covered in the rolling forecast article.
Department budgets and group consolidation is for departments that each submit their own budget, in a group with more than one company providing services to the others. Those internal charges come out before the group result means anything.
Before opening the advanced set
The advanced reports assume you already read a P&L and a balance sheet. If not, the core report guides are the place to start; variances and working capital work the same way in both sets.
Every report's Excel workbook is free to download, in Thai and English.