To automate Myntra settlement reconciliation in Tally, export the settlement, sales and returns reports from Myntra, standardise them into one template, and match each order to its payout line. Then import summarised vouchers into Tally against fixed ledgers for sales, returns, fees, tax deductions and the Myntra receivable. Finally, match the bank credit to the settlement total and investigate every difference.
What Tally can and cannot do for marketplace settlements
Tally is an accounting book, not a reconciliation engine. It records vouchers well, but it will not compare a Myntra settlement report with your orders, returns and bank credit. Automation therefore means preparing the data outside Tally and importing clean vouchers.
Decide the posting level first. A Myntra payout covers many orders, so most brands post a summarised set of vouchers per settlement cycle and keep order-level matching in a working file. Posting every order line into Tally bloats the books and slows reports.
Set up ledgers and a mapping table first
Automation fails when charges land in the wrong ledger. Create these before you import anything:
- Myntra as a party ledger, acting as your receivable.
- Sales ledgers structured as your accountant advises for GST.
- Sales returns ledger, kept separate from sales.
- One expense ledger per charge type that appears in your settlement report, such as commission and each fee line.
- Tax ledgers for amounts deducted or collected by the marketplace. Confirm the treatment of TCS and TDS with your tax adviser.
- Bank ledger for the receipt.
Then build a mapping table that links every column or charge name in the Myntra report to a Tally ledger. Charge names change over time, so make unmapped items fail loudly instead of falling into a miscellaneous ledger.
Step-by-step: from Myntra Excel report to Tally vouchers
- Download the reports. Get the settlement report plus the sales and returns reports for the same period from the Myntra seller portal. Layouts vary, so check the current versions.
- Standardise the data. Build one row per order line with order ID, SKU, order date, sale value, return flag, each fee, tax deductions and net payout.
- Validate totals. The sum of your rows must equal the summary totals in the report. If not, stop and fix the data.
- Map charges to ledgers using your mapping table.
- Build summarised vouchers. Create sales, returns and a journal for fees and deductions per settlement cycle. Put the settlement ID and period in the narration.
- Import into Tally. Use the voucher import options in your TallyPrime version (Excel or XML), or ask your Tally partner. Test in a dummy company first.
- Post the bank receipt against the Myntra ledger and clear or explain the difference.
Checks to run before you import
Run these checks on the working file, not after the entries are in Tally, where corrections mean reversing vouchers.
| Check | What it catches |
|---|---|
| Settlement total vs bank credit | Short payments, holdbacks, timing gaps |
| Returns in report vs returns received | Credited returns that never reached your warehouse |
| Fees vs agreed terms | Wrong commission or fee lines |
| Duplicate order IDs | Double posting across cycles |
| Period overlaps | Orders counted in two settlements |
For the fee check, compare each line with your seller agreement and the current rate card. Do not rely on remembered percentages, and confirm the latest terms with your Myntra account contact.
Handle returns, short payments and timing differences
Most unexplained differences come from three places:
- Returns: reverse the sale in the cycle where the return appears in the report, and track physical receipt separately. Missing or damaged returns may be claimable, so check the claim window in your agreement.
- Short payments: where the bank credit is below the settlement total, hold the difference in the Myntra receivable and log it as an open item. Do not write it off to expenses.
- Timing: orders delivered near period end may settle in the next cycle. Carry them as receivable rather than forcing a match.
Keep a recovery register with the order ID, amount, reason, date raised, status and amount recovered. Without it, open items vanish into the receivable balance.
When a spreadsheet workflow stops scaling
A template and mapping table work at modest volumes. As order counts, return rates and settlement cycles grow, the manual matching becomes the bottleneck. MarketplaceMetrics by Fundle reconciles marketplace sales and settlements, checks commissions and fees against agreed terms, and tracks returns and recovery cases. Myntra Excel reports are reviewed, and other marketplaces are in scope discussion. Pricing is a tailored quote. Tally remains your book of record either way.
Worked example
Illustrative example only. The figures below are invented to show the logic. They are not real rates or results.
| Line | Amount (₹, illustrative) |
|---|---|
| Gross sales in cycle | 1,00,000 |
| Less: returns | (18,000) |
| Net sales | 82,000 |
| Less: commission and fees per report | (16,400) |
| Less: tax deducted by marketplace per report | (820) |
| Expected payout | 64,780 |
| Bank credit received | 63,780 |
| Unexplained difference | 1,000 |
You would post the sales, returns and fee vouchers from the report, then record the ₹63,780 receipt against Myntra. The ₹1,000 stays as an open item in the recovery register until you trace it to a holdback, a deduction or a short payment.
Questions and answers
Can Tally reconcile Myntra settlements by itself?
No. Tally's reconciliation features are built around bank statements. It will not compare Myntra settlement lines with orders and returns. You need a prepared file or a reconciliation tool, and Tally then receives the verified vouchers.
Should I post every Myntra order as a separate voucher in Tally?
Usually not. Most brands post summarised vouchers per settlement cycle and keep order-level detail in a reconciliation file. Check with your accountant, especially if you need order-level GST reporting from Tally itself.
How do I treat TCS and TDS deducted by Myntra?
Record them in separate tax ledgers using the amounts shown in the settlement report. Rates and treatment depend on current law and your situation, so confirm with your tax adviser and match the figures to your tax statements.
How often should I reconcile Myntra settlements?
Reconcile every settlement cycle rather than monthly. Short payments and return disputes are easier to trace when the data is recent, and claim windows may be limited. Check the time limits in your seller agreement.