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 do I use QuickBooks classes to track profit and loss per rental property?
In QuickBooks Online Plus or Advanced, create a class for each property and assign it to every income and expense transaction. Then run the Profit and Loss by Class report to see exactly how each property is performing.
Read answerHow should a property management company set up bookkeeping for multiple properties?
Use QBO classes to track each property individually, keep owner funds and security deposits in separate trust accounts, and produce per-property owner statements every month. Your management fee is your revenue, not the rent you collect.
Read answerHow does a food truck owner handle bookkeeping differently than a restaurant?
Food truck bookkeeping revolves around tracking revenue by location, managing vehicle expenses, handling commissary kitchen costs, and staying on top of variable event fees and permits. The mobility that makes the business model appealing is exactly what makes the financial tracking more complex than a fixed-location restaurant.
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 do I track food cost percentage at the end of each week using QuickBooks?
Use the formula Beginning Inventory + Purchases - Ending Inventory = COGS, then divide by food revenue. Set up QuickBooks with the right accounts and record a weekly inventory count so you can run this calculation consistently.
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 answer

