Quick Answer: How to Import Excel Data to Tally Prime?
TrulyInvoice allows accountants to convert and import Excel data directly to Tally Prime without TDL modules. To import manually: 1) Prepare Excel with column headers (Date, Party Name, Invoice No, Item, GST Rate), 2) Map columns to Tally ledger fields, and 3) Post via XML. Alternatively, TrulyInvoice AI OCR lets you skip Excel preparation entirely by scanning purchase PDFs or WhatsApp invoice photos directly into F9 purchase vouchers.
- Supports standard Excel column headers: Date, Party, Invoice No, Item, Amount, GST Rate
- Direct XML import via Port 9000 connector — no TDL license required
- TrulyInvoice AI OCR alternative: Scan PDF/images directly into Tally without Excel typing
- Flat ₹599/month pricing for unlimited voucher sync with zero per-invoice credit fees
Excel to Tally Converter Software & Import Guide [Free Templates]
Complete tutorial for converting and importing Excel data to Tally. Learn how to structure PDF templates, map columns, and sync vouchers directly to TallyPrime.
When to Use Excel Import
Structured data scenarios: When you have data already in PDF format from other systems, exports from ERPs, or manually compiled data.
Bulk data migration: When switching from another accounting software to Tally, Excel import is the standard migration method.
System-to-system transfer: When integrating between Tally and other business systems that export to Excel.
Periodic bulk updates: When you need to update masters (ledgers, stock items) in bulk periodically.
Step-by-Step Excel Import Process
Follow these steps to import Excel data to TallyPrime.
Prepare Excel Data
Format data using our templates. Ensure correct column headers and formats.
Open Tally Import
Go to Gateway of Tally > Import Data > Excel (TallyPrime 4.0+)
Select File
Choose your Excel file. Tally will read the columns.
Map Fields
Map Excel columns to Tally fields. Most auto-map correctly.
Import Data
Click Import. Tally processes and creates vouchers.
Verify Data
Check imported vouchers in Tally. Reconcile totals.
Excel Column Mapping & Formats
TallyPrime requires matching column structures to parse transactions correctly. If you are setting up a custom spreadsheet manually, use the following pre-mapped formats.
1. Sales Voucher Columns
| Column Header | Data Type | Required | Example Value / Rules |
|---|---|---|---|
| Voucher Date | Date | Yes | 01-04-2026 (DD-MM-YYYY format) |
| Voucher No | String/Number | Yes | TI/2026/089 (Unique identifier) |
| Party Name | String | Yes | Customer's billing name matching Tally ledger |
| Party GSTIN | String | Optional | 27AAAAA1111A1Z1 (Auto-checked for state rules) |
| Taxable Value | Number | Yes | 10000.00 (Value before GST) |
| GST Rate (%) | Number | Yes | Statutory slabs: 5, 12, 18, 28 |
2. Purchase Voucher Columns
| Column Header | Data Type | Required | Example Value / Rules |
|---|---|---|---|
| Voucher Date | Date | Yes | 02-04-2026 (DD-MM-YYYY) |
| Supplier Invoice No | String/Number | Yes | SUP-9082 (Referenced supplier bill number) |
| Supplier Name | String | Yes | Vendor ledger name matching Tally Prime ledger database |
| Taxable Value | Number | Yes | 25000.00 |
| GST Rate (%) | Number | Yes | 5, 12, 18, 28 (For ledger distribution) |
3. Bank Receipt Columns
| Column Header | Data Type | Required | Example Value / Rules |
|---|---|---|---|
| Transaction Date | Date | Yes | 03-04-2026 (DD-MM-YYYY) |
| Chq/Ref No | String/Number | Optional | UTIB000290192 (Cheque, IMPS, NEFT, or UPI reference) |
| Ledger Name | String | Yes | Account ledger name in Tally (e.g. customer name or suspense ledger) |
| Deposit Amount | Number | Yes | 54000.00 (Amount credited to bank account) |
| Bank Ledger | String | Yes | Tally bank ledger (e.g. HDFC Current A/c) |
Common Format Errors & Fixes
10 common Excel import errors and their solutions.
| Error | Cause | Solution |
|---|---|---|
| Date format mismatch | DD-MM-YYYY vs MM-DD-YYYY | Use DD-MM-YYYY format consistently |
| Invalid GSTIN | Wrong GSTIN format or invalid GSTIN | Validate GSTIN format (15 characters, 2 digits + 13 alphanumeric) |
| Ledger not found | Ledger name doesn't exist in Tally | Create ledger first or use auto-create feature |
| Missing required field | Required column is empty | Fill all required fields before import |
| Duplicate invoice number | Same invoice number used twice | Ensure unique invoice numbers |
| Invalid numeric value | Text in numeric column | Ensure all numeric columns contain numbers only |
| Stock item not found | Item doesn't exist in Tally | Create stock item or use auto-create |
| Tax rate mismatch | Invalid GST rate (not 5, 12, 18, 28) | Use valid GST rates only |
| Amount calculation error | Amount ≠ Quantity × Rate | Check calculations or let Tally auto-calculate |
| Party GSTIN missing | GSTIN required for interstate supply | Add party GSTIN for interstate transactions |
Skip Excel with AI Invoice Automation
Why prepare Excel when you can extract data directly from PDFs?
| Method | Time | Steps |
|---|---|---|
| Excel Import | 30 minutes per batch | Prepare Excel → Import → Verify |
| Manual Entry | 5 minutes per voucher | Open Tally → Enter data → Save |
| AI OCR (TrulyInvoice) | 15 seconds per invoice | Upload PDF → Review → Sync |
ROI: Excel vs AI
For 100 invoices: Excel import takes 30 minutes + Excel preparation time. AI OCR takes 25 minutes total (15 seconds × 100). Skip the Excel step entirely with PDF to Tally automation.
GST-Specific Import Rules
Special considerations for GST compliance during Excel import.
GST Rate Mapping
Use valid GST rates: 5, 12, 18, 28. Tally auto-calculates tax based on rate and taxable value.
HSN Code Requirements
Include HSN code column for stock items. Required for GST compliance.
GSTIN Validation
Ensure party GSTIN is in correct 15-character format. Required for interstate supply.
Tax Type Detection
Tally auto-detects CGST+SGST vs IGST based on party state and your state.
Reverse Charge
Mark reverse charge transactions in Excel for RCM compliance.
Exempted Supplies
Use NIL rate or exempt category for exempted supplies.
Frequently Asked Questions
How to import Excel data to Tally?
TallyPrime 4.0+ has built-in Excel import. Go to Gateway of Tally > Import Data > Excel. Select the Excel file, map fields, and import. For older versions, use third-party tools like TrulyInvoice.
What PDF format is required for Tally import?
Tally requires specific column headers and formats. Common formats include: Party Name, Date, Invoice Number, Item Name, Quantity, Rate, Amount, GST Rate, Ledger Name. TallyPrime's import module requires matching these exact headers to parse transactions correctly.
Can I import all voucher types from Excel?
Yes, you can import Sales, Purchase, Receipt, Payment, Journal, and Contra vouchers from Excel. Each voucher type requires a specific column layout (such as Date, Party, Invoice Number, Ledgers, and Values) so that Tally maps them correctly.
What are common Excel import errors in Tally?
Common errors include: Date format mismatch (DD-MM-YYYY vs MM-DD-YYYY), invalid GSTIN format, missing required fields, duplicate invoice numbers, and ledger not found in Tally. Double check your data formats, column names, and ledger existence in Tally before attempting an import.
Is there a limit to Excel import in Tally?
TallyPrime has no strict limit on Excel import rows. However, very large files (10,000+ rows) may take time to process. For bulk imports, consider breaking into smaller batches of 500-1000 rows each.
How does TallyPrime map varied tax slabs (5%, 12%, 18%, 28%) during sales voucher import?
When importing sales vouchers via Excel, TallyPrime reads the tax rate specified in your spreadsheet column. If you have defined specific sales ledgers for each tax slab (e.g., Sales @ 18%), you must map the spreadsheet rate column to Tally's ledger name field so it routes entries to the corresponding GST rate ledgers without errors.
Can I import stock items from Excel?
Yes, you can import stock items, stock groups, and stock categories from Excel. Required columns include Item Name, Stock Group, Units, HSN Code, GST Rate. Ensure the values match Tally's exact master ledgers.
What if ledgers don't exist in Tally?
Tally will show error if ledger doesn't exist. Either create ledgers manually first, or use Tally's auto-create ledger feature (if enabled). Some third-party tools can auto-create missing ledgers during import.
How to validate Excel before importing to Tally?
Use our validation checklist: Check date formats, validate GSTIN format, ensure required fields are filled, verify numeric columns have numbers, check for duplicates, and test with a small sample before full import.
Is Excel import better than manual entry?
Excel import is faster for bulk data (100+ entries) but still requires manual Excel preparation. For invoice processing, AI OCR (like TrulyInvoice) can extract data directly from PDFs, skipping the Excel step entirely.
Can I undo Excel import in Tally?
You can delete imported vouchers in Tally. Go to the voucher display, select the imported vouchers, and delete. However, this is time-consuming for bulk imports. Always backup before importing.
What are third-party Excel to Tally tools?
Popular tools include Excel4Tally, Quick2Tally, Excel2Tally, and Import2Books. TrulyInvoice stands out as it allows users to bypass Excel completely by using layout AI to scan and import invoices directly from PDF files.