Bank, cash and reconciliation

Bank accounts, payment batches and matching the ledger to the bank statement.

Baca dalam Bahasa Indonesia

On this page
  1. Bank accounts in the ledger
  2. Recording cash: always against a document
  3. Paying suppliers in a run
  4. Importing the statement and matching
  5. The month-end reconciliation
  6. Petty cash
  7. In Voltrus
  8. Checklist

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 outDocumentJournal
Customer pays an invoiceCustomer paymentDr Bank / Cr Accounts Receivable
Customer pays before you know what forMoney on accountDr Bank / Cr Unapplied Receipts
You pay a supplier billSupplier payment (often in a payment run)Dr Accounts Payable / Cr Bank
Rent, electricity, fees: a supplier sends an invoiceSupplier bill with a GL account on each line, then a supplier paymentDr expense / Cr Accounts Payable, then Dr Accounts Payable / Cr Bank
You pay tax to the stateTax remittanceDr Tax or PPh Payable / Cr Bank (PPN also clears the month's input VAT)
Salaries, bank charges, owner's capital, loansManual journalDr 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:

  1. Finance lists the bills due by the run date.
  2. Someone with authority reviews the list and holds back any that are disputed or not yet matched.
  3. The system records one payment per supplier and currency, and produces a bulk-transfer file.
  4. 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:

  1. Export the statement from internet banking as CSV or MT940 (most Indonesian banks offer one of these for corporate accounts).
  2. 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 by currency, fx_rate. Lines already imported are skipped, so overlapping statements are safe.
  3. 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.
  4. Review each proposed match and Post receipt. The receipt is recorded against the invoices and the line is marked Cleared.
  5. 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.

DateAmountDescriptionProposalAction
3 Mar6,660,000TRF PT ALPHA INV-0012INV-0012 in fullPost receipt
4 Mar10,900,000PT BETA PEMBAYARANINV-0020, Rp 11,100,000 less PPh 23 200,000Post receipt
5 Mar25,000,000CV GAMMAnoneOn account for CV Gamma
6 Mar−5,550,000TRF KE PT SUPPLIERoutgoingPaid by payment run; Ignore
7 Mar−15,000BIAYA ADMoutgoingManual 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 March182,400,000
Add: deposits recorded, not yet on the statement6,000,000
Less: payments recorded, not yet cleared by the bank(12,500,000)
Adjusted bank balance175,900,000
Balance per ledger (bank account), 31 March175,900,000
Difference0

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.

Run it in Voltrus ERP

Everything in these guides is built in: documents that post to the ledger as they happen, Indonesian tax, MRP and costing, with AI agents that propose and people who approve.

See Voltrus ERP