Industry playbook
E-commerce sellers (Amazon, Flipkart, Meesho, Shopify)
How e-commerce sellers automate marketplace settlements, returns and GST with hisabkitab
Picture a home-décor and apparel seller listing on Amazon, Flipkart and Meesho and running its own Shopify store. It ships from its own warehouse in one state, holds additional GST registrations for marketplace fulfilment warehouses, and handles a few hundred orders on a busy day.
See hisabkitab for E-commerce sellers (Amazon, Flipkart, Meesho, Shopify) →
The challenges
Why marketplace money never matches marketplace sales
Settlements are not sales
A marketplace payout nets off commission, shipping, fixed fees, ads, TCS and TDS from the sale value. Matching a single bank credit to hundreds of orders and deductions by hand takes days, and errors go straight into the profit figure.
Returns, RTO and claims
Customer returns, return-to-origin parcels and damaged-in-transit claims arrive weeks after the sale. Without credit notes against the original orders, GST is overpaid and stock never matches the warehouse.
TCS and TDS deducted by operators
Marketplaces collect GST TCS and deduct income-tax TDS on seller payouts. If these are not reconciled with the operator's statements, the seller misses credits that are rightfully theirs.
One business, several GSTINs
Stock placed in marketplace warehouses in other states needs a GST registration in each state. Each GSTIN files its own returns, and keeping books, stock and transfers straight across them is a common source of mistakes.
Invoice numbers that fail GSTR-1
Marketplace order IDs are often long, while GST invoice numbers must stay within 16 characters. Uploading sales built on raw order IDs can cause GSTR-1 errors that surface only at filing time.
A day in the life
A day before vs after hisabkitab
Before
Staff download settlement reports from each marketplace and reconcile them in Excel for days.
Returns are tracked in a sheet; credit notes are rarely raised against the original orders.
TCS and TDS are taken from the marketplace statement without checking.
Each state registration's books are maintained separately with manual stock transfers.
With hisabkitab
Marketplace sales and settlement sheets from Amazon, Flipkart and Meesho are imported straight into hisabkitab.
Returns and RTOs are recorded as credit notes against the original sales, restoring stock.
TCS and TDS are reviewed through the TCS and TDS reports before claiming.
Each GSTIN runs as its own company under one login, and GSTR-1 data is validated before upload.
Solutions
How hisabkitab solves it
Settlement matching
Amazon/Flipkart/Meesho settlement imports
Import the platform-provided sales and settlement sheets. Orders, fees, commissions and deductions post to the right ledgers, so the payout in the bank can be matched to the orders behind it.
Own-store orders
Shopify / WooCommerce integration (Advance)
Connect your own store so orders flow into hisabkitab instead of being re-typed.
Returns and RTO
Sale Return / Credit Note
Record each return against its original sale so stock and GST liability are corrected for the right period.
Operator TCS and TDS
TCS Report + TDS Report
Track TCS collected and TDS deducted by each marketplace, and compare with the operator's statements before claiming credit.
Several state registrations
Multi-company (one company per GSTIN)
Run each state registration as a separate company under one login. Advance includes four companies, with more as add-ons.
GSTR-1 rejections
GSTR-1 validation
Check GSTR-1 data for issues such as over-length invoice numbers before upload, so errors are fixed in your books, not on the portal.
True profit per SKU
Custom Field formula + Item-wise Profit Report
Use a Net realisation formula to see what each SKU actually earns after marketplace costs.
Inside the software
Built for your books
Custom formula example
Net realisation = Selling price − Marketplace commission − Shipping fee − Fixed/closing fee. Example: ₹1,499 − ₹225 − ₹85 − ₹30 = ₹1,159 realised before GST effects and ads.
4-level grouping
Items: Home Décor → Cushion Covers → Fabric (Velvet) → 16×16 Set of 5. Customers/channels: Channel (Amazon) → Fulfilment type → State → Marketplace ledger.
Reports you’ll use
TCS Report · TDS Report · Item-wise Profit Report · Stock Summary · GST Report · Party-wise Sales Report
Compliance notes
E-commerce operators collect GST TCS on net taxable supplies made through them (currently 0.5% under CGST/SGST or IGST) and may deduct income-tax TDS on payouts; both should be reconciled with operator statements before claiming. Stock held in another state's fulfilment centre generally requires registration in that state. GST invoice numbers must not exceed 16 characters, and B2B orders above the e-invoicing threshold need an IRN.
Recommended plan
The plan that fits
Advance
₹6,999/year, exclusive of 18% GST (or ₹13,999 for 3 years)
Marketplace sellers need multi-company for state GSTINs, a native store integration, unlimited e-invoices and e-way bills, and AI-OCR for supplier bills, which is why the business mapping places them on Advance.
FAQs
Frequently asked questions
Can hisabkitab import Amazon, Flipkart and Meesho data?
Yes. Import the sales and settlement sheets that each platform provides. Orders, returns, fees and deductions are brought into hisabkitab so you can match payouts to orders and keep GST and stock accurate, without retyping hundreds of lines every week.
How do I handle stock in marketplace warehouses in other states?
Each state registration runs as its own company under one hisabkitab login. Record stock transfers between them and file returns per GSTIN. Advance includes four companies, and extra companies can be added for ₹999 a year each, exclusive of GST.
Why do my marketplace invoice numbers fail on GSTR-1?
GST invoice numbers must be within 16 characters. Some marketplace exports use long order IDs where an invoice number is missing. hisabkitab's GSTR-1 validation flags issues like this before you upload, so you fix the data in your books instead of fighting portal errors at the deadline.
Can I see profit per SKU after marketplace fees?
Yes. Use a Net realisation formula on a custom field, for example selling price minus commission, shipping and fixed fees, and read margins in the Item-wise Profit Report. It shows which SKUs earn money on which channel, which is rarely obvious from the marketplace dashboard alone.
How do I claim TCS collected by the marketplace?
Record TCS on every settlement and check it with the TCS Report against the operator's statement. Once they agree, the credit can be claimed as your CA advises in your GST filing. TDS deducted on payouts is tracked similarly through the TDS Report for your income-tax return.
Keep exploring
Related industry playbooks
Match every payout to every order
Book a demo and bring one month's marketplace settlement sheet: we will show it imported, matched and broken down into true profit per SKU.
