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