Amazon Reconciliation

AED 43.8K in Gross Sales. AED 15.3K in Amazon Payout. Where Did the Money Go?

We reconciled a real Amazon settlement line by line. The gap between gross sales and deposit was AED 28,500 — every dirham was mapped. Here is what we found, and what you should check in your own account.

Real UAE marketplace account · 14-day settlement cycle · FBA reconciliation

Gross Sales
AED 43.8K
Before any deductions
Actual Deposit
AED 15.3K
What reached the bank
Apparent Gap
~AED 28.5K
Before reconciliation
Residual After Recon
AED 124
After full mapping

A Gap That Looks Like a Problem, Until You Map It

A seller sees AED 43,800 in gross sales on their Amazon dashboard. The bank deposit shows AED 15,300. If you do not know what sits between those two numbers, that gap looks like a significant problem — money unaccounted for, fees unknown, possible errors in Amazon’s system.

In practice, the gap is almost always explainable. Amazon does not simply send you a percentage of your sales. It deducts every cost that touches the order — fulfilment fees, referral fees, advertising charges, refund costs, storage, promotions — before calculating your payout. The settlement report is the document that shows the arithmetic.

Most sellers never open it. They check the deposit, assume it looks about right, and move on. The problem is that "looks about right" is not the same as "is correct." And for accounts doing meaningful volume, a 1–2% error in Amazon’s favour compounds quickly.

“The gap was AED 28,500 before reconciliation. After mapping every line in the settlement report, the unexplained residual was AED 124. That is the number that tells you whether reconciliation is complete.”

The Settlement Ledger, Line by Line

Settlement Period · 14 Days
One standard Amazon settlement cycle — UAE marketplace, FBA
Starting Point
Gross Product Sales
Gross
AED 43,800
Deductions
FBA Fulfilment Fees
Deduct
− AED 12,650
Referral Fees
Deduct
− AED 6,650
Advertising Charges
Deduct
− AED 6,050
Customer Refunds
Deduct
− AED 2,600
Promotions & Coupons
Deduct
− AED 920
Other Item Fees
Deduct
− AED 640
Storage Fees
Deduct
− AED 580
Positive Adjustments
Shipping Credit Adjustment
Credit
+ AED 1,440
Reconstructed Payout
Calculated
~ AED 15,170
Actual Bank Deposit
Confirmed
AED 15,300
Unexplained Residual
Review
AED 124

Why the Residual Matters More Than the Total

AED 124 is a small number. But the residual is not the point — the discipline of getting to it is. When you can reconcile a settlement to a small, explainable remainder, you know your fee structure is approximately correct. When you cannot, you do not know which part is wrong.

The sellers most at risk are those who never attempt this mapping and instead assume that Amazon’s numbers are always accurate. They are usually close. But "close" on a high-volume account can represent thousands of dirhams per settlement cycle.

Understanding the arithmetic also tells you something more useful: exactly which fee category is consuming the most margin. In this settlement, FBA fees (AED 12,650) and referral fees (AED 6,650) together account for more than AED 19,000 — over 43% of gross sales. Advertising adds another AED 6,050. Before you look for hidden errors, you need to understand the structure of legitimate costs.

How Reconciliation Actually Works

Step 01
Pull the settlement report from Seller Central
Go to Payments → Settlement Reports. Download the flat file for the period you are reviewing. This contains every transaction type, not a summary.
AED 43,800
Step 02
Map every deduction category
Group line items by type: fulfilment fees, referral fees, advertising, refunds, storage, other. Each category should match a known rate or agreement.
− AED 29,090
Step 03
Identify positive adjustments
Credits appear in the settlement too — shipping adjustments, reimbursements for lost or damaged inventory, promotional funding. These offset deductions.
+ AED 1,440
Step 04
Reconstruct your expected payout
Add gross sales, subtract all deductions, add positive adjustments. This is your calculated payout. In this settlement: AED 43,800 − AED 29,090 + AED 1,440 = ~AED 15,170.
~ AED 15,170
Step 05
Compare against actual deposit
Check the amount that reached your bank. In this case: AED 15,300. The difference between reconstructed (AED 15,170) and actual (AED 15,300) is AED 130.
AED 15,300
Step 06 · Resolution
Identify and document the residual
The AED 124 residual sits in a line item not yet fully categorised — a small rounding difference or minor adjustment. Once identified, reconciliation is complete. This is the threshold you are working toward.
Residual: AED 124

Before and After You Open the Settlement Report

Before Reconciliation
~AED 28,500
Unexplained gap between gross sales and deposit. No visibility into which deductions are legitimate, which are unexpected, and whether any charges are in error.
After Reconciliation
AED 124
Residual after mapping every deduction and credit. All major cost categories are accounted for. The remainder is small enough to investigate as a specific line item.

Three Questions for Every Line Item

