The bank balance is the starting point of every cash forecast: how much money there really is today. This tab holds one row per bank account or petty cash box, with its latest balance and the date of that balance.
Enter balances, not transactions. If your workbook has a list of debits and credits, the last balance of each account in that list is the figure to enter here.
Where the numbers come from
- The bank statement or online banking per account.
- The site petty cash book.
- Bank reconciliation reports, if you have them.
Columns and how to fill them
Tab Saldo_Bank_Input in the free finance template. The examples are fictional. One row per bank or cash account. Enter balances here, not totals of transactions from Saldo_Bank.
| Column | Example | How to fill it |
|---|---|---|
| Nama Bank/Kas | Bank Contoh | The bank account or cash box name, for example "BCA Operations" or "Site petty cash". One row per account. |
| Nomor Rekening | DEMO-REK-001 | Store account numbers as text to preserve leading zeros. This ID is fictional. |
| Jenis | Bank Operasional | Distinguish Bank Operasional from Kas Kecil. Use an available workbook category. |
| Saldo Terkini (IDR) | 150000000 | Enter 150000000 as a number without Rp or grouping separators. Keep genuine zero and negative balances. |
| Tanggal Saldo | 30/09/2026 | Use the statement or cash-count date, not the upload date. |
| Mutasi Tersedia | Ya | State whether transaction history is available; follow the workbook choices if provided. |
| Keterangan | Contoh fiktif; saldo sesuai rekening koran | 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
- Every account the project uses has one row, including petty cash.
- The balance date is the cut-off date or very close to it.
- The balance matches the bank statement on that date.
- Account numbers are stored as text so leading zeros are kept.
Common mistakes
- Adding up all transactions and calling it a balance.
- The same account listed twice with different dates.
- Balances typed as text such as "Rp150,000,000", so they cannot be calculated.
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
Should site petty cash be included?
Yes, as its own row with the type Kas Kecil, so all available money is visible.
What about a negative balance?
Enter it as it is. An overdraft is important information for the cash forecast.
How often should it be updated?
At every report cut-off date, for example every week.