Automate Myntra Payment Reconciliation in Tally

Why Myntra payouts rarely match your Tally books

Your books record sales when you invoice. Myntra pays you later, in net amounts, after deducting commissions, fees, returns and tax-related items. One bank credit can therefore cover many orders, several returns and a handful of charges. A simple bank-to-sales match in Tally will almost never tie out.

Common causes of gaps:

• Timing: sales in one month, settlement in the next.
• Returns and cancellations netted off later payouts.
• Fee lines that differ from what your agreement says.
• Tax deductions that need to be booked separately for your return filings.
• Adjustments carried across settlement cycles.

What automation realistically means

Tally is an accounting system, not a marketplace reconciliation engine. Trying to force order-level matching inside Tally usually ends in bloated ledgers. A workable setup has three layers:

1. Match: compare Myntra settlement data with your sales and returns records, order by order.
2. Check: test commissions and fees against your seller agreement and rate card, and flag deviations.
3. Post: push summarised, approved totals into Tally as vouchers, in the format your accountant prefers.

Automate the first two layers fully. Keep the third controlled, with a human review before anything is imported.

Set up Tally so reconciliation has somewhere to land

Before any automation, make sure the ledger structure can hold the answers. Discuss the exact structure with your accountant, but a typical layout includes:

• A Myntra receivable (party) ledger to clear against bank receipts.
• Separate expense ledgers for commission, fixed or closing fees, shipping or logistics charges and other deductions, so you can see each cost.
• A sales returns ledger.
• Ledgers for tax deducted or collected by the marketplace, as your tax adviser advises.
• A suspense or "under review" ledger for differences not yet explained.

Avoid dumping net payouts straight into sales. It hides fee leakage and makes return analysis impossible.

A step-by-step workflow for each settlement cycle

1. Download the data. Export the settlement and sales or returns reports from your Myntra seller panel in Excel. Keep the original files unaltered.
2. Tie the payout to the bank. Confirm the settlement total equals the credit in your bank statement.
3. Match orders. Map every settled order to your sales records, and every return to the original sale.
4. Test the fees. Recompute commission and other charges using your agreed terms and compare them with what Myntra deducted.
5. List exceptions. Missing orders, unexplained deductions, returns not credited, and fee differences.
6. Post to Tally. Book the receipt, the fee ledgers and returns as summarised entries, with exceptions in the review ledger.
7. Track recovery. Raise claims for disputed items and follow them until cleared or written off.

What to check before you trust a payout

Never assume the deduction is right because it came from the marketplace. Check these each cycle:

• Commission and fees: compare with your seller agreement and current rate card. Rates change, so confirm the latest terms with your Myntra account contact rather than relying on old emails.
• Returns: every return should show a matching reversal, and returned stock should be received or compensated as per policy.
• Tax items: TCS, TDS and GST treatment depend on current law and your registration. Confirm treatment and rates with your tax adviser and the tax documents Myntra issues.
• Carry-forward adjustments: one cycle's shortfall may be recovered from the next, so track it until closed.

Choosing a tool to do the matching

Spreadsheets work at low volumes, but they break when order counts, return cases and fee rules grow. When evaluating tools, ask whether they handle Myntra's Excel reports, whether fee checks use your own agreed terms, whether returns and recovery cases are tracked to closure, and what the output looks like for your accountant.

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 today, and other marketplaces can be discussed for scope. Pricing is a tailored quote based on your setup.