Cash is the one number nobody can argue with: the bank statement says what it says. That makes the bank the best check on the rest of your books. If the ledger's bank balance matches the statement, every receipt and payment was recorded; if it does not, something is missing or duplicated. This check is bank reconciliation (rekonsiliasi bank), and controllers do it every month without exception.
In spreadsheet companies the bank is usually the source of the books: someone exports the statement and types categories next to each line. In an ERP it works the other way round. Receipts and payments are recorded against invoices as they happen, and the statement is used to confirm them.
Bank accounts in the ledger
Each real bank account should be its own asset account in the chart of accounts: "BCA IDR 123-456", "Mandiri USD 789-012", "Petty cash". A single "Cash & Bank" account for everything makes reconciliation impossible, because no statement shows the combined balance.
Recording cash: always against a document
Every movement of cash should be explained by a document:
| Money in or out | Document | Journal |
|---|---|---|
| Customer pays an invoice | Customer payment | Dr Bank / Cr Accounts Receivable |
| Customer pays before you know what for | Money on account | Dr Bank / Cr Unapplied Receipts |
| You pay a supplier bill | Supplier payment (often in a payment run) | Dr Accounts Payable / Cr Bank |
| Rent, electricity, fees: a supplier sends an invoice | Supplier bill with a GL account on each line, then a supplier payment | Dr expense / Cr Accounts Payable, then Dr Accounts Payable / Cr Bank |
| You pay tax to the state | Tax remittance | Dr Tax or PPh Payable / Cr Bank (PPN also clears the month's input VAT) |
| Salaries, bank charges, owner's capital, loans | Manual journal | Dr expense or Bank / Cr Bank or liability |
The last row is the only one done by hand. Everything else comes out of the receivables and payables flow described in Accounts receivable and payable.
Paying suppliers in a run
Paying bills one by one from internet banking is slow and error-prone. Good practice is a payment run (pembayaran massal) once or twice a week:
- Finance lists the bills due by the run date.
- Someone with authority reviews the list and holds back any that are disputed or not yet matched.
- The system records one payment per supplier and currency, and produces a bulk-transfer file.
- The file is uploaded to internet banking, where a second person releases it.
Step 4's second person is the control: the person who prepares payments should not be the one who releases them at the bank.
Importing the statement and matching
Reconciliation in Voltrus starts by importing the bank statement:
- Export the statement from internet banking as CSV or MT940 (most Indonesian banks offer one of these for corporate accounts).
- On Bank, paste it into Statement text (CSV or MT940), give it a Statement reference, and click Import & match. A CSV needs the columns
date, amount, reference, description, optionally followed bycurrency, fx_rate. Lines already imported are skipped, so overlapping statements are safe. - Voltrus tries to match each incoming line to open customer invoices. It proposes a match when the line pays exactly one invoice, one invoice short by 2% (PPh 23 withheld by the customer), or a single combination of one customer's invoices that adds up to the line.
- Review each proposed match and Post receipt. The receipt is recorded against the invoices and the line is marked Cleared.
- For an incoming line you cannot match yet, choose On account: the money is held for the customer in Unapplied Receipts until you apply it.
Each line has a status: Unmatched, Matched (a proposal waits for you), Cleared (posted) or Ignored.
| Date | Amount | Description | Proposal | Action |
|---|---|---|---|---|
| 3 Mar | 6,660,000 | TRF PT ALPHA INV-0012 | INV-0012 in full | Post receipt |
| 4 Mar | 10,900,000 | PT BETA PEMBAYARAN | INV-0020, Rp 11,100,000 less PPh 23 200,000 | Post receipt |
| 5 Mar | 25,000,000 | CV GAMMA | none | On account for CV Gamma |
| 6 Mar | −5,550,000 | TRF KE PT SUPPLIER | outgoing | Paid by payment run; Ignore |
| 7 Mar | −15,000 | BIAYA ADM | outgoing | Manual journal; Ignore |
The month-end reconciliation
Matching lines is the daily work. The month-end proof is a short statement, one per bank account:
| Amount | |
|---|---|
| Balance per bank statement, 31 March | 182,400,000 |
| Add: deposits recorded, not yet on the statement | 6,000,000 |
| Less: payments recorded, not yet cleared by the bank | (12,500,000) |
| Adjusted bank balance | 175,900,000 |
| Balance per ledger (bank account), 31 March | 175,900,000 |
| Difference | 0 |
Any difference left over is a missing or duplicated entry: a bank charge not journalled, a receipt posted twice, a payment recorded to the wrong bank account. Find it before you close the month, not after.
Petty cash
Treat petty cash (kas kecil) as a bank account of its own with a fixed float, for example Rp 5,000,000. Spending is recorded from receipts with a manual journal (Dr the expenses / Cr Petty cash), and the float is topped up from the bank for exactly the amount spent. At any moment, cash in the box plus receipts must equal the float. Count it at each month end.
In Voltrus
Checklist
- Create one ledger account per bank account and per petty cash box.
- Import statements at least weekly and clear incoming lines against invoices.
- Pay suppliers through a payment run, prepared by one person and released at the bank by another.
- Journal bank charges, interest and other direct debits, then mark those lines ignored.
- At month end, prepare and sign a reconciliation for every account; leave no unexplained difference.