Marketplace Payment Reconciliation: Record Gross Sales, Not the Deposit

Your marketplace deposited $35,300 into your bank account last month. Then your Form 1099-K arrives showing $58,400. Neither number is a mistake — but if your books show $35,300 as revenue, your books are wrong, and the gap is silently distorting everything from your tax return to your pricing decisions. The deposit is what's left after the marketplace takes its cut; your revenue is what customers actually paid you. This guide shows you how to reconcile the two, every month, without drowning in settlement reports.

You will learn why a payout never equals your sales, the gross-recording rule that keeps you consistent with your 1099-K, a clearing-account method that makes each payout reconcile to zero, how to read settlement line items on Amazon-style marketplaces and Shopify alike, and the monthly routine that catches missing money before it becomes a tax problem.

Why Your Payout Never Equals Your Sales​

A marketplace payout is a net residual, not a sales figure. The marketplace collects the full amount from your customers, subtracts everything it is owed or required to withhold, and sends you what's left. A typical payout bundles all of this into a single bank deposit:

• Referral or commission fees on each order
• Fulfillment, shipping, and storage fees
• Payment processing fees
• Customer refunds issued during the period
• Advertising spend charged to your seller account
• Reserve withholdings (funds held back against future returns and chargebacks)
• Reimbursements owed back to you for lost or damaged inventory
• Prior-period adjustments and corrections

So a $35,300 deposit might represent $58,400 in customer payments minus $8,760 in referral fees, $6,140 in fulfillment fees, $890 in storage, $2,310 in refunds, $3,420 in advertising, plus a $310 reimbursement, minus a $1,890 increase in your reserve. Three different documents tell three parts of that story: the order report shows what customers bought at gross value, the settlement or payout report shows what the platform computed as payable line by line, and your bank statement shows what actually arrived. Reconciliation is the discipline of tying all three together so that every dollar of gross sales traces to a fee you can verify, a refund you authorized, a reserve you can track, or cash in the bank.

This matters far beyond tidy books. Businesses that record only the deposit understate revenue, hide their true fee load, and lose the ability to answer the single most useful channel question: what percentage of sales is this marketplace actually costing you?

The Gross-Recording Rule: Book Sales and Fees Separately​

The foundational rule of marketplace bookkeeping is simple: record gross sales as revenue and record every fee as its own expense. Never record the net deposit as revenue.

There are three reasons this is non-negotiable. First, your tax forms speak gross. The IRS requires third-party settlement organizations to report the gross payment amount in Box 1a of Form 1099-K with no adjustments for fees, credits, refunds, shipping, or discounts — those items are not income, and you deduct them from the gross amount when you file your return. If your books show net deposits as revenue, your revenue will never tie to your 1099-K, and answering an IRS notice becomes an archaeological dig through a year's worth of settlement reports.

Second, net recording hides costs you need to manage. A seller doing $58,400 in monthly sales with $19,210 in combined fees is paying about 33 percent of every sale to the channel. That fee load is the number that tells you whether to raise prices, renegotiate, or shift volume to a cheaper channel — and it is invisible if fees never appear in your books as expenses.

Third, gross recording is what makes refunds, reserves, and reimbursements trackable. A refund is a reduction of revenue (or a contra-revenue entry), a reserve movement is a receivable from the platform, and a reimbursement is income or a recovery — each needs its own line so timing differences across months don't corrupt your profit figures.

One related trap: sales tax or marketplace-facilitated tax collected from buyers is not your revenue either. It passes through you to the taxing authority and belongs on your balance sheet as a liability until remitted, regardless of whether it appears in your gross settlement lines.

The Clearing-Account Method That Makes Payouts Reconcile to Zero​

The cleanest way to implement gross recording is a clearing account — one per sales channel — that holds each platform's activity until its payout settles. Think of it as a staging area between the marketplace and your bank. Here is the full cycle for a single payout period:

1. Record gross sales. Debit the channel clearing account (an asset, essentially a receivable from the platform) and credit Sales Revenue for the full customer-paid amount.
2. Record fees as expenses. Debit the appropriate expense accounts — marketplace referral fees, fulfillment fees, payment processing fees, advertising — and credit the clearing account.
3. Record refunds. Debit Refunds or Sales Returns (contra-revenue) and credit the clearing account for refunds issued in the period.
4. Record reserve movements. If the platform increased your reserve, debit a Marketplace Reserve receivable and credit the clearing account; reverse it when the reserve is released.
5. Transfer the payout. When the deposit lands, debit your bank account and credit the clearing account for the net amount.

When every line is captured, the clearing account returns to zero (apart from timing items like uncleared reserves). A nonzero balance is your early-warning system: it means a fee was missed, a refund was posted to the wrong period, or a payout hasn't arrived yet. Investigate the residual instead of forcing it to zero with a plug entry — the residual is the reconciliation doing its job.

Keep channels separate. Amazon, Shopify, Etsy, eBay, and Stripe should each get their own clearing account, because each platform has its own fee schedule, payout cadence, and report format. Consolidating them into one account turns every investigation into a multi-platform puzzle. Summary entries per payout period are fine for most small sellers; high-volume sellers may post daily summaries, but the structure is identical either way.

Reading a Settlement Report Line by Line​

Every platform's report looks different, but the anatomy is the same. Learn the line-item types once and you can read any of them.

Amazon-style marketplace settlements​

Download the settlement report from Seller Central (Payments reports) and read it in this order:

