Need Simple Template To Import in Tally

Simple Excel Template

Often people ask: "I need a simple excel template to import sales data in Tally. Which one should I use?"

udiMagic comes with several predefined Standard Excel templates. For Sales and Purchase excel formats, two different versions are provided viz BASIC and ADVANCED (with advanced features). To begin with, start with the BASIC template. If you requirements are NOT fulfilled with the BASIC template, then go for the ADVANCED template. 

CHOOSE What You Want

Alternatively, you can Create A New Template by selecting the fields / columns that you want from an existing template. This can be done using the udiMagic Online Template Builder here:  https://www.rtslink.com/excel-to-tally-templates/

Read more on udiMagic at: https://www.rtslink.com  

If you face any problems, post your comments in the comments box below.

udiMagic v10 Release 1.1

Decimal Places in Tally ERP

Change Decimal Places In Amount - udiMagic Settings

By default, the udiMagic Software supports two "Decimals Places in Amount". In simple words, when we import data from Excel to Tally ERP, the amount is rounded off to 2 decimals. However, in some countries (like Oman), the transactions are generally recorded with 3 decimals in amount.

In this latest release, a new option has been included in the udiMagic Settings which allows you to set / change the "Decimal Places in Amount" as shown below:

In addition, ensure that you specify the correct decimal places  in the Excel sheet wherever the ROUND() function is used.

NOTE:
In certain excel templates provided with udiMagic Software, the ROUND() function is used. You must change the ROUND() to specify the decimal places as per your requirement.

Multi-Currency in Tally ERP

Multi-currency Import Excel to Tally

Recording multi-currency vouchers in Tally ERP can be a difficult task, unless you are an experienced Tally user.

udiMagic v10

The excel templates provided with udiMagic software, help you import vouchers with multi-currency in Tally ERP, quickly and easily. You need to specify the Currency, Forex Amount, Rate of Exchange for recording payment, receipt and other entries. You can also import Base-currency vouchers by keeping these columns blank viz. Currency, Forex Amount, ROE.

Supports all financial vouchers like Payment, Receipt, Journal, Contra, Sales and Purchase without inventory.

Forex and Base Currency

• To import vouchers with Forex, specify the "Currency, Forex Amount, ROE".
• To import vouchers in Base currency, keep the "Currency, Forex Amount and ROE" columns blank.

Download Multi-Currency Excel templates

Cess based on Quantity, GST entries in Tally ERP

Cess based on Quantity - Tally ERP

Under the GST regime, some products attract "Additional Cess" based on quantity (in addition to Cess based on value). This feature "Cess based on qty" is now supported by udiMagic Software. 

Excel Template Name : Vouchers-V10-Sales-Purchase-With-Stockitems-Advanced.xls

Location : C:\udiMagicDemo

Kindly note that the "Cess based on Quantity" has to be specified in the column RATE/per unit in the aforesaid excel template. 

udiMagic Demo download link:

udiMagic Excel to Tally Software - Free to try

INTRODUCING UDIMAGIC V10.0

We are pleased to announce the launch of udiMagic v10 

The details are as under :-

Backward compatibility for Old Templates

With udiMagic v10 onwards, the old-templates (i.e. excel templates  of v9.0 r2.3 or higher) are  included in a folder named "old-templates" within the folder where the udiMagic software is installed. 

Here's what is means. 

In udiMagic v10, if you use an old template (i.e. v9. r2.3 or higher), the XML file for that template will be selected automatically by the udiMagic software. Prior to this, if you used a template of  older version, you had to manually select the XML file for that template to upload data into Tally.

Bulk record processing for UNDO entries

UNDO entries is a feature which allows the user to remove / delete the entries which were previously imported into Tally using udiMagic. By default, when you use the option UNDO entries, the records are processed one-by-one and are removed / deleted from Tally. 

A new option "Bulk upload / record processing for UNDO entries" has been now included in udiMagic Settings. When this option is ticked / enabled, the records are processed in Bulk. By default, this option is disabled.

Templates Modifications

1. Vouchers-V10-Receipts-and-Payments-with-multiple-references.xls
The DATE (Column B) has been shifted after the VCHNO column.

