TH
Home / Report guides
REPORT READING GUIDE

Reading guides for the FP&A reports

Each guide shows the real workbook, figures from the sample file, a reading order, the core formulas, the points most often misread, and what to check once you see them.

Statements from a trial balance, a rolling forecast and department budgets

The advanced set covers work the core set does not: mapping a trial balance onto a chart of accounts, rolling the forecast forward each time a month closes, and consolidating departmental budgets into a group result. It uses a different sample dataset from the core set, so the two are read separately.

See the advanced reports →

Start from the question you need to answer

For a monthly summary to management, start with the Executive Review. It puts revenue, profit and month-end cash against budget on one page, so the meeting can pick which issue to take first.

When profit is off plan, go to P&L Budget vs Actual to find the line where the gap sits. If it is in revenue or gross profit, continue to Sales & Gross Margin; if it is in spending, to OPEX & Workforce.

Cash questions take a different route. Cash, Balance Sheet & Inventory shows how much is tied up in receivables and stock, CAPEX & Depreciation shows when an asset purchase reaches cash and when it reaches profit, and Forecast & Outlook shows year-end cash when the plan changes.

One set of numbers across the reports

Reports 01–07 share one synthetic dataset, so a figure in one report can be traced into another. August revenue of THB 10.921m in the Executive Review is the same figure as in the P&L, and net profit of THB 1.648m is where the walk from profit to cash in report 06 begins.

If terms like YTD, EBITDA or DSO are unfamiliar, keep the glossary open alongside. Ideas that recur across reports, such as reading a budget variance or the cash conversion cycle, have their own articles.

Every report's Excel workbook is free to download, in Thai and English.

See all files →