How do I reconcile Amazon payouts with my bank account?
The reason Amazon reconciliation is confusing is that your bank deposit doesn’t match your sales. Amazon deposits a net payout that includes your sales revenue minus selling fees, FBA fees, refunds, advertising charges, and sometimes a reserve holdback. Trying to match your total sales to bank deposits will never work because Amazon already subtracted their cut before sending you money.
The key document is your Settlement Report from Amazon Seller Central. This report shows exactly what made up each payout: product sales, shipping credits, promotional rebates, selling fees, FBA fees, refunds issued, reimbursements, and any other adjustments. When a deposit hits your bank account, the settlement report tells you what’s inside that number.
To reconcile manually, download the settlement report for the period matching your deposit. Verify the net amount on the report matches what hit your bank account. Then record the deposit broken into its components. Gross revenue goes to sales, Amazon fees go to an expense account, refunds reduce revenue. Your books now reflect actual sales and actual fees rather than just a mysterious lump sum deposit.
E-commerce businesses face an extra layer of complexity with timing. Amazon typically pays every two weeks, but the settlement period doesn’t align neatly with calendar months. A payout you receive in early July might include sales from the last two weeks of June. For accurate monthly financials, you need to adjust for this timing difference or accept that your monthly numbers will be slightly off.
Most Amazon sellers eventually use integration software like A2X or Link My Books. These tools pull your Amazon data automatically and create accurate journal entries in QuickBooks or Xero. They handle the timing, separate the fee categories, and save hours of manual work. The monthly cost pays for itself quickly if you’re doing any real volume.
A few things to avoid. Don’t record revenue when the sale happens and again when the deposit arrives because that double-counts your income. Don’t ignore the fees embedded in the payout because you need those expenses on your books to know your true margins. Don’t reconcile the bank deposit as a single entry because you lose all the detail that makes the data useful.
Getting this right matters beyond just accurate books. Understanding your actual Amazon fees as a percentage of sales, your refund rate, and your FBA costs helps you price products correctly and figure out whether Amazon is actually profitable for your business. A Scottsdale bookkeeper familiar with Amazon can set up your chart of accounts to track these metrics automatically so you can see real profitability by product or category.
Full-Service Bookkeeping for Greater Phoenix
The Next Step:
A Quick Conversation
Tell us about your situation. We'll listen, ask a few questions, and give you a clear price to handle the work.
More Questions
How do I account for Shopify payouts and transaction fees?
Record your gross sales as revenue and Shopify fees as a separate expense. Don't just book the net payout amount to income or you'll underreport revenue and miss tracking what you're actually paying in fees.
Read answerHow do I track product costs and landed costs for e-commerce?
Track every cost required to get inventory to your warehouse, not just the supplier invoice. Calculate landed cost per unit by totaling freight, duties, broker fees, and insurance, then dividing by units received.
Read answerHow do I value inventory for my online retail business?
Most e-commerce businesses use FIFO (First In, First Out) to value inventory. This method assumes you sell your oldest inventory first, which typically matches how online retail works and simplifies compliance.
Read answerWhat's the best way to track Amazon seller fees in QuickBooks?
The key is breaking apart Amazon's net deposits into gross sales and individual fee categories. You can do this manually using settlement reports or automate it with integration tools like A2X.
Read answerHow do I prepare my retail store books for an audit?
Start with reconciled accounts, verified inventory records, and documentation for every transaction. Retail audits focus heavily on inventory valuation, cash handling, and sales tax compliance.
Read answerWhat bookkeeping mistakes do small retail stores make?
Small retail stores commonly fail to track inventory as an asset, mix personal and business transactions, and skip daily cash reconciliation. These mistakes make financial reports meaningless and create tax problems.
Read answer