How do I automate marketplace payment reconciliation?
How small D2C brands can automatically match marketplace and payment-gateway settlements to orders, fees and returns, and where AI helps with exceptions.
Anadoris Digital · · 4 min read

Selling on your own website and two or three marketplaces means money arrives from many places: marketplace settlements, payment gateways, courier companies remitting cash-on-delivery collections. Each sends its own report in its own format, with fees, commissions, refunds and adjustments mixed in. Checking that you received what you were owed is tedious, so many small brands simply do not do it regularly.
That is risky. Missed payouts, wrong fee deductions, refunds charged twice and COD remittances that never arrived can go unnoticed for months. Reconciliation turns those settlement reports into a clear answer for every order: paid, partly paid, pending or missing.
What needs to be matched
- Marketplace settlements: sale amount, commission, shipping fees, other fees, taxes withheld and adjustments per order.
- Payment gateway settlements for prepaid website orders, with gateway charges.
- COD remittances from couriers or shipping aggregators.
- Refunds and returns, including reverse shipping charges.
- Bank receipts, so you can confirm settlements actually arrived.
Rules do most of the work
The core of reconciliation is matching, and matching is mostly rules, not AI. Each settlement line carries an order ID, and each order in your system should carry the same ID. Automated imports read each report, map its columns to a common format, and match line by line. Totals per settlement are then matched against bank receipts.
Payment gateway reports for website orders are usually the simplest to match, because each payment carries the order reference. Marketplace reports are more complex, with several lines per order spread across different settlement periods. Expect to group lines by order before comparing.
Once matched, each order can be compared with what you expected: the selling price minus the commission and fees you agreed to. Differences beyond a small tolerance become exceptions for review.
Expected amounts require knowing your fee structure. Record commission rates, fixed fees, shipping charges and any category-specific terms for each channel, with the date they apply from. Marketplaces change fees from time to time, so the record needs an owner who updates it when notices arrive. Without it, every difference looks like an error, or none do.
Where AI helps
AI is useful at the edges of the process, where rules struggle.
- Reading new or changed report formats and suggesting how columns map to your structure.
- Explaining unfamiliar fee or adjustment descriptions in plain language.
- Grouping exceptions by likely cause, such as a fee rate change, a return not yet processed or a missing COD remittance.
- Drafting dispute or query messages to marketplace support, with the order details attached, for a person to send.
- Summarising each month’s position for the founder or accountant.
AI should not decide what is correct. Fee structures, tax treatment and disputes need a person who understands the contracts, and final entries should be reviewed by your accountant.
Keep an audit trail. For each exception, record what was found, what action was taken, any ticket number with the marketplace, and the outcome. This history helps with future disputes, shows your accountant how each difference was resolved, and reveals whether the same problem keeps recurring with a particular channel or courier.
A reconciliation checklist
- Consistent order IDs across your store, marketplaces and shipping tools.
- Settlement reports downloaded on a fixed schedule from every channel.
- Agreed fee and commission rates recorded per channel and category, so expected amounts can be calculated.
- Automatic matching of settlement lines to orders.
- Settlement totals matched to bank receipts.
- An exception list reviewed weekly, with an owner for each type.
- Fee and commission records updated whenever a channel announces a change.
- Disputes tracked to resolution, with dates.
- COD remittances matched to delivered orders, with overdue amounts chased by a named owner.
Common gaps it uncovers
Once reconciliation runs regularly, the same issues tend to appear: orders delivered but never settled, returns where the refund was deducted but the product never came back, fees charged at a different rate than expected, and COD collections remitted late or not at all. Finding these early matters because marketplaces and couriers often have time limits for raising claims.
Cash on delivery deserves special attention. Couriers and aggregators collect cash on your behalf and remit it later, sometimes after deducting charges. Match every delivered COD order to a remittance line and chase anything delivered longer ago than your agreed remittance cycle. These gaps are easy to miss because nothing visibly fails; the money simply does not arrive.
Where to start
Choose the channel with the most orders. Download three months of its settlement reports and match them to your orders in a spreadsheet, noting every mismatch. That manual pass shows what rules you need and how messy the data is. Then automate the import and matching for that channel before adding the next. Anadoris Digital can build reconciliation into your ERP so settlements, orders and bank receipts meet in one place.
Related service: AI & Automation · More on this topic: AI & Automation articles
