Most failed Tally imports are not software problems. They are data problems: a date stored as text, a ledger name with an extra space, a GSTIN with a typo. Spend ten minutes preparing your Excel file and the import runs cleanly the first time. This checklist covers what to look at before you import into TallyPrime.
1. One row, one entry (or one line of an entry)
- Keep one header row at the top and data directly below it. No merged cells, no blank rows in the middle, no subtotal rows.
- For invoices with several items, use one row per item and repeat the invoice number on each row so they group into one voucher.
- Remove report titles, logos and "Total" lines copied from other software.
2. Dates must be real dates
A date that looks right can still be text. Select the column and change the number format: real dates change, text stays the same. Use one format for the whole column, for example DD-MM-YYYY.
Also check that every date falls inside the financial year and period open in your Tally company.
3. Ledger and party names must match Tally exactly
Tally treats "ABC Traders", "ABC Traders " (trailing space) and "A.B.C. Traders" as three different ledgers. Before importing:
- Use Excel's
TRIM()to remove extra spaces. - Keep spellings the same as in Tally, including "Pvt Ltd" vs "Private Limited".
- Better still, identify parties by GSTIN. Names vary; GSTIN does not.
If you need to create many ledgers first, see the guide on importing stock items or ledgers.
4. GST columns
| Check | Why |
|---|---|
| GSTIN is 15 characters, no spaces | Wrong GSTIN breaks GSTR-1 and GSTR-2B matching |
| First two digits of GSTIN = state code | Decides CGST+SGST (same state) or IGST (other state) |
| GST rate is a number (18, not "18%" as text) | Text values cannot be used to calculate tax |
| Taxable value + tax = invoice total | Catches typing errors and missing cess |
| Place of supply filled for B2C interstate sales | Needed for correct GST reporting |
5. Numbers and rounding
- Amounts should be numbers, not text with commas or "₹". Right-aligned cells are usually numbers; left-aligned cells are usually text.
- Round to two decimals with
ROUND(), and keep a round-off column if your invoices have one. - Debit and credit should balance for every journal or bank entry.
6. Voucher numbers and duplicates
- Each invoice number should appear only once per party (or once per voucher type for sales).
- Use Excel's Conditional Formatting → Duplicate Values on the invoice-number column before importing.
- If you import the same sheet twice by mistake, a tool with a duplicate check will skip entries that already exist.
7. Stock items (for invoices with inventory)
- Item names and units (Nos, Kg, Box) must match Tally.
- Quantity × rate should equal the line amount.
- Godown and batch columns are needed only if you use them in Tally.
8. Take a backup, then import
Before a large import, take a Tally backup. Import a small sample first, check a few vouchers in Tally, then import the rest.
Map your format once, reuse it every month
You do not have to rebuild your sheet into a fixed template every month. In QuikAccount you map your own Excel columns once, and Import Data does the rest each month. Step-by-step help is in the guide to importing an Excel sheet in Tally.
