How to Read Your Amazon Transaction Report & Spot Discrepancies

Your Amazon transaction report is the most detailed record of every financial event in your seller account — from sales and refunds to fees, adjustments, and reimbursements. Yet most Indian sellers never examine it beyond glancing at the final settlement amount. This is a costly mistake. Hidden within these reports are commission overcharges, incorrect weight-based fees, missing reimbursements, and other discrepancies that can add up to lakhs of rupees over a year. Learning to read and analyse your transaction report is one of the highest-ROI skills a seller can develop.

Understanding the Report Structure

Amazon provides several financial reports through Seller Central, but the transaction-level detail is found in the Payments reports section. Navigate to Reports > Payments > Transaction View or download the Date Range Report for a comprehensive CSV file. Each row represents a single financial event — an order payment, a fee charge, a refund, an adjustment, or a transfer to your bank account.

Key columns to understand include: the transaction type (Order, Refund, Service Fee, Adjustment, Transfer), the order ID (which links back to a specific customer order), the product details, the total amount, and the breakdown into principal (the sale price), commission, FBA fees, shipping credits, and other charges. The settlement period groups these transactions into payment cycles, and the net amount is what gets deposited into your bank account.

Spotting Commission Rate Errors

Amazon charges referral fees (commissions) based on your product category. These rates are published on Amazon Seller Central and range from 2% to 30%. However, errors occur when products are categorised incorrectly, when rate changes are applied retrospectively, or when promotional rate periods end without your knowledge.

To check for commission errors, calculate the referral fee percentage for a sample of transactions by dividing the referral fee by the selling price. Compare this against the published rate for your product category. If you find discrepancies, file a case with Amazon Seller Support with the specific order IDs and the expected vs actual commission rates. Common scenarios include products that should be in a lower-commission category being misclassified under a higher-commission one — particularly when selling bundled products or accessories.

Verifying FBA Fees and Weight Charges

For FBA sellers, fulfilment fees are calculated based on the product's size tier and weight. Amazon measures and weighs products at their fulfilment centres, and these measurements determine your fees. The problem is that Amazon's measurements do not always match your actual product specifications — packaging changes, measurement errors, or products being assigned to the wrong size tier can inflate your fees.

Download the FBA Fee Preview report and cross-reference the dimensions and weight Amazon has on file against your actual product specifications. If you find discrepancies, submit a re-measurement request through Seller Central. Sellers have reported overcharges of Rs 10-30 per unit due to incorrect weight classification, which at scale represents significant lost revenue. Maintain a master list of your product specifications and review Amazon's recorded dimensions quarterly.

Tracking Refunds and Return Adjustments

When a customer returns a product, Amazon processes a refund and deducts it from your settlement. However, the refund should also trigger a partial commission refund to you — Amazon refunds a portion of the referral fee when a return is processed. Verify that you are receiving these commission refunds by matching refund transactions against the original order commissions.

Also watch for cases where Amazon issues a refund to the customer but you never receive the returned product. Under Amazon's FBA returns policy, if the item is not returned to the fulfilment centre within 45 days, you are entitled to a reimbursement. Track your refund-to-return reconciliation to identify these missing reimbursements. Some sellers have recovered significant amounts by systematically claiming reimbursements for unreturned items.

Building a Systematic Review Process

Rather than waiting for year-end to review your transaction reports, establish a systematic weekly or bi-weekly review process. Download the settlement report after each payment cycle and run the following checks: verify total settlement matches bank deposit, sample-check commission rates on 10-15 transactions, compare FBA fees against expected rates, and reconcile refunds against returned inventory.

For sellers processing more than 100 orders per day, manual review is impractical. This is where automated reconciliation tools become essential. They can ingest your Amazon transaction data, apply automated checks across thousands of line items, and surface only the exceptions that need human attention. The time saved and discrepancies caught typically deliver a return many times the cost of the tool.