Picture a bank account with three hundred payments landing in it in one day. On its own, that is a full day's work for someone matching deposits to invoices. Now picture four such accounts, all landing on the same desk, every single day. That is what an 8-person accounting firm in Bristol was dealing with.
The firm works with online brands that sell through Shopify, Amazon, Stripe and PayPal, sometimes all four at once. Every payment looks a little different depending on where it came from. Fees are calculated differently. Refunds settle on a different clock. The firm was good at this kind of work, which is exactly why fast-growing online brands kept choosing them. But as their clients grew, the number of payments grew with them, and a small team started falling behind.
Money coming in from different countries needed sorting. Tax treatment changed depending on where a customer or a warehouse sat. Reports that used to go out by the 5th working day of the month were going out by the 20th, sometimes later.
Clients notice that. Late numbers mean late decisions, and a growing e-commerce brand makes stock, pricing and hiring calls off its numbers every week, not once a quarter.
It Wasn't a Backlog Problem. It Was Four Different Payment Languages
The instinct when reports start slipping is to assume the team needs to work faster, or that someone needs to come in on a Saturday to catch up. That instinct misses what was actually happening on this firm's desk. The problem was not volume alone. It was that four platforms don't just send money on four different schedules, they describe that money in four different ways.
A Shopify payout, an Amazon settlement, a Stripe transfer and a PayPal withdrawal are not the same shape of transaction wearing a different logo. Each one nets different fees against the sale before it ever reaches the bank, on a different timetable, in a report formatted for that platform's own reconciliation tools. Treating all four like one generic "sales deposit" is exactly how firms end up with unexplained gaps that only get investigated once a client asks why the numbers don't tie out.
A firm reconciling by hand across four platforms is really running four separate reconciliation processes in parallel, for every client, every day. Add a second e-commerce client and the work does not double. It compounds, because now there are eight processes running in parallel, and the team doing it is still the same eight people.
How Shopify, Amazon, Stripe and PayPal Payments Actually Reconcile
Reconciling a platform payout means matching what lands in the bank against what the platform says it collected and deducted, order by order, fee by fee. The mechanics differ enough between platforms that a process built for one will misfire on another.
| Platform | What makes it different to reconcile |
|---|---|
| Shopify Payments | Payouts land on a rolling, near-daily basis, net of card processing and app fees, so a month's sales arrive as dozens of smaller deposits rather than one lump sum. |
| Amazon | Settlements typically land roughly every fortnight and bundle thousands of individual orders into one payout, with referral fees, fulfilment fees and advertising spend all netted out before it reaches the bank. |
| Stripe | Payout timing is configurable per account, and a single Stripe account can carry multiple currencies and products, so the same client's Stripe feed can behave differently month to month. |
| PayPal | Balances often sit until withdrawn on demand rather than on a fixed schedule, and buyer disputes or holds can delay funds reaching the bank well after the original sale was recorded. |
None of this is a reason to avoid the work. It is a reason to treat each platform as its own reconciliation, cleared on its own terms, before the results get combined into one set of management accounts. Skip that step and a mismatch on one platform gets buried inside a combined total that still looks roughly right, right up until it doesn't.
Where Firms Lose the Race Against the Calendar
Watching firms take on more e-commerce clients, the same patterns show up again and again once volume outgrows the team.
Waiting for month-end to reconcile. A month of unreconciled transactions across four platforms is not four times the work of a week. It is a queue where every unresolved item makes the next one harder to trace, because the trail of what happened when has gone cold.
Treating refunds and chargebacks as an afterthought. A refund processed by Amazon two weeks after the original sale needs to be matched against that sale, not dropped into a general adjustments account to be sorted out later. Later is when the reporting deadline is already close.
One unmatched payment is a five-minute fix. The same gap, repeated across four platforms and multiple clients because nobody caught it same-day, becomes the reason a report that should take an afternoon takes a week.
Assuming a general bookkeeper can pick up e-commerce work without a shift in process. Bookkeeping for a single UK business with one bank feed and a handful of suppliers is a genuinely different job to bookkeeping for a brand selling across four platforms and multiple currencies. The software skills overlap. The daily discipline required does not.
Letting supplier bills queue behind sales reconciliation. Firms under pressure naturally prioritise the sales side because that is what the client asks about first. Supplier bills left unprocessed for weeks turn into the same kind of backlog, just on the other side of the ledger, and it surfaces at exactly the same reporting deadline.
A Practical Framework for Daily Multi-Channel Reconciliation
The firms that keep pace with growing e-commerce clients share one habit: they stop treating reconciliation as a period-end task and treat it as a daily one.
- Reconcile each platform separately first. Match Shopify, Amazon, Stripe and PayPal against the bank on their own terms before combining anything into one view. Combining early hides exactly the mismatches you need to see.
- Do it the same day the payout lands, not the same week. A payout is easiest to trace back to its orders on the day it arrives. A week later, the platform's own reporting window may have moved on, and the trail gets harder to reconstruct.
- Give refunds and chargebacks their own checklist. They arrive out of sequence with the original sale and need a deliberate match, not a general adjustment entry that gets tidied up "later".
- Keep supplier bills on the same daily cadence as sales. A books close is only as current as its slowest side. Letting payables lag behind receivables just moves the backlog, it doesn't remove it.
- Close each day before the next one starts. The moment reconciliation falls behind by more than a day, every subsequent day inherits the previous day's unresolved items on top of its own.
Are your e-commerce clients' reports arriving later than they should?
Speak to a qualified CA about building a daily reconciliation process that runs overnight, so your team starts each morning with books that are already current.
Book a free 30-minute consultationWhy This Needed a Dedicated Overnight Team, Not Another Spreadsheet
The Bristol firm did not have a skills problem. It had a clock problem. Four clients, four platforms, hundreds of payments a day, and a team of eight who also had to review the work, talk to clients and run the rest of the practice during UK business hours. No template or software shortcut changes the fact that daily reconciliation across four platforms takes daily hours, and those hours were already spoken for.
We stepped in to handle one clear part of the job: checking and matching all these payments every day. Matching money coming in against what each platform said was owed. Sorting out anything that didn't match. Handling supplier bills. All of it done overnight, so the firm's own team starts each morning with books that are already up to date, not weeks behind.
This is the same structural logic behind any working dedicated offshore team model: a named team working inside the firm's own software, on a defined slice of the work, so the firm's own staff spend their time reviewing and advising rather than matching transactions at midnight to keep up. The firm keeps the client relationship, the final numbers and the professional sign-off. What changes is that the daily grind of reconciliation stops competing with everything else eight people are trying to do during the same eight hours.
What Changed on the Ground
Reports now go out by the 5th working day. Not the 20th. That is not a productivity trick, it is the direct result of the backlog no longer existing by the time month-end arrives. When each day's payments are already matched, closing the month is a review exercise, not an archaeology project.
Clients notice when reports arrive on time, every time. This firm's client retention shows it. A brand that gets its numbers on the 5th working day can act on last month's performance while it is still relevant. A brand that gets them on the 20th is already a third of the way into deciding on stale information, and every one of its competitors selling on the same platforms knows it.
If your reports keep slipping later than they should, the fix usually isn't a faster spreadsheet or a weekend catch-up session. It's separating daily reconciliation from monthly reporting, and giving the daily work somewhere dedicated to land. Published pricing is on the website, and a free 30-minute consultation is the fastest way to see what that would look like for your own client mix.
