Amazon Seller Hisab & Monthly Profit Loss Calculation: Complete Step-by-Step Guide
The Dangerous Gap Between Gross Sales and Bank Payouts
One of the most common pitfalls for Amazon India sellers is treating Gross Sales (Product Revenue) as business profit. A seller generating ₹10,00,000 in monthly orders may find only ₹4,80,000 deposited into their bank account by Amazon. After paying inventory suppliers, packaging, and operating costs, many sellers find themselves in a cash-flow deficit without knowing which specific products are causing the loss.
True Amazon Seller Hisab requires reconciling your raw monthly settlement ledger transaction by transaction, calculating exact unit cost of goods sold (COGS), and identifying hidden reverse courier charges on returned items.
The 5 Amazon Fee Deductions Every Seller Must Track
Amazon India's fee architecture deducts multiple fees before initiating periodic NEFT disbursements:
| Deduction Category | How It Is Calculated | Impact on Margins |
|---|---|---|
| Referral Fee | Category percentage (typically 3% to 18% of selling price). | Standard platform commission. |
| Closing Fee | Fixed fee based on price slabs (₹5 up to ₹61+ per item). | High percentage burden on low-ticket items under ₹300. |
| Easy Ship / FBA Fees | Weight handling fee based on physical/volumetric weight slab. | Increases sharply on national and heavy shipments. |
| Customer Returns & Refunds | Product price refund to buyer minus partial fee refund. | Seller pays shipping both ways; inventory may return damaged. |
| TDS (194-O) & TCS GST | 1% TDS under Income Tax Act + 1% TCS under GST laws. | Immediate cash withholding (claimable as tax credit). |
How to Export Amazon Date Range Transaction Reports
To do your monthly hisab accurately, you must download the unaggregated transaction report from Seller Central:
- Log in to Amazon Seller Central India (sellercentral.amazon.in).
- From the left navigation drawer, go to Reports > Payments.
- Click on the Date Range Reports tab along the top bar.
- Click the Generate Report button.
- Select Transaction (do NOT select Summary, as Summary lacks individual order IDs and SKUs).
- Select Custom Date Range (e.g. 1st Oct to 31st Oct) and choose CSV format.
- Click Generate. After 1–2 minutes, click Download.
The Exact Mathematical Formula for Amazon Seller Hisab
The true net monthly profit formula for your Amazon seller business is:
Net Profit = [ Bank Settlement Amount (Order Sales - Referral Fees - Closing Fees - Easy Ship Fees - Refunds - Taxes) ] - [ Sum of (Units Delivered * Unit Purchase Price COGS) ]
If you have non-order expenses (such as Amazon Sponsored Products advertising spend or monthly professional seller fees), these are subtracted from your overall account net earnings.
Accounting for Customer Returns and RTO Courier Holdbacks
High return rates on Indian e-commerce (especially Cash on Delivery parcels) erode profitability. When an order is refunded, Amazon returns part of the referral commission, but the seller forfeits the forward Easy Ship delivery fee and may incur return processing charges. If the returned item arrives unsellable, the entire product inventory cost becomes a total loss.
Tracking your hisab SKU by SKU allows you to detect items where the return rate exceeds 20%, allowing you to adjust pricing, fix packaging, or discontinue the product before it wipes out profits from winning items.
Using LabelCropper Hisab for Private Reconciliation (₹50)
Instead of wrestling with complex Excel formulas, VLOOKUPs, and pivot tables, Indian sellers can use LabelCropper E-Commerce Hisab for just ₹50 per report. The tool processes your raw Amazon CSV locally inside your browser memory with zero server uploads, matches bank settlement figures to the exact paisa, and provides live SKU-wise profit/loss margins.