• Order lines — product charges, shipping collected from the customer, gift wrap. This is your gross for the period.
• Refund lines — amounts debited back for returns and cancellations, each referencing its original order ID. Verify that every refund matches a return you actually authorized.
• Fee lines — referral fees, closing fees, fulfillment (FBA) fees, and monthly storage fees. Spot-check the referral percentages against your category's published rate; miscategorized products get overcharged routinely.
• Other charges — advertising spend and subscription fees billed through the seller account. These are easy to double-count if your ad platform invoices also flow into your books — pick one source.
• Reimbursement lines — credits for lost or damaged FBA inventory. These are income (or recoveries against inventory loss), not reductions of fees, and sellers routinely leave them unclaimed.
• Reserve and balance lines — beginning balance, ending reserve, and the resulting transfer amount. The reserve is still your money; track it as a receivable so a growing reserve doesn't read as shrinking profit.

Shopify payouts​

Shopify's finance summary and payouts report break each payout into charges (gross customer payments including shipping and taxes collected), refunds, adjustments, transaction fees, and the resulting net payout. The reconciliation formula is: charges minus refunds, plus or minus adjustments, minus fees, equals the bank deposit. Note that Shopify reports refunds as reductions of the payout in the period the refund is processed, which may differ from the period of the original sale — match refunds to payouts by payout ID, not by calendar intuition, and let the clearing account absorb the timing gap.

For every platform, the verification habit is the same: sum each line-item type for the period, confirm gross-to-net math reproduces the deposit to the penny, and confirm the deposit date and amount match your bank feed. A payout whose lines don't add up to the deposit is either missing lines (export the full date range, not a screen view) or contains an adjustment you haven't categorized yet.

A Worked Example: From $58,400 in Sales to a $35,300 Deposit​

Walk through one settlement period with realistic numbers:

The journal entries behind it: debit the Amazon clearing account and credit revenue for $58,400; debit refunds (contra-revenue) for $2,310; debit fee and advertising expenses totaling $19,210; debit the reserve receivable for $1,890; credit the clearing account for each; then debit the bank and credit clearing for $35,300. The clearing account nets to zero, revenue ties to the order report, and total channel cost — $19,210 in fees plus $2,310 in refunds against $58,400 in sales — is visible as a 36.8 percent all-in channel cost. That percentage is the number to watch month over month; a sudden jump usually means a fee increase, a miscategorized product, or runaway ad spend.

Reconciling to Your 1099-K at Year-End​

Because Box 1a of Form 1099-K reports gross payment volume with no adjustments, your year-end task is to prove that your books' gross marketplace sales equal the form's gross — then show the fees, refunds, and adjustments as deductions that bridge gross down to taxable income. Build that bridge deliberately:

1. Sum each channel's gross revenue per your books for the year.
2. Compare each total to the corresponding 1099-K Box 1a. Investigate material differences before filing: common causes are returns processed in January against December sales, payouts straddling New Year's Eve, and sales tax included in one figure but not the other.
3. Verify that fees and refunds appear as deductions on your return (Schedule C or your entity return), not as reductions of reported gross income. The IRS guidance is explicit that those items are deducted from the gross amount.
4. Keep the settlement reports. If the IRS questions a mismatch, the settlement files plus your clearing-account history are the audit trail that resolves it in one letter instead of a long correspondence exam.

Note that federal 1099-K reporting thresholds have moved several times in recent years, and several states impose lower thresholds of their own — confirm the current figures in the IRS's 1099-K guidance rather than assuming last year's rules still hold. Regardless of whether you receive a form, all of the income is still reportable; the form changes the paperwork, not the taxability.

Seven Mistakes That Break Marketplace Books​

1. Recording the deposit as revenue. The original sin. It understates income, erases fee expenses, and guarantees your books won't tie to your 1099-K.
2. Posting refunds to the wrong period. A December sale refunded in January belongs against January's payout. Refunds follow the settlement period, not the sale date.
3. Ignoring the reserve. A growing reserve looks like shrinking profit if you never book the receivable. Track it monthly.
4. Lumping all fees into one line. "Amazon fees" as a single expense hides whether referral, fulfillment, storage, or advertising drove a cost spike. Break them out.
5. Mixing channels in one account. One clearing account per platform, always. Shared accounts make every discrepancy a cross-platform investigation.
6. Double-counting advertising. Ad spend billed through your seller account and ad spend invoiced separately are the same dollars — book them once, from one source.
7. Booking collected sales tax as revenue. Tax you collect on behalf of a state is a liability, not income. Recording it as revenue overstates sales and understates what you owe.

Your Monthly Marketplace Close Checklist​

Turn the method above into a 30-minute monthly routine:

• Export each channel's order, settlement, and payout reports for the closed period
• Post gross sales, fees, refunds, and adjustments to each channel's clearing account
• Verify each payout's math: gross minus fees minus refunds plus or minus adjustments equals the deposit
• Match every deposit to the bank feed by amount and date
• Clear the clearing accounts to zero (except tracked reserves and in-transit payouts)
• Review the all-in channel cost percentage against prior months and investigate jumps
• File the reports where your tax preparer can find them in January

Marketplace reconciliation stops being intimidating once the structure is in place. The settlement report does the hard arithmetic for you; your job is simply to give every line a proper home in the books instead of letting the net deposit masquerade as revenue.

Keep Every Channel's Books Clean From Day One​

As your marketplace sales grow across Amazon, Shopify, and beyond, the gap between gross sales and bank deposits only gets harder to track by hand — and spreadsheet summaries of settlement reports are where fee creep hides. Maintaining separate clearing accounts per channel, with every fee and refund recorded as its own line, is what turns a confusing pile of payouts into books you can trust at tax time. Beancount.io provides plain-text accounting that gives you complete transparency and control over your financial data — no black boxes, no vendor lock-in. Get started for free and see why developers and finance professionals are switching to plain-text accounting.