Excel workbooks you can open and use
Every report on this site has its Excel workbook free to download, without registration, in Thai and in English, each with a SHA-256 value to check your copy against the original.
Core reports 01–07
-
Download 01 Executive Review
The one page that puts sales, profit and cash side by side, so a meeting can start from a shared picture before anyone opens a detailed report.
Details and download → -
Download 02 P&L Budget vs Actual
The workbook that answers why profit differs from plan, split line by line into sales, cost and expense.
Details and download → -
Download 03 Sales & Gross Margin
The best-selling product is not always the one that earns the most gross profit. Compare revenue, gross profit and margin by product, then split the revenue variance into price and volume.
Details and download → -
Download 04 OPEX & Workforce
When spending rises, separate headcount, pay per person and activity. Department costs sit next to FTE in one file.
Details and download → -
Download 05 Forecast & Outlook
When the sales plan changes, profit, cash and inventory move by different amounts. Switch between Base, Upside and Downside and read all three together.
Details and download → -
Download 06 Cash, Balance Sheet & Inventory
The company made a profit, yet closing cash rose by less. Walk from net profit through receivables, inventory and payables to closing cash.
Details and download → -
Download 07 CAPEX & Depreciation
Cash for an asset leaves in one month; its depreciation reaches profit over the useful life. The asset register shows both timings against the capital budget.
Details and download →
Advanced reports 08–10
-
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.
Details and download → -
Download 09 Rolling 12-month forecast
Close a new month, change one cell, and the forecast window and opening balances move with it.
Details and download → -
Download 10 Department budgets & consolidation
Each department enters its own budget; the file rolls them into a group P&L and removes internal transactions, each one traceable.
Details and download →
Which file to open first
If your monthly job is a summary for management, start with the Executive Review. To explain why profit differs from plan, follow with P&L Budget vs Actual.
Each variance then has its own file: product sales and margin in Sales & Gross Margin, spending and FTE in OPEX & Workforce, receivables, stock and cash in Cash, Balance Sheet & Inventory, and capital spending in CAPEX & Depreciation.
To plan ahead, Forecast & Outlook runs to year end with three cases, while the rolling 12-month forecast moves its window with each closed month.
If your source is only a trial balance, start with TB-mapped statements. To combine several departments or companies, use Department budgets & consolidation.
Files 01–07 share one synthetic dataset, so you can open them side by side and go from the overview to the detail. Files 08–10 use a different dataset, so the two groups' figures cannot be compared.
What opens them
They are plain .xlsx files with no macros and no links to other files. Every formula has been recalculated in Microsoft Excel desktop and in LibreOffice against reference values. If you are unsure where a cell comes from, the report guides explain each one.
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.
