Collecting cash

Receipts, applying payments, aging follow-up, refunds and credit notes.

Baca dalam Bahasa Indonesia

On this page
  1. Recording what was received
  2. Reading the aging report
  3. Refunds and credit balances
  4. In Voltrus
  5. Checklist

A sale is not finished until the cash is in the bank. Profitable companies run out of money because receivables pile up faster than they are collected. Collections is the least glamorous part of order to cash, and the one with the most direct effect on whether you can pay suppliers next month.

Recording what was received

Every incoming payment should be recorded once, applied to the invoices it pays, and matched to a line on the bank statement. Three common situations:

  • A payment for one invoice. The simple case: apply it, and the invoice becomes paid.
  • One transfer covering several invoices. Customers often pay a batch. Record one receipt and spread it over the invoices it covers.
  • Money you cannot yet match. A transfer arrives with no reference, or before the invoice exists. Do not guess. Hold it on account for that customer and apply it once you know what it is for.

Short payments because of PPh 23

When a customer that is a withholding agent pays you for services, they withhold PPh 23 (currently 2% of the service value) and pay you the rest. The withheld part is not lost: it is a prepaid tax you can credit against your own income tax, provided the customer gives you the bukti potong.

Example: invoice for services of Rp 10,000,000 plus PPN 11%.

Amount
Invoice total (10,000,000 + PPN 1,100,000)11,100,000
PPh 23 withheld (2% × 10,000,000)−200,000
Cash received10,900,000
DebitCreditAmount
BankAccounts receivable10,900,000
Prepaid PPh 23Accounts receivable200,000

The invoice is fully settled. Chase the bukti potong the same week; without it you cannot claim the credit. See PPh withholding.

Money held on account

StepDebitCredit
Unidentified receipt from the customerBankUnapplied receipts
Later applied to an invoiceUnapplied receiptsAccounts receivable

Unapplied receipts is a liability: it is the customer's money until it settles something. Review it at every month end; old balances there usually mean an invoice was missed.

Reading the aging report

The receivables aging sorts unpaid invoices by how overdue they are: current, 1–30, 31–60, 61–90 and over 90 days. It is the collector's work list.

CustomerCurrent1–3031–6061–9090+
PT Sinar Jaya40,000,00015,000,000
CV Baru8,000,000
PT Lama12,000,000

How to work it:

  • Current: nothing to do except make sure the invoice and faktur pajak arrived.
  • 1–30: a friendly reminder call or message. Most late payment is administrative.
  • 31–60: escalate to the customer's finance manager, and stop new credit (Voltrus's credit check already refuses new orders for customers with overdue invoices).
  • 61–90: involve your sales owner and agree a payment plan in writing.
  • Over 90: consider it at risk. Decide on legal steps, and talk to your accountant about an allowance for doubtful debts.

Days sales outstanding

DSO is the headline measure: receivables ÷ credit sales × days in the period. Rp 300 million of receivables against Rp 450 million of credit sales in a 30-day month is a DSO of 20 days. If your terms are 30 days and DSO is 45, customers are on average paying two weeks late. Track it monthly; see The KPIs that matter.

Refunds and credit balances

A customer can end up with a credit balance: they paid twice, or a credit note was issued after they paid (for example for goods they returned; see customer returns). The balance is your liability. Either apply it to their next invoice or refund it. Record the refund as a payment going out, so the ledger and the bank agree.

In Voltrus

What Voltrus does for you:

  • Statement matching. Import a bank statement (CSV or MT940) on the bank page. Incoming lines are matched automatically when they fit one invoice, one invoice short-paid by exactly 2% PPh 23, or a unique combination of one customer's invoices. A matched line can be posted as the receipt in one step.
  • On account. An incoming line you cannot match can be held on account for a customer (numbered OA/yyyy/mm/nnnn), then applied, unapplied or refunded later.
  • PPh 23 on receipts. A receipt can record the PPh 23 the customer withheld; it posts to Prepaid PPh 23.
  • Refunds. A customer with a credit balance shows Refund credit balance in its next steps. A refund is money going out, so it is subject to the payment approval limit: above it, an Admin approves.
  • Payments are never edited. A wrong payment is corrected with a reversing payment, keeping the trail clean.

What it does not do yet: there are no automatic payment reminders or dunning letters, and no early-payment discount terms. Use the aging for follow-up, and log calls as follow up activities in the invoice's or customer's discussion so the next person sees the history.

Checklist

  • Import the bank statement at least weekly and post matched receipts.
  • Never leave money unrecorded because it is unidentified; hold it on account.
  • Collect bukti potong for every PPh 23 short payment.
  • Work the aging every Monday and log each follow-up.
  • Review unapplied receipts and credit balances at month end.

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