Apply these to each charge in your settlement report
01
Was this charge recorded in our own cost tracking?
If a fee appears in the settlement but does not exist in your internal records, you are carrying an unrecognised cost. This is not necessarily an error — but it needs to be acknowledged and categorised before you can model your true margins.
02
Does this charge belong to this settlement period?
Amazon sometimes applies fees from prior periods — storage charges, advertising true-ups, refund adjustments — in a later settlement. If a charge appears unexpectedly, check whether it corresponds to activity from a previous cycle before treating it as anomalous.
03
Can it be mapped to a specific transaction or policy?
Each fee type in the settlement corresponds to either a transaction (a sale, a refund, a shipment) or a policy (your referral rate, your FBA fee tier, your storage rate). If a charge cannot be mapped to either, it is a candidate for a Seller Central case — not an assumption that Amazon is correct.

Reconciliation vs. Reimbursement: Two Different Activities

Reconciliation
Verifying what Amazon charged
What it isMapping every line in your settlement report to a known cost type, until the residual gap is small enough to explain.
What it tells youWhether the fees Amazon charged you match the rates and transactions in your account — and whether your cost model is complete.
When to do itEvery settlement period, before you calculate contribution margin for any SKU. Fees that were not captured will make your margin model wrong.
OutcomeA confirmed cost structure and a small, documented residual — typically under AED 200 for a standard settlement cycle.
Reimbursement
Recovering money Amazon owes you
What it isIdentifying cases where Amazon lost or damaged your inventory, failed to reimburse a customer return, or charged you for a fulfilment error — and opening a case to recover those funds.
What it tells youWhether you are leaving recovered margin on the table. Reimbursements do not happen automatically — Amazon will not surface them unless you identify and claim them.
When to do itQuarterly at minimum, across your FBA inventory records. Higher-volume accounts may benefit from monthly review, particularly for categories with higher damage or return rates.
OutcomeRecovered funds credited to your account — typically within 30 days of an approved case. In this account, AED 40.99 was identified as a potential reimbursement candidate.

The Second Settlement Shows the Same Pattern

This was not a one-off. A second settlement from the same account period showed the same structure: a large apparent gap that maps almost entirely to legitimate, categorisable deductions.

Second Settlement Period · Same Account
Gross Sales
AED 31.2K
Actual Deposit
AED 11.2K
Residual After Recon
~AED 24
Same fee categories, same arithmetic. The apparent gap of AED 20,000 resolves to approximately AED 24 once every deduction is mapped. The pattern holds across cycles once the settlement structure is understood.

Two settlements, two apparent gaps, both reduced to small residuals through the same process. The consistency matters: it means the account's fee structure is stable and approximately correct. Variation between cycles — in the fee rates, not just the amounts — is where errors tend to appear.

What Reconciliation Reveals That the Dashboard Does Not

Amazon Seller Central shows you gross sales and your deposit. It shows you advertising spend if you check Advertising Console separately. It does not show you the ratio of fulfilment fees to revenue, or what percentage of gross sales is absorbed by refunds, or whether your storage costs are growing faster than your sales.

The settlement report shows you all of this, because it is the complete arithmetic of the payout calculation. Once you have mapped it, you can calculate contribution margin with precision — not an estimate based on listed fee rates, but the actual amount taken from your account in a specific period.

For accounts selling across multiple categories or at varying price points, the settlement also reveals something useful about your fee structure: whether your higher-priced items carry disproportionately high fulfilment costs, or whether your return rates are concentrated in specific SKUs. These are margin questions that start with reconciliation.

The 7-Step Reconciliation Workflow

  1. 01
    Download the flat-file settlement report from Seller Central
    Navigate to Payments → Settlement Reports. Download the complete flat file, not the summary view. The flat file contains individual transaction types that are aggregated and therefore hidden in the summary.
  2. 02
    Identify your gross product sales figure
    This is your starting point. It represents sales revenue before any Amazon deductions. Confirm it matches what you see in the Business Report for the same period — discrepancies here need to be explained before you continue.
  3. 03
    Group and total every deduction by category
    Sort the flat file by transaction type. Group into: FBA fees, referral fees, advertising, refunds, promotions, storage, other item fees. Total each group. This tells you where your margin is being consumed before you look for errors.
  4. 04
    Identify all positive adjustments and credits
    Credits from shipping adjustments, reimbursements, or promotional funding appear as positive values. These offset your deductions. If you received a reimbursement for lost inventory, it will appear here — but only if Amazon processed it. Not all eligible reimbursements are automatically issued.
  5. 05
    Reconstruct your expected payout
    Gross sales minus all deductions plus all positive adjustments equals your calculated payout. Build this in a spreadsheet rather than doing it mentally. The calculation should be reproducible — you will run it every settlement cycle.
  6. 06
    Compare your calculated payout to the actual deposit
    Check the bank statement or the Payments section in Seller Central for the confirmed deposit amount. Subtract your calculated payout from the actual deposit to identify the residual. A residual under AED 200 on a standard cycle is typical. Above that threshold, continue investigating.
  7. 07
    Document the residual and investigate if above threshold
    A small residual (under AED 200) is usually a timing difference or minor rounding. A larger residual warrants a line-by-line review of unmatched items. If you identify an error — an overcharge, a missing credit, a fee applied at the wrong rate — open a Seller Central case with the specific transaction ID. Do not submit vague disputes; Amazon requires specific documentation.

