Entries not shown in Bank Reconciliation

Entries missing in Tally Bank Reconciliation

Problem description

When we import the Bank payment or receipt entries with transaction-type as "e-Fund transfer" in Tally, these entries are not shown in the Bank Reconciliation statement.

Solution

In the transaction type column in the Excel sheet, specify "Same bank transfer" instead of "e-Fund transfer" and then retry import the XLS into Tally.

udiMagic v10 Release 1.9

Excel Template Modifications

Compound Unit in StockItem Master

Template : Master-StockitemMaster.xls
Description : This template now includes new fields/columns for specifying "Compound Unit" details viz "First Unit, Conversion Factor, Second Unit"

Multi-line Address in Employee Master

Template : Master-Employee.xls
Description : This template now includes additional columns to specify the Employee Address.

Template fixes

Template : Vouchers-V10-Journal-with-multiple-references.xls
Description : The "IsCostCentreOn" feature is NOT enabled automatically for the newly created ledgers. This bug has been now rectified.

Customer dashboard

The Customer dashboard now includes a new option :

Renewal
udiMagic users can now Renew their Subscription based licenses using this option and avail additional benefits.

Renewal of subscription has to be done on or before the expiry of the existing subscription period.

Users can login into the Customer dashboard using the underneath link :
https://www.rtslink.com/customer/

3 ways to Import data in Tally

Different methods to import Excel data in Tally

There are several ways to import excel data in Tally using udiMagic software. Watch the videos (links given at bottom) to know more.

1. Copy/paste data in Standard template

You can put your data in the Standard templates using copy/paste or can manually enter it. However, this may be tedious if the data is voluminous.

STEPS

• Copy/paste from your Excel file into the Standard template
• Import data from Standard template into Tally ERP

2. Mapping (in Standard Excel template)

In this case, you once map the columns in the Standard EXCEL template. Next, the data is copied from your Excel sheet to the Standard template with a single click. You can then import data from the Standard template into Tally using udiMagic. 

STEPS

• Map the columns in Standard template
• Transfer data from your Excel file into Standard template with a single click
• Import data from Standard Excel template into Tally ERP

See Video (English) :  https://www.youtube.com/watch?v=4bmfRXlQXKc

See Video (Hindi) : https://www.youtube.com/watch?v=X-J9X4iSIpI

3. Mapping (in udiMagic Software)

In this case, you once map the columns in the udiMagic Sofware itself. You can then import data directly from your Excel sheet into Tally using udiMagic.

STEPS

• Map columns in udiMagic software
• Import data directly from your Excel file into Tally ERP

See Video: https://www.youtube.com/watch?v=8axVdhAJ6zM

Excel opening blank when you double-click a file icon or file name

Symptoms

When you double-click an icon or file name for a Microsoft Excel workbook, Excel starts but displays a blank screen where you expect the file to appear.

Resolution

Please refer this link to resolve the issue:
https://support.microsoft.com/en-in/help/2994633/excel-how-to-troubleshoot-excel-opening-blank-when-you-double-click-a

Alternatively,  restart your system and then try opening the Excel file.

Notes:
The above occasionally happens when you import data from Excel to Tally ERP.

udiMagic v10 Release 1.8

Excel Template Modifications

1. Mapping feature

The following templates support the NEW MAPPING feature:

Vouchers-V10-Journal-with-multiple-references.xls
Vouchers-V10-Payroll-Attendance.xls
Vouchers-V10-Physical-Stock-Journal.xls
Vouchers-V10-Receipts-and-Payments-with-multiple-references.xls
Vouchers-V10-Stock-Journal.xls


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

ST Category does not exist

Fix : How to fix the error ST Category 'Not applicable' does not exists in Tally ERP 9

Applicable to :  Branch to HO utility (Old users only)

Steps to resolve the issue

1. In Gateway of Tally, press F11 and select the option "Statutory & Taxation".
2. Enable the option "Enable Service Tax" and set the option "Define service category and tax details as masters" to Yes.
3. Press Ctrl+A to save the configuration.
4. Next, from Gateway of Tally, select option "Accounts Info >> Statutory Info >> Service Categories".
5. Next, select the option "Create" and specify the Name as "Not applicable" and press Ctrl+A to save the Service Tax Category.
6. Next, disable the "Enable Service Tax" option in "Gateway of  Tally >> F11 >> Statutory & Taxation".