Marketplace reconciliation is one of the most time-consuming jobs in retail finance, and much of the automation sold to finance teams doesn’t have as much impact on it as it should. Cash reconciliation is the single most time-consuming part of month-end for most finance teams, taking 20 to 50 hours a month on average (Ledge, 2025 month-end close benchmarks), and for retailers selling through Amazon or Shopify, marketplace settlements are a large part of it.
The reason it takes so long is the format in which the money arrives. Amazon pays out one or two bank credits a fortnight, and each has already had referral fees, FBA fees, storage, advertising, refunds, reimbursements and a reserve movement deducted. Referral fees vary by category, advertising is netted off rather than invoiced, a standard reserve holds funds for seven days after delivery and longer if Amazon applies an account-level reserve (WorldFirst), and last month’s refunds are set against this month’s orders. Shopify payouts have the same shape, with chargebacks in place of reserves.
Getting this wrong has three costs:
- Understated revenue. Booking the net payout as revenue records sales after Amazon’s fees have been deducted, so reported turnover is lower than what customers actually paid.
- VAT errors in both directions. UK VAT is due on the gross sale to the customer, so booking net under-declares output VAT. And since August 2024 Amazon charges 20% UK VAT on its fees to UK sellers, so fees that are never separated out are reclaimable input VAT that never gets reclaimed (Armstrong Watson).
- Unchallenged fees and unclaimed reimbursements. Fees that are never reconciled are never checked for errors, and Amazon’s reimbursements for lost or damaged FBA stock go unclaimed because nobody is looking for them
Why a settlement can’t be matched like a payment
If you sell through Amazon or any marketplace that nets its fees before paying out, there is no set of individual payments to match. The finance team is working backwards from a single net figure to gross sales, each category of fee, the refunds and the reserve, and deciding the VAT treatment of every line as it goes. That is accounting work that takes days each month is done in a spreadsheet.
Why general finance automation doesn’t solve it
Two shortcuts are common. Booking the net payout as revenue is fast but ultimately the wrong way, for the reasons above. Exporting the settlement and building a bigger spreadsheet is the manual work described above.
The third response is understandable, because AP, expense and card tools do automate reconciliation, for the payments they are built around: a business’s own outgoing payments against invoices and receipts. They have no concept of a marketplace fee schedule, a referral rate that varies by category or a rolling reserve, so they cannot read a settlement file, and pointing one at the marketplace changes nothing.
So what does automate marketplace reconciliation?
What you need is a tool built to read settlement reports. The category goes by several names, marketplace settlement reconciliation, e-commerce accounting automation or marketplace bookkeeping software, and UK sellers commonly use A2X, Link My Books or Synder.
These connect to Seller Central and Shopify, read each settlement at line level, split it into gross sales, each fee type, refunds, reimbursements and reserve movements, apply the VAT treatment per line, and post summarised journals to Xero, Sage or QuickBooks that agree to the bank credit.
For a £41,000 payout, the journal might show £54,200 gross sales, £8,100 referral fees, £3,300 FBA fees, £900 advertising, £1,400 refunds, £400 reimbursements and £600 moved to reserve. Reconciliation becomes a journal-to-bank check that takes minutes.
Match the tool to the direction of money
Money arriving through a marketplace needs a tool that reads settlements. Money leaving the business, through supplier invoices, company cards and employee expenses, is a mature automation category with plenty of options, and it absorbs a lot of finance hours as well.
A team losing its week to Amazon will get that week back from a settlement tool. A team losing its week to supplier invoices, card statements and expense claims should look at the outgoing side, which is where Moss sits. It automates invoice processing, card spend and reimbursements, but has no role in reconciling marketplace payouts.
What changes
With a settlement tool in place, the fortnightly payout arrives with its journal already posted and agreeing to the bank line, and the management accountant’s job is a ten-minute check rather than a week of rebuilding. The time that comes back can go on the analysis the team has been missing, such as which SKUs’ fees are eroding margin.
