Amazon Settlement Reconciliation: How to Calculate True Profit Per Order (2026 Guide)

Why Amazon Sellers Struggle to Know Their Real Profit Per Order

Ask ten Amazon India sellers for their monthly Gross Merchandise Value (GMV) and all ten will answer within seconds by checking the Seller Central mobile app. Ask those same sellers how much net cash they actually made on Order #408-7921405-8812349 after Amazon deducted referral commissions, fixed closing fees, Easy Ship weight-handling charges, GST TCS, Sponsored Products ad spend, and customer return penalties, and nine out of ten cannot give an exact number.

This visibility gap happens because Amazon does not settle orders one by one. Instead, Amazon aggregates thousands of forward orders, customer refunds, FBA storage charges, weight adjustments, and promotional rebates into a single bi-weekly NEFT bank transfer. When a ₹1,499 order lands in your bank account 14 days later as part of a lumped deposit, the connection between top-line revenue and unit-level profitability is obscured inside a 50,000-row flat file.

In this operational guide, we break down how to decode the Amazon India settlement report, calculate your true realized profit per order (Contribution Margin 3), and automate Amazon payment reconciliation so you never scale a loss-making ASIN or forfeit an eligible SAFE-T reimbursement claim.

Key Takeaways

• Gross Sales Does Not Equal Bank Payout: Between category referral fees (8%–17%), tiered fixed closing fees (₹7–₹51), Easy Ship or FBA weight slabs, 18% GST on marketplace services, and 1.1% statutory TCS/TDS withholdings, Amazon retains 22% to 38% of an order's selling price before remittance.
• Per-Order Profit Requires 3-Way Matching: True unit economics can only be calculated by linking three data sources at the Order ID level: (1) Internal OMS/SKU COGS Ledger, (2) Amazon SP-API Settlement Flat File V2, and (3) Corporate Bank UTR Deposit Statements.
• Four Hidden Leaks Drain 3%–5% of GMV: Volumetric weight overbilling, unreturned customer refunds past the 45-day SLA, category commission misclassifications, and un-reimbursed damaged returns silently turn profitable orders into net losses.
• Automated OMS Reconciliation Replaces Paid Add-Ons: Using an integrated platform like PointNXT Payment & Returns Reconciliation links warehouse barcode gate-entry scans directly to settlement audits at ₹0 extra module cost compared to standalone tools like Unicommerce UniReco.

1. The Amazon Settlement Sheet Decoder: Every Deduction Line Explained

To know how much money you make per order, you first need to translate the transaction types inside Amazon's Flat File V2 Settlement Report (accessible via Seller Central → Reports → Payments → All Statements or programmatically via the Selling Partner Finances API). Every single order triggers up to nine distinct financial entries:

"When we audited 1.2 million Amazon India transactions across 85 mid-market brands, over 78% of sellers were miscalculating their per-order profit by 6% to 11% because they relied on estimated fee percentages rather than reconciling actual post-settlement weight slabs, unreturned refunds, and non-recoverable return shipping charges."

Ankit Sharma, E-Commerce Operations & Financial Reconciliation Architect at PointNXT

2. Worked Mathematical Waterfall: Calculating Realized Profit on a Single Amazon Order

Most sellers use a rough mental formula: Selling Price minus 25% Amazon fee minus Product Cost = Profit. That shortcut fails in production because Amazon fees step up non-linearly across price bands, shipping zones, and return outcomes.

Below is the exact per-order unit economics waterfall used inside PointNXT's Order-Level Profit Ledger for a standard ₹1,499 D2C personal care SKU sold on Amazon India (Easy Ship National delivery, 500g package slab, 12% GST on product):

Line Item                                  Scenario A: Clean      Scenario B: Weight     Scenario C: Customer
                                           Delivered Order        Overbilled (1.5kg)     Return (Restocked)
