Guide · The report

Amazon's Date Range report, column by column: what each one means

The Date Range Transaction report lists every money movement in your Amazon Egypt account for the dates you pick, one row each: an order, a refund, a fee or a transfer to your bank. Each row says what happened, to which order and product, and how much it moved your balance, split into the sale and each fee. Read column by column, it adds up to what the month added to your Amazon balance.

Accreza team · Published 9 October 2026 · written with AI and checked by the team against Amazon Egypt's selling-fee page · fees as checked on 28 September 2026

Where do you download it?

In Seller Central, open Reports, then Payments.
Choose Date Range Reports, with the report type Transaction.
Pick a whole month, then download the CSV.

Use the file as Amazon gives it. A copy that has been edited or cut down easily loses the rows that aren't tied to an order, such as storage or advertising, and a missing row reads as a zero. A few lines of notes from Amazon can sit above the column names: the table starts at the row that begins with date/time.

It isn't the settlement report. A settlement covers a payment cycle, which can run across two months; the Date Range report covers exactly the dates you pick, which is what a monthly profit needs.

What is each row? The type column

The type column says what the row is. The ones you'll meet most:

Order: a sale. The money columns show the price, the fees Amazon took and what was left.
Refund: a sale given back, with the original order's number. What a return costs you reads it in detail.
Transfer: money Amazon sent to your bank. It's your payout leaving your balance, not a cost.
Service Fee: a charge to your account rather than an order, such as the subscription or advertising.
FBA Inventory Fee: charges on your stock in Amazon's warehouses, such as storage.
Adjustment: a correction, such as Amazon paying you back for a unit lost or damaged in its warehouse.
Easy Ship: charges for orders Amazon's carrier collected from you.

You may also meet Liquidations, A-to-z Guarantee Claim, Amazon Fees, FBA Transaction Fees and Others. Whatever the type, the description column names what the row is for.

The columns, one by one

date/time: when Amazon posted the row. The time is in UTC, not Cairo time, so a row posted just after midnight in Cairo carries the day before. At the start and end of a month, that moves a few rows into the neighbouring month.
settlement id: the payment cycle the row was paid in. A month's report holds rows from more than one settlement.
type: what the row is (above).
order id: the order's number. On a refund it's the original order's number, which is how you match the two. It's empty on rows charged to your account.
sku: your product code, empty on account rows. If your SKUs are all digits, open the file with this column as text: a spreadsheet turns them into numbers and can drop leading zeros, and then your costs no longer match.
description: on an order or a refund, the product's title; on an account row, the charge's name. Read it before treating a row as a sale.
quantity: the units on the row.
marketplace: the store the row belongs to, amazon.eg.
fulfillment: who shipped the order: Amazon (FBA) or you. Only Amazon-fulfilled orders carry an FBA fee.
order city, order state, order postal: where the order went. No money.
product sales: what the customer paid for the product, before Amazon's fees. Negative on a refund.
shipping credits: what the customer paid for shipping.
promotional rebates: your discounts and coupons, as a negative amount.
selling fees: the referral fee, with its 14% VAT included. Negative on an order; on a refund, the part Amazon gave back.
fba fees: the FBA fulfilment fee, VAT included.
other transaction fees: other charges on the row; on advertising rows, the advertising fee.
other: includes the cash-on-delivery collection fee, and on advertising rows, the VAT on the advertising.
total: the row's effect on your balance, its money columns added together.

Example: one order, as the report shows it

A product in Kitchen sold at E£400, a Standard Parcel of 1 kg, Fulfilled by Amazon (the product from the Excel sheet article). Its row:

Example

type: Order
quantity: 1
product sales: 400.00
selling fees: -52.44
fba fees: -29.64
total: 317.92

The referral fee of E£46.00 and the fulfilment fee of E£26.00 each show with their 14% VAT added, so together they are E£82.08, and the total is what this order added to your balance: E£317.92. Your own cost of the product isn't in the report. An example at an assumed price, with fees from Amazon's published table.

Five mistakes that throw a profit sheet off

Using the settlement report for a month: it covers a payment cycle, so it can mix two months.
Adding VAT to the report's fees: it's already in them. Add it only to fees taken from Amazon's fee table.
Counting transfers as costs: a Transfer row is your payout going to your bank.
Losing account rows: storage, advertising and the subscription have no order number, so a filtered or cut-down copy drops them first.
Reading the date as Cairo time: the time is in UTC, so rows near midnight at the month's edges belong to the other month.

Source: the report itself, as Seller Central exports it (Reports → Payments → Date Range Reports → Transaction); the example's fees from the selling-fee page on sell.amazon.eg, last checked 28 September 2026.

Common questions

Is the Date Range report the same as the settlement report?

No. A settlement covers one payment cycle, which can run across two months. The Date Range report covers exactly the dates you pick, so a whole month gives you that month and nothing else.

Do the fees in the report include VAT?

Yes. The selling fees and fba fees columns already include the 14% VAT. Amazon's fee table doesn't, so a fee in the report is higher than the same fee in the table.

Why doesn't the total match what reached my bank?

Your bank receives transfers, one per settlement, and a settlement's dates don't line up with your month. Add up the total column for the month, leaving out the Transfer rows, and you get what the month added to your Amazon balance.

Why do some rows have no order number?

They are charges to your account rather than to an order: the subscription, storage, advertising and the like. Their description column names the charge.

From the columns to your month. Your Date Range report becomes a profit-and-loss statement in your own browser. Check it free