Import ICICI Bank statement from Excel to Tally

You can now directly import the ICICI [Current account] Bank Statement into Tally ERP using udiMagic Excel to Tally converter.

Download the Bank Statement Excel to Tally templates. 

Import ICICI Bank Statement from Excel to Tally

1. Start Tally and open a Company
2. Start udiMagic
3. Select option "Excel to Tally"
4. Select option "Import data into Tally"
5. Click the Browse button and select the Excel file "Vouchers-Bank-Statement-ICICI-Current.xls"
6. Select the XML file "Vouchers-Bank-Statement-ICICI-Current-XML-tags.xml"
7. Click the Start button

To view the data imported in Tally, use the option "Gateway of Tally | Display | Daybook"

If you do NOT have udiMagic Software installed in your computer, you must first download the udiMagic DEMO / Trial version. 

udiMagic v9.0 Release 2.3

udiMagic Excel to Tally Software
Applicable to : udiMagic v9.0 Release 2.3

NEW TEMPLATEs

1. Vouchers-Bank-statement-Single-Column-Dr-Cr.xls

This template is similar to the existing template Vouchers-Bank-statement.xls. The difference is that is contains only 1 column for Debit and Credit amounts.

2. Master-GSTClassifications.xls

This template allows you to create new GST Classifications in Tally ERP 9. To use the GST Classifications, you must first enable the GST feature and GST Classifications in Tally.

TEMPLATEs (Modifications)

1. Vouchers-Bank-statement.xls

Fixes: In some Bank statements, the amount greater than 1,00,000 has commas. This creates problem if you are using Excel 2007 or lower as the amount with commas is not converted to numeric value. In udiMagic v9.0 R2.3, we have this issue has been addressed and now even amounts with commas can be imported from Excel to Tally.

2. Vouchers-V9-Sales-Purchase-Basic.xls

Fixes: Discount ledger gets created even though the discount is not specified. This has now been resolved.

3. Vouchers-V9-Sales-Purchase.xls

Fixes: Discount ledger gets created even though the discount is not specified. This has now been resolved.

udiMagic v9.0 Release 2.2

udiMagic Excel to Tally Software
Applicable to : udiMagic v9.0 Release 2.2

Fixes:
While importing data from Excel to Tally using udiMagic, if there is an invalid XML character in the Excel sheet, the whole batch / bunch of records is not uploaded into Tally. Also, udiMagic does not display any error message. This has now been rectified in udiMagic v9.0 r2.2 and an error message "Unable to to XML tags" is displayed if an invalid XML character is found in the Excel sheet. The xml details are written to "parse.err" file.

udiMagic v9.0 Release 2.1

udiMagic Excel to Tally Software
Applicable to : udiMagic v9.0 Release 2.1

TEMPLATEs (Modifications)

1. Vouchers-V9-Sales-Purchase.xls

Fixes:
The Round Off ledger amount is not displayed correctly in the Voucher modification screen in following cases:
a. Purchase with Items + Voucher Mode
b. Purchase without Items + Voucher Mode

2. Vouchers-V9-Sales-Purchase-Basic.xls

Fixes:
The Round Off ledger amount is not displayed correctly in the Voucher modification screen in following cases:
a. Purchase with Items + Voucher Mode
b. Purchase without Items + Voucher Mode

3. Vouchers-Stock-Journal.xls

This format now supports Material IN and Material OUT vouchers also. A new column to specify the Party Ledger Name has been added in this template.

udiMagic Limited Edition

The following features are now supported in udiMagic Limited Edition also :

1. Debugging
2. Undo Entries

udiMagic v9.0 Release 2.0

udiMagic Excel to Tally Software
Applicable to : udiMagic v9.0 Release 2.0

TEMPLATEs (Modifications)

1. Vouchers-V9-Sales-Purchase.xls

a. New Columns added under "Despatch details"

- Bill of Lading/LR No

- Date

- Motor Vehicle No

b. New Columns added under "Other ledgers before Tax"

- Cost Category (for all ledgers)

- Cost Centre (for all ledgers)

c. New Columns added under "Other ledgers after Tax"

- Cost Category (for all ledgers)

