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.
What is inside the file
The sheet list below is read out of the actual workbook when this page is built, not typed. If the file changes, the list changes with it.
Where to look first
- Start on the P&L sheet and read the variance column before the value columns — the variance is what needs explaining.
- Sort variances largest first and take the top three. The rest is usually noise.
- Check the monthly sheet to see whether a variance is one month or every month. Those need different responses.
- If your chart of accounts does not match the file, fix it on the mapping sheet, never by editing figures on the P&L sheet.
Read the guide to this report first →
What you need before using it on your own company
- This year’s monthly actuals, coded to your chart of accounts.
- The monthly budget, coded to the same chart of accounts.
- Any adjustments already posted, so the variances you see are not purely accounting entries.
Download the workbook
Two sample reports download without registration or an email address, in Thai and in English, with SHA-256 values so you can verify what you received.
Check the file against the original
The SHA-256 values below come from the pack’s FILE_MANIFEST.json and are re-checked against the real files every time the site is built; a mismatch fails the build. To verify your copy yourself:
certutil -hashfile 02_PnL_Budget_vs_Actual_TH.xlsx SHA256sha256sum 02_PnL_Budget_vs_Actual_TH.xlsx| File | bytes | SHA-256 |
|---|---|---|
| 02_PnL_Budget_vs_Actual_TH.xlsx | 56,172 | 93fe7e2ba92a91560651396d750a77413349ee1a73be44109a9035edd871b462 |
| 02_PnL_Budget_vs_Actual_EN.xlsx | 53,551 | cdbf672d18473bc753c0fabbe66f1abf6783018be2635f2c19c57a4e50f89ca6 |
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.