A profit and loss statement can show a profit while the bank account is empty. A 13-week cash forecast answers a more urgent question every Monday: is there enough money in the bank to pay wages, suppliers and tax for the next three months? Lenders and turnaround advisers abroad treat it as the main gauge of a company’s ability to pay; in Indonesia it is good practice, not a legal requirement.
The lines to fill
| Line | For a contractor |
|---|---|
| Opening cash | All bank accounts, reconciled to the statements |
| Progress payments per project | When the money actually arrives, net of the advance deduction and the final income tax withheld by the client |
| Retention and guarantees | The 5% retention on government projects is held at PHO and paid after FHO, not deducted from every payment |
| Site wages | Weekly, from attendance |
| Suppliers and subcontractors | By their payment terms; pay-when-paid subcontracts follow the progress payment |
| Tax and BPJS | Tax on the 15th, BPJS Kesehatan on the 10th, BPJS Ketenagakerjaan on the 15th |
| Office | Office payroll, rent, loan instalments, guarantee fees |
| Closing cash and minimum line | If below the line, plan action now |
Example: the first six weeks (Rp million)
| Week | Opening | In | Out | Closing | Note |
|---|---|---|---|---|---|
| 1 | 400 | 0 | 70 | 330 | Wages 40, suppliers 30 |
| 2 | 330 | 0 | 70 | 260 | Wages 40, suppliers 25, BPJS Kesehatan 5 |
| 3 | 260 | 0 | 120 | 140 | Wages 40, suppliers 50, tax 30; below the Rp150 m line |
| 4 | 140 | 350 | 100 | 390 | Block M8 progress payment received (net); wages 40, office payroll 60 |
| 5 | 390 | 0 | 75 | 315 | Wages 40, suppliers 35 |
| 6 | 315 | 0 | 170 | 145 | Wages 40, suppliers 40, subcontractor 90; below the line again |
This example shows two problems three weeks before they happen. The options: collect the progress payment sooner, move supplier payments with their agreement, or draw a working capital facility in week 3. The net progress payment above is only an example; work out the advance deduction and final income tax from your contract and tax rules.
Every Monday
- Replace the week just past with actual figures from the bank statement.
- Add the new week 13.
- Compare plan with actual line by line: a late progress payment must show, not hide in an "other" line.
- Update progress payment dates from each project’s billing status.
- If closing cash falls below the minimum line, decide this week’s action.
Common mistakes
- Using invoice dates instead of the dates money actually arrives.
- Forgetting the advance deduction and final income tax, so payments look larger.
- Using a foreign template that deducts retention from every invoice, when government projects hold it at PHO.
- Tax and BPJS not entered on their dates.
- A forecast built once and never updated.
The full guide is in How to create a construction finance report in Google Sheets. It has a free template (Excel or Google Sheets) and a checker that reads your own workbook.
Ready to use the Komander agents on your projects?
When your workbook is complete, apply for a pilot: we help connect your project data to the Finance, Cost and Scheduler agents and review the first reports with you.
Send to melwani@komander.ai. Your workbook check result is included when there is one; the workbook itself is not sent.
Common questions
What is a 13-week cash flow?
A week-by-week forecast of cash in and out for the next 13 weeks, starting from a reconciled bank balance and updated every week.
Why 13 weeks?
About one quarter: long enough to see problems early, short enough to forecast week by week with accuracy.
How is cash flow different from profit and loss?
Profit and loss recognises income and cost when they occur; cash flow records when money actually enters and leaves the account.
References
- Atlar: what is the 13-week cash flow forecast: direct method, weekly
- CFO.com: the 13-week cash flow forecast: the lender’s key gauge