Automate grocery remittance matching inside Xero
Supermarket remittances are some of the most complex in any industry. Hundreds of line items, promotional deductions, negative-value credits, and formats that change by retailer. RemitClear matches them against your Xero invoices automatically. Tested at 100% accuracy across ASDA, Sainsbury's, NISA, and more.
Trusted by finance teams in Australia and the UK
The Problem
Grocery remittances are a different beast
If you supply to UK supermarkets, your remittance advices look nothing like a standard payment notification. A single Sainsbury's remittance can contain 200+ line items across dozens of pages. Tesco remittances run 10-30 pages. Even a routine ASDA payment is 2-8 pages of PDF.
Each remittance mixes standard invoice payments with promotional deductions (retro promotions, fixed discounts, volume rebates), negative-value credit lines, and reference formats that differ by retailer. Matching these against open Xero invoices manually means opening the PDF, cross-referencing line by line, handling the deductions separately, and reconciling the net payment, often across multiple supplier accounts.
For bookkeeping practices managing grocery retail clients, this is the single most time-consuming reconciliation task in the practice. One practice we work with estimates 20 pages per remittance on average across their grocery clients, with remittances arriving weekly from each retailer. That is hours of manual matching every single week.
The formats are the problem. Grocery retailers each use their own remittance layout, their own invoice reference conventions, and their own approach to deductions. A tool that works for simple one-page B2B remittances breaks down when it meets a 214-line Sainsbury's payment run.
The Solution
RemitClear handles the complexity that grocery remittances demand
Upload your supermarket remittance PDF and RemitClear extracts every line item, invoice payments, deductions, credits, matches each invoice line against your open Xero invoices, and posts the payment batch directly into Xero.
How it works for grocery retail suppliers:
1. Upload the remittance
PDF from ASDA, Sainsbury's, Tesco, NISA, Morrisons, Waitrose, Blakemore, Co-op, or any other UK grocery retailer. Drop it into RemitClear or forward the email.
2. OCR extraction across every line
RemitClear reads the full remittance, even 200+ line documents, and extracts invoice numbers, amounts, and deduction codes. It handles the different formats each retailer uses without manual configuration.
3. Automatic matching against Xero
Each extracted line is matched against your open Xero invoices. Part payments, overpayments, and negative-value credit lines are all handled. Deduction lines (retro promotions, rebates, fixed discounts) are identified and flagged separately.
4. Review and post
Approve the matches and RemitClear posts the batch payment into Xero with the original remittance attached as an audit document. For remittances exceeding Xero's batch limit, RemitClear splits automatically into sequential batches.
Proof
Tested on real supermarket remittances
RemitClear has been tested against real remittance advices from UK grocery retailers, using live Xero data:
100% match rate on tested samples
100% match rate on tested samples, including all-negative-value formats
100% match rate on tested samples
RemitClear has processed remittances with 600+ invoice lines in a single document, extracting every line item, flagging part payments and promotional deductions, and matching invoices against Xero automatically. These are not synthetic test files. They are real remittances from real grocery suppliers, tested with live Xero data.
Formats tested and supported
ASDA
PDF remittances, 2-8 pages, including all-negative formats
Sainsbury's
Excel/CSV remittances, 100-200+ lines, including retro promotion codes (RP/DB/FD)
Tesco
PDF remittances, 10-30 pages
Morrisons
Email-body remittances, 10-20 lines
Waitrose
Email-body remittances, 10-20 lines
NISA
PDF remittances, multi-page
Blakemore
PDF remittances, typically single-page
Co-op
PDF and CSV remittances, including negative-value credit deduction lines
Edge Cases
Built for the edge cases that break other tools
Grocery remittances are full of edge cases. RemitClear handles them:
Negative-value lines
Co-op and other retailers include credit deductions as negative amounts on their remittances. RemitClear processes these correctly rather than treating them as credit notes, a distinction that matters for accurate Xero reconciliation.
Promotional deductions
Sainsbury's remittances include retro promotion credits (RP codes), fixed discount deductions (FD codes), and volume rebates (DB codes). RemitClear identifies and flags these line types so your team can allocate them to the correct cost codes in Xero. Invoice matching is automated; deduction coding is surfaced for review because every practice charts these differently.
200+ line remittances
A single Sainsbury's payment run can contain 200+ invoices. RemitClear processes the full document in one pass. Where the remittance exceeds Xero's 200-invoice batch payment limit, RemitClear splits it into sequential batches automatically.
Part payments and overpayments
Grocery retailers frequently pay less or more than the invoiced amount due to deductions, promotions, or timing. RemitClear handles partial and over-allocations, flagging discrepancies for review.
Mixed formats across retailers
ASDA sends PDFs. Sainsbury's sends Excel files. Morrisons sends email-body remittances. RemitClear handles all three without requiring you to change your workflow per retailer.
Who It Is For
For grocery suppliers and the bookkeepers who manage them
RemitClear is built for:
Grocery and FMCG suppliers who invoice supermarkets and receive complex multi-page remittance advices
Bookkeeping practices managing clients who supply to ASDA, Sainsbury's, Tesco, Morrisons, Waitrose, NISA, Co-op, Blakemore, or other UK grocery retailers
Finance teams spending 4+ hours per week on remittance matching across multiple retailer accounts
If your clients' remittances regularly exceed 10 pages or 50 invoice lines, and you are matching them manually in Xero, RemitClear eliminates that workflow.
Product Demo
See RemitClear in Action
Remittance document
Remittance_April_2025.pdf
142 KB
Xero invoice matching
Waiting for extraction...
Posted to Xero
Payments recorded successfully
FAQ
Frequently Asked Questions
Does RemitClear work with ASDA remittance advices?
Yes. RemitClear has been tested against real ASDA remittance advices with a 100% match rate. It handles ASDA's PDF format, including remittances where every line is a negative value.
Can RemitClear handle Sainsbury's remittances with 200+ lines?
Yes. RemitClear has processed remittances with 600+ invoice lines in a single document. It handles Sainsbury's Excel and CSV formats at 100% accuracy, and identifies promotional deduction codes (RP, DB, FD), flagging them for separate cost code allocation.
Does RemitClear support Tesco, Morrisons, and Waitrose formats?
Yes. RemitClear supports PDF remittances from Tesco (typically 10-30 pages), email-body remittances from Morrisons and Waitrose (typically 10-20 lines), PDF remittances from NISA, and single-page remittances from Blakemore. If your retailer is not listed here, send us a sample and we will confirm compatibility, usually same day.
How does RemitClear handle promotional deductions and rebate codes?
Grocery retailers like Sainsbury's include retro promotions, fixed discounts, and volume rebates as deduction lines on their remittances. RemitClear identifies these line types and flags them for review. Invoice matching is automated, but deduction coding is surfaced separately because every practice allocates these to different cost codes in Xero.
Can RemitClear process Co-op remittances with credit deductions?
Yes. Co-op remittances include negative-value credit deduction lines. RemitClear processes these correctly as negative amounts rather than misclassifying them as credit notes. This was a specific edge case we built for and tested against real Co-op remittance data.
I manage multiple grocery retail clients as a bookkeeping practice. Can I use RemitClear across all of them?
Yes. RemitClear works per Xero organisation, so you can set it up for each of your grocery retail clients. Bookkeeping practices managing multiple clients get the biggest time saving because the same remittance matching pain repeats across every client who supplies to supermarkets. One setup per client, and the format handling works across all supported retailers without per-retailer configuration.
Related Solutions
Xero Remittance Matching
The core RemitClear workflow for any Xero organisation receiving remittance advices.
Multi-Invoice Payment Matching
Handle remittances where a single payment covers dozens or hundreds of invoices.
Automated Cash Application
End-to-end cash application automation purpose-built for Xero.
Send us your worst supermarket remittance
Book a 30-minute demo. Bring the longest, messiest remittance your clients receive, Sainsbury's 200-liner, ASDA negatives, Co-op credit deductions, and we will process it live on the call.
Or email jacob@remitclear.com with 2-3 sample remittances and we will test them before we talk.