Reconcile Amazon Seller Payouts to Your Bank Statement

TL;DR An Amazon seller payout is a net number. Each deposit on your bank statement is the result of a settlement period's sales minus Amazon's fees, refunds, advertising charges, adjustments and any amount held back as a reserve, plus the reserve released from the previous period. To reconcile, start from the bank deposits, find the settlement each one relates to in Seller Central's payment reports, and break the settlement into its components so they sum exactly to the deposit. Book the gross sales as income and the fees, refunds and ad spend as their own lines, rather than recording the deposit as sales. Do it settlement by settlement, and keep a running schedule of reserves so the balance Amazon owes you is always explained.

Amazon sellers often look at their bank account, see a deposit from Amazon every couple of weeks, and record it as revenue. It's an understandable shortcut, and it's wrong in a way that matters. Your sales are overstated in some places and understated in others, fees disappear from your expenses, and if Amazon holds funds back, your income in one period can look oddly low and in the next oddly high.

This guide shows how to reconcile Amazon payouts to your bank statement properly: how settlements work, which reports to use, a step-by-step method, a worked example in Excel, how to book it, and how to handle reserves, refunds and multiple marketplaces. Seller Central changes often and differs by marketplace, so we describe reports and options in general terms. The same approach works whether you sell a few products or thousands.

How Amazon payouts work

Amazon collects money from your customers, deducts what you owe it, and pays the rest to your bank account. Each payout is tied to a settlement period, commonly around two weeks, although timing can vary by account, marketplace and payout settings.

Within a settlement, the main components are usually:

• Product sales, the price your customers paid for the items.
• Shipping and gift wrap credits paid by customers, where applicable.
• Taxes collected, where Amazon collects and remits sales tax or VAT on your behalf under marketplace rules, which may appear as collected and then withheld.
• Amazon fees, such as referral fees and, for FBA sellers, fulfilment fees, plus storage and other service fees.
• Refunds, which reverse sales, usually with part of the referral fee returned.
• Advertising charges, which may be deducted from the settlement depending on your payment settings.
• Subscription fees, such as a professional selling plan fee.
• Adjustments and reimbursements, for example for lost or damaged inventory.
• Reserves, an amount held back from the current settlement, and the release of the previous reserve.

The deposit that reaches your bank is the net of all of these. That's why a payout is never your sales figure.

The reports you need

You'll work from two sides.

Your bank statement. The list of actual deposits from Amazon, with dates and amounts. If you have PDF statements, convert them so each deposit is a row. SheetStatement does this and checks the statement's opening and closing balances; the free plan includes 3 pages a month, and Starter ($9), Pro ($19) and Business ($39) monthly plans handle more.

Amazon's payment reports. Seller Central generally provides:

• A payments or statement view showing each settlement period, its total, and the amount transferred to your bank.
• Settlement reports, often downloadable as flat files, listing every transaction in a settlement with its type and amount.
• Date range or summary reports, which group activity by type for a period you choose, useful for monthly summaries.

For reconciliation, the settlement-level data is the most useful because each settlement corresponds to one payout. Date range reports are better for monthly accounting summaries but won't line up neatly with deposits.

Step-by-step reconciliation

Step 1: list the bank deposits

Filter your converted bank statement for Amazon deposits and put them in a table:

Step 2: match each deposit to a settlement

For each deposit, find the settlement in Seller Central with the same transfer amount. The deposit usually arrives a few days after the settlement period ends. Add the settlement ID and period to your table.

If a deposit doesn't match any settlement, check for:

• A split or failed transfer, where Amazon retried a payment.
• A different marketplace, if you sell in more than one region and some payouts go to the same bank account.
• A transfer you requested manually, if your account allows that.

Step 3: break each settlement into components

From the settlement report, total each transaction type. A pivot table works well: transaction type in rows, sum of amount in values. Our guide to pivot tables for bank data explains the setup, and the same steps apply to settlement files.

Group them into a summary you can book:

Step 4: prove the settlement equals the deposit

=ROUND(SUM(B2:B11) - B12, 2)

where B12 is the deposit amount from your bank statement. It must be zero. If it isn't, the most likely causes are a missing transaction type in your grouping, a reserve you forgot, or a deposit matched to the wrong settlement.