Settlement Reconciliation Checklist

Nine items to verify in every settlement cycle
  1. Gross sales match Does the gross sales figure in the settlement report match what you see in Business Reports for the same period? Discrepancies at this stage affect everything downstream.
  2. FBA fee rates are correct Amazon updates FBA fee tiers periodically. Confirm that the per-unit fees charged match the current rate card for your product dimensions and weight. An incorrect size tier costs you more per order.
  3. Referral fees are at the correct category rate Referral fee percentages differ by category. If your products are miscategorised, you may be paying a higher referral rate than your category should carry.
  4. Advertising charges match your campaign spend Cross-reference the advertising line in the settlement against your Advertising Console spend report for the same period. The figures should match to within small rounding margins.
  5. Refunds include re-credited fulfilment fees When a customer returns an item, Amazon should credit back the fulfilment fee associated with that order. Check that refund credits reflect the full fee recovery, not just the sale price.
  6. Storage fees match expected rates and inventory levels Storage fees are charged monthly based on cubic feet. If your storage charge has increased, confirm whether it reflects higher inventory levels or a fee rate change — including any long-term storage fee surcharges.
  7. All positive credits are accounted for Credits can appear for shipping adjustments, reimbursements, or other corrections. Ensure every credit line is identified and corresponds to a known event, not an unresolved anomaly.
  8. Lost or damaged FBA inventory has been identified for reimbursement Amazon's systems do not always automatically reimburse lost or damaged inventory. Run an inventory reconciliation against your FBA inventory report to identify units that were received, lost, and not reimbursed.
  9. The residual is documented and below threshold After mapping every deduction and credit, document the unexplained residual. A residual under AED 200 is acceptable for a standard 14-day cycle. Anything larger requires further investigation before you close the reconciliation.

Frequently Asked Questions

How often should I reconcile my Amazon settlement?

Every cycle — Amazon pays out approximately every 14 days, and each settlement report covers a distinct period. Running reconciliation per cycle means you identify fee anomalies while the transactions are still recent and cases can be opened with specific data. Quarterly reconciliation misses the window for accurate disputes and allows errors to compound across multiple cycles.

What if my residual is large — say AED 2,000 or more?

A large residual almost always indicates that one or more line items have not been correctly categorised. Start by sorting the flat file by amount and working through the largest unmatched items first. Common causes include: a large advertising charge that was applied to the wrong period, a promotional adjustment that was not captured in your model, or a bulk refund event linked to a return promotion. If you cannot identify the source after reviewing specific line items, contact Seller Support with the transaction IDs and ask for clarification on those charges specifically.

What is the difference between a settlement report and a Business Report?

The Business Report shows you sales activity — units ordered, sessions, conversion rates, revenue. It does not show you the cost deductions Amazon applies before paying you. The settlement report shows you the payout calculation: every fee, every refund, every credit, and the final transfer amount. Reconciliation requires the settlement report, not the Business Report. Sellers who rely only on Business Reports to estimate their economics are missing the cost half of the equation.

How do I identify if Amazon owes me a reimbursement?

Run an inventory reconciliation: compare your starting FBA inventory at the beginning of the period, add inbound shipments, subtract sales and customer returns, and compare the result to your closing inventory. Units that are unaccounted for — not in your inventory, not shown as sold, not returned to you — are candidates for reimbursement. Amazon's own Inventory Adjustments report in Seller Central shows adjustments made to your inventory, including those coded as lost or damaged. Cross-reference that report against any reimbursements you have received to identify gaps.

Is reconciliation worth the time for smaller accounts?

The direct financial recovery from a small account may not justify intensive monthly reconciliation. But reconciliation has a secondary value that applies regardless of account size: it tells you your actual cost structure. A seller who cannot reconcile their settlement does not know their true margins, even if the total recovery from error correction is small. For accounts below AED 20,000 monthly gross, a quarterly reconciliation with a simpler summary approach is usually sufficient. For accounts above that threshold, cycle-by-cycle reconciliation is standard practice.

About the data in this article: Settlement figures are drawn from a real Amazon UAE account managed by Saddl. Gross sales, fee categories, and payout amounts have been confirmed against the raw settlement flat file. Identifying details have been removed. The reconciliation methodology described follows Amazon's documented settlement report structure. Reimbursement amounts are identified candidates, not confirmed recovered amounts, unless stated otherwise. Fee rates are accurate for the period of the settlement and may differ from current Amazon fee schedules.
Saddl · Managed Marketplace Operations

Know exactly what Amazon is taking — and whether it is correct.

Saddl reconciles your Amazon and Noon settlements monthly as part of managed account operations. If there is an error in your fee structure, we find it. If there is a reimbursement you have not claimed, we identify it.

Request an account review

UAE & GCC marketplace operators · Amazon & Noon · No obligation

← Return to all articles