How do I reconcile Amazon FBA settlement reports with what shows in my bank account?
The deposit Amazon sends to your bank account is not your revenue. It is the net result of everything that happened during that settlement period: gross product sales, FBA fees, referral fees, refunds, reimbursements, advertising charges, storage fees, and sometimes a reserve holdback. Amazon bundles all of that together and sends you a single number. That number will almost never match what you see in your Seller Central sales dashboard.
This is where most Amazon sellers get confused. They see $8,000 in sales for the period but only $5,200 hits the bank. The difference is all the line items Amazon netted out before paying you. If you record $5,200 as revenue, you are understating your sales and missing thousands of dollars in deductible business expenses like FBA fulfillment fees, referral commissions, and storage costs. If you record $8,000 as revenue but don’t account for the fees separately, your profit and loss statement won’t reflect reality either.
The right approach is to break each settlement into its components. Download the settlement report from Seller Central and you will see every transaction that made up the deposit. Gross sales go to revenue. Each fee category goes to its own expense account. Refunds reduce revenue. Reimbursements for lost or damaged inventory get recorded separately. The net of all those entries should equal the bank deposit exactly.
Doing this manually works when you have a handful of settlements per month. Once you scale past a few hundred orders, manual reconciliation becomes painfully slow and error-prone. A single miscategorized line can throw off your entire reconciliation. Tools like A2X or Webgility connect to your Amazon account and your accounting software, then automatically parse each settlement report into a summary journal entry with the correct accounts mapped. The journal entry debits your bank account for the net deposit and breaks out gross revenue, fees, refunds, and other components into their proper accounts.
If you use QuickBooks Online, A2X integrates directly and posts these entries for you. You still need to review them, but the heavy lifting of parsing hundreds of individual transactions into clean categories is handled. The settlement total in QuickBooks will match your bank deposit, and your income statement will show real gross revenue alongside real fee expenses.
One thing to watch for is reserve holds. Amazon sometimes withholds a portion of your settlement as a reserve, especially for newer accounts or during high-return periods. That money hasn’t left Amazon yet, so it shouldn’t show as a deposit. It needs to sit in a receivable or clearing account until Amazon actually releases it. Missing this creates a reconciliation gap that is hard to track down later.
Getting this right from the start saves you from a painful catch-up bookkeeping project down the road. Many Amazon sellers run for a year or two recording just the net deposits as income and then discover at tax time that their books are essentially useless for understanding profitability or filing accurate returns.
If you sell on Amazon and want your books to reflect what is actually happening in your business, proper settlement reconciliation is not optional. Our bilingual bookkeeping services help e-commerce sellers in Central Florida and beyond set up the right processes so every settlement period closes clean and your numbers tell you the truth about your margins.
Central Florida's Trusted Bookkeeping Firm
Start Here:
A 30-Minute Consultation
Tell us about your business and what's going on with your books. We'll figure out exactly what you need, and give you a straightforward quote.
More Questions
How does sales tax nexus work for a Florida-based e-commerce seller shipping to other states?
Your Florida location creates automatic nexus in the state, but you likely owe sales tax in other states too. Since the 2018 Wayfair ruling, any state where you exceed economic nexus thresholds can require you to collect and remit sales tax.
Read answerHow do I account for damaged, expired, or obsolete inventory in my books?
You remove the value from your books through a write-down or write-off. This means debiting an expense account and crediting your inventory asset account, with documentation to support the adjustment.
Read answerHow do I track daily cash sales and deposits when my restaurant handles a lot of cash?
Use a daily cash reconciliation sheet that calculates expected cash on hand from your POS report, then compare it to your actual count. Record any over/short amount, deposit daily, and match your deposits to the reconciliation.
Read answerShould I use a daily sales journal or just record bank deposits for my restaurant?
Use a daily sales journal with a sales clearing account. Recording bank deposits as revenue understates your actual sales and hides where money goes between the POS and your bank account.
Read answerHow should a bar owner track pour cost and spot liquor inventory variances?
Calculate pour cost by dividing the cost of liquor used by liquor revenue. Industry standard is 18-24%. Track variances by comparing physical inventory counts against POS drink sales, and investigate anything over 3-5%.
Read answerWhat is prime cost in a restaurant and why is it the most important number to track?
Prime cost is your total cost of goods sold (food and beverage) plus your total labor costs (wages, benefits, and payroll taxes). It should fall between 55% and 65% of total revenue, and it matters more than any other number because it covers the two largest controllable expenses in your restaurant.
Read answer