The Gaji_Upah tab sums up staff salaries and worker wages per month per project: how many people, gross pay, deductions, and the amount paid out.
Wages are the largest regular cost on many projects, so this summary matters for the monthly cash-out forecast.
Where the numbers come from
- The payroll list, or attendance and weekly wage summaries.
- Transfer slips or wage receipts.
- Labour contracts for the remaining contract value column.
Columns and how to fill them
Tab Gaji_Upah in the free finance template. The examples are fictional. Optional when wages already appear in Pengeluaran. Additional contract fields require evidence; do not guess values or overwrite the summary on the right.
| Column | Example | How to fill it |
|---|---|---|
| Periode (Bulan) | September 2026 | Use the same payroll period for headcount and wage amounts. |
| Proyek/Blok | E2 | The project or block this row belongs to, for example C4. One row is for one project only. |
| Jumlah Pekerja | 10 | The number of people paid in this period. |
| Total Gaji Bruto (IDR) | 50000000 | Total wages before deductions. |
| Potongan (IDR) | 2000000 | Total deductions, such as cash advances or tax, taken off the gross wages. |
| Total Gaji Bersih (IDR) | 48000000 | D5 − E5 = 48000000. Reconcile to payroll and payment evidence. |
| Tanggal Pembayaran | 30/09/2026 | The date the wages were or will be paid. |
| Keterangan | Contoh; belum diduplikasi ke Pengeluaran | Extra notes that help explain the row, for example a confirmation status or the reason for a change. May be blank. |
| Sisa Nilai Kontrak KA Tukang | (blank) | Blank in this example because no remaining-contract basis is supplied. Populate only if applicable and verified. |
How to check it
- Net pay = gross pay minus deductions.
- Headcount and pay are for the same period.
- Wages already in Pengeluaran are not recorded here again.
- The payment date matches the transfer evidence.
Common mistakes
- Weekly wages recorded in Gaji_Upah and again in Pengeluaran.
- Crew advances recorded as full wages.
- The remaining labour-contract value guessed without the contract.
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
Is this tab required?
No, if all wages are already in Pengeluaran. Pick one place so they are not counted twice.
How do I record labour-contract crews?
Their payments can be recorded here per month; fill the remaining contract value only when there is a contract and a site measurement.
What counts as a deduction?
For example advances being repaid, the worker’s social security share, or income tax, as on the payroll.