Amazon settlements often bundle many sales, refunds, and fees into a single payout that arrives weeks later. When you are also selling on Shopify, it can make it hard to clearly understand how gross sales turn into net cash in your accounting system.
I am curious how others handle this. Do you rely on reports, spreadsheets, or accounting workflows to reconcile Amazon settlements and feel confident in your numbers?
Hello @webgility_hq!
One common approach is to break it into three parts: sales, fees, and payouts. Start by exporting Amazon’s Settlement Report and Transaction Report, then match them against your actual bank deposits. This helps you clearly see gross sales, Amazon fees (referral, FBA, storage, ads), refunds, and the final net payout.
If you’re still early or low volume, a simple spreadsheet can work. Just make sure each settlement is reconciled to one bank deposit and reviewed regularly. Consistency is key here. Reconcile weekly or per settlement so issues dont pile up.
Hope this helps clarify the process and makes reconciliation less painful 
What worked best for us was treating each Amazon settlement like a mini P&L. We export the Transaction View report, split it into sales, fees, and refunds, then match it with the bank payout. It’s not perfect GAAP-wise, but it makes the gross-to-net differences much easier to see.
Thanks for sharing this, Jan. Breaking each settlement into sales, fees, and payouts makes a lot of sense, especially with how much Amazon bundles into a single deposit.
I like the point about reconciling per settlement instead of waiting until month-end. That consistency piece is probably what helps keep things from snowballing over time. Appreciate you laying out the workflow.
That’s an interesting way to look at it, treating each settlement like a mini P&L. Even if it’s not perfectly GAAP-aligned, having visibility into gross-to-net per settlement seems way more actionable than staring at one rolled-up number.
Do you do that review as settlements come in, or batch them later in the month?