-------------------------------------------------------------------------------------------------------------
1. Customer Selling Price (Incl. 12% GST)   ₹1,499.00              ₹1,499.00              ₹1,499.00
2. Net Taxable Product Revenue              ₹1,338.39              ₹1,338.39              ₹0.00 (Refunded)
3. Product GST Output Liability (12%)      -₹160.61               -₹160.61                ₹0.00 (Reversed)
-------------------------------------------------------------------------------------------------------------
AMAZON SETTLEMENT DEDUCTIONS:
4. Category Referral Fee (15% of ₹1,499)   -₹224.85               -₹224.85                ₹0.00 (Credited back)
5. Fixed Closing Fee (>₹1,000 Easy Ship)   -₹51.00                -₹51.00                -₹51.00 (Retained)
6. Easy Ship Weight Handling (National)    -₹68.00 (0.5kg)        -₹144.00 (1.5kg err)   -₹68.00 (Unrecovered)
7. 18% GST on Amazon Service Fees          -₹61.89 (ITC Claim)    -₹75.57 (ITC Claim)    -₹21.42 (ITC Claim)
8. Statutory 1% GST TCS + 0.1% TDS         -₹14.72 (Tax Credit)   -₹14.72 (Tax Credit)    ₹0.00
-------------------------------------------------------------------------------------------------------------
NET BANK SETTLEMENT (NEFT DEPOSIT)          ₹1,078.54              ₹988.86                -₹140.42 (Clawback)
-------------------------------------------------------------------------------------------------------------
INTERNAL UNIT ECONOMICS (CM1 TO CM3):
9. Add Back Claimable Tax Credits (ITC+TCS)+₹76.61                +₹90.29                +₹21.42
10. Less: Product GST Remitted to Govt     -₹160.61               -₹160.61                ₹0.00
11. Less: Landed Product COGS              -₹410.00               -₹410.00                ₹0.00 (Restocked QC)
12. Less: Corrugated Box & Void Fill       -₹32.00                -₹32.00                -₹32.00 (Destroyed)
13. Less: Attributed Amazon PPC Ad Spend   -₹135.00               -₹135.00               -₹135.00 (Sunk CAC)
-------------------------------------------------------------------------------------------------------------
REALIZED NET PROFIT PER ORDER (CM3)        +₹417.54 (+27.8%)      +₹341.54 (+22.8%)      -₹286.00 (NET LOSS)

Look closely at the three scenarios above:

1. The Return Multiplier Effect: One single customer return (Scenario C) burns ₹286.00 in sunk shipping, closing fee, packaging, and ad spend, even when the physical item returns undamaged and is restocked into sellable inventory. It takes 0.68 clean delivered orders just to pay for a single returned order. If the returned unit arrives damaged or gets lost in reverse transit without a SAFE-T claim, your loss on that single order jumps from -₹286.00 to -₹696.00 (wiping out the entire profit of nearly two successful orders).
2. The Silent Weight Tax: In Scenario B, when an automated sorting scanner misreads your 450g box as 1.5kg, your net profit per order drops by ₹76.00 (a 5% margin compression). Across 3,000 monthly orders, that single dimensional error drains ₹2,28,000 every month.

Want to test your own SKU numbers? Run your pricing through our free interactive Amazon India Seller Profit Calculator or compare FBA vs. 3PL costs in the FBA vs. OMS Cost Calculator.

3. The 4 Major Settlement Leaks That Skew Per-Order Profitability

Even if your pricing spreadsheet looks healthy on paper, four operational discrepancies routinely distort your realized Amazon payouts. Here is how to identify and audit each leak:

Leak 1: Easy Ship & FBA Volumetric Weight Slab Creep

Amazon calculates weight-handling fees using the greater of dead weight or volumetric weight: (Length × Width × Height in cm) / 5000. When warehouse packers use slightly oversized corrugated cartons, or when polybag corners puff out on conveyor belts, cubiscan lasers record an inflated dimension. Because Amazon applies that updated measurement across subsequent dispatches of the same ASIN, a single bad scan can overcharge hundreds of orders in a settlement cycle.

The Fix: Maintain a master SKU dimension and calibrated weight registry inside PointNXT Amazon Seller Software. Whenever a settlement line item charges a weight handling fee above the SKU's expected slab, PointNXT isolates the affected Order IDs and generates a bulk dispute table with scale photographs.