Step 5: book the components

Record the settlement as a single journal entry or a split deposit, with each component on its own line, against your bank account for the net payout. That way income, refunds and each fee type land in the right accounts, and the bank side matches the actual deposit.

Worked example

An illustrative settlement for an FBA seller. All figures are invented to show the method.

Bank statement: Amazon deposit on 14 March of $7,348.20.

Settlement summary from the report:

Check: 11,960.00 − 540.00 − 1,794.00 − 1,912.40 − 186.20 − 820.00 + 96.80 + 1,244.00 − 700.00 = 7,348.20. Matches the deposit.

What this shows:

• Sales for the period were $11,960.00, not $7,348.20. Recording the deposit as sales would understate revenue by more than $4,600.
• Amazon fees totalled $3,892.60 (referral, fulfilment, storage), and advertising another $820.00. These are real costs that would vanish if you only booked the net.
• The reserve lines net to +$544.00. That's not income or expense; it's a change in the money Amazon is holding for you. Booked as income, it would distort the period.

Booking the payout

A common approach is to use a clearing account, often called something like "Amazon clearing" or "Amazon receivable", which represents money Amazon owes you.

For each settlement:

1. Record gross sales as income, credited, with the clearing account debited.
2. Record refunds, fees, advertising and adjustments against their own accounts, with the clearing account on the other side.
3. When the deposit arrives, debit the bank account and credit the clearing account.

After each settlement, the clearing account balance should equal the reserve Amazon is holding, plus any settlement that has closed but not yet paid out. If it drifts away from that, something has been missed.

If your accounting software supports split deposits, you can achieve the same result by recording the bank deposit with several lines: sales, refunds, each fee and the reserve movement. The QuickBooks Online import guide and the Xero reconciliation guide explain how to match a deposit to a split transaction or a manual journal in those tools.

Many sellers use connector apps that post settlement summaries automatically. They can save a great deal of time, but they still benefit from the monthly check described here: every deposit matched, every settlement summarised, the clearing account explained.

Tracking the reserve

The reserve is the part that confuses most people. Amazon may hold back part of a settlement to cover potential refunds or chargebacks, and release it in a later settlement. Keep a simple schedule:

The balance column should always equal the reserve held in the most recent settlement. If you see a released amount that doesn't match the previous held amount, there's a settlement you haven't reconciled, or the reserve rules changed.

At year-end, the reserve balance is part of what Amazon owes you. It belongs on the balance sheet, not in income.

Monthly reporting versus settlements

Settlement periods rarely line up with calendar months. You have two options:

• Book by settlement. Record each settlement on its end date. Simple, and accurate over the year, but a month may include one, two or three settlements.
• Book by month. Use a date range report for the calendar month to record sales and fees, and use the clearing account to absorb the timing difference with payouts.

Small sellers usually book by settlement. Sellers who need accurate monthly margins, for investors or lenders, often book by month. Either way, reconcile deposits to settlements as above; that's what proves your bank and Amazon agree. Ask your accountant which method suits your reporting.

Refunds and returns

Refunds show up in settlements as negative amounts, often with part of the referral fee credited back. Treat them carefully:

• Record refunds as a reduction of sales or in a sales returns account, not as an expense.
• Record the referral fee credit as a reduction of fees.
• If the customer returned the item to inventory, your inventory and cost of goods sold also need adjusting. That's outside bank reconciliation, but don't forget it.

A refund in this settlement may relate to a sale from months ago. That's normal; record it when it appears.

Multiple marketplaces and currencies

If you sell on several Amazon marketplaces, each may have its own settlements and its own payouts, possibly in different currencies:

• Reconcile each marketplace separately. Don't mix US and UK settlements in one schedule.
• Match deposits in the bank's currency. If a payout was converted before it reached your account, the deposit amount is in your bank's currency while the settlement is in the marketplace's. Note the effective rate and record any difference as a foreign exchange gain or loss.
• Keep a separate clearing account per marketplace if you book through clearing.

The Wise statement guide covers handling multi-currency balances in a spreadsheet, which helps if your payouts land in a multi-currency account.

Sales tax and VAT

