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.
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 Cash Review: net profit, add back depreciation, then the changes in receivables, inventory and payables.
- Continue with capital spending, borrowing, repayments and dividends to explain closing cash.
- Open Balance Sheet to confirm assets equal liabilities plus equity, then Inventory to see which type of stock grew.
- Before passing the file on, open Checks. If a line fails, do not send it yet.
Read the guide to this report first →
What you need before using it on your own company
- Monthly P&L and balance sheet.
- Month-end receivables, payables and inventory, with inventory by type if you have it.
- Each month's capital spending, borrowing, repayments and dividends.
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 06_Cash_Balance_and_Inventory_TH.xlsx SHA256sha256sum 06_Cash_Balance_and_Inventory_TH.xlsx| File | bytes | SHA-256 |
|---|---|---|
| 06_Cash_Balance_and_Inventory_TH.xlsx | 180,093 | a07d086b7cc183219f1721ffeacc59697cfedbcc9d55b0d5b02003ff760dd48e |
| 06_Cash_Balance_and_Inventory_EN.xlsx | 176,249 | 856eaf5673bb6dc73fa217c48052aad908bc38c4d96fafe061f6a46a302056bd |
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.
Download the workbook
What will you use this file for?
Optional. No personal details.
Thanks. This helps decide which files to build next.