Guide
How to use the Meesho to Tally Converter
1. Download the reports
Meesho GST report (monthly)
- 1Meesho Supplier Panel → GST report (under Payments on most panels) for the month.
- 2Unzip
gst_<id>_<MM>_<YYYY>.zipand upload tcs_sales.xlsx and tcs_sales_return.xlsx.
GST portal TCS credit (optional, for the TCS check and TCS to-do)
- 1Log in at gst.gov.in → Services → Returns → TDS and TCS Credit Received, choose the financial year and month, then Download (Excel). Unzip it and upload the .xlsx.
- 2It is the same file the GST Summary pages use; one per GSTIN login if you have several registrations.
Menu names in Seller Central change now and then. If a label looks different, search the report name in Seller Central's search bar.
2. Read the results
HSN-wise
Taxable value and GST per HSN code and rate, split B2B / B2C, net of returns. This is what Tally's GSTR-1 HSN summary should show after import.
GST rate-wise / State-wise
The same totals by rate (inter/intra-state) and by place of supply, to cross-check with GSTR-1 and GSTR-3B.
Tally vouchers
Every voucher the XML file will create, numbered like Meesho: one per invoice (B2B with GSTIN), returns as credit notes with Meesho's credit note number. Optionally B2C can be summarised per state per day or month.
Masters
The unit, stock items (per HSN, HSN or SKU, each with its HSN and GST rate), party, sales and output GST ledgers the vouchers use. "From" shows whether an item came from the HSN or fell back to HSN.
TCS check and TCS to-do
When you add the GST portal TCS file: the comparison with Meesho's GSTR-8, and a checklist of manual Tally entries (the TCS credit journal, accepting the credit on the portal, and what to do about each mismatch). Tick each item as you finish it.
Checks
Lines with no HSN, unknown states, or GST that doesn't match the rate. Fix them before importing.
3. What to do next
- Back up your Tally company (or import into a test company first).
- Turn on the features the file uses: F11 → Inventory (item invoices) and, with several GST registrations (TallyPrime 3.0+), F11 → GST → Enable multiple GST registrations.
- Turn on the tax tolerance once per company: Alt+K → F11 → Ctrl+I → Additional Configurations → F12 → enable Ignore difference in tax values, up to 1. See "Tally errors" below for why.
- Download Tally XML: masters + vouchers (one file) and import it: TallyPrime → Import → Transactions (Tally ERP 9: Gateway → Import Data → Vouchers). It creates the registrations, voucher types, unit, stock items and ledgers first, then the vouchers. For masters that already exist, choose "Combine (Merge)".
- Check Tally's import summary. If a voucher failed, Tally writes the reason in
Tally.impin the TallyPrime folder; the error list below explains the common ones. - Open GSTR-1 in Tally. Clear the "Uncertain Transactions" for interstate credit notes (see below), then compare the HSN and rate totals with the HSN-wise tab here.
Tally errors and how to fix them
Messages you may see in Tally's import summary, Tally.imp, or GSTR-1 → Uncertain Transactions.
Reference master is missing
A voucher uses a ledger, stock item, voucher type or GST registration that isn't in Tally. Import the one-file download (masters + vouchers together) rather than the separate files, and don't mix files from different downloads. Still failing? Your GST registrations may have other names: put your naming in Settings → GST registration name (e.g. {state} Registration). Tally.imp names the exact master.
Voucher numbering series is selected for other registration
Your existing "Sales" voucher type has a numbering series tied to one GST registration. Keep Settings → Create own voucher types per GST registration on (default): the file creates "Meesho Sales - Delhi", "Meesho Credit Note - Delhi" and so on, with manual numbering, so Meesho's invoice numbers are used as they are.
Mismatch between expected tax amount and modified tax amount
The vouchers are imported; this shows in GSTR-1 → Uncertain Transactions. The file keeps Meesho's tax exactly, but Meesho rounds product and shipping tax separately, so Tally's own calculation is often a few paise different. Fix once per company: Alt+K → F11 → Ctrl+I → Additional Configurations → F12 → enable Ignore difference in tax values, up to 1. A difference above ₹1 means a real problem: check the Checks tab.
Nature of original sale is not specified / Unable to determine original sales value
Shows in GSTR-1 → Uncertain Transactions for credit notes against interstate B2C sales: Tally needs the original invoice value to decide the GSTR-1 table (B2C Small or 9B). Open it, select all vouchers, set Original sales invoice value = Less Than or Equal to 2.5 Lakhs (true for almost every Meesho order) and press Ctrl+A. The results above tell you how many credit notes this affects.
Voucher numbers in Tally are 1, 2, 3 (not Meesho's invoice numbers)
The file always uses Meesho's invoice and credit note numbers, but Tally replaces them when the voucher type uses Automatic numbering. Keep Create own voucher types per GST registration on: those types are created with Manual numbering. If a type with that name already existed, or you post into your own "Sales", open it (Alter → Voucher Type), set Method of voucher numbering = Manual, delete the renumbered vouchers and import again.
Voucher number length exceeds (16 characters)
GST invoice numbers may have at most 16 characters. Daily/monthly summary vouchers are now numbered like AMZS261011-29-07 (S = sales, R = returns, date, place of supply, registration), always 16 or less. If you use a long prefix, the dashes are dropped; if it is still too long, the Checks tab lists the vouchers. Delete the old long-numbered vouchers and import again.
Daily / monthly voucher totals don't match Meesho
Fixed: a summary voucher adds up the same product sold at different prices, and Tally recalculates each line as quantity × rate. The rate is now written with enough decimals (e.g. 422.8833) that Tally's quantity × rate equals Meesho's amount exactly. Re-download and re-import. Tax differences of a few paise are explained under "Mismatch between expected tax amount".
Products have no HSN / GST rate
Choose your Tally version in Settings: TallyPrime 3.0+ and Tally.ERP 9 store HSN and GST differently. Re-download and re-import the masters with Combine (Merge).
Vouchers open "As Voucher" instead of Item Invoice
Turn on inventory (F11), keep Settings → Voucher mode = Item invoice, refresh this page (Ctrl+F5) and download again.
4. Good to know
- •Already have sales ledgers in Tally? Put their exact names in Settings and skip the ledgers file.
- •TCS deducted by Meesho isn't part of sales; book it with the Meesho settlement (payment) entry.
- •Import each month only once. Re-importing creates duplicate vouchers; delete the old ones first if you need to redo a month.
- •The ledger file sets HSN and GST rate on each sales ledger so Tally's GST reports pick them up. Check one ledger after import, since Tally versions differ slightly.
5. FAQ
Does it work with TallyPrime and Tally ERP 9?
Yes. Choose your version in Settings: TallyPrime 3.0+ (default, item invoices with HSN/GST on items and several GST registrations) or Tally.ERP 9. Test with one month in a test company first.
Can returns be a negative sale instead of a credit note?
Yes. Settings → Returns → "Sale cancellation: negative values in the sales voucher". Each return then reduces sales with negative stock, sales and GST lines (in a daily/monthly summary they go into the same voucher). Credit notes stay the default because GSTR-1 reports them in table 9B.
Can I correct a wrong or missing HSN?
Yes. Settings → HSN corrections: one line per product, "HSN or SKU, new HSN" (or "old HSN, new HSN" to replace a code everywhere, or "Missing, HSN" for lines without one). It is saved in your browser and used on the GST Summary page too. Also fix it in the Meesho Supplier Panel so next month's report is right.
Is the GST the same as Meesho's?
Yes, to the paisa: the tax on every voucher is Meesho's (including free-shipping and other promotions that take GST back). Tally may calculate a few paise differently; turn on "Ignore difference in tax values" up to 1 (see Tally errors).
Are my files stored?
No. The GST report files are processed on our server in memory to create the Tally XML and deleted straight away. We never store them or share them.
Why monthly vouchers and not one per order?
Meesho's GST report has sub-order numbers (20 characters) but no invoice numbers, and a GST invoice number may have at most 16. So each state gets one sales voucher and one credit note per month (or per day), numbered like MSHS2610-29. Choose "One per sub-order" in Settings if you really need it; the Checks tab then lists the long numbers.
It says a column is missing. What now?
You probably uploaded a different report, or Amazon renamed a column. Download the report exactly as in step 1. If it still fails, tell us the report name and we'll add support.