How to bulk allocate overpayments in Xero

Last updated: July 2026

Short answer: in Xero, overpayments are allocated one at a time, the same way as credit notes. Businesses that get paid before invoicing — clubs, membership organisations, event businesses, anyone whose customers pay up front — accumulate dozens or hundreds of overpayments that all need the same treatment, which is where a bulk run helps.

Why overpayments pile up

An overpayment is created whenever a customer pays more than their outstanding balance, or pays before an invoice exists. Each one sits as unallocated credit on the contact, and outstanding overpayments appear on customer statements — which can confuse members who have in fact paid in full. The fix is allocating each overpayment against the matching invoice.

The manual process (one overpayment at a time)

1. Open the contact and find the overpayment under their transactions, or find it via Business → Sales overview.
2. Open the overpayment.
3. Choose Options → Allocate credit.
4. Type the amount to apply against each open invoice, then save.
5. Repeat for every overpayment, for every member.

With 80 members each carrying overpayments across many events, that is hundreds of allocations for balances that usually net to zero — exactly the case a bulk run is for.

Allocating overpayments in bulk

BulkOps (built by us) connects to your Xero organisation through Xero's official OAuth and handles credit notes and overpayments together in one pass:

• It scans every unallocated overpayment and credit note, and every open invoice, and proposes matches: same contact, exact-amount matches first, then oldest invoices first.
• Where an overpayment exactly matches an invoice amount — the typical prepaid-membership case — the pair is matched automatically and both clear to zero.
• You see a full preview and untick anything before a single write happens.
• One click undoes an entire job, and every write is logged with a CSV audit trail.

It's free to try — previews are unlimited and your first 25 executed allocations cost nothing, no card required.

Related guides: bulk allocating credit notes and removing an allocation.

FAQ

Can I stop overpayments appearing on customer statements?

You can customise which columns statements show, but the cleanest fix is allocating the overpayments — the statement then reflects a genuine zero balance.

Is bulk overpayment allocation safe?

Yes, when done through Xero's API with preview and undo: the API supports removing an overpayment allocation, so the whole job is reversible. Avoid bulk tools for irreversible actions.

What about prepayments?

Prepayments are a separate Xero document type with tax implications on allocation. BulkOps currently handles overpayments and credit notes; if you have a prepayment-heavy workflow, tell us about it.