01
Executive Review
A single overview page to open a meeting with
How did the business perform, and what needs attention first?
Open the guide →
Sample workbooks: free, no sign-up
FINANCIAL SUMMARY TEMPLATES FOR MANAGEMENT
Financial reporting templateswith Excel workbooks whose formulas and method you can audit at every step
The set runs from an executive summary and budget-versus-actual P&L through to a rolling forecast and departmental consolidation. Every formula is recalculated in LibreOffice and in Microsoft Excel and compared against independently derived values. The reading guides are free, and sample workbooks are available to inspect before you commit to anything.
Thai and English workbooks maintained as separate files · Example data for general business, trading and light manufacturing
Company Name Co., Ltd.
Aug 2026 · Synthetic data
FP&A / 01
Net revenue · THB millions
10.921
-4.51% vs budget
Actual
Budget
View chart data
| Month | Actual | Budget |
|---|---|---|
| Jan | 9.036 | 9.521 |
| Feb | 9.503 | 9.991 |
| Mar | 10.684 | 11.217 |
| Apr | 9.323 | 9.744 |
| May | 10.581 | 11.087 |
| Jun | 10.598 | 11.239 |
| Jul | 10.470 | 10.955 |
| Aug | 10.921 | 11.437 |
Gross margin34.22%
EBITDA · THB m2.174
Closing cash · THB m30.634
↳The next question: is the revenue gap driven by price, volume, or both?
1,152values where the browser tool was compared with Excel, none differing
2engines every formula is recalculated in: LibreOffice and Microsoft Excel
TH / ENEvery report in both languages, kept as separate files
12months in the rolling forecast horizon
A STARTING POINT FOR
THE REPORTS
The core set, and an advanced set for deeper work
Each guide shows the real workbook, figures read off the sheet, a reading order, the core formulas, and the points most often misread.
02
P&L · Budget vs Actual
Breaks the gap between actual and budget down by line, to locate where profit moved
Is the profit gap coming from sales, cost of goods, or operating expenses?
Open the guide →03
Sales & Gross Margin
The highest-selling product and the highest-margin product are rarely the same
Which products sell well, and which contribute the most gross profit?
Open the guide →04
OPEX & Workforce
Operating costs read alongside headcount
Is spending changing because of staffing, cost per person or activity levels?
Open the guide →05
Forecast & Outlook
Adjust an assumption and see the effect immediately
If the plan changes, what happens to profit, cash and inventory?
Open the guide →06
Cash, Balance Sheet & Inventory
A profitable business can still run short of cash. This shows which line it is tied up in.
Why does cash move differently from profit?
Open the guide →07
CAPEX & Depreciation
The cash leaves once; the cost is recognised across the asset’s life
When will an asset purchase affect cash and profit?
Open the guide →EXTENSION 08–10
Advanced reports for the next layer of work
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.
08
TB-mapped linked statements
Turn a trial balance into three statements that reconcile.
With only a trial balance, how do you produce monthly statements that reconcile?
Open the guide →09
Rolling 12-month forecast
Close a month and the forecast window moves with it.
Once a new month is closed, what do the next twelve months look like?
Open the guide →10
Department budgets and group consolidation
Roll department budgets into a group result, with intercompany eliminations.
Once every department submits its budget, what is the group result after internal transactions are removed?
Open the guide →POWER QUERY
Monthly data preparation, built once and refreshed
Power Query Studio collects worked examples of cleaning Thai digits and Buddhist-era dates, removing rows revised after the fact, reconciling two sources and combining a folder of files, in an Excel workbook where every step can be opened in the Query Editor.
LEARNING TO READ THEM
Built for people who have to read financial figures without an FP&A background
FP&A is financial planning and analysis. Start from the three principles below, then use what the reports show to identify causes and make clearer business decisions.
01
Start with the period and scale.
A value of 1,000 in a THB-thousands table means one million baht. One month's result is not a full-year total.
02
Interpret the sign in context.
Revenue above budget is generally favourable. Costs above budget need investigation. A positive variance is not always good news.
03
Recorded profit is not money in the account yet
Goods sold may not be collected yet, and goods bought may not have sold. Adjust the example alongside to see the effect on cash.
INTERACTIVE EXAMPLE
If customers pay later, how much does cash change?
Using August revenue of 10.921 million baht to show how collection time relates to cash.
0 days10 days
Additional cash tied up in AR · THB m1.057
Cash after this isolated effect · THB m29.577
Learning example: assume stable revenue, all sales on credit, a 31-day month and everything else unchanged. Additional AR = Revenue ÷ 31 × Extra days. This is an isolated sensitivity, not a full forecast recalculation.
This example moves one lever. To move sales, receivable days, inventory days and payable days together and see all twelve months of cash Open the working capital simulator →
WHAT IS IN THE PACK
What the pack contains, and how to extend it
Start from a sample file you can open immediately, then adapt the data, the assumptions and the structure to your company.
- Excel workbooks per report, Thai and English as separate files
Each report has a Thai and an English workbook, with live formulas, native charts and check sheets.
- Usage guides and report explanations
Thai and English Markdown guides are included in the pack. The web reading guides on this site are free to read.
- Sample data and a data dictionary
CSV/JSON datasets, field definitions and documented model policies.
- Documentation for further development
An AGENT_SPEC for each report and builder source code for further development.
- Verification records and model boundaries
Documentation describes prior checks, including recalculation in Microsoft Excel, and limitations to review before using company data.
DEVELOPMENT NOTE
FP&A
Reports Pack.
While developing the working-capital tool the working assumption was that higher sales would reduce cash. Moving sales alone to 130% instead raised closing cash by 4.33 million baht. Only with receivable days extended to 75 did cash fall, by 11.61 million. The page copy was corrected to match what the model shows.
Open the working capital toolTwo sample reports are available now, without registration Go to downloads →
01 / CHOOSE
Start with a business question.
Choose the report that matches what you need to understand.
02 / READ
Read the worked example.
Understand the scale, variance and key measures.
03 / ADAPT
Use reconciled company data.
Adapt assumptions and structure to the business.
04 / ACT
Turn findings into actions.
Document the cause, owner and follow-up date.
BEFORE YOU START
Common questions
How much finance knowledge do I need?
Start with the reading guides and examples. Changes to formulas, costing policies or company data should be reviewed by the person responsible for finance.
Does every company use the same format?
This is a generic starting structure. Companies have different account mappings, calendars, costs and KPIs, so adapt it before using it as a recurring management pack.
Will editing the Thai file update the English file?
The language versions and individual report files are independent. Choose a working master and refresh related data consistently.
What should I check before using company data?
Check units, dates, version names, formula ranges and the Checks sheet. Adding products, departments, assets or periods may require changes to formulas and controls, not just new rows.
Are these the results of a real company?
No. These are synthetic figures for Company Name Co., Ltd., used to explain the reports. They are not promises of business results.
How were the Excel files tested?
Every formula was recalculated in both LibreOffice and Microsoft Excel desktop against an independent reference calculation. Thai and English workbooks agree, and there are no macros or external links. Details are in the pack's verification report.