Your Payout Never Matches the Settlement Report: A Field Guide to OMS Settlement Reconciliation

We have a client, a beauty brand out of Shenzhen doing over $20 million a year on Amazon US. Late last year their CFO called me about a settlement reconciliation mess, and said something I still remember word for word: "Susan, every month I look at the settlement report and I feel like Amazon is reaching into my pocket. I just can't catch its hand."

Here's what was happening. Every two-week settlement cycle, Amazon issues a settlement report showing what they're owed. But the money that actually landed in the company's bank account always came up short. A few thousand dollars a month, adding up to nearly six figures over the year. Their finance team spent three months reconciling, built spreadsheets with dozens of tabs, and never got the numbers to tie out. The founder suspected the platform was skimming. Finance suspected the warehouse. The warehouse pointed at the OMS and said every shipment was accounted for. Three sides, one very loud meeting, and finally they called us in — we're their 3PL, we ship their goods.

I asked them to put three things on the table: the line-item settlement report from the most recent cycle, the OMS order and refund records for the same period, and the actual bank deposits. Two hours later we had the answer: nobody stole the money. The books just didn't reconcile. The "receivable" on the settlement report and the "receivable" in their heads were two completely different numbers.

That's what I want to talk about today: when your marketplace settlement report doesn't match your bank deposit, how to do OMS settlement reconciliation properly. The punchline up front — in nine out of ten cases, the platform didn't miscalculate. The fee categories were never broken out.

Read the Settlement Report First: The Money "Disappears" in Several Moves

A settlement report isn't one table. It's thousands of line items. Take Amazon: a single order gets split into product revenue, referral fee, FBA fulfillment fee, refund, refunded referral fee... plus order-agnostic lines like monthly storage fees, long-term storage fees, advertising spend, and reimbursement or chargeback adjustments. Each on its own row. A two-week cycle for a mid-size seller easily runs into the thousands of rows.

The classic rookie mistake is taking the "total receivable" from the report's summary page and comparing it straight to the bank deposit. That number has already been reduced by a stack of deductions: the refund reserve — money the platform withholds against future returns and chargebacks, released in a later cycle; advertising spend — if you run ads on the platform, it often comes straight out of settlement; plus assorted fees. Bank deposit = receivable − reserve − ads − miscellaneous. Reconcile receivable against deposit and you'll never tie out.

So step one of reconciliation: download the detailed settlement report and break it apart by fee type. Revenue is one bucket, refunds another, referral fees another, fulfillment fees another, storage fees another, advertising another, reimbursements and claims another. Never look at them blended. Blended, nobody can reconcile anything.

The 5 Most Common Discrepancies — I've Watched Clients Trip on Every One

First: the refund reserve. Each cycle the platform withholds a reserve against future returns and chargebacks. The money isn't gone, it's delayed. But many sellers' OMS setups have no "reserve" field at all, so finance books the full receivable as revenue, and at month-end the cash flow comes up short. Change the definition, and the books "stop reconciling."

Second, and the most infuriating: when a customer returns an item, the product price is refunded but Amazon does not refund the FBA fulfillment fee. Your OMS shows "refund" and you assume the order nets to zero. On the platform's side, the fulfillment fee stays deducted. In high-return categories like apparel and beauty, this adds up fast. Our beauty client runs return rates above 15% year-round — this one line alone accounted for tens of thousands of dollars a year in "missing" money. Money their books said shouldn't exist, deducted by the book.

Third: long-term storage fees. FBA charges elevated rates on inventory sitting past a certain age threshold — far above standard monthly storage (check the platform's current published policy for exact thresholds and rates, they change). Most sellers' OMS has no concept of inventory age at all. Stock sits for half a year, nobody notices, and then the long-term storage line on the settlement report is ugly. The painful part: this money never had to be spent. Clear it earlier, move it out earlier, and the charge disappears.

Fourth: advertising spend crossing cycles. Ad spend burns daily; settlement cycles cut every two weeks. Ad deductions and order revenue run on different rhythms. Your ROI looks great this month, then the settlement shows a big ad deduction and the margin thins out. Sellers who blend ad spend into operating numbers end up convinced "the platform is skimming."

Fifth: reimbursements and chargebacks. Lost units, damaged units, platform-ruled chargebacks, plus reimbursements that land after you win a claim — all mixed in with fees on the same report, money flowing both ways. Without line-by-line reconciliation, it's unreadable. One practical note: FBA lost-inventory claims have filing deadlines (per the platform's current policy), and they don't bend. We've seen clients discover lost units six months late and get a one-word answer from the platform: expired.

The 3-Step OMS Settlement Reconciliation: Download, Split, Match

Step one: download the settlement detail. Amazon's settlement reports export per cycle; Walmart and eBay each have their own versions. Skip the summary page. The detail is where the truth lives.

Step two: split by fee type. The seven buckets above, each totaled separately. Do the first pass by hand in a spreadsheet. Once the flow works, then think about automating reconciliation inside your OMS.

Step three: match every line against OMS orders. Take the order numbers and refund IDs from your OMS and find their rows in the settlement detail. Order amount correct? Refund amount correct? Any fee lines that shouldn't be there? Line by line. The first pass is painful — a mid-size seller's two-week volume can take two people two or three days. But once you've run it once, you own a "standard definition," and every cycle after that is just reuse.

Here's an illustration (illustrative figures only — always verify against the platform's current published fee schedule) of where the money goes on a $29.99 item:

Sellers think they're earning $29.99. What's actually usable is $15.49. I'd suggest every seller run this math on their own catalog once — then look at their pricing again with fresh eyes.

The Counterintuitive Part: Reconciliation's Biggest Win Isn't Recovering Money

After all these years, I've noticed something counterintuitive: clients start settlement reconciliation to "get back what the platform overcharged." By the time they finish, the recovered few thousand dollars is rarely the real prize. The real prize is the pile of money they discover they never had to spend — long-term storage fees, unmanaged ad campaigns, SKUs with terrible return rates still getting restocked aggressively. In the end, you're not auditing the platform's books. You're auditing your own operation. Platform mischarges can be appealed and recovered. Nobody plugs your own leaks for you.

One more trade-off worth thinking about: should reconciliation be fully automated? My advice — run two cycles by hand first. Learn the definitions, learn the discrepancy patterns, then automate. Automating with wrong definitions just produces wrong numbers faster.

Next Time You're at the Negotiating Table, Ask These Three Questions

Back to our beauty client. They now run the three-step reconciliation every single cycle, finance and operations sharing one set of definitions. No more shouting matches. If you're a seller, or you're about to sign with a 3PL, ask these three questions next time you're negotiating:

One: whose numbers are the source of truth? Between your OMS data and the platform settlement report, what's the acceptable variance threshold — and who's responsible for explaining anything beyond it?

Two: when platform deductions look wrong, does the 3PL help you appeal? FBA lost-inventory claims, fee disputes — is it "we'll chase it for you" or "go open a case yourself"? Get the service boundary in the contract. Verbal promises don't count.

Three: who watches slow-moving inventory? Long-term storage fees are a slow bleed — can the 3PL's system alert you by inventory age, or do you only find out when the settlement report arrives?

Three questions, and you'll know whether a 3PL is worth signing with. Contracts are negotiated, not just signed.

By Susan, 3PL Sales Director