The ideas behind the reports, worked through
Latest
-
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.
Read the article → -
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.
Read the article →
Management reporting and FP&A
How to lay out a monthly report, budget variances, year to date against the full-year forecast, the cash conversion cycle and rolling forecasts, each worked through with figures from the same sample workbooks as the report guides.
-
What a monthly management report should contain, and in what order
A monthly report sent to management is often read only as far as the first page. If that page does not say how the month went against plan and what needs deciding, the rest of the report goes largely unused.
Read the article → -
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.
Read the article → -
Year to date versus full-year forecast: what each number answers
Management usually asks two questions back to back: how much have we done this year, and where will we finish? The first is answered by the year-to-date figure. The second needs a forecast.
Read the article → -
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.
Read the article → -
Rolling forecast versus annual budget: what each one is for
A budget finished in November explains less of the business by July. Material prices have moved and a large customer has pushed back its orders, but the budget figures are where they were. A rolling forecast deals with this by moving its window forward every month.
Read the article → -
Price-volume analysis: was it fewer units or lower prices?
August revenue is THB 0.516m below budget. The first question in the meeting is whether the company sold less than planned or sold for less. The two answers lead to different fixes.
Read the article → -
Copilot in Microsoft Excel for financial reporting: what it does, what it needs, what to check
Copilot in Microsoft Excel can write formulas, build PivotTables and charts, and summarise data from a plain-language request, Thai included. Microsoft also says it can make mistakes or misread data, and that anything it creates should be checked before you rely on it. This is a practical summary for financial reporting, as of October 2026.
Read the article → -
Testing Copilot in Excel on a sample P&L: questions with known answers
The quickest way to learn how well Copilot reads financial data is to ask it questions you already know the answers to. The free Executive Review workbook keeps its monthly P&L in an Excel Table, and the correct answers are below. Ask one at a time and compare.
Read the article →
Where the article figures come from
Every figure is computed when the site is built, from the same synthetic dataset as reports 01–07; none is typed in. The one exception is the working capital simulator example in the cash cycle article, which uses the report 09 model and says so where it appears.
Excel, Power Query and Power BI for reporting
-
How to Create Excel Reports with Power Query and Power BI
To create a useful Excel report, start with a clear business question. Organise your data in an Excel Table, summarise it with formulas or a PivotTable, and present the results in a simple dashboard. Use Power Query when you need to prepare the same data every month. Add Power BI when your team needs interactive reports, shared access and a managed process for updating data.
Read the article →
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.
Read the article → -
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.
Read the article →
Excel for investors
Using Excel to screen stocks with tests you can check. The worked examples are fictional companies from the stock-screener template and do not come from the report guides' workbooks.
-
Screening Thai stocks in Excel: ten price and fundamental tests for SET100
A share trading near its lowest price in years may have fallen with the whole market, or because its profits really did weaken. A screening table in Excel separates the two before you start reading financial statements, and cuts the list to a handful of names.
Read the article →
Dividend stocks
-
Ten SET100 dividend companies, read through their accounts
Four years and the latest half-year of accounts for ten SET100 dividend stocks: whether profit turns into cash, whether cash after investing covers the dividend, and which figures to watch.
Read the article → -
TOA accounts: margins up every year, with cash to spare for the dividend
Read the article → -
COM7 accounts: record profit, negative operating cash flow
Read the article → -
TU accounts: a paper loss in 2023, while the cash kept coming
Read the article → -
PTTEP accounts: cash well above profit, but nearly all of it reinvested in 2025
Read the article → -
TFG accounts: profit follows chicken and pork prices, and so does the dividend
Read the article → -
RCL accounts: good-year profits went into the fleet
Read the article → -
AMATA accounts: half a year's profit nearly matches last year, thanks to lumpy land transfers
Read the article → -
WHA accounts: profit above cash, and dividends above the cash left over
Read the article → -
BA accounts: an airline propped up by its airports and investments
Read the article → -
KTC accounts: loans grow, cash falls; loans slow, cash returns
Read the article →
Every report's Excel workbook is free to download, in Thai and English.
