None of these look like mistakes at the time
Ask a seller to describe a mistake they've made tracking a payout, and most will struggle to name one — not because they haven't made any, but because the ones that matter most don't announce themselves. The deposit still looks roughly right. The payout still arrives. Nothing throws an error.
That's exactly what makes the ten below worth listing explicitly. Each one produces something that looks fine on the surface — right up until a seller adds up a full quarter of payouts against gross sales and finds a gap no one can immediately explain.
None of the ten below are hypothetical edge cases dreamed up for effect — each is a pattern that recurs across sellers of very different sizes and marketplaces, the ordinary, unremarkable ways a payout quietly drifts out of sync with what a sales report says it should be.
1 · A reserve hold treated as a shortfall
A marketplace holds back part of a payout as a buffer against future refunds or disputes, and the seller reads the smaller-than-expected deposit as a shortfall — a fee that was too high, a sales figure that was wrong — without checking whether the settlement report actually shows a reserve line explaining the gap.
The reserve isn't lost money. It's released later, sometimes weeks or months on, as a separate deposit that, without the original context, looks like an unexplained windfall rather than what it actually is.
The tell: a payout noticeably smaller than gross sales minus known fees, with a reserve line on the settlement report no one checked.
2 · A refund landing in the wrong period
A customer returns an item purchased in one settlement period, but the refund gets processed and deducted in the following period's payout — so the sales report for period one and the settlement report for period two each show a piece of the same transaction, with no obvious link between them.
Reconciled period by period without accounting for that lag, both periods look slightly wrong even though, taken together across the two, the numbers are entirely consistent.
The tell: a refund deduction on a settlement report with no matching sale in the same period's gross sales export.
3 · Ad spend deducted before it ever reaches the bank
Sponsored product spend gets deducted directly from the payout by the marketplace, rather than billed separately — so the net deposit is lower than gross sales minus commission alone, and a seller who doesn't track ad spend as its own line item mistakes the gap for a missing or miscounted sale.
The spend is real and was authorized, but it lives in the settlement report's deduction section, not anywhere in a typical gross sales export — invisible unless the settlement report is read specifically for it.
The tell: a payout gap that tracks closely with a known advertising campaign's spend for the period.
4 · Currency conversion nobody accounted for
A seller shipping internationally has sales denominated in more than one currency, converted to a home currency somewhere between the marketplace and the bank — and the exact conversion rate applied rarely equals the rate a seller might assume from checking an exchange-rate site on a different day.
The resulting variance is usually small and entirely expected, but treated as an unexplained discrepancy instead of a currency-conversion artifact, it gets investigated as if it were a fee error every single cycle.
5 · A fee filed under the wrong category
A settlement report lists a fee under a category that doesn't match what a seller expected — a referral fee categorized as a fulfillment fee, or vice versa — and the seller, checking category totals against a mental model of what each should be, flags a discrepancy that isn't actually one.
The total deduction is correct; it's simply filed under a label the seller wasn't expecting, which looks like an error until the category structure itself is checked against what the marketplace currently uses.
The tell: a fee category that jumped or vanished between two settlement periods, with the total deductions unchanged.
6 · Payout period versus calendar period
A settlement report covers whatever window the marketplace defines — often a two-week cycle that starts and ends mid-month — while a gross sales export gets pulled for a clean calendar month. Comparing the two directly means comparing numbers that were never meant to describe the same window.
The mismatch isn't a data error on either side — it's a structural fact about how payout periods and calendar periods relate, and it produces a discrepancy every single cycle until someone aligns the two windows deliberately.
7 · A chargeback processed outside the normal flow
A customer disputes a charge with their card issuer rather than requesting a refund through the marketplace, and the resulting chargeback gets deducted through a different mechanism than an ordinary refund — sometimes on a different timeline, sometimes under a different fee category entirely.
Treated as a routine refund, a chargeback's timing and amount can look inconsistent with the original sale in a way an ordinary refund never would, simply because the two processes aren't actually the same one.
The tell: a deduction labeled as a dispute or chargeback fee, arriving on a schedule that doesn't match the refund pattern.
8 · A promotional deduction invisible in gross sales
A coupon or a marketplace-funded promotion reduces the price a customer actually paid, but a gross sales export pulled from a different system sometimes still shows the pre-discount list price — so the settlement report's deduction for the promotional difference looks like an unexplained loss against a sales figure that was never quite accurate to begin with.
Reconciling against the wrong version of “gross sales” — list price instead of actual price paid — guarantees a discrepancy on every promoted order, regardless of how carefully the settlement report itself is read.
9 · Hundreds of orders treated as one line
A high-volume seller's settlement report can contain hundreds or thousands of individual order lines, and rather than checking each category's total against its own subtotal, the temptation is to eyeball the grand total against the deposit and call it close enough.
A close-enough total can hide a real error in one category fully offset by an unrelated discrepancy in another — two mistakes that happen to cancel out in the grand total while both remain individually wrong and worth understanding.
The tell: a grand total that reconciles while individual fee categories, checked separately, don't quite add up.
10 · Facilitator tax withheld at source
In jurisdictions where marketplace facilitator laws apply, the marketplace itself collects and remits sales tax on the seller's behalf, withholding that amount before the payout — a deduction that has nothing to do with marketplace fees at all, but shows up in the same settlement report alongside them.
A seller who reconciles gross sales against payout without separating tax withholding from fee deductions ends up with a fee-reconciliation figure that's actually a mix of two entirely different kinds of deduction, muddying both.
Why none of these trigger an alarm
Look at the ten together and a pattern emerges: not one of them breaks the arithmetic. The settlement report still sums to the deposit. The payout still arrives on schedule. Every one of these is an error of attribution or timing — the right deduction existing, just landing in a period, category or context the seller wasn't expecting.
That's precisely why a casual glance at whether the payout “looks about right” catches none of them. They require checking whether each specific deduction is connected to the specific sale, period and category it should be, which is a fundamentally different kind of check than confirming a total.
The pattern behind all ten
Every one of these causes happens at the same moment: the instant a deduction is checked against gross sales — or isn't — without checking it against everything that's actually known about the settlement report's own structure. A period assumed to be a calendar month. A category assumed to mean what a seller thinks it means. A reserve assumed to be a loss rather than a hold.
The fix, in every case, is the same shape: read the settlement report's own periods, categories and line items on their own terms, every single time, rather than forcing them into a mental model built for a different kind of report. That consistency is what a systematic matching process provides and an ad hoc review, however careful, structurally can't.
It's worth sitting with that for a moment, because it reframes the whole list. These aren't ten unrelated traps to memorize — they're ten symptoms of one underlying gap, and closing that one gap addresses all ten at once rather than requiring ten separate fixes.
A twenty-minute check that catches most of it
Pull your most recent settlement report and check for a reserve line before assuming a smaller-than-expected payout is a shortfall.
Confirm the settlement report's period boundaries match the gross sales export you're comparing it against — not just the calendar month.
Check whether ad spend is deducted at source and, if so, whether it's tracked as its own line separate from commission.
Scan fee categories for one that jumped or vanished between two periods, with the overall total unchanged.
Check any large or unusual refund for whether it belongs to a sale from a prior settlement period.
Confirm tax withholding, if applicable, is tracked separately from fee deductions rather than blended into one figure.
Six checks, about twenty minutes against a typical seller's most recent settlement report. It won't catch everything that's ever gone wrong, but it's a fast, honest read on whether any of the ten above has already crept into your current payout tracking.
The mistake that compounds all the others
There's an eleventh pattern underneath the ten, worth naming separately: none of this knowledge survives a handoff unless it's written down. A seller or bookkeeper who's learned which marketplaces hold reserves, which fee categories tend to shift, which reference formats are normal — all of that context leaves with them unless it's documented somewhere the next person can find it.
Sellers with high turnover in whoever handles the books are, in practice, the ones most exposed to every cause on this list, simply because the informal knowledge that used to compensate for an imperfect process keeps resetting to zero.
A composite case, built from several real ones
No single seller hits all ten in one year, but the pattern below — assembled from cases that recur across many sellers rather than any one in particular — shows how a few of these compound into something bigger than any of them look on their own.
A seller running Amazon and Etsy alongside a Shopify store had reconciled payouts loosely for as long as anyone could remember — a glance at each deposit, no line-level check. At year-end, gross margin looked about five points lower than expected, with no obvious explanation from the sales side.
Working backward through the year's settlement reports turned up three separate, unrelated causes. A reserve held on the Amazon account early in the year had never been tracked as pending, and its eventual release six months later had been logged as unrelated other income rather than matched back — mistake one. A run of Etsy orders during a site-wide promotional period had been reconciled against list price instead of the actual discounted price paid — mistake eight, worth a meaningful share of the total gap on its own. And a currency-conversion variance on cross-border Shopify orders had been investigated repeatedly as a fee error every single month, wasting hours without ever finding anything, because it was never actually an error — mistake four.
None of the three would have been remarkable on its own, caught within the cycle it happened. Stacked across a full year of loose reconciliation, they added up to a margin gap the owner noticed and had no immediate explanation for — exactly the scenario a line-level, every-payout reconciliation is built to prevent.
Why these compound instead of canceling out
A reasonable instinct is to assume small errors in both directions roughly cancel — a deduction misread one way balanced by another misread the other way, netting out to something close to correct. In practice, that's not how most of these ten behave.
Most of them are one-directional. A reserve treated as a loss only ever produces an understated margin, never overstated. Ad spend invisible in gross sales only ever makes the payout look short, never long. A fee misclassification doesn't cancel out anywhere; it just redistributes the confusion from one category to another.
Because the errors skew in a consistent direction relative to whichever cause produces them, they accumulate rather than average out, which is exactly why a gap that looks small after one payout can look substantial after a full quarter of the same unchecked pattern repeating.
That one-directional bias is the strongest argument for reconciling every payout rather than sampling occasionally: it caps how much any single unchecked cause can accumulate before someone notices.
Each cause, and its one fix
Ten causes can feel like ten separate things to remember. In practice, each one has a single, specific habit that prevents it — worth having as a quick reference rather than re-deriving from the full description each time.
| Cause | The one fix |
|---|---|
| 1 · Reserve read as shortfall | Check for a reserve line before treating a smaller payout as an error |
| 2 · Refund in the wrong period | Track refunds against their original sale's period, not the period they're deducted in |
| 3 · Ad spend invisible in sales | Read ad spend as its own settlement line, separate from commission |
| 4 · Currency variance | Expect a small conversion variance on cross-border orders and stop re-investigating it |
| 5 · Fee miscategorized | Read the settlement report's own current category structure, not a remembered one |
| 6 · Period misalignment | Reconcile against the settlement report's own period boundaries, not the calendar month |
| 7 · Chargeback outside normal flow | Track disputes and chargebacks as their own category, separate from ordinary refunds |
| 8 · Promotion invisible in gross sales | Reconcile against actual price paid, not list price |
| 9 · Hundreds of lines as one total | Check each fee category's subtotal individually, not just the grand total |
| 10 · Tax withheld at source | Separate facilitator tax withholding from fee deductions in the reconciliation |
None of these ten fixes require new tools or a change in how the business operates day to day. Each is a single habit, applied consistently — which is the same underlying principle as the pattern discussed above, just made concrete enough to actually act on the next time any of these ten situations comes up.
Print this table, or keep it pinned somewhere visible during payout reconciliation, and most of the ten stop being mistakes waiting to happen and start being a five-second check each cycle.
Who actually catches these, in practice
In operations with more than one person touching the books — a founder and a bookkeeper, or an owner reviewing monthly — these ten causes get caught noticeably more often than in a solo-run seller handling both listings and reconciliation with no one double-checking the work.
That's not a comment on any individual seller's competence. It's simply that a second person looking at the same settlement report asks different questions, notices different things look odd, and isn't blind to the same assumptions the first person has already made without realizing it.
Sellers without the luxury of a second reviewer aren't without options — a short, explicit checklist like the one in this article substitutes reasonably well for a second pair of eyes, precisely because it forces the same questions a second reviewer would ask, even when there isn't one available.
If you're new to reconciling payouts, start here
A seller reconciling payouts for the first time doesn't need to memorize all ten causes before doing anything useful. Three checks, done on the next settlement report, catch a disproportionate share of what's likely to have already gone quietly wrong.
Compare the current settlement report's category totals against the previous one — anything that jumped or vanished is worth a specific look.
Scan for any reserve line and confirm whether it's tracked as pending rather than lost.
Check whether ad spend, if you run any, appears as its own deduction on the settlement report.
None of these three require deep familiarity with the marketplace's reporting history — they're checks anyone can run against a current settlement report within a few minutes, well before the rest of the reconciliation learning curve has been climbed.
A fourth, less mechanical step matters just as much: ask directly whether payouts have ever been reconciled on a regular cadence at all, or only glanced at when something looked obviously wrong. The answer shapes how much of this article's ten points are worth worrying about immediately versus over the coming payout cycles.
Does order volume make this worse, or better?
Intuitively, a higher-volume seller with more orders and more settlement lines would seem to have more room for these causes to hide. In practice the relationship is more complicated than that, and cuts both ways depending on which cause is in question.
Higher-volume sellers are more exposed to causes five and nine — fee miscategorization and hundreds of orders treated as one line — because they're more likely to have the settlement complexity and category variety that create those specific problems in the first place. A seller with a handful of orders per period rarely has a category structure complex enough to misfile something.
Lower-volume sellers are more exposed to causes one and six — reserve holds and period misalignment — for the opposite reason: with fewer orders, there's less redundancy, and a single missed reserve or misaligned period is a much larger share of that seller's total revenue than the same miss at a high-volume operation with hundreds of orders smoothing out the noise.
The practical conclusion is the same either way: no volume level is naturally immune to this list, just exposed to a different subset of it.
Knowing which end of that spectrum your own business sits on is worth a moment's honest thought — it points directly at which two or three of the ten deserve the closest attention first, rather than treating all ten as equally likely.
What this doesn't fix
Naming these ten causes doesn't decide whether a fee rate the marketplace charged was actually correct, doesn't calculate tax owed on marketplace sales, and doesn't tell you when a discrepancy is worth disputing versus writing off. Those remain decisions for whoever owns the seller's finances, made with accurate information — which is the one thing this list is actually trying to protect.
The step-by-step method for reconciling a payout to gross sales without falling into any of these ten is in how to reconcile marketplace payouts to gross sales.