Allocate Payment to Invoice: Part Payments and Overpayments

Matching a customer payment to an invoice is simple when they pay one invoice, in full, with the invoice number as the reference. The trouble starts when they pay three invoices in one lump, pay half, pay too much, or put "ACCOUNTS" as the reference. The fix in every case is the same: work out exactly which invoices the money covers, allocate payment to invoice after invoice until it runs out, and record whatever's left over properly instead of letting it sit unmatched.

Why getting this right matters

An unmatched payment causes two problems at once. The invoice still looks unpaid, so your aged receivables report is wrong and you might chase a customer who's already paid. And the money sits in your bank with no home, so your reconciliation won't close cleanly.

Get matching right and both problems disappear.

Scenario 1: one payment covering several invoices

Ben runs a joinery workshop in Toowoomba. On 12 Oct 2026 a builder deposits $5,170 with the reference "BUILDCO OCT". No invoice numbers.

Ben checks what the builder owes:

The default approach is oldest first, which is what most customers intend. Two invoices are cleared and the third is part-paid with $1,760 still outstanding.

But don't assume. If a customer has a disputed invoice, they may have deliberately skipped it. A quick email ("We've applied your $5,170 to invoices 1041, 1043 and part of 1047, does that match your records?") avoids a mess at the next statement.

Tip: ask regular customers to send a remittance advice. It takes them thirty seconds and saves you ten minutes of guessing.

Scenario 2: a part payment

A customer owes $4,400 on a single invoice and pays $2,000 with a note saying the rest is coming next month.

Record the $2,000 against the invoice. The invoice stays open with $2,400 owing, and it keeps ageing from its original due date. Don't create a new invoice for the balance, and don't reduce the original invoice to $2,000; both break your audit trail.

If you've agreed a payment plan, note the dates and amounts on the customer record so whoever chases next knows what was promised.

Scenario 3: an overpayment

A café owes Ben $880 for a set of shelves and pays $968. Probably they paid the GST-inclusive figure twice in their head, or paid an old quote. Either way, they've given you $88 that isn't yours yet.

You have three sensible options:

1. Refund the $88. Cleanest if you don't expect more work from them soon.
2. Hold it as a credit on their account and apply it to their next invoice. Tell them you've done this.
3. Ask them. Often the best option; they might have meant to pay another invoice you haven't sent yet.

What you shouldn't do is book the extra $88 as income. It's money you owe back to the customer until it's refunded or used. In bookkeeping terms it sits as a credit balance in receivables, or in a customer deposits/credits liability account, depending on how your software handles it.

Scenario 4: a short payment

You invoice an overseas client $1,500 and $1,482 arrives. The $18 gap is almost certainly a bank or transfer fee taken on the way through.

Record the $1,482 as received against the invoice, then deal with the $18:

• If your terms say the customer covers transfer fees, you can leave $18 owing and ask for it. Most businesses don't bother for small amounts.
• Otherwise, record the $18 as a bank fee expense so the invoice closes at zero.

Same idea with card or payment processor fees: the invoice was paid in full, but the deposit is net of fees. Record the full payment against the invoice and the fee as an expense, so the deposit, the invoice and the fee all reconcile.

If the gap isn't a fee, say $150 short on a $1,650 invoice, don't write it off. It's probably a dispute or an error. Ask.

Scenario 5: no reference, or the wrong name

A deposit of $1,210 arrives from "J & K NGUYEN" with no reference. Nobody by that name is in your customer list.

Work through it:

1. Search for open invoices of exactly $1,210. An exact amount match is usually right.
2. Check whether the payer is a director or owner paying a company invoice personally. Common with small businesses.
3. Look at timing. Did you send a $1,210 invoice in the past few weeks?
4. Still stuck? Park it in a suspense or unallocated receipts account and email recent customers. Clear it within the month, not the year.

Never leave a deposit uncategorised just because it's awkward. Unexplained money in the bank is how reconciliations drift.

Scenario 6: a payment for an invoice you haven't sent

Sometimes a customer pays from a quote or a verbal price before you've invoiced. Create the invoice now, matching what was agreed, then apply the payment. If they've paid a deposit for future work, record it as a customer deposit (a liability) until the work is done and invoiced.

A quick routine for matching payments

Do this weekly, or every few days if you get a lot of payments:

• [ ] Reconcile the bank account up to yesterday
• [ ] For each customer deposit, check the reference and amount against open invoices
• [ ] Allocate oldest first unless there's a remittance saying otherwise
• [ ] Record fees separately so invoices close at zero
• [ ] Put overpayments on account or refund them; never into income
• [ ] Park true unknowns in suspense and chase them the same week
• [ ] Run your aged receivables report and confirm it looks right

For the bigger picture of matching across your whole bank account, see our bank reconciliation software guide.

How HelloBooks helps

When a customer payment comes through your connected bank account (most Australian banks and cards) or a CSV statement import, it lands in a review list. On the reconcile screen, HelloBooks lines your statement up against your ledger and gives each line an AI match suggestion with a confidence score and the reason it picked that match, so you only need to work through the exceptions, like the overpayments and mystery deposits above. If a match is wrong, you can unmatch it in one click.

Invoices, unlimited email payment reminders and AR ageing are on the Free plan (A$0, no card, no expiry). Pro (A$30/month) adds AI auto-categorisation and unlimited bank connections, which helps if customer payments land in more than one account. More on automated bookkeeping.

FAQs

Should I always apply payments to the oldest invoice first?

It's a sensible default, but a remittance advice or the customer's instructions override it. If they've told you which invoices they're paying, follow that.

Is a customer overpayment income?

No. It's money you owe back to the customer until you refund it or apply it to a future invoice. Record it as a credit on their account, not as revenue.

How do I record a payment that's short because of a bank fee?

Apply the amount received to the invoice and record the difference as a bank fee expense, unless your terms require the customer to cover fees and you plan to ask for it.

What if I can't identify a deposit at all?

Put it in a suspense or unallocated receipts account so your bank still reconciles, then investigate. Aim to clear it within the same month.

Can I just delete an old invoice that was part-paid and never finished?

Don't delete it. If the remainder won't be paid, issue a credit note or write off the balance as a bad debt, so there's a record of what happened. Your accountant can help with the right treatment.

Matching is the unglamorous bit of bookkeeping that makes every other report trustworthy. Get it right every week and month-end becomes a lot quieter.

Start free, no card needed. Try HelloBooks Free