- Cost Centre (for all ledgers)

d. New Column added under "Tax Classification details"

- Override Voucher

PS: This must be used only if you want to override the Tax Classification details at the Voucher level.

e. Additional Cess (i.e Cess based on Quantity)

Under the GST regime, some products attract "Additional Cess" based on quantity (in addition to Cess based on value). This is now supported by udiMagic Standard template. Kindly note that the "Additional Cess" has to be specified as RATE/per unit.

f. Point of Sale (POS) feature

The POS feature is now supported which allows you to specify the following details :

- Gift Voucher details

- Credit/Debit Card details

- Bank Ledger details

- Cash Ledger details

g. Fixes

The Round Off ledger amount is not displayed correctly in Voucher modification screen in following cases:

a. Sales with Items + Voucher Mode + Round Amount is Negative

b. Sales without Items + Voucher Mode + Round Amount is Negative

2. Vouchers-V9-Sales-Purchase-Basic.xls

Fixes: 

The Round Off ledger amount is not displayed correctly in Voucher modification screen in following cases:

a. Sales with Items + Voucher Mode + Round Amount is Negative

b. Sales without Items + Voucher Mode + Round Amount is Negative

3. Vouchers-V9-Financial-Transactions-Advanced.xls

In this template, you can now specify "Multiple Cheques/Instruments" against a single Bank ledger.

4. Master-StockItemMaster.xls

a. New Column added

- Enable Cost tracking

- Rate per Unit (under Price levels)

b. Bill of Materials (BOM)

The BOM feature is now supported.

5. Vouchers-V9-Sales-Purchase-Horizontal-Basic-without-Stockitems.xls

Fixes: 

The Round Off ledger amount is not displayed correctly in Voucher modification screen in following cases:

a. Sales with Items + Invoice Mode + Round Amount is Negative

b. Sales without Items + Invoice Mode + Round Amount is Negative

6. Vouchers-V9-Sales-Purchase-Horizontal-Advanced-without-Stockitems.xls

Fixes: 

The Round Off ledger amount is not displayed correctly in Voucher modification screen in following cases:

a. Sales with Items + Invoice Mode + Round Amount is Negative

b. Sales without Items + Invoice Mode + Round Amount is Negative

udiMagic v9.0 Release 1.9

udiMagic Excel to Tally Software
Applicable to : udiMagic v9.0 Release 1.9

NEW TEMPLATEs

1. Vouchers-V9-Sales-Purchase-Horizontal-Basic-without-Stockitems.xls

You can use this template to import Sales, Purchase, Debit Notes, Credit Notes (all without StockItems).

The new feature in this template are as follows :
a. Invoice Mode : You can specify whether to import voucher as "Accounting Voucher" or "Invoice Voucher"
b. You can now map this Standard template to your Excel sheet.

This template replaces the old template named "Vouchers-V9-Sales-Horizontal-format-without-stockitems.xls" and "Vouchers-V9-Purchase-Horizontal-format-without-stockitems.xls" which did not support mapping.

2. Vouchers-V9-Sales-Purchase-Horizontal-Advanced-without-Stockitems.xls
This is the advanced version of the previous template. It additionally supports Cost Category, Cost Centre also.

TEMPLATEs  (Modifications)

1. Vouchers-V9-Sales-Purchase.xls
New Column added : A new column has been added to specify "Invoice Mode". i.e whether to import voucher in "Accounting Voucher" or "Invoice Voucher"

Fixes: While importing Sales/Purchase without Stockitems, the Cost Centre details were not imported / reflected in Tally. This has now been rectified.

2. Vouchers-V9-Sales-Purchase-Basic.xls

New Columns added

a. Party Ledger Alias :  You can now specify the Party Code / Alias in this column.

b. Invoice Mode :  You can specify whether to import voucher as "Accounting Voucher" or "Invoice Voucher"

3. Vouchers-V9-Sales-Horizontal-format-without-Stockitems.xls

New Columns added

a. Nature of Return

b. Debit/Credit Note No

c. Date

d. URD-Original Sale Value

PS:

