Accounts payable are bills from suppliers, vendors or subcontractors that have arrived but are not fully paid. The report shows how much money must go out and when.
One row is one bill for one project. The Status column separates bills officially recorded (Posted), still being checked (Draft), and left out of the forecast (Dikecualikan).
Where the numbers come from
- Supplier bills or invoices.
- Purchase orders and delivery notes to match the goods received.
- Proof of payments already made.
Columns and how to fill them
Tab Hutang_Usaha in the free finance template. The examples are fictional. One bill and one project per row. Posted, Draft, and Dikecualikan have different meanings.
| 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. Tagihan | DEMO-AP-001 | The supplier’s bill number. It is used to match payments; fill it in even when the bill is still Draft. |
| Status | Posted | Use Posted only when officially recorded. Do not promote Draft just to appear ready. |
| Tanggal Tagihan | 10/09/2026 | The date the supplier bill was issued or received. |
| Tanggal Jatuh Tempo | 10/10/2026 | The payment deadline on the invoice or bill. The agent flags anything past this date. |
| Rencana Tanggal Bayar | 08/10/2026 | Enter the planned payment date separately from contractual due date. |
| Nilai Tagihan (IDR) | 50000000 | The full supplier bill amount in rupiah, as a number. |
| Sudah Dibayar (IDR) | 10000000 | Match paid amounts to the same bill and project. |
| Sisa Belum Dibayar (IDR) | 40000000 | H5 − I5 = 40000000. Preserve existing formulas. |
| Kategori | Material | Use a supported source classification. Do not guess unknown categories. |
| Keterangan | Contoh; invoice sudah diverifikasi | Extra notes that help explain the row, for example a confirmation status or the reason for a change. May be blank. |
How to check it
- Balance owed = bill amount minus amount paid.
- A bill that comes from a PO also reduces Sisa Komitmen in Pesanan_Pembelian, so it is not counted twice.
- The planned payment date is kept separate from the due date.
- Only verified bills are Posted.
Common mistakes
- Changing Draft to Posted to make the report look complete.
- One bill covering two projects in one row.
- The same bill in Hutang_Usaha and still in full in Pesanan_Pembelian.
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 the difference between payables and purchase orders?
A purchase order is a commitment not yet billed. Once the supplier sends a bill, the amount moves to payables.
What does Dikecualikan mean?
A bill deliberately left out of the cash forecast, for example because it is disputed. Write the reason in Keterangan.
Why keep the planned payment date apart from the due date?
Because the company may pay earlier or later than the due date. The cash forecast uses the planned date.