How to Read an Amazon Settlement Report, Line by Line

If you sell on Amazon, you have probably looked at a deposit in your bank account and wondered how it relates to what you sold. It rarely matches. The settlement report is where the answer lives, but it is a dense file and nobody explains how to read it. This is how I approach it.

What a settlement report actually is

A settlement report is Amazon's statement for a settlement period. It lists every financial event in that period: sales, fees, refunds, reimbursements, ad charges, storage fees and the final transfer to your bank. The total at the bottom is what Amazon intends to pay you.

Two things trip people up:

• Settlement periods are not calendar months. They run on Amazon's cycle, so a period can start in one month and end in the next. Some accounts have a period that closes mid-month.
• Orders and payments are different timelines. An order placed today may not appear in a settlement for days or weeks. A refund may land in a period long after the original sale.

So you cannot compare your sales for March to your deposits for March and expect them to agree. That is normal, not a mistake.

The columns that matter

The raw report is a flat file with many columns. You can ignore most of them at first. These are the ones I look at:

• Order ID. Ties the line to a specific order. Some lines, like storage fees, have none.
• Transaction type. The broad category: Order, Refund, Other-transaction and so on.
• Amount type. What kind of money it is: ItemPrice, ItemFees, Promotion, and similar.
• Amount description. The specifics: Principal, Tax, Shipping, Commission, FBA fulfillment fee and so on.
• Amount. The number, positive or negative.
• Posted date. When Amazon recorded it, which is the date to use for matching.

The pattern is that one order produces several lines. A single sale might have a principal line, a tax line, a shipping line, a commission line and an FBA fee line. Add them up by order ID and you get what that order really paid you.

Walking through one order

Here is an illustrative example with made-up numbers, not a real report.

A customer buys one item for 30.00 with 2.40 of sales tax.

1. Principal: +30.00
2. Tax: +2.40
3. Tax collected and remitted by the marketplace: -2.40
4. Commission (referral fee): -4.50
5. FBA fulfillment fee: -5.00

Net to you: 20.50.

The tax lines are the part that confuses people. In many places Amazon collects and remits sales tax itself as a marketplace facilitator, so the tax shows up and then offsets. It is not your revenue and it is not your expense. Which jurisdictions this applies to and what you must still report is a question for your accountant or tax adviser, not something to guess at.

If that order is later refunded, you will see a Refund line with the principal returned as a negative, often with part of the commission given back and sometimes a refund administration fee kept. The refund can post in a different settlement from the sale.

Lines that are not orders

The lines with no order ID are where money quietly leaks. Look for:

• Advertising charges. Sometimes billed separately, sometimes inside the settlement, depending on your setup.
• Storage fees and long-term storage fees. Monthly and not tied to a sale.
• Reimbursements. Money Amazon pays you for lost or damaged inventory. Good to see, but it should be recorded as such, not mixed into sales.
• Subscription fee. The monthly seller plan charge.
• Reserves and adjustments. Amazon may hold back funds, which then release later.

These matter because they reduce your real margin per unit. If you only look at order-level fees, you will overstate profit.

How to check that the deposit adds up

This is the habit worth building. For each settlement:

1. Take the total from the settlement report.
2. Find the matching deposit in your bank statement. Confirm the amount and date.
3. Sum the report lines by category: sales, tax, fees, refunds, other.
4. Confirm those categories add to the total.
5. Note anything with no order ID that you do not recognise and look it up in Seller Central.

If the bank deposit and the report total differ, the usual causes are a reserve, a split settlement across two periods, or a currency conversion. Work out which before you book anything.

Booking it sensibly

A common mistake is to record the bank deposit as income. That hides the fees and refunds inside a single net number, so you lose sight of what Amazon costs you. A cleaner approach is to record gross sales, then fees, refunds and other charges as separate lines, with the deposit clearing against a settlement or clearing account. How you do that exactly depends on your chart of accounts, so ask your bookkeeper to set it up once.

Watch for these

• Fees that rise without you changing anything, such as FBA fees after a size or weight reclassification.
• Refunds for items that were never returned to inventory.
• Reimbursements you are owed but have not received.
• Settlements that straddle a month end, which can distort your monthly profit if you book by deposit date.

Doing this at scale

Reading one settlement by hand is fine. Doing it every cycle, next to payouts from Shopify, Faire, Walmart and the rest, is where it gets heavy, because every channel has its own format and timing. KovaBooks reconciles orders, payouts, fees, refunds and tax per channel inside Shopify, so you can see profit per order and export to QuickBooks.

Either way, learn to read the report once. You will spot problems much sooner.