How do I reconcile Amazon payouts to actual sales, fees and refunds?
Amazon deposits hit your bank account as a single number, but that number represents dozens or hundreds of transactions netted together. Your payout includes gross sales minus referral fees, minus FBA fees, minus refunds, minus advertising costs, and sometimes minus reserves Amazon holds for future claims. Booking that deposit as revenue makes your books wrong in ways that matter for taxes and business decisions.
The IRS receives Form 1099-K from Amazon showing your gross transaction amounts, not your net deposits. If your books show $80,000 in Amazon revenue because that’s what hit your bank account, but Amazon reports $120,000 in gross sales to the IRS, you have a mismatch. The IRS sees unreported income. You’ll need to explain and document that the $40,000 difference is fees, refunds, and advertising. Breaking out the components upfront avoids this problem entirely.
Beyond taxes, accurate reconciliation shows you what’s actually happening in your business. When fees, refunds, and advertising are hidden inside a net deposit, you can’t see if referral fees are eating your margins, whether your refund rate is climbing, or if advertising spend is producing results. Your gross margin looks wrong because you’re dividing cost of goods sold by net rather than gross.
Use the Settlement Report in Seller Central to reconcile each payout. This report breaks down exactly what’s in the deposit: every order, refund, fee category, advertising charge, and reserve adjustment. The summary at the top shows totals by category that should tie to the amount deposited. Download it for each settlement period, typically every two weeks.
Set up your chart of accounts to handle these components separately. You need accounts for Amazon gross sales, referral fees expense, FBA fees expense, advertising expense, and a liability account for reserves. When the deposit hits, you’re not recording revenue. You’re clearing out what Amazon collected on your behalf and recognizing the pieces in their proper categories.
E-commerce bookkeeping gets complicated when you have returns processed after the original settlement period, inventory reimbursements, promotional credits, or fee adjustments. Each needs to be tracked and categorized correctly. Most accounting software won’t handle this automatically without configuration or integration tools that pull Amazon data directly.
At minimum, reconcile monthly so your financial statements reflect actual performance. If you’re running high volume, every settlement period is better so you catch discrepancies sooner. The mechanics are tedious but the alternative is books that don’t match what Amazon reports to the IRS and financial statements that hide real problems.
For sellers doing significant volume, this reconciliation becomes one of the more time-consuming parts of monthly bookkeeping. If you’re spending hours on it or avoiding it because it’s confusing, that’s a sign you might benefit from small business bookkeeping and tax services in The Woodlands to handle the complexity and keep your records accurate.
Greater Houston's Small Business Bookkeeping Partner
The Next Step:
A Quick Conversation
Tell us about your business and what you need help with. We'll listen, ask a few questions, and give you a straightforward quote.
More Questions
What should a Texas restaurant track for sales tax and mixed beverage tax?
Texas restaurants track regular sales tax on food plus two separate mixed beverage taxes on alcohol. Mixed beverage sales tax is collected from customers while gross receipts tax comes from your revenue.
Read answerHow should Spring and Tomball service businesses track jobs across multiple crews?
Every expense and labor hour needs to be coded to a specific job as it happens. Set up time tracking for crews, integrate your scheduling software with QuickBooks, and allocate truck expenses consistently by crew or as general overhead.
Read answerHow do I catch duplicate income or expenses in QuickBooks Online?
Duplicates usually come from bank feed rules, invoice-deposit matching issues, repeated manual entries, or merchant processor payouts. Regular bank reconciliation and source document review are the most reliable ways to catch them.
Read answerWhat bookkeeping records should a new business in The Woodlands set up before its first tax season?
Set up a separate business bank account, configure QuickBooks Online properly, and register for Texas sales tax if applicable. Be aware of franchise tax filing requirements and establish a monthly reconciliation routine before tax season arrives.
Read answerWhen does a business need fractional CFO support instead of basic bookkeeping?
Bookkeeping records what happened. A CFO helps you decide what should happen next. When you're facing major decisions, pricing questions, or growth challenges, you've likely outgrown basic bookkeeping.
Read answerWhat should a contractor include on invoices for progress billing?
Progress billing invoices should include the original contract amount, approved change orders, completion status, previous billings, deposits applied, and retainage held. This clarity prevents confusion between revenue earned and cash collected while reducing client disputes.
Read answer