The Real Cost of Manual Reconciliation for Online Retailers

Manual reconciliation costs online retailers in four ways: staff hours spent downloading and matching reports, errors that slip into the books, money that is never recovered because short payments and fee mistakes go unnoticed, and slower decisions because the numbers arrive late. The wage cost is the most visible, but for multichannel sellers the missed recoveries and delayed decisions are often larger. Measuring all four is the first step to deciding whether automation is worth it.

Where the hours go

A typical manual process for one marketplace looks like this: log in, download the settlement file, clean it in a spreadsheet, look up each order in the order system, compare amounts, investigate differences, then post a journal to the accounting system. Repeat for every channel, every cycle.

The cycle itself drives the workload. Amazon.com.au, for example, closes a settlement every 14 days (Amazon Seller Central, 2026), so a seller on Amazon alone faces around 26 settlement files a year. Add eBay, Kogan, BIG W Market, a Shopify store and a buy now pay later provider, each with different file layouts and timing, and reconciliation becomes a permanent part-time job.

The volume of rules adds to it. Amazon AU's fee schedule lists referral fees that vary by category, several with price thresholds where the rate changes (Amazon Seller Central, 2026). Checking each order's fee by hand against the right rule is slow, so in practice most manual processes skip it.

The error problem

Manual work under time pressure produces mistakes. In a Gartner survey of 497 people working in controllership roles, 18% of accountants said they make financial errors at least daily, a third make several a week and 59% make several a month (Gartner, 2024). The same research linked errors to capacity: 73% of accountants reported that new regulations had increased their workload over the previous three years.

In reconciliation, typical errors include matching a refund to the wrong order, double-counting a payout that spans two months, booking fees net instead of gross, and treating GST-exclusive fees as GST-inclusive. Each one takes longer to find and fix later than it would have taken to prevent.

The cost nobody sees: unrecovered money

The biggest hidden cost of manual reconciliation is what does not get checked. When the team is short of time, the goal becomes "make the totals agree", not "prove every order was paid correctly". That leaves:

• shipped orders that were never paid, or paid short;
• fees charged at the wrong category rate;
• refunds processed without the matching fee credit;
• reserves or reimbursements that were never released.

The longer a discrepancy sits, the harder it is to evidence. Amazon's settlement downloads, for example, remain available for 90 days after they are generated. Once the evidence is hard to find, the claim is usually abandoned. See hidden marketplace fees for where these leaks most often occur.

Slow books, slow decisions

Reconciliation is usually the longest task in the month-end close. APQC benchmarking of around 2,300 organisations found a median of 6.4 calendar days to complete the monthly close, with the slowest quarter taking 10 days or more (CFO.com/APQC, 2018). For a retailer, a week-long close means pricing, ad spend and stock decisions for the new month are made on last month's estimates. Our month-end close checklist shows how to shorten it.

How to put a number on it

You can estimate your own cost in an afternoon:

1. Hours. Time one full reconciliation cycle per channel. Multiply by cycles per year and by the loaded hourly cost of the person doing it.
2. Errors. Count journal corrections and BAS adjustments over the last year, and estimate the time each took.
3. Recoveries. Take a sample of one month and check every order properly. Whatever you find that was short-paid or overcharged, multiply by twelve as a rough annual figure.
4. Delay. Note how many days after month end you have reliable channel profit numbers.

Be realistic about benefits, too. CPA Australia's 2025-26 small business survey found only 30% of Australian small businesses said their technology investment improved profitability (CPA Australia, 2026). Software helps when it removes real hours and recovers real money, so choose tools you can measure against the baseline above.

Key figures

• 18% of accountants make financial errors at least daily, and 59% make several a month (Gartner, 2024).
• 73% of accountants say new regulations increased their workload over three years (Gartner, 2024).
• The median monthly close takes 6.4 calendar days; top performers take 4.8 days or less (CFO.com/APQC, 2018).
• 39% of finance functions using AI apply it to anomaly and error detection (Gartner, 2024).
• Only 30% of Australian small businesses said technology investment improved profitability in 2025 (CPA Australia, 2026).

How eComChannels helps

eComChannels Finance auto reconciliation replaces the download-clean-match routine. It collects remittances and settlements from connected marketplaces, matches every line to orders in eComChannels order management, and applies your fee rules to check each charge. Your team only reviews the exceptions: short payments, unexpected fees, unmatched refunds and unreleased reserves.

That cuts the hours spent on each cycle, reduces the manual keying where errors creep in, and turns missed recoveries into a working list of claims to raise. Because reconciled data is ready soon after each payout, channel profit figures are available days earlier, which shortens the month-end close. Book a demo or start a 30-day free trial.

FAQ

How long should marketplace reconciliation take?

It depends on order volume and the number of channels. With automation, the matching itself should be close to instant; human time should go only on investigating exceptions.

Is a spreadsheet good enough for reconciliation?

For one channel and low volumes, it can be. As channels, fee rules and order counts grow, spreadsheets become slow and error-prone, and order-level fee checks usually get skipped.

What should I automate first?

Start with the channel that has the most orders or the most complex fees. That is usually where the most hours and the most unrecovered money sit.