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
Do Texas LLCs still need to file a franchise tax report if no tax is due?
Yes. Texas LLCs must file a No Tax Due Report by May 15 each year even when they owe nothing. Skipping this filing can result in forfeited good standing and penalties.
Read answerWhat bookkeeping setup works for pool service routes in The Woodlands?
Pool service bookkeeping needs to separate recurring maintenance from repairs, track chemical inventory, and handle prepaid service agreements. A chart of accounts built for route-based service work keeps everything organized.
Read answerHow do I prepare QuickBooks Online for year-end tax filing?
Start by reconciling every bank and credit card account through December 31. Then clean up uncategorized transactions, verify payroll and 1099 data, review AR/AP for accuracy, and close out stale balances before handing off to your tax preparer.
Read answerHow should a Houston bar separate food, beer, wine and liquor sales in bookkeeping?
Create separate income accounts for each category because Texas taxes them differently. Mixed drinks and wine by the drink face both 8.25% mixed beverage sales tax and 6.7% gross receipts tax, while beer and food follow standard sales tax rules.
Read answerWhat financial strategy reports help identify unprofitable customers?
Customer profitability reports, gross margin analysis, AR aging, and recurring vs one-off revenue breakdowns reveal which customers drain your resources. Together these reports show who costs more to serve than they're worth.
Read answerHow can a home builder see profit by subdivision or project?
Set up your accounting software to track income and expenses by subdivision using classes, locations, or projects in QuickBooks. When every transaction is coded to a specific development, you can run reports showing profitability for each one.
Read answer