HomeE-commerce reconciliation
E-commerce · Surat · Sellers across IndiaE-commerce reconciliation, accounting and tax for online sellers
Selling online is a complete business, and its finances need complete care. We reconcile every marketplace payout to your orders, keep your books, handle your GST and income tax, and send you a clear report of what you actually earned.
One firm for the whole money side of selling online
From the first order to the money in your bank and the tax return at year end, every step is handled by our Chartered Accountants, so your reports, books and returns all agree.
Payment reconciliation
Every settlement matched to its order and SKU, and every payout matched to your bank. Short payments, wrong charges and pending orders are listed.
Claims and recovery
We help raise claims with each marketplace for amounts that are short or missing, and track each one until it is settled or closed.
Accounting
Marketplace sales, returns, charges and payouts recorded correctly in your books every month, ready for audit.
GST
Sales tied to your GST returns month by month, and the GST TCS collected by marketplaces matched and claimed on time.
Income tax and TDS
Income-tax TDS deducted by marketplaces matched with your tax credit statement and claimed in your return.
Profit and MIS reports
Realisation, returns and charges by month, SKU and marketplace, so you can see which products and portals actually make money.
Guides by marketplace
Marketplaces covered
Amazon
Flipkart
Meesho
Myntra
Nykaa
Blinkit
Zepto
Instamart
Marketplace names and logos are trademarks of their respective owners, shown only to indicate the platforms our reconciliation covers. No affiliation or endorsement is implied.
What your reconciliation report looks like
This is our report layout, filled with made-up figures for a fictional fashion brand selling on Myntra. Each tab is a sheet in the Excel workbook you receive every month.
Reconciliation waterfall % of gross value
Charges
| Average charges per order | ₹297 |
| Average commission per order | ₹203 |
| Average logistics per order | ₹93 |
Data checks
| Orders with a return | 4,013 · 40.8% |
| Orders where charges exceeded the payment | 3,331 · 33.9% |
| Orders still pending payment | 22 |
Monthly P&L ₹ lakh
| Jul | Aug | Sep | Total | Sep vs Aug | Remark | |
|---|---|---|---|---|---|---|
| Gross sales | 51.19 | 56.14 | 47.98 | 155.31 | −8.16 | |
| Returns and RTO | −20.32 | −23.52 | −17.90 | −61.74 | 5.62 | |
| Net sales | 30.87 | 32.61 | 30.08 | 93.57 | −2.53 | Lower sales |
| Commission | −6.42 | −6.98 | −6.59 | −19.99 | 0.39 | Higher commission % |
| Forward logistics | −0.57 | −0.64 | −0.54 | −1.75 | 0.10 | |
| Return logistics | −2.40 | −2.89 | −2.15 | −7.43 | 0.74 | Fewer returns |
| Pending payment | 0.00 | 0.00 | −0.28 | −0.28 | −0.28 | 22 orders unpaid |
| Total realisation | 21.48 | 22.11 | 20.53 | 64.11 | −1.58 | |
| of which TDS and TCS (to claim) | 0.18 | 0.19 | 0.17 | 0.54 | −0.01 | |
| Cash settlement | 21.30 | 21.92 | 20.35 | 63.57 | −1.57 | |
| Non-order settlements | −0.78 | −0.86 | −1.16 | −2.80 | −0.30 | Higher non-order debits |
| Bank realisation | 20.52 | 21.06 | 19.19 | 60.77 | −1.86 | Lower bank realisation |
| Return rate (value) | 39.7% | 41.9% | 37.3% | 39.8% | ||
| Realisation ratio | 69.6% | 67.8% | 68.2% | 68.5% |
Customer returns (RT) and returns to origin (RTO), by month
| Month | RT orders | RTO orders | RT value | RTO value |
|---|---|---|---|---|
| July | 1,051 | 269 | ₹16,27,906 | ₹4,04,417 |
| August | 1,237 | 315 | ₹18,86,153 | ₹4,65,925 |
| September | 903 | 238 | ₹14,24,947 | ₹3,64,633 |
| Total | 3,191 | 822 | ₹49,39,006 | ₹12,34,975 |
Average charges on a returned order: ₹185, almost all of it logistics. Returns cost money even when the product comes back.
SKU summary, settled orders top 6 SKUs by sales
| SKU | Sold | Returned | Net qty | Net sales | Commission | Logistics | Realisation | Per unit | Return % |
|---|---|---|---|---|---|---|---|---|---|
| SKU-1041 | 812 | 268 | 544 | ₹8,85,632 | ₹1,90,411 | ₹90,944 | ₹6,04,277 | ₹1,111 | 33.0% |
| SKU-2207 | 640 | 301 | 339 | ₹5,85,792 | ₹1,27,703 | ₹75,520 | ₹3,82,569 | ₹1,129 | 47.0% |
| SKU-1188 | 575 | 154 | 421 | ₹5,59,088 | ₹1,18,527 | ₹56,350 | ₹3,84,211 | ₹913 | 26.8% |
| SKU-3052 | 430 | 211 | 219 | ₹4,00,332 | ₹88,874 | ₹54,180 | ₹2,57,278 | ₹1,175 | 49.1% |
| SKU-0976 | 388 | 92 | 296 | ₹2,67,880 | ₹54,915 | ₹32,592 | ₹1,80,373 | ₹609 | 23.7% |
| SKU-2219 | 214 | 131 | 83 | ₹1,65,419 | ₹37,054 | ₹28,248 | ₹1,00,117 | ₹1,206 | 61.2% |
A separate list shows every SKU with orders still awaiting payment.
Order report vs GST report
| Jul | Aug | Sep | Total | |
|---|---|---|---|---|
| Sales as per order report | ₹52,60,950 | ₹57,99,560 | ₹48,76,330 | ₹1,59,36,840 |
| Less: cancellations | −₹1,18,620 | −₹1,42,930 | −₹1,09,860 | −₹3,71,410 |
| Less: packed in the next month | −₹84,370 | −₹1,27,450 | −₹96,120 | −₹3,07,940 |
| Add: previous month's orders | ₹61,240 | ₹84,370 | ₹1,27,450 | ₹2,73,060 |
| Sales as per GST report | ₹51,19,200 | ₹56,13,550 | ₹47,97,800 | ₹1,55,30,550 |
The sales figure used in the reconciliation ties to the sales reported for GST, month by month, before any payout is matched.
Non-order settlements credits and debits not linked to any order
| Month | Credits | Debits | Net |
|---|---|---|---|
| July | ₹48,210 | −₹1,26,540 | −₹78,330 |
| August | ₹12,480 | −₹98,760 | −₹86,280 |
| September | ₹36,540 | −₹1,52,380 | −₹1,15,840 |
| Total | ₹97,230 | −₹3,77,680 | −₹2,80,450 |
Each entry is listed with its UTR, reference and description, so every recovery, debit note or adjustment can be checked and questioned.
Date-wise payments vs bank book September, 6 of 24 settlement dates shown
| Settlement date | Prepaid | Cash on delivery | Non-order | Total settled | As per books | Difference |
|---|---|---|---|---|---|---|
| 02 Sep | ₹1,88,420 | ₹92,310 | −₹24,860 | ₹2,55,870 | ₹2,55,870 | 0 |
| 05 Sep | ₹1,42,665 | ₹70,120 | ₹0 | ₹2,12,785 | ₹2,12,785 | 0 |
| 09 Sep | ₹1,76,240 | ₹81,955 | ₹6,420 | ₹2,64,615 | ₹2,64,615 | 0 |
| 12 Sep | ₹1,58,390 | ₹76,540 | −₹41,250 | ₹1,93,680 | ₹1,92,440 | ₹1,240 |
| 16 Sep | ₹1,69,825 | ₹88,210 | ₹0 | ₹2,58,035 | ₹2,58,035 | 0 |
| 19 Sep | ₹1,51,760 | ₹69,420 | −₹18,930 | ₹2,02,250 | ₹2,02,250 | 0 |
Every settlement is matched to the amount actually received in the bank. The highlighted difference is followed up.
Order-wise working 6 of 9,830 orders shown
| Order ID | Invoice date | SKU | Invoice value | Return | Net sales | Commission | Logistics | TDS + TCS | Realisation (incl. TDS + TCS) | Remark |
|---|---|---|---|---|---|---|---|---|---|---|
| 1000••4821 | 04 Jul | SKU-1041 | ₹1,628 | — | ₹1,628 | ₹341 | ₹18 | ₹9 | ₹1,269 | Settled |
| 1000••5307 | 06 Jul | SKU-2207 | ₹1,728 | RT | ₹0 | ₹0 | ₹205 | ₹0 | −₹205 | Return: logistics charged |
| 1000••6114 | 11 Aug | SKU-1188 | ₹1,328 | RTO | ₹0 | ₹0 | ₹176 | ₹0 | −₹176 | RTO: logistics charged |
| 1000••6982 | 19 Aug | SKU-3052 | ₹1,828 | — | ₹1,828 | ₹406 | ₹19 | ₹10 | ₹1,403 | Settled |
| 1000••7745 | 02 Sep | SKU-0976 | ₹905 | — | ₹905 | ₹186 | ₹17 | ₹5 | ₹517 | Short paid: ₹185 |
| 1000••8210 | 27 Sep | SKU-2219 | ₹1,993 | — | ₹1,993 | ₹446 | ₹19 | ₹0 | ₹0 | Pending payment |
Every order is listed with its invoice, return, charges, tax deducted, payment date and a remark, so any figure in the summary can be traced to the orders behind it.
Fictional brand and made-up figures, laid out exactly like our report. The real report is an Excel workbook prepared for each marketplace, with every order listed.
Why marketplace payouts rarely match your sales
Each marketplace deducts commissions, fees, shipping and returns before it pays you, and its reports are built for its own systems, not your books. Small errors repeat across thousands of orders.
Short settlements
Orders that were delivered but paid at less than the agreed amount, or not paid at all.
Commission and fee errors
Commission, fixed fees and collection charges deducted at the wrong rate or for the wrong category.
Returns not credited
Customer returns and RTO shipments where the product came back but the credit or the stock did not.
Shipping weight overcharges
Shipping fees charged on a higher weight slab than the package actually weighed.
TCS and TDS credits
GST TCS collected and income-tax TDS deducted by marketplaces, which need to be matched with what appears on the GST and income-tax portals.
Missed claim windows
Most marketplaces set time limits for raising claims. Issues found months later are often too late to recover.
From portal reports to money in the bank
- Share your reports
Settlement, order, return and GST reports from each seller panel, and your bank statement. We tell you exactly which ones to download.
- We match every order
Our in-house tool reconciles each settlement to its order and SKU, ties sales to the GST report and matches every payout to your bank.
- You get the report
The full workbook every month, with a short summary of what needs action: short payments, pending orders and unexplained debits.
- Claims, books and returns follow
Claims are raised and tracked, entries are posted to your books, and GST and TDS credits are claimed in your returns.
Built for India's online sellers
Fashion, textile and ethnic-wear brands sell on several marketplaces at once, often with high return rates and thin margins. Every portal reports differently, and reconciling them by hand each month takes time most teams don't have.
Our head office is in Vesu, Surat, with offices in Ahmedabad and Mumbai. We work with sellers across India online.
Who it's for
- Fashion, ethnic-wear and saree brands
- D2C brands selling on several marketplaces
- Brands on quick commerce: Blinkit, Zepto, Instamart
- Manufacturers and wholesalers starting to sell online
- Sellers with high return or RTO rates
Frequently asked questions
Which marketplaces do you cover?
Amazon, Flipkart, Meesho, Myntra, Nykaa, Blinkit, Zepto and Instamart. If you sell on another platform, ask us; the same approach usually applies.
What does the report include?
One Excel workbook per marketplace: an overview with the reconciliation waterfall, a monthly P&L from gross sales to bank realisation, returns and RTO, an SKU summary, sales tied to the GST report, non-order settlements, a date-wise bank match and every order listed with a remark. The sample above shows the layout.
What do I need to share?
The settlement (payment), order, return and GST reports from each seller panel, and your bank statement. We will tell you exactly which reports to download from each marketplace.
How often should reconciliation be done?
Monthly works for most sellers, so issues are found while the marketplace's claim window is still open. Past periods can be reconciled too.
Do you also keep our books and handle GST and income tax?
Yes. Accounting, GST returns, GST TCS credits, income-tax TDS credits and your income-tax return can be handled together with the reconciliation, so your books, returns and reports agree.
Do I need to be in Surat?
No. Our head office is in Surat and we have offices in Ahmedabad and Mumbai, but the work can be done fully online for sellers anywhere in India.
See how your marketplace payouts reconcile.
Request a walkthrough