This template has now been moved to the folder c:\udiMagic\templates-discontinued". Kindly use the new template "Vouchers-V9-Sales-Purchase-Horizontal-Basic-without-Stockitems.xls" or "Vouchers-V9-Sales-Purchase-Horizontal-Advanced-without-Stockitems.xls".

4. Vouchers-V9-Purchase-Horizontal-format-without-Stockitems.xls

New Columns added

a. Nature of Return

b. Debit/Credit Note No

c. Date

d. URD-Original Sale Value

PS:

This template has now been moved to the folder c:\udiMagic\templates-discontinued". Kindly use the new template "Vouchers-V9-Sales-Purchase-Horizontal-Basic-without-Stockitems.xls" or "Vouchers-V9-Sales-Purchase-Horizontal-Advanced-without-Stockitems.xls".

5. Vouchers-V9-Financial-Transactions-Single-line-entry-Advanced.xls

Fixes : While mapping, error "Nesting of Formula too deep" appears. Now rectified.

6. Vouchers-V9-Financial-Transactions-Single-line-entry-Basic.xls

Fixes : While mapping, error "Nesting of Formula too deep" appears. Now rectified.

7. Master-LedgerMaster.xls

New Columns added

a. Mailing Name

b. Assessee of Other Territory

c. Consider Party as Deemed Exporter for Purchases

d. Is a transporter

8. Master-StockItemMaster.xls

Fixes : Incorrect formula / typo for GSTDETAILS. Rectified in v9.0 r1.8

udiMagic v9.0 Release 1.7

udiMagic Excel to Tally Software
Applicable to : udiMagic v9.0 Release 1.7

Mapping Formula Length
The MAXIMUM LENGTH of Formula supported by udiMagic Mapping feature has been now increased from 255 characters to 8192 characters.

PS:
The earlier versions of udiMagic had a limit of 255 characters for Formula Length for the Mapping feature.

NEW TEMPLATEs
1. Master-Employee.xls
This excel template allows you to import Employee Master details from Excel to Tally.

TEMPLATEs  (Modifications)

1. Master-StockGroupMaster.xls
New column to specify the "GST Classification"

TEMPLATES (Fixes)

Vouchers-V9-Sales-Purchase-Basic.xls
Fixes : Provision for grouping on Sales/Purchase ledger for transactions without inventory is now done.

Vouchers-V9-Sales-Purchase.xls
Fixes : Provision for grouping on Sales/Purchase ledger for transactions without inventory is now done.

Vouchers-V9-Financial-Transactions-Basic.xls
Fixes : InstrumentDate and InstrumentNumber values do NOT appear correctly - Now rectified.

Master-StockItemMaster.xls
Fixes : GST details SKIP condition now includes GST Classification check.

udiMagic v6.0 support to be discontinued from 1st April 2018

udiMagic v6.0 (or lower versions) customers / users are requested to note that the support for udiMagic v6.0 shall be discontinued from 1st April 2018 and there shall be no product enhancements in udiMagic v6.0 thereafter.

Also, to avail technical support and product enhancements, users will have to upgrade to the latest version.

If XML tags are required for any new formats, then XML tags compatible with the latest version shall only be provided.

udiMagic v9.0 Release 1.6

Excel to Tally templates
Applicable to : udiMagic v9.0 Release 1.6

TEMPLATEs  (Modifications)

1. Vouchers-V9-Sales-Purchase-Basic.xls
• If the Sales / Purchase ledger column is kept blank, the default ledger names are taken. Now, the default ledger names have the Tax percentage as suffix.
• A new column has been added to specify the "Stockitem Part Number".
• A new column has been added to "Disable GST effect" while importing data into Tally. You must set it to Yes, if you want to upload entries with VAT.
• Fixes : The tag URDORIGINALSALEVALUE is now set as "Lesser than or equal to 2.5 lakhs" if the voucher type is Credit Note or Debit Note [Otherwise GSTR-1 displays message "Original Sales details not specified"]
2. Vouchers-V9-Sales-Purchase.xls
• If the Sales / Purchase ledger column is kept blank, the default ledger names are taken. Now, the default ledger names have the Tax percentage as suffix.
• A new column has been added to "Disable GST effect" while importing data into Tally. You must set it to Yes, if you want to upload entries with VAT.
3. Voucher-V9-Payroll-Attendance.xls
• New Columns have been added to specify the Gender, BloodGroup, IncomeTaxNo, AadharNo, PF No, UAN, PRAN, ESI No etc
4. Vouchers-V9-Financial-Transactions-Single-line-entry-Basic.xls
• New columns have been added to specify the "ReferenceNo" and "ReferenceDate"
5. Vouchers-V9-Financial-Transactions-Single-line-entry-Advanced.xls
• New columns have been added to specify the "ReferenceNo" and "ReferenceDate"
• New columns have been added for "Bank Instrument details"

