udiMagic v10 Release 1.6

Excel Template Modifications

1. Mapping feature

The following templates support the NEW MAPPING feature:

Master-LedgerMaster.xls
Master-StockItemMaster.xls
Vouchers-V10-Financial-Transactions-Basic.xls
Vouchers-V10-Financial-Transactions-Advanced.xls
Vouchers-V10-Sales-Purchase-Without-Stockitems-Basic.xls
Vouchers-V10-Sales-Purchase-Without-Stockitems-Advanced.xls

See Video in English : https://www.youtube.com/watch?v=4bmfRXlQXKc
See Video in Hindi : https://www.youtube.com/watch?v=X-J9X4iSIpI

2. Vouchers-V10-Financial-Transactions-Single-line-entry-Advanced.xls

The following new fields / columns have been added:
a. PARENT DR LEDGER  (Specify the Parent Group Name for Debit Ledger)
b. PARENT CR LEDGER  (Specify the Parent Group Name for Credit Ledger)

New Mapping Feature - udiMagic v10 Release 1.5

Map Your Excel data and Import in Tally ERP

The following templates support the NEW MAPPING feature:

1. Vouchers-V10-Bank-statement.xls
2. Vouchers-V10-Bank-statement-Single-Column-Dr-Cr.xls
3. Vouchers-V10-Sales-Purchase-With-Stockitems-Basic.xls
4. Vouchers-V10-Sales-Purchase-With-Stockitems-Advanced.xls

Mapping Feature - How it works?

Learn how to use the mapping feature to import your excel data into Tally ERP 9. Here, mapping refers to a process wherein you have to associate each column in the Standard Excel file with the relevant column in your Excel file.

See Video in English : https://www.youtube.com/watch?v=4bmfRXlQXKc
See Video in Hindi : https://www.youtube.com/watch?v=X-J9X4iSIpI

udiMagic v10 Release 1.4

Excel Template Modifications

1. Vouchers-V10-Bank-statement.xls
A NEW column for "VoucherNumber" has been included.

2. Vouchers-V10-Bank-statement-Single-Column-Dr-Cr.xls

A NEW column for "VoucherNumber" has been included.

3. Vouchers-V10-Sales-Purchase-With-Stockitems-Advanced.xls

A NEW column for "SKIPVoucher" has been included. If this contains "Yes", then the Voucher is skipped and is NOT imported into Tally ERP. The default value for this column is "No"

udiMagic Single Template Edition

Excel to Tally - udiMagic Single Excel Template 

We are pleased to inform you about launch of udiMagic Single Template Edition.

udiMagic Single template Edition

• You can now BUY a Single template as per your requirement.
• Available on 1 month and 1 year subscription basis.
• For price details, please visit https://www.rtslink.com/buy/

udiMagic v10 Release 1.3

Fixes in Release 1.3

Supplier and Consignee Address

While importing the Purchase Vouchers from Excel to Tally ERP 9, the Supplier Name does NOT appear correctly in Tally. This  has now been rectified and the following Excel templates have been updated :

Vouchers-V10-Sales-Purchase-with-Stockitems-Advanced.xls

Vouchers-V10-Sales-Purchase-without-Stockitems-Advanced.xls

Vouchers-V10-Sales-Purchase-without-Stockitems-Basic.xls

Place of Supply

The StateName appears more than once in GSTR1 B2C report as the data specified contains GUJARAT and Gujarat. This has now been rectified and the Place of Supply is now converted to Proper case before importing it in Tally.

Fix: Excel Fill Handle is missing

How to enable Fill handle in Excel?

The Fill Handle feature in Excel allows you to select a series of cells with incremental values and drag the cell corner to complete the series. However, if this does not work then check out the following :

1. Click "File"
2. Click "Options"
3. Click "Advanced"
4. Next, tick the option "Enable fill handle and cell drag-and-drop"
5. Next, save the settings and then retry to fill the series by dragging the cell corner.

Multi-Currency Excel templates

Import FOREX entries in Tally

Using the Excel templates provided with udiMagic v10 Release 1.2, you can now upload Sales and  Purchase entries with Inventory and Multi-Currency into Tally ERP 9.

In these latest Excel templates, two additional columns have been provided for CURRENCY and ROE (Rate of Exchange). If you specify the Currency and ROE, the entries are automatically reflected in FOREX currency in Tally ERP 9. If you keep these columns blank, then the entries are uploaded in Tally in base currency.

The multi-currency feature is now supported in the following Excel templates :

Sales, Purchase, Debit Note, Credit Note entries with Multi-currency

Vouchers-V10-Sales-Purchase-With-Stockitems-Basic.xls
Vouchers-V10-Sales-Purchase-With-Stockitems-Advanced.xls

For Receipt, Payment, Journal, Contra entries with Multi-currency

Vouchers-V10-Financial-Transactions-Basic.xls
Vouchers-V10-Financial-Transactions-Advanced.xls