Leak 2: Refunded Orders With Missing Physical Returns (The 45-Day Trap)

On both Easy Ship and FBA, Amazon debits the customer's refund from your settlement balance the moment the return pickup is scanned by the courier. However, reverse logistics parcels frequently stall at regional hubs or get lost in transit. For FBA returns, if the customer fails to return the item within 45 days of refund issuance, Amazon is supposed to automatically reimburse the seller, yet audits show that 4% to 7% of unreturned FBA refunds require manual case escalation, and Easy Ship lost returns require proactive SAFE-T claims within strict filing windows.

The Fix: Never treat a "Return Initiated" status as a completed return. PointNXT links every Amazon return authorization to a mandatory Warehouse Barcode Gate-Entry Scan. Any refunded order without a physical warehouse dock scan (or FBA reimbursement credit) after 45 days is automatically pushed to your claims queue. Read our detailed breakdown in Cross-Marketplace Returns Discrepancy & Recovery Claims.

Leak 3: Damaged, Used, or Counterfeit Switch Returns (SAFE-T Claims)

When a buyer returns an old used product, an empty box, or a physically damaged item via Easy Ship or Self-Ship, sellers can recover up to 100% of the order value through an Amazon SAFE-T (Seller Assurance for E-Commerce Transactions) claim. However, Amazon rejects SAFE-T claims that lack clear images of the outer shipping polybag, the intact AWB barcode label, and the damaged product.

The Fix: PointNXT's return QC station prompts warehouse operators to scan the return AWB barcode under an overhead camera, automatically binding timestamped unboxing photos and videos to the Order ID for one-click SAFE-T submission.

Leak 4: Unattributed Sponsored Products Ad Spend (TACOS Distortion)

Many Amazon sellers deduct their monthly advertising invoice as a lump-sum company overhead at the end of the month. That hides the fact that 20% of your catalog may be consuming 70% of your ad budget while generating negative post-return contribution margins. As detailed in our guide on Order-Level Profitability & Ad Spend Alignment, attributing PPC spend down to the ASIN and order level is the only way to calculate true Contribution Margin 3 (CM3).

4. Step-by-Step Workflow: How to Reconcile Amazon Settlements into Tally & Zoho Books

Once you have reconciled your per-order payouts and isolated fee disputes, your finance team still needs to close the monthly books accurately for GST and income tax compliance. Entering a net bank deposit of ₹8,42,150 directly as "Amazon Sales" in Tally is a serious accounting error that under-reports both your gross turnover and your claimable GST Input Tax Credit (ITC).

Instead, every Amazon settlement statement must be booked using a balanced double-entry journal voucher that separates gross sales, marketplace service expenses, GST ITC, statutory withholdings, and net bank receipts:

PointNXT automates this entire accounting bridge. Instead of spending 10 days every month reconciling B2C invoices, GSTR-8 TCS credits, and Amazon fee tax invoices manually, PointNXT exports pre-mapped vouchers directly into Tally Prime, Zoho Books, and SAP Business One. For a deeper look at tax credit matching, read our guide on TDS & TCS Withholding Reconciliation for E-Commerce GST.

5. Why Integrated OMS + WMS Reconciliation Beats Standalone Tools

When scaling brands realize that manual Excel reconciliation is unsustainable, they typically evaluate two software paths:

• Path A: Standalone or Bolted-On Reconciliation Add-Ons (e.g., Unicommerce UniReco): Legacy vendors charge ₹30,000 to ₹80,000+ per year as an extra module fee on top of your OMS license. Worse, because the financial reconciliation module is separated from the warehouse floor, you still have to manually sync return gate-entry logs and compile unboxing evidence photos from separate folders.
• Path B: PointNXT Unified OMS + WMS + Native Reconciliation: PointNXT embeds Amazon payment reconciliation and per-order profitability tracking directly inside the core ₹2/order platform at ₹0 additional module cost. Because your order processing, master SKU weights, warehouse barcode return scans, and SP-API settlement parsers live in one database, discrepancies are flagged the moment a settlement report arrives.