Full disclosure: I'm the developer of BulkOps, a Xero add-on. The manual steps below work with or without it.
If you run a rebates-heavy or returns-heavy business on Xero, month-end usually includes one specific chore: applying dozens or hundreds of credit notes to open invoices. Xero handles this one credit note at a time — bulk allocation is a long-standing request on Xero's Product Ideas board (480+ votes) — so if you need it done in bulk, here is the manual process and the tool I built for exactly this.
The manual steps in Xero
- Business → Invoices (or Credit notes). Open an unallocated credit note.
- Credit note options → Allocate credit.
- Enter the amount to apply against each open invoice for that contact. Save.
- Repeat for the next credit note.
Four to six clicks plus typing per credit note. Fine for a handful; at a hundred or more it becomes an afternoon.
Worth knowing: allocation is same contact only and same currency only, and only approved documents appear on the screen. CSV import doesn't apply credits — it creates documents.
If money actually moved, bank reconciliation's Find & Match can clear some items. For credit notes that should simply offset open invoices, the allocation screen is the way.
Doing it in one run with BulkOps
BulkOps connects with Xero's official OAuth and:
- scans every unallocated credit note and open invoice, and proposes matches (same contact; exact amounts first, then oldest invoices first)
- shows the full preview line by line — you untick anything before a single write happens
- runs the approved batch as a job under Xero's API rate limits (a 1,400-allocation run paused on the daily limit and resumed on its own the next morning)
- undoes an entire job in one click — Xero's API allows removing allocations, and every write is logged with before/after state and exportable as CSV
It also does overpayment allocation, batch payment runs that include credit notes, bulk attachment export, and bulk tracking-option archiving — the other bulk jobs people ask for on the same board.
Previews are unlimited and free; the first 25 executed allocations are free, no card. If it doesn't fit your setup, email support@microspear.app and tell me why — that's genuinely useful to me.
Full guide with the FAQ: https://bulkops.microspear.app/guides/bulk-credit-note-allocation-xero
Top comments (0)