Key takeaways
- Ecommerce payment reconciliation matches three records: orders in the store, payouts from payment providers and receipts in the bank.
- Marketplaces add a fourth: funds held for sellers, which may be customer money under payments regulation.
- Fees, refunds, partial captures, currency conversion and payout timing cause most differences.
- A marketplace that holds seller funds should reconcile what it owes sellers against what it holds, every day.
What ecommerce payment reconciliation is
An online business takes payments through one or more providers, such as a card processor, a wallet and a buy-now-pay-later provider. Each provider pays out on its own schedule, net of its fees. Ecommerce payment reconciliation confirms that every order was paid, every payment was paid out, and every payout reached the bank.
The method is the same three-way match used across payments: the store's order records, the provider's transaction and payout reports, and the bank statement. Our guide to what payment reconciliation is covers the general method; this guide focuses on what is specific to online selling.
What makes ecommerce different
Orders and payments do not line up neatly. A customer may pay in two parts, have one item refunded, or pay in a different currency from the store's. Card payments can be authorised when the order is placed but captured only when it ships. Some providers pay daily, others weekly. Discounts, gift cards and store credit reduce the cash received without reducing the order value.
Marketplaces add another layer. A marketplace collects money from buyers and pays sellers later, after deducting its commission. Between collection and payout, it holds seller funds. In the UK and EU, a marketplace that holds funds for sellers may be providing a regulated payment service unless it uses a licensed provider or falls within an exclusion, and in the US the same activity can require money transmission licences. That makes the funds held for sellers a customer-money balance, not just a payable.
Worked example: a marketplace payout cycle
A marketplace collects $1.24 million from buyers in a week. It deducts its 12% commission and processing costs, and owes sellers the rest. Payouts to sellers run every Friday. Until then, the marketplace holds the sellers' money.
The reconciliation checks that the funds held in the marketplace's seller funds account equal the total it owes sellers, after refunds and disputes. If the account holds less, the marketplace has used seller money for something else, even briefly, which is exactly the risk payments regulation exists to prevent.
| Line | Amount (USD) |
|---|---|
| Buyer payments collected | 1,240,000.00 |
| Less refunds | (31,500.00) |
| Less marketplace commission (12% of net sales) | (145,020.00) |
| Owed to sellers | 1,063,480.00 |
| Held in seller funds account | 1,063,480.00 |
| Difference | 0.00 |
Controls that scale
Load provider reports automatically rather than downloading them by hand. Match payouts to bank receipts by payout reference. Match orders to payments by order identifier. Keep seller funds in a separate account and reconcile it daily against the amount owed to sellers. Record every difference with a cause.
Safeheld reconciles provider payouts, ledgers and bank accounts, and tracks funds held for others against what is owed. See settlement reconciliation and Safeheld reconciliation.
Frequently asked questions
What is ecommerce payment reconciliation?
Matching store orders, payment provider payouts and bank receipts, and explaining every difference.
Why do payouts differ from order totals?
Providers deduct fees, refunds and disputes, and pay on their own schedules and in their own currencies.
Are marketplace seller funds regulated?
They can be. Holding funds for sellers may be a regulated payment or money transmission activity unless an exclusion applies or a licensed provider is used.
How often should a marketplace reconcile seller funds?
Daily, comparing funds held with the amount owed to sellers.
References
About Safeheld
Safeheld reconciles client money every day, resolves every difference and prepares every regulatory return for sign-off, for regulated firms in the United States, the United Kingdom, the European Union, Canada, Australia, Singapore and Hong Kong. To discuss your operations, contact us at safeheld.com/contact.
This article is for general information and does not constitute legal or regulatory advice.