Weekly ecommerce tips, deals & news.
A reconciliation error is a gap between what your store says it earned and what actually reached your bank account. It shows up when you match orders against payouts and deposits, and the numbers won’t line up. Some gaps have a harmless reason, like a payout still in transit. A true reconciliation error is a difference you can’t explain yet.
A reconciliation error works by hiding between your orders, your processor’s payouts, and your bank statement. Each record is correct on its own terms. However, each one counts money at a different moment and in a different way. So the error appears only when you can’t trace a difference back to a known cause.
Think of it like a grocery receipt and the bag you carry home. The receipt lists everything you paid for. Yet the bag might be missing an item you returned at the counter, or one left behind at the till. To check the bag, you work through the receipt line by line.
WooCommerce records the full price the customer paid. Your payment processor then subtracts its fees and holds the rest for a while. Later, it sends a lump-sum payout that mixes many orders together. So the deposit in your bank rarely matches any single number in your WooCommerce reports.
Most reconciliation errors trace back to a short list of causes:
For example, fees and refunds explain most of a normal month’s gap. By contrast, an unpaid manual order costs the full order value. So a gap that suddenly grows deserves a closer look than one that stays steady.
Reconciliation is a matching exercise done in three steps. First, you export the period’s orders, including refunds and order status. Next, you match those orders to each processor payout, line by line. Then you match each payout to a deposit on your bank statement.
In practice, every difference you find gets a label, such as a fee, a refund, or a payout in transit. Whatever is left without a label is the reconciliation error. As a result, that leftover amount is the number worth chasing.
Reconciliation errors matter because small businesses already struggle with cash timing. In the Federal Reserve’s Small Business Credit Survey, 51% of firms cited uneven cash flows as a financial challenge. A gap you can’t explain makes that problem harder to plan around.
Fees are the most predictable part of the gap. For example, Federal Reserve data puts the average debit card interchange fee at $0.34 on a $46.32 purchase. What’s more, that’s before your processor adds its own charges. Timing adds another layer, since manual processor payouts typically take 1–4 business days to reach your bank.
Exports are how most stores get order data into their books. Visser Labs reports that its Store Exporter Deluxe plugin is trusted on 20,000+ stores. Still, no public benchmark tracks how often store books fail to reconcile. So treat these figures as the moving parts of the gap, not an error rate.
Reconciliation errors hide longest in orders that never touch your card processor. A bank transfer or check order has no payout to match against. If staff mark it as paid by mistake, nothing flags it automatically. Likewise, a chargeback can arrive weeks after the sale, landing in a different month’s payout.
A reconciliation error in practice usually starts as a month-end total that feels a little low. Here’s a hypothetical example. Imagine a small candle store called Fern & Wick that sells online and to a few local gift shops.
At the end of the month, WooCommerce shows $24,600 in sales across 600 orders. However, the bank statement shows only $21,403 in deposits. That’s a gap of $3,197. The owner, Priya, assumes it’s just fees and nearly moves on.
Instead, Priya exports the month’s orders and labels each part of the gap. Processing fees account for $890. Refunds on six orders account for another $410. On top of that, one chargeback cost $62 plus a $15 dispute fee.
Next, she checks the last two days of the month. Those sales, worth $1,180, were still in transit and landed the following week. That part is a timing difference, so it isn’t an error at all.
Altogether, the labeled items explain $2,557. That leaves $640 with no label. Tracing it, Priya finds a gift-shop order paid “by bank transfer” and marked as Processing. The money never arrived, but the order shipped anyway.
Priya emails the gift shop and collects the $640 within a week. Then she changes her routine. Manual payment orders now stay On Hold until the deposit appears in the bank.
She also sets up a weekly order export instead of a monthly one. As a result, any future gap is a week old, not a month old. In short, the $640 was only found because she refused to call the whole gap “fees.”
You prevent reconciliation errors by reconciling often and with clean data. The shorter the period, the fewer orders you have to trace. These habits help most:
Clean exports make every step faster. For that reason, many stores schedule a regular order export straight to their bookkeeper. Visser Labs explains how to reconcile WooCommerce with QuickBooks using an export-based method. Its Store Exporter Deluxe plugin can schedule order exports and deliver them by email, FTP, or to cloud services.
Finally, keep a running log of every gap you label. Over a few months, patterns appear, such as one payment method that always runs late. Those patterns tell you which step to fix first.
| What you’re comparing | Reconciliation Error | Timing Difference |
|---|---|---|
| What it is | A gap with no known cause | A gap with a known, temporary cause |
| Does it clear itself? | No, someone has to find it | Yes, once the money lands |
| Typical example | An unpaid order marked as paid | A payout still in transit |
| What to do | Trace it to the source record | Note it and check next period |
A reconciliation error needs action, while a timing difference only needs patience. However, the danger is mixing them up. If you label every gap as timing, a real error can roll forward month after month.
That’s why a timing difference should always carry an expected date. If the money hasn’t landed by then, treat it as an error. By contrast, a gap caused by typing a wrong figure is a data entry error, which reconciliation often uncovers.
Your WooCommerce total shows gross sales, while your bank shows net payouts. Processing fees, refunds, chargebacks, and payouts still in transit all sit between the two. Label each of those first, then chase whatever amount is left over.
Weekly works well for most small stores, and daily suits high-volume ones. Monthly is the minimum, since your books need to close each month. The longer you wait, the more orders you have to trace.
Record the gross sale and the processing fee separately. Booking only the net payout hides your true fee costs and makes refunds harder to trace. Most bookkeepers recommend the gross method for exactly this reason.
A reconciliation error matters because it means money you think you have may not exist. Left alone, small gaps hide unpaid orders, missed refunds, and growing fees. Regular reconciliation turns those surprises into quick, routine fixes.
Copyright © StoreOwnerTips.com. All Rights Reserved.