Under marketplace facilitator rules in many places, Amazon may collect and remit sales tax or VAT on certain sales. In settlement data, that can show as tax collected and then withheld, netting to zero in the payout. Whether and how you record those amounts depends on your jurisdiction and your obligations, so check with a tax adviser. Don't treat collected tax as your revenue.

This section is general information, not tax advice.

Negative settlements

Sometimes a settlement ends with fees, refunds and charges larger than sales, for example during a slow period with high storage fees or after a wave of returns. In that case there's no deposit. Depending on your account settings and marketplace, the negative balance may be carried into the next settlement, or Amazon may charge a card or debit a bank account on file.

Reconcile it the same way. Summarise the settlement by component, and the total will be negative. If the balance was carried forward, it appears as an opening amount in the next settlement, and your clearing account will show Amazon briefly owing nothing, or you owing Amazon. If it was charged to a card or bank account, find that charge on the relevant statement and match it against the clearing account just as you would a deposit, in the opposite direction.

What to hand your accountant

At year-end or for a quarterly review, a tidy package saves your accountant time and saves you fees:

• A deposit-to-settlement schedule for the period: every Amazon deposit on the bank statement, its settlement ID and period, and a tick showing the settlement summary equals the deposit.
• Settlement summaries by component, ideally totalled by month as well.
• The reserve schedule and the closing clearing account balance, with an explanation of what it consists of.
• The original reports and bank statements, so every number can be traced.

If you also sell outside Amazon, keep each channel's reconciliation separate, then combine at the summary level. Our tax preparation checklist lists other records commonly needed at year-end.

A monthly checklist

1. Convert the bank statement and list every Amazon deposit.
2. Match each deposit to a settlement.
3. Summarise each settlement by component and confirm it equals the deposit.
4. Book each settlement with gross sales, refunds, fees, ads, adjustments and reserve movements.
5. Update the reserve schedule.
6. Check that the clearing account balance equals the current reserve plus any unpaid settlement.

This sits well inside a wider month-end close checklist. For comparison, the process is very similar to reconciling Shopify payouts and Stripe payouts, which also deposit net amounts.

Common problems

A deposit doesn't match any settlement. Check other marketplaces, failed and retried transfers, and whether you're looking at the right bank account.

A settlement doesn't sum to the deposit. A transaction type is missing from your grouping, often a less common fee or adjustment. Filter the settlement file for types you haven't mapped.

Income looks too low one month and too high the next. You're probably booking deposits as income, and reserves are moving between periods. Switch to booking gross sales with a clearing account.

Advertising appears in some settlements and not others. Depending on your payment settings, ad charges may be deducted from settlements or charged to a card. If they're charged to a card, they'll appear on your card statement instead.

The bank statement shows the deposit a few days after the settlement end. That's normal. Match on amount and settlement, not on date alone.

Get your bank deposits into Excel first

Reconciliation starts with a clean list of deposits. Upload your bank statement PDFs to SheetStatement, confirm the balances tie out, and export to Excel. Try it with 3 free pages a month.

FAQ

Why is my Amazon payout less than my sales?

Because it's net of fees, refunds, advertising, adjustments and any reserve Amazon holds. Your sales figure is the gross amount before those deductions.

Should I record Amazon deposits as income?

Not as a single sales line. Record gross sales as income and fees, refunds and ad spend separately, so your income and expenses are both accurate.

What is the Amazon reserve?

An amount Amazon may hold back from a settlement and release later. It's money owed to you, so it belongs on the balance sheet rather than in income.

Which Seller Central report should I use?

Settlement-level reports line up with individual payouts, which makes them best for reconciliation. Date range summaries are handy for monthly reporting.

How do I handle settlements that cross month-end?

Either book each settlement on its end date, or book sales and fees by calendar month using a clearing account. Choose one method and apply it consistently.

Do I need to record marketplace sales tax?

It depends on your jurisdiction and obligations. This is general information, not tax advice; ask a tax adviser.

Can I reconcile several marketplaces together?

It's much easier to reconcile each marketplace separately, with its own schedule and, if you use one, its own clearing account.

How much does SheetStatement cost?

The free plan includes 3 pages a month. Starter is $9 a month, Pro is $19 and Business is $39.