A purchase order (PO) is spending already agreed with a supplier but not fully billed. The money has not gone out yet, but it will, so it belongs in the cash forecast.
Sisa Komitmen is the part of the PO not yet billed. Once the supplier bills it, that part moves to Hutang_Usaha.
Where the numbers come from
- The signed PO.
- Supplier bills already received for that PO.
- The payment terms agreed in the PO.
Columns and how to fill them
Tab Pesanan_Pembelian in the free finance template. The examples are fictional. Track PO commitments not yet billed. Reconcile to payables when billed without double counting.
| Column | Example | How to fill it |
|---|---|---|
| Proyek/Blok | E2 | The project or block this row belongs to, for example C4. One row is for one project only. |
| Nama Supplier/Vendor | Vendor Contoh | The supplier or vendor name as on the bill or purchase order. |
| No. PO | DEMO-PO-001 | The purchase order number. It matches supplier bills to their order. |
| Tanggal Pesan | 20/09/2026 | The date the purchase order was sent to the supplier. |
| Termin Bayar (hari) | 30 | Use agreed PO payment terms, not a guessed default. |
| Perkiraan Tanggal Tagihan | 05/10/2026 | Expected supplier invoice date, not necessarily the order date. |
| Perkiraan Tanggal Bayar | 04/11/2026 | Expected payment date reflects invoice timing and agreed terms. |
| Nilai PO (IDR) | 80000000 | The total purchase order value in rupiah. |
| Sudah Ditagih (IDR) | 30000000 | How much of the order the supplier has already billed. The rest is money still to go out. |
| Sisa Komitmen (IDR) | 50000000 | H5 − I5 = 50000000 not yet billed. This is different from an unpaid balance. |
| Keterangan | Contoh PO berjalan | Use TIDAK ADA PO BERJALAN only when genuinely absent, not when records are missing. |
How to check it
- Remaining commitment = PO amount minus amount billed.
- Amount billed matches the bills for this PO in Hutang_Usaha.
- Expected payment date = expected bill date plus the payment terms.
- Fully billed or cancelled POs are taken off the list.
Common mistakes
- Treating the remaining commitment as the unpaid balance. Not yet billed and not yet paid are different things.
- Payment terms guessed instead of taken from the PO.
- Cancelled POs still counted as money going out.
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
Why record a PO before there is a bill?
Because the money is already promised. Without POs the cash forecast looks looser than it really is.
What if a PO is billed in stages?
Add each bill to Sudah Ditagih; the remaining commitment falls to zero.
What if we do not use POs?
Write TIDAK ADA PO in Keterangan when it is confirmed there are none, so it is not taken as missing.