Blog

E-Commerce Financial Reporting: What Amazon Sellers Miss

The biggest bookkeeping mistake an e-commerce retailer can make is treating an Amazon settlement deposit as revenue. A single biweekly deposit can obscure gross sales, refunds, FBA fees, referral fees, storage fees, chargebacks, and reserve holdbacks, all rolled up into one net number. For a Boise seller doing $2 million a year through Amazon or a Salt Lake brand running FBA and Shopify in parallel, those buried adjustments can easily be 15 to 25 percent of gross sales.

Skip the reconciliation and the P&L understates revenue, understates cost of goods sold, and hides fee categories entirely. Reserves show up as unexplained cash timing gaps. Sales tax filings look wrong because gross sales in the books do not match what the marketplace reports.

Why Amazon Settlement Reports Are Not GAAP Financials

Amazon’s settlement report shows what hit the bank account. It is a cash accounting artifact of a specific two-week window. GAAP requires revenue recognition when the sale occurs (when the customer takes ownership), not when Amazon releases the cash 14 to 30 days later. The gap between the two produces a persistent reconciliation exercise that most sellers ignore until year-end scramble.

Gross Sales vs. Net Deposits: The Reconciliation Gap

A useful chart of accounts breaks every Amazon settlement into its components:

  • Gross product sales (revenue)
  • Refunds and returns (contra-revenue)
  • Referral fees (COGS or fulfillment expense)
  • FBA fulfillment fees (COGS or fulfillment expense)
  • Storage fees, aged-inventory surcharges, disposal fees (COGS or holding cost)
  • Advertising spend (sales and marketing)
  • Sales tax collected (liability, not revenue)
  • Reserves and unavailable balance changes (balance sheet timing)

Amazon’s Transaction Detail report exports all of this at the individual-order level. A monthly reconciliation posts the totals to the right accounts and produces gross sales that tie back to the seller’s tax filings and marketplace reports.

Reserve Accounting: When Amazon Holds Your Cash

Amazon holds part of every seller’s earnings in a reserve balance that can shift up or down each period. Reserves exist to cover returns, chargebacks, and A-to-Z guarantee claims. From a cash flow standpoint, a growing reserve is a real drain even though the underlying sales are strong.

The right accounting is to record the full gross sale in revenue, book the fees as expenses, and treat the reserve balance as a receivable (Amazon owes the seller the reserve amount). Ignoring the reserve treats real earnings as if they disappeared.

Referral, FBA, and Storage Fees: Where They Belong

Three fee categories dominate the Amazon expense line. Referral fees (a percentage of the sale price, typically 8 to 15 percent depending on category) function as a marketplace commission. Most sellers book them to COGS because they are directly tied to each unit sold.

FBA fulfillment fees (per-unit pick, pack, and ship) also belong in COGS for the same reason. Storage fees (monthly per cubic foot) and long-term storage surcharges (aged-inventory penalties) are trickier. They correlate with inventory levels rather than sales. Many sellers book them as a separate fulfillment expense line to make the drag on aged inventory visible.

1099-K Reconciliation and Sales Tax Overlap

Amazon issues a Form 1099-K to sellers meeting the reporting threshold. The gross reportable amount on the 1099-K includes all payment transactions processed, including sales tax collected by Amazon under marketplace facilitator laws. That total will not match the seller’s gross revenue on the tax return unless the reconciliation strips sales tax out.

Sales tax collected by Amazon on the seller’s behalf under marketplace facilitator laws should not appear as revenue in the seller’s books. Amazon remits it to the state directly. Booking it as sales tax liability and then reversing when Amazon remits keeps the P&L clean and prevents double-reporting.

Building a Chart of Accounts That Handles All This

A workable chart of accounts for an Amazon-heavy seller looks like this at the revenue and cost level:

  • 4000 Product Sales (gross)
  • 4010 Refunds and Returns
  • 5000 Cost of Goods Sold (landed cost of units sold)
  • 5100 Referral Fees
  • 5200 FBA Fulfillment Fees
  • 5300 Storage and Long-Term Storage Fees
  • 5400 Chargebacks and A-to-Z Claims
  • 6100 Amazon Advertising (PPC)
  • 2100 Sales Tax Collected (liability)
  • 1200 Amazon Reserve Balance (asset)

Automation helps. Third-party tools (A2X, Link My Books, LinkMy) parse Amazon settlement reports and post to QuickBooks or Xero with the correct account mapping. The cost is modest and the time savings meaningful once monthly volume passes a few hundred orders.

E-commerce accounting is not particularly complex, but the number of small moving parts adds up. The retail advisory team at Cooper Norman has set up chart of accounts and monthly close processes for Idaho and Utah Amazon and Shopify sellers. If your monthly P&L looks nothing like the deposits in your bank account, our client accounting services group can bring the two into alignment.

Back to the Journal

Newsletter

Practical owner guidance, monthly.

Tax, transition, and decision insights from the Cooper Norman team.