Processing your data...
← Back to Tools
🛒 E-Commerce Accounting Automation

E-Commerce Monthly Statement Importer

Convert monthly Forward Sales and Sales Return Excel sheets (Meesho, Amazon, Flipkart) into clean, state-wise consolidated Tally Prime XML vouchers (Accounting Invoice mode) with automatic Local vs. Interstate GST split.

⚙ī¸ Tally Configuration & Mapping

Ledger Names & GST Rates Configuration

📁 1. Forward Sales Report *Required

Waiting for file

Upload monthly forward sales (.xlsx/.xls) containing end_customer_state_new, taxable value, and tax.

📊
Click to select or drag & drop Forward Sales Excel
Supports Meesho, Amazon, Flipkart reports

↩ī¸ 2. Sales Return Report (Optional)

None uploaded

Upload sales return statement (.xlsx/.xls) to create consolidated Credit Note vouchers.

đŸ“Ļ
Click to select or drag & drop Sales Return Excel
Optional: Aggregates returns into Credit Notes

📖 How to Import E-Commerce Statements into Tally Prime

1

Upload Statement Files

Upload your Forward Sales and optional Sales Returns Excel report downloaded directly from Meesho, Amazon, or Flipkart seller panel.

2

Review State Consolidation

Check aggregated totals per state. The tool applies standard GST rules: Gujarat entries split into CGST + SGST (50:50), while out-of-state rows are classified as IGST.

3

Direct Import into Tally Prime

Click Download Tally Prime XML. Open Tally Prime, press Alt + O (Import Data) > Transactions (or Vouchers) > Select the downloaded XML.