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 handle accounts payable efficiently?
Efficient accounts payable comes down to centralizing invoice intake, coding bills as they arrive, and batching payments on a set schedule. Most inefficiency comes from chasing paper, scrambling at the last minute, and paying bills one at a time.
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 answerAre there bookkeepers in the East Valley who specialize in e-commerce?
Yes, several bookkeeping firms in the Greater Phoenix area specialize in e-commerce. Since bookkeeping is largely digital, you're not limited to firms physically located in the East Valley.
Read answerHow do I catch up on months of bookkeeping?
Gather all your statements, find the last month that reconciled correctly, and work forward from there. For each month, enter and categorize transactions, then reconcile every account before moving on. Chronological order matters because transactions often reference each other.
Read answerWhat accounting method should I use for my Shopify store?
Most small Shopify stores can legally use cash basis accounting, but accrual often makes more sense once you're carrying inventory. Cash is simpler for tax prep, but accrual shows actual profitability by matching product costs to the revenue they generate.
Read answerHow do I calculate cost of goods sold for my e-commerce store?
Cost of goods sold equals beginning inventory plus purchases minus ending inventory. For e-commerce, include product costs and inbound freight in COGS, but keep platform fees and outbound shipping as operating expenses.
Read answer