How wholesale suppliers reconcile supermarket payment runs in Xero

Sell to supermarkets or through distributors and your accounts receivable follows their rhythm, not yours. Payment arrives on the buyer's schedule as one large transfer covering dozens of invoices, accompanied by a remittance that itemises them, often with deductions for promotions, claims or short-supply that you did not raise yourself. Reconciling these runs in Xero is a monthly set-piece worth doing methodically.

What makes a supermarket run distinctive

• Volume: one payment routinely settles dozens of invoices, often crossing Xero's 50-invoice batch cap.
• Deductions: the payer nets off charges, promotional allowances, freight claims and short-delivery adjustments before paying.
• Their references, not yours: the remittance uses the buyer's purchase-order or reference scheme, which may not match your invoice numbers directly.
• A fixed cadence: the run arrives on a predictable date, which is the one thing working in your favour.

The deduction problem

The hardest part of a supermarket run is not the volume; it is the deductions. The buyer pays the invoice total minus a set of charges, and those charges may or may not correspond to credit notes in your system. If you have raised matching credit notes, you allocate them and the run balances. If you have not, the shortfall looks like a part-payment against invoices that were actually paid in full, and the arithmetic drifts.

A reconciliation routine that holds up monthly

• Map references first: build or reuse a lookup from the buyer's reference scheme to your invoice numbers, so matching is a join, not a search.
• Separate clean lines from deductions: settle the fully paid invoices, then work the deductions as a distinct list.
• Classify each deduction: credit note already raised, credit note to raise, or dispute to lodge.
• Batch within the cap: group the settled invoices into batches of 50 or fewer and record each as a batch deposit.
• Reconcile the single bank line against the batches once every batch balances and deductions are accounted for.

Make next month faster than this month

Because the run repeats, every bit of structure you add compounds. A stable reference mapping, a consistent invoice numbering scheme, and a saved routine turn a full morning into an hour. The buyer will not change how they pay to suit you, so the leverage is entirely on your side of the ledger.

This is also where automated matching pays back fastest, because the same buyer pays the same way every cycle. A tool that learns the buyer's reference scheme, nets the deductions, and proposes a balanced allocation across dozens of invoices turns the monthly set-piece into a review. You still decide which deductions to accept and which to dispute; you just stop doing the transcription to get there.