How to Import Meesho Reports into Tally: Full Guide
Meesho suppliers face a specific accounting problem: high order volumes, thin margins, heavy RTO, and a supplier panel that exports data as files rather than feeding any accounting software directly. Meesho has no documented public seller API, so every route into TallyPrime starts with the same two downloads. This guide covers what to download, how to map it, and how to convert it into balanced vouchers without retyping anything.
The two exports that matter
From the Meesho supplier panel you need:
- The GST sales report: one row per sub order event, with Sub Order No, Order Date, Event Type (Sale, Return or RTO), GST Rate, Taxable Value, IGST/CGST/SGST, Total Invoice Value and End Customer State. This drives your sales vouchers, credit notes and GST workings.
- The settlement / payment statement: Sub Order No, Payment Date, UTR of the bank transfer, Final Settlement Amount, Meesho Commission (including GST), GST on Commission, TCS and TDS. This drives receipts, fee entries and tax credits.
Download both for the same period, ideally a full calendar month, and keep the originals unedited; they are your audit trail.
Ledger mapping before the first import
| Report field | Tally ledger | Notes |
|---|---|---|
| Taxable Value (Sale rows) | Rate-wise sales ledgers | One per GST slab |
| IGST/CGST/SGST | Output tax ledgers | Split by End Customer State logic, preserved from report |
| Meesho Commission | Commission expense | Report figure includes GST; split it out |
| GST on Commission | Input GST ledger | Usually claimable ITC; confirm with your CA |
| TCS | TCS Receivable (u/s 52) | 0.5% of net taxable supplies |
| TDS | TDS Receivable (u/s 194-O) | 0.1% of gross sales |
| Final Settlement Amount | Bank via receipt voucher | Group by UTR to match statement credits |
The import workflow, step by step
- Post sales: every Sale row becomes a sales voucher at Total Invoice Value against the Meesho party ledger, with rate-wise ledgers and tax split preserved.
- Post returns and RTO: Return rows become credit notes. RTO rows need their own treatment because the goods come back to you, often with courier-return costs; the full logic is in our RTO accounting guide.
- Post settlement entries: per UTR group, a receipt voucher for the bank credit, journals for commission and GST on commission, and TCS/TDS to receivables.
- Reconcile: UTR group totals against bank statement credits, and the party ledger against unsettled sub orders.
Automating with file upload
Doing the above by hand at Meesho volumes is punishing, and because there is no public seller API, tools claiming to "sync" Meesho are either reading files like everyone else or doing something you should ask hard questions about. TallySutra's Meesho-to-Tally workflow is explicitly file-based: you upload the official GST sales report and payment statement from the supplier panel, and the platform parses sub orders, generates balanced TallyPrime vouchers, itemises commission and taxes, and reconciles settlements by UTR. Rows that fail validation, an unmatched RTO, a tax split that does not sum, a Sub Order No already imported, land in an exception queue for review, and a CA approval step gates the export to Tally XML or the push through the Gateway desktop app. Re-uploads are duplicate-safe by Sub Order No, so correcting a period is a re-download and re-upload, not a cleanup job. TallySutra never scrapes the panel and never asks for your Meesho login; it reads only the exports you choose to upload.
First-month checklist
- Chart of accounts agreed with your CA, including RTO and returns ledgers.
- One full month's pair of reports imported and reconciled to the bank.
- Party ledger equals unsettled sub orders at month end.
- GSTR-1 workings traced from the GST sales report totals.
Get one month clean and every following month is a repeat. The mechanics of the settlement file itself are unpacked in our payment statement explainer, which is worth reading before your first reconciliation.
A realistic expectation for the first cycle: budget an afternoon for ledger setup and the first reconciled month, then expect the routine to shrink to an hour or two thereafter. The common beginner mistakes are all avoidable: editing exports before import, posting bank credits as sales, ignoring RTO rows because they look like noise, and importing overlapping date ranges without duplicate protection. Every one of them is cheaper to prevent than to unwind, which is why the workflow above leans so heavily on unedited files, sub-order-level posting and idempotent imports. Get those three principles right and the specific tooling choice matters far less than it seems.
Frequently asked questions
Can any software connect directly to my Meesho account?
Meesho has no documented public seller API, so there is no sanctioned live connection for third-party accounting tools. Legitimate workflows are built on the official exports from the supplier panel. TallySutra works exclusively in file-upload mode: you download the GST sales report and payment statement yourself and upload them, and it never asks for panel credentials or scrapes pages.
Which Meesho reports do I need for complete books?
Two: the GST sales report, which carries sub-order-level sales, returns and RTO events with taxable values and tax splits, and the settlement or payment statement, which carries what Meesho actually paid you per sub order with commission, GST on commission, TCS and TDS. Sales come from the first, money and costs from the second, and reconciliation ties them together.
How are duplicate imports prevented when I re-download reports?
Every Meesho row carries a Sub Order No, which acts as a stable identifier. A duplicate-safe importer records which sub orders have already been converted into vouchers and skips them on re-upload, importing only genuinely new rows. TallySutra does this automatically; if you import manually, maintain a register of posted Sub Order Nos and check against it before entering a re-downloaded file.
TallySutra turns Amazon, Flipkart and Meesho reports into reconciled, reviewed TallyPrime vouchers — duplicate-safe, with every rupee traceable to its source row.
Book a 30-minute demo