Import Your Tally Data

Why Import from Tally?

If you've used Tally for years, moving to iAccounting doesn't mean abandoning your past data. Our Tally import preserves:

• Chart of accounts — every ledger you created, with the same names and groupings.
• Opening balances — exactly as on your Tally trial balance.
• Party masters — customers, vendors with their GSTINs, addresses, contact details.
• Stock items — names, units, HSN codes, opening qty & value.
• Historical vouchers (optional) — for cross-year reporting.

The whole import usually takes 5–10 minutes for a small business with under 1,000 vouchers.

Two Import Methods

We'll cover the XML method here — it works for 95% of users.

Step 1 — Export from Tally

For Tally Prime

1. Open your Tally company.
2. Press Alt+E (Export) → "Masters" for ledgers/items, or "Day Book" for vouchers.
3. Format: XML.
4. Output File Name: pick a memorable name (e.g., my-co-fy2025-26.xml).
5. For period: pick "All Vouchers" or your financial year.
6. Press Enter → file saves to Tally's Data folder.

For Tally ERP 9

1. Gateway of Tally → Display → Account Books → Day Book.
2. Press Alt+E.
3. Configure: Format = XML, Output = on screen.
4. Save the resulting XML file.

Step 2 — Upload to iAccounting

1. Log in to iAccounting → Setup → Migration → Import from Tally.
2. Click "Upload XML".
3. Select your exported file. The system parses and shows a preview.

The preview shows counts:

• 247 Ledgers found
• 89 Customers / 41 Vendors
• 156 Stock Items
• 1,432 Vouchers
• Date range: 1 Apr 2024 – 31 Mar 2025

Step 3 — Map Ledgers (Important)

iAccounting tries to auto-map Tally ledgers to its standard chart of accounts. Sometimes it asks for help with ambiguous ones.

Click each unmapped row → pick the right iAccounting ledger from the dropdown. Or click "Create as New" to add it to your chart.

Step 4 — Map GST Rates & HSN

If Tally stored tax info (CGST/SGST/IGST), iAccounting maps it automatically using the GST rate you assigned in Tally. If HSN codes were missing, you'll see a warning — fix these post-import from Items → Bulk Edit.

Step 5 — Dry Run & Verify

Before committing, iAccounting runs a dry run:

• Validates voucher numbers (no duplicates).
• Validates GSTIN format on parties.
• Confirms debits = credits in every journal entry.
• Checks date sanity (vouchers within selected FY).

You get an Issues Report. Common issues:

Step 6 — Commit the Import

Once issues are zero or acceptable, click "Commit Import". The system:

1. Creates all masters (ledgers, parties, items).
2. Posts opening balances.
3. Posts vouchers in chronological order.
4. Generates a summary PDF.

Progress bar shows live status. A 1,500-voucher import takes ~3 minutes.

Step 7 — Verify After Import

Quick checks once the import is done:

1. Trial Balance — match against your Tally trial balance to the rupee.
2. Party-wise outstanding — confirm Sundry Debtors and Creditors balances match.
3. Stock summary — confirm quantities and values.
4. Bank balances — match against bank statement.
5. GSTR-1 / GSTR-3B — generate a sample month's GST report and compare with what you filed.

Two-Way Tally Sync (CA Firms)

If you're a CA managing clients who still use Tally as source-of-truth:

• Pull from Tally daily/weekly → automation happens in iAccounting.
• Push verified entries back to Tally — so the client's Tally stays the official record.

Set up from Setup → Integrations → Tally Sync. Requires Tally Server license at client end. We'll publish a dedicated CA-firm guide for this soon.

Common Tally Import Issues

"Encoding error in XML"

Some older Tally versions export with Windows encoding. Re-export selecting UTF-8 in Tally's export options.

"Vouchers in negative quantity"

Stock items in Tally that went negative without GRN. Fix the underlying issue in Tally, re-export.

"Duplicate voucher numbers"

Common when Tally has multiple voucher series (Sales, Sales-Export, etc.). iAccounting handles this with auto-prefix; if not, customise voucher numbering post-import.

"Party GSTINs are blank"

Not blocking — vouchers still import. But GSTR-1 will fail until you fill them. Use Parties → Bulk Edit → Import GSTINs from CSV.

What's Next?

• Create Your First GST Invoice in iAccounting
• File GSTR-1
• Bank Reconciliation