What is the best way to reconcile Amazon seller deposits?
The settlement report is your source of truth. Amazon doesn’t deposit what you sold. They deposit what you sold minus fees, refunds, FBA storage, advertising spend, and a dozen other line items. Trying to match the bank deposit to your gross sales will never work.
Download the settlement report from Seller Central for each payout period. This report breaks down exactly what made up that deposit: product sales, shipping credits, gift wrap credits, promotional rebates, selling fees, FBA fees, refunds issued, advertising costs, and any other adjustments. The net of all these components equals what hit your bank account.
Set up a clearing account in your bookkeeping software. When the settlement period closes, record the full breakdown from the report. Gross sales go to revenue. Each fee type goes to its own expense category. Refunds reduce revenue. The net amount sits in the clearing account until the deposit arrives in your bank, then you clear it out. This method keeps your books accurate and makes the bank reconciliation straightforward.
For e-commerce sellers with any real volume, manual reconciliation becomes unsustainable. Tools like A2X or Link My Books connect to your Amazon account and automatically parse settlement reports into proper journal entries in QuickBooks. They handle the complexity of splitting out dozens of fee types and matching everything to the correct accounting periods. The monthly cost pays for itself in time saved and errors avoided.
Reconcile on the same schedule Amazon pays you. If you’re on a 14-day payout cycle, reconcile every two weeks. Letting multiple pay periods stack up makes it harder to catch discrepancies and track down issues while the details are still fresh.
Watch for timing differences at month end. A sale on January 30th might not settle until February. Accrual-based sellers need to recognize that revenue in January even though the cash arrives later. The settlement report shows when transactions actually occurred, not just when they paid out.
The biggest mistake sellers make is recording just the deposit amount as revenue. That understates your actual sales and hides your true fee burden. You need to see gross sales and the real cost of selling on Amazon separately. Otherwise you can’t make informed decisions about pricing, advertising spend, or whether the platform is even profitable for you. Working with an Andover, MA bookkeeping service familiar with Amazon’s reporting can help you set up systems that capture this detail from the start.
The Merrimack Valley's Trusted Accounting Partner
The Next Step:
A 15-Minute Call
Tell us about your business and what you're dealing with. We'll listen, ask a few questions, and give you a straightforward quote.
More Questions
Can someone help me learn how to use QuickBooks?
Yes, professional training is available and often saves hours compared to piecing together free tutorials. A trainer can configure your chart of accounts correctly, teach you the features you'll actually use, and catch mistakes before they compound.
Read answerHow did the Wayfair decision change sales tax requirements?
Before 2018, you only collected sales tax in states where you had physical presence. The Wayfair decision let states require collection based on economic activity alone, typically once you exceed $100,000 in sales or 200 transactions.
Read answerWhat documents do I need to provide for a bookkeeping cleanup?
Bank statements for all business accounts are the foundation. You'll also need credit card statements, payroll records if you have employees, prior tax returns, and access to your existing accounting software.
Read answerWhat are the Massachusetts payroll tax requirements?
Massachusetts employers must handle state income tax withholding, unemployment insurance contributions, and Paid Family and Medical Leave. Each requires separate registration and quarterly filings, with rates that change annually.
Read answerWhat are the bookkeeping requirements for Airbnb hosts?
Airbnb hosts need to track all rental income, document deductible expenses, and monitor personal use days for tax purposes. Many hosts also face local occupancy tax obligations that require separate registration and reporting.
Read answerCan a bookkeeper help me if I'm behind on quarterly estimated taxes?
A bookkeeper helps by getting your books current so you know your actual income and can calculate what you owe. They provide the foundation your tax professional needs to determine estimated tax amounts and catch-up payments.
Read answer
