Unique ID in udiMagic — Prevent Duplicate Vouchers During Excel to Tally Import

Published · Updated

Before we begin, let's have look at these real-world examples.

Aadhaar Number : It is a 12-digit unique identification number issued by the Indian government to every individual resident of India.
Mobile Number : Every user is given a unique mobile number on purchase of SIM card.
GST Invoice Number : Under the Indian GST Regime, every Invoice must have a unique number and it must be unique during that financial year.

Now, just imagine what would happen if same mobile number is given to two or more persons. Chaos, isn't it?

Unique ID for Vouchers in Tally

To import data from Excel into Tally, every voucher must be given a unique id.

  • It can be numeric or alpha-numeric.
  • The max-length must be 24 characters.

Note:
For Sales Invoices, you can use the Invoice Number as the Unique ID.

Common mistakes

Here are some common mistakes relating to unique id.

Example 1 - Unique ID is wrongly repeated.

Excel sheet where the same Unique ID is repeated on two payment rows

As a result, only four vouchers will be imported in Tally as shown below:

  • Payment Rs 100
  • Payment Rs 300
  • Payment Rs 400
  • Payment Rs 500

Example 1 - Unique ID is now corrected

Excel sheet with a distinct Unique ID on every payment row

Now, all the five vouchers will be imported in Tally

  • Payment Rs 100
  • Payment Rs 200
  • Payment Rs 300
  • Payment Rs 400
  • Payment Rs 500

Example 2 - Unique ID is kept blank.

Excel sheet with the Unique ID column left blank

As a result, zero (0) vouchers will be imported in Tally.

Example 2 - Unique ID is now given correctly.

Excel sheet with a Unique ID filled in on every row

Now, all the five vouchers will be imported in Tally.

Example 3 - Party Code is given in the Unique ID column. This is wrong.

Excel sheet using the party code instead of the invoice number in the Unique ID column

As a result, only four vouchers will be imported in Tally as shown below:

  • INV-2 - Vishal Traders
  • INV-3 - B K Autolink
  • INV-4 - Prithvi Enterprises
  • INV-5 - Amandeep Traders (Note: INV-5 overwrites the INV-1)

Example 3 - Invoice Number is now correctly given in the Unique ID column.

Excel sheet using the invoice number in the Unique ID column

Now, all the five vouchers will be imported in Tally.

  • INV-1 - Amandeep Traders
  • INV-2 - Vishal Traders
  • INV-3 - B K Autolink
  • INV-4 - Prithvi Enterprises
  • INV-5 - Amandeep Traders

Example 4 - Unique ID column (containing Invoice Numbers) is not sorted.

Excel sheet where the Unique ID column of invoice numbers is not sorted

As a result, the INV-2 is not imported correctly.

  • INV-1
    • Item X
    • Item Y
  • INV-2 (Wrong)
    • Item B
    • Item C
  • INV-3
    • Item M

Example 4 - Unique ID column is now sorted.

Excel sheet where the Unique ID column of invoice numbers is sorted

Now, all the invoices will be imported correctly.

  • INV-1
    • Item X
    • Item Y
  • INV-2 (Correct)
    • Item A
    • Item B
    • Item C
  • INV-3
    • Item M

Ready to import your Excel data into Tally?

Download udiMagic and start a 14-day free trial — no credit card required.

Download udiMagic View Pricing