TEMPLATEs (Renamed)New template : Voucher-V9-Payroll-Attendance.xls
Old template : Voucher-V8-Payroll-Attendance.xls

New template : Vouchers-V9-Financial-Transactions-Single-line-entry-Basic.xls
Old template : Vouchers-V6-Financial-transactions-single-line-entry.xls

New template : Vouchers-V9-Financial-Transactions-Single-line-entry-Advanced.xls
Old template : Vouchers-V6-Financial-transactions-single-line-entry-with-cost-centres.xls

udiMagic v9.0 Release 1.5

Excel to Tally templates
Applicable to : udiMagic v9.0 Release 1.5

TEMPLATEs  (Modifications)

1. Vouchers-V9-Sales-Purchase.xls
New Columns have been added to specify the Ledger-wise description. The Ledger-wise description works only in case of Sales / Purchase Vouchers without StockItems.

2. Vouchers-V9-Financial-transactions-Basic.xls
New Column added to specify Narration (for each Ledger).

3. Vouchers-V9-Financial-transactions-Advanced.xls
New Column added to specify Narration (for each Ledger).

TEMPLATEs (Renamed)
New template : Vouchers-V9-Sales-Purchase.xls

Old template : Vouchers-V8-Sales-Purchase.xls

New template : Vouchers-V9-Sales-Purchase-Basic.xls

Old template : Vouchers-V8-Sales-Purchase-Basic.xls

udiMagic v9.0 Release 1.4

Excel to Tally templates
Applicable to : udiMagic v9.0 Release 1.4

NEW TEMPLATEs

Master-Budgets.xls
This template allows import of Budgets from Excel to Tally.

TEMPLATEs  (Modifications)

Vouchers-V8-Sales-Purchase.xls
Minor fixes : Credit Days not imported when BYB Ref No is empty - now rectified.

Others
A new version named udiMagic Custom Edition has been introduced. The Custom Edition will include templates for specific domains.

Currently, we have included templates for Cadbury distributors

For more details on udiMagic Custom Edition, please refer :
https://www.rtslink.com/products/

Your feedback

Customer feedback is valuable. Many features introduced in udiMagic Software are based on the suggestions and feedback of our users.

We request udiMagic users to RATE the udiMagic Software using the underneath link.

Log-in into the Customer dashboard using your udiMagic Serial / Key :
https://www.rtslink.com/customer/

RATINGS are displayed at https://www.rtslink.com/downloads/

udiMagic v9.0 Release 1.2

Excel to Tally templates
Applicable to : udiMagic v9.0 Release 1.2

TEMPLATEs  (Modifications)

1. Vouchers-V9-Sales-Horizontal-format-without-stockitems.xls

This template now supports the following features :
a. CostCentre at Voucher Level

2. Vouchers-V9-Purchase-Horizontal-format-without-stockitems.xls

This template now supports the following features :
a. CostCentre at Voucher Level

3. Vouchers-V8-Sales-Purchase-Basic.xls

Fixes :
a. Debit Note now includes Original Purchase Invoice No and Date

TEMPLATEs  (Renamed)

The following templates have been renamed :

Old Name : Vouchers-V8-Sales-Horizontal-format-without-stockitems.xls

New Name : Vouchers-V9-Sales-Horizontal-format-without-stockitems.xls

Old Name : Vouchers-V8-Purchase-Horizontal-format-without-stockitems.xls

New Name : Vouchers-V9-Purchase-Horizontal-format-without-stockitems.xls