KomanderGuides
Company financeFinance / PRACTICAL GUIDE

13-Week Cash Flow for Contractors: How to Build It and Use It Every Week

How to build a company cash forecast for the next 13 weeks: an opening balance from the bank account, progress payments net of the advance deduction and final income tax, wages, suppliers, subcontractors, tax and BPJS on their dates, a minimum cash line, and a weekly update.

Komander.ai Panduan team · 3 min read · Updated 9 October 2026

Edited by Ravi MelwaniCEO & Co-founder, Komander.ai

Prices and rules are summarised from the sources listed below and updated regularly. Check local prices and the relevant authority before relying on them.

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.

Bank balanceCash inCash outClosing cashMinimum lineRoll weekly
One cycle of the 13-week cash flow.

The lines to fill

LineFor a contractor
Opening cashAll bank accounts, reconciled to the statements
Progress payments per projectWhen the money actually arrives, net of the advance deduction and the final income tax withheld by the client
Retention and guaranteesThe 5% retention on government projects is held at PHO and paid after FHO, not deducted from every payment
Site wagesWeekly, from attendance
Suppliers and subcontractorsBy their payment terms; pay-when-paid subcontracts follow the progress payment
Tax and BPJSTax on the 15th, BPJS Kesehatan on the 10th, BPJS Ketenagakerjaan on the 15th
OfficeOffice payroll, rent, loan instalments, guarantee fees
Closing cash and minimum lineIf below the line, plan action now

Example: the first six weeks (Rp million)

WeekOpeningInOutClosingNote
1400070330Wages 40, suppliers 30
2330070260Wages 40, suppliers 25, BPJS Kesehatan 5
32600120140Wages 40, suppliers 50, tax 30; below the Rp150 m line
4140350100390Block M8 progress payment received (net); wages 40, office payroll 60
5390075315Wages 40, suppliers 35
63150170145Wages 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

  1. Replace the week just past with actual figures from the bank statement.
  2. Add the new week 13.
  3. Compare plan with actual line by line: a late progress payment must show, not hide in an "other" line.
  4. Update progress payment dates from each project’s billing status.
  5. If closing cash falls below the minimum line, decide this week’s action.

Common mistakes

Start from a template

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.

Get the templateCheck my 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 with GmailEmail app

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

  1. Atlar: what is the 13-week cash flow forecast: direct method, weekly
  2. CFO.com: the 13-week cash flow forecast: the lender’s key gauge