Wednesday, November 14, 2018

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:

Friday, November 2, 2018

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.

Tuesday, October 16, 2018

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.

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

Thursday, October 11, 2018

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.

Friday, August 31, 2018

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.

Wednesday, August 8, 2018

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.

Monday, July 16, 2018

udiMagic Limited Edition

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

1. Debugging
2. Undo Entries

Friday, June 29, 2018

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

Friday, May 11, 2018

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

Friday, March 30, 2018

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.

Thursday, March 15, 2018

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.

Friday, March 2, 2018

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


Saturday, February 17, 2018

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

Tuesday, January 23, 2018

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/


Wednesday, January 10, 2018

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/

Friday, January 5, 2018

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