Common Tally Import Errors and How to Fix Them: Troubleshooting Guide

When syncing Shopify orders to Tally, import errors can occur. This guide covers the most common issues and their solutions. Bookmark this page for quick reference when troubleshooting.

Error 1: "Ledger Not Found"

What It Means

Tally can't find the party ledger (customer) or expense ledger referenced in the voucher.

Common Causes

1. Customer doesn't exist as a ledger
2. Ledger name mismatch (spelling, case)
3. Stock item not created in Tally
4. GST duty ledger missing

Solutions

For Party Ledgers:

1. Enable auto-creation in sync settings

   • New customers create automatically
   • Created under "Sundry Debtors" group

2. Check name mapping

   • Shopify: "John Doe"
   • Tally expects: Exact match or mapped name

3. Pre-create ledgers

   Gateway → Accounts Info → Ledgers → Create
   Name: [Customer Name]
   Group: Sundry Debtors
   

For Stock Items:

Sync can either use stock items or direct sales ledgers:

Configure in sync settings which approach to use.

For GST Ledgers:

Ensure these duty ledgers exist:

• CGST (Output)
• SGST (Output)
• IGST (Output)
• Cess (if applicable)

Error 2: "Invalid Date Format"

What It Means

The date in the voucher doesn't match Tally's expected format.

Common Causes

1. Date format mismatch (DD-MM-YYYY vs MM-DD-YYYY)
2. Invalid date (future date, 31st of 30-day month)
3. Date outside financial year

Solutions

Check Tally Date Settings:

Gateway → F12 → General → Date Format
- Use: DD-MM-YYYY (Indian standard)

Verify Financial Year:

Gateway → F11 → Company Features → Accounting Features
- Books Beginning From: Should cover voucher dates

For Future Orders: If order date is in future (rare edge case):

• Check Shopify order date
• May indicate test orders
• Sync settings can use "sync date" instead of "order date"

Error 3: "Voucher Number Already Exists"

What It Means

A voucher with the same number already exists in Tally.

Common Causes

1. Duplicate sync attempt
2. Manual entry already created
3. Voucher numbering conflict

Solutions

Enable Automatic Numbering:

In Tally voucher type configuration:

Gateway → Accounts Info → Voucher Types → Alter → Sales
- Method of Voucher Numbering: Automatic

Use Prefix for Sync:

Configure sync to use unique prefix:

• Manual vouchers: SA-001, SA-002
• Synced vouchers: SHOP-1001, SHOP-1002

Check for Duplicates:

In sync dashboard, verify order wasn't already synced:

• Check sync history
• Search by order number
• Verify voucher in Tally

Error 4: "GST Rate Mismatch"

What It Means

The GST rate in the voucher doesn't match the stock item's configured rate.

Common Causes

1. Product tax rate in Shopify differs from Tally
2. HSN code not configured
3. Tax type mismatch (CGST/SGST vs IGST)

Solutions

Configure GST in Stock Items:

Gateway → Inventory Info → Stock Items → Alter → [Item]
- GST Applicable: Yes
- HSN/SAC: [Enter HSN code]
- GST Rate: [Match Shopify rate]

Use GST Mapping Table:

In sync configuration, map Shopify tax to Tally:

For CGST/SGST vs IGST:

Sync automatically determines based on:

• Your business state (configured)
• Customer shipping state (from order)

If always getting wrong tax type:

• Verify your business state setting
• Check customer address completeness

Error 5: "Company Not Open"

What It Means

The target Tally company isn't currently open.

Common Causes

1. Wrong company selected in Tally
2. Company closed for maintenance
3. User logged into different company

Solutions

Open Correct Company:

Gateway → Select Company → [Your Company]

Configure Sync for Company:

In sync agent settings:

• Company name must match exactly
• Case-sensitive in some versions

Verify Connection:

Agent → Settings → Test Connection
Should show: "Connected to [Company Name]"

Error 6: "XML Parse Error"

What It Means

The XML format is invalid or contains unexpected characters.

Common Causes

1. Special characters in names (& < > etc.)
2. Unicode characters not supported
3. Malformed data from Shopify

Solutions

Special Characters:

The sync handles most special characters automatically:

• & becomes &
• < becomes <

• becomes >

If still seeing issues, check product/customer names for unusual characters.

Unicode/Emoji:

Remove emojis from:

• Product names
• Customer names
• Address fields

Malformed Shopify Data:

Check order in Shopify admin:

• Missing required fields
• Incomplete address
• Invalid phone format

Error 7: "Connection Refused"

What It Means

The sync agent can't connect to local Tally.

Common Causes

1. Tally not running
2. ODBC not enabled
3. Firewall blocking
4. Wrong port

Solutions

Start Tally: Ensure Tally is running and company is open.

Enable ODBC:

Gateway → F12 → Advanced Configuration
- Enable ODBC Server: Yes
- Port: 9000 (or your configured port)

Check Firewall:

Windows Firewall may block localhost connections:

Windows Settings → Firewall → Allow App → Tally

Verify Port:

In Agent: Connection Test
Should show port and status

Error 8: "Insufficient Permissions"

What It Means

The Tally user doesn't have permission to create vouchers.

Common Causes

1. Security settings in Tally
2. User rights not configured
3. Company in audit mode

Solutions

Check User Rights:

Gateway → F3 (Company Features) → Security Control
- Ensure creating vouchers is allowed

Admin Login:

For sync, use admin or full-access user:

Gateway → Alter → User → [User] → Allow All

Disable Audit Mode:

If company is in audit mode:

Gateway → F11 → Accounting Features
- Use Security Control: No (or adjust)

Diagnostic Steps

When encountering any error:

Step 1: Check Agent Logs

Agent → Logs → View Recent
- Timestamp of error
- Full error message
- Order details

Step 2: Verify Tally Status

• Is Tally running?
• Is correct company open?
• Can you manually create voucher?

Step 3: Test with Simple Order

• Create test order in Shopify
• Simple product, standard rate
• Single line item

Step 4: Check Sync Dashboard

• Order status
• Error message
• Retry option

Step 5: Contact Support

If issues persist, contact support with:

• Error message (full text)
• Agent version
• Tally version
• Steps to reproduce

Prevention Best Practices

1. Regular Monitoring

Check sync status daily:

• Any failed orders?
• Error patterns?

2. Keep Tally Updated

Install latest updates for:

• Bug fixes
• GST compliance
• Better XML handling

3. Maintain Clean Data

In Shopify:

• Complete customer addresses
• Proper product names
• Valid tax configuration

4. Configure Properly

One-time setup matters:

• GST mappings
• Ledger creation rules
• Voucher type settings

Getting Help

Self-Service:

• Check this guide first
• Review agent logs
• Test manually in Tally

Support Options:

• Email support (included in all plans)
• Priority support (Business/Enterprise)
• Phone support (Business/Enterprise)

Contact Support | View Pricing