Report workbooks 01–10: free download, no sign-up

For finance teams and business owners

Free Excel templates for financial and business reports

From an executive review and a budget-versus-actual P&L to sales, cash, a rolling forecast and department budgets. Every report comes as a Thai and an English workbook with editable formulas, recalculated in Microsoft Excel and LibreOffice. Each report has a guide to reading its figures.

Download the free Excel templates Browse the report guides

Thai and English editions are separate files · The figures belong to a fictional business, so adapt them before using your own

fx=SUMIFS(Actual,Month,$B$2) − SUMIFS(Budget,Month,$B$2)

RPTIC.com Monthly report · Synthetic data

FP&A / 01

Net revenue · THB millions

10.921 4.51% below budget

Actual Budget

View chart data

Actual versus budget revenue, Jan–Aug 2026, THB millions
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

USEFUL FOR

Finance teamsBusiness ownersTrading businessesManufacturing businesses

Latest articles, tools and Excel files

Latest · Excel updates for finance work

Copilot in Excel: bringing in data from other workbooks, Power BI and the web, and finding who changed a cell

At month end the data you need sits in several places: branch sales in separate workbooks, sales figures in a Power BI report, exchange rates on the web. Copilot in Excel can pull these into a workbook from one prompt, and it can tell you who changed which cell and when. Each source has its own conditions, and some data does not stay up to date. Information as of October 2026.

Latest · Excel updates for finance work

Rules, personalization and skills: getting Copilot in Excel to do month-end work the same way every time

Every month end, whoever builds the report types the same instructions to Copilot again: amounts in baht, no decimals, negatives in brackets, which table holds the actuals, how to compare them with budget. Copilot in Excel has three places to keep those instructions so you set them once. Information as of October 2026.

Management reporting and FP&A

DSO, DIO, DPO and the cash conversion cycle, worked through

A business that is selling more can end the month with less cash, if customers are paying later or stock is sitting longer in the warehouse. Three measures show it: DSO, DIO and DPO.

Management reporting and FP&A

Reading a budget variance: favourable, unfavourable, and what to check next

August closes with revenue THB 0.516m below budget and operating expenses THB 12.92k above it. Both are bad news. In the variance column, one is negative and the other positive.

Earlier

Thai Income Tax Calculator 2026 (B.E. 2569) and Deduction PlannerINTERACTIVE TOOL
Ten SET100 dividend companies, read through their accountsStock accounts
How to Create Excel Reports with Power Query and Power BIExcel, Power Query and Power BI for reporting
Testing Copilot in Excel on a sample P&L: questions with known answersManagement reporting and FP&A

See all articles →

Illustration: an Excel file opening into a layered paper world of tables, charts and people working with data

CHECK THE FILE YOURSELF

Every figure in a report traces back to its formula and source sheet

Open a sample workbook, click a figure in the report, and the Formula Bar shows which sheet it pulls from. Every formula is open to edit, and there are no macros.

How to build an Excel report and take it into Power BI Download the report workbooks

INTERACTIVE TOOL

Thai income tax calculator 2026: estimate from your salary

Enter your monthly salary and see an estimate of the year's tax straight away. Before the year ends you can still buy insurance or tax-saving funds to lower it.

Monthly salary (baht)

Estimated tax for the year 20,450 baht About 1,704.17 baht a month

Based on 12 months of salary, less expenses, the personal allowance and estimated social security. Insurance, funds, children and other deductions are not included yet.

Add deductions to lower the tax →

THE REPORTS

Excel templates for monthly financial reports

Each guide shows the real workbook, figures read off the sheet, a reading order, the core formulas, and the points most often misread.

Executive Review

A single overview page to open a meeting with

How did the business perform, and what needs attention first?

Open the guide →

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 →

Sales & Gross Margin

The best-selling product may not be the one earning the most gross profit

Which products sell well, and which contribute the most gross profit?

Open the guide →

OPEX & Workforce

Operating costs read alongside headcount

Is spending changing because of staffing, cost per person or activity levels?

Open the guide →

Forecast & Outlook

Adjust an assumption and see the effect immediately

If the plan changes, what happens to profit, cash and inventory?

Open the guide →

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 →

CAPEX & Depreciation

Cash goes out when the asset is paid for; depreciation is recorded as an expense over its useful life

When will an asset purchase affect cash and profit?

Open the guide →

EXTENSION 08–10

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.

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 →

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 →

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 →

See the advanced reports →

POWER QUERY

Power Query for Excel: combine and clean your data

Power Query Studio collects worked examples of combining a folder of files, converting Buddhist-era dates and Thai digits, keeping only the latest revision of each order, and reconciling two sources. Every step can be opened in the Query Editor.

Explore the Power Query examples

The examples on this site are free to read. The Power Query Studio workbook is not available to download yet.

Power Query Studio dashboard after Refresh All in Excel: net sales, rows used, rows to fix, monthly and channel charts

READING FINANCIAL REPORTS

Three things to check before drawing conclusions from a financial report

Before deciding the business did better or worse, check the period and units, which way each variance runs, and the gap between profit and cash.

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.

Interpret the sign in context.

When variance is actual minus budget, a positive revenue variance is usually good news, but a positive expense variance means overspending. Read the sign together with the line item.

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.

Open the finance glossary → Articles that work through the ideas →

TRY THE 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.

Additional collection days 3 days

0 days10 days

Extra cash tied up in receivables · THB m1.057

Cash after the slower collection · THB m29.577

Learning example: assume stable revenue, all sales on credit, a 31-day month and everything else unchanged. Extra receivables = Revenue ÷ 31 × Extra days. This is an isolated sensitivity, not a full forecast recalculation.

This example changes one value. To adjust sales, receivable days (DSO), inventory days (DIO) and payable days (DPO) together and see all twelve months of cash Open the working capital simulator →

FILES AND GUIDES

What you get, and how to start

Open the file with the fictional business’s figures first, to see which sheet each formula draws on. Then adapt the data and assumptions to your company.

Thai and English report workbooks, as separate files
Each report workbook has live formulas, charts, data sheets and a Checks sheet for reconciling totals. No macros.
Reading guides on this site
Every report has a guide to its key figures, core formulas, reading order and the points most often misread. Free to read.
Sample data in the file
The figures belong to a fictional business, RPTIC.com, so you can see how the formulas work before replacing them with your own.
How the files were checked
The formulas in report workbooks 01–10 were recalculated in Microsoft Excel and LibreOffice and compared with the values in the file, and the Thai and English files agree. Before using company data, still check the units, formula ranges and the Checks sheet.

FREE, NO SIGN-UP

Free tools and Excel files

Thai income tax calculator 2026INTERACTIVE TOOL
Working capital simulatorINTERACTIVE TOOL
Report workbooks 01–10FREE DOWNLOAD

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

Are the Excel report templates really free?

Yes. The Thai and English workbooks for reports 01–10 are free, with no sign-up or email. The guides, articles and calculators on this site are free too. Only the Power Query Studio workbook is not available to download yet.

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 made-up figures for a fictional business, RPTIC.com, used to explain the reports. They are not promises of business results.

How were the Excel files tested?

The formulas in report workbooks 01–10 were recalculated in Microsoft Excel desktop and in LibreOffice and compared with the values saved in the file; Excel found no differences. The Thai and English workbooks agree, and there are no macros or formulas that pull from other files.

Which software do I need?

Report workbooks 01–10 are .xlsx files tested in Microsoft Excel desktop and LibreOffice; the Thai-language forms were tested in Excel desktop. They have not been tested in Excel for the web, Excel on mobile or Google Sheets, so some formulas or charts may behave differently.