Branch to Head Office - Transform Tally data

UDIMagic v3.0 Release 1.62



UDIMagic v3.0 Release 1.62 allows you to transform (Branch office) data before importing it into Head-Office Tally Accounting Software.

Illustration

Branch Office
Assuming, you have a Branch Office wherein Accounting is done in Tally. Here, at the Branch Office, only SALES vouchers entries are done. Now, you need to transfer the Branch Office data to Head-Office.

Head Office
At the Head-Office, you need to maintain consolidated data and hence will be importing the Branch-office data into the Head-Office (Tally). However, you want that the SALES vouchers (of Branch Office) be transformed/renamed as "BRANCH SALES" and then the same to be imported into the Head-Office Tally.

In simple words, this allows you to have TWO different Sales Voucher-types. i.e. one for Head-Office Sales and another for Branch-Office sales (BRANCH SALES voucher-type).

UDIMagic v3.0 Release 1.62 allows you to apply transformation rules to the Branch Office data before importing it at Head-Office. This allows you to do almost anything as per your requirement.

PS:
Support for writing transformation rules is available to UDIMagic [Professional version] users only.

---

Import selected data into Tally

UDIMagic - Excel to Tally


The UDIMagic v3.0 Release 1.61
allows you to import specific rows from MS-Excel into Tally Software.

To import part-data, you need to specify the FROM and TO rows.

By default, all rows are processed by UDIMagic. However, UDIMagic stops processing when it finds a BLANK row or a HIDDEN row.

---

Posting multiple Vouchers from a single Excel Sheet

FAQ's : Excel to Tally

I want to import MS-Excel data into Tally such that TWO Vouchers are passed for each record in the MS-Excel sheet. Is it possible using UDIMagic Software?

Yes. It can be done.

Information for UDIMagic Partners
All you need to do is to write XML tags that contain TWO <VOUCHER> tags. Each <VOUCHER> tag will post one Voucher into Tally.

The XML tags file will look like this :-

<-- XML tags to create 1st Voucher -->
<VOUCHER>
.... XML tags .....
</VOUCHER>

<-- XML tags to create the 2nd Voucher -->
<VOUCHER>
.... XML tags .....
</VOUCHER>

Remarks:-
As you can see, we have specified TWO <VOUHCER> tags in the XML tags file for posting TWO vouchers for a single Excel-sheet record.

---

Tally error : Can't Import. Please check tally.imp file

FAQs : Excel to Tally

I am trying to import Vouchers into Tally Software using UDI-Magic Software. Though UDI-Magic shows no errors still no data is imported into Tally and the Tally screen (calculator panel) shows error "Cant' Import. Please check Tally.imp file"

The above error generally appears if you are using the Tally Demo (Educational) version and the Vouchers in the Excel Sheet have DATE's other than 1st or 2nd (of any month).

The Educational version of Tally accepts Vouchers for the 1st and 2nd of each month. i.e. You cannot import Vouchers having date other than the 1st or 2nd of any month.

---

Tally Error: Voucher Totals do not match

"Voucher Totals do not match. Dr 122.00 Cr 122.00 Diff 0.00"

Surprised. Even though the Debit and Credit figures shown in the error are same, Tally Software still shows Dr and Cr mismatch.


Cause of the Problem:-
It is likely that the Excel sheet that you are using contains some FORMULA's. Though the display format (may) have been set to 2 decimals, MS-Excel internally does not round it off to 2 decimals until you use the =ROUND() function.

Solution :-
Search for FORMULA's used in the Excel sheet and use the =ROUND() function wherever decimal points are required.

For example, let us assume, cell D2 has a FORMULA. i.e. =+A2 / B2.
You must change it to =Round(+A2 / B2,2)

Remarks:-
1) You can set the number of decimals places DISPLAYED in Excel-sheet using option "Format >> Cell >> Number". However, when UDIMagic programmatically retrieves the cell-data, MS-Excel may return a different value which is not rounded-off to two decimals.

2) Hence, you must use the =Round() function in Excel sheet wherever required, so that when UDIMagic programmatically retrieves the cell-data, the figure rounded-off to 2 decimals is returned.

Importing CSV data into Tally Software using UDIMagic

CSV (Comma Separated values) files are plain-text files having extension (.csv or .txt) that contains data-values that are separated by commas. The first line in the file must be the Header-line and is followed by data-rows.

CSV files can be directly opened/ viewed in MS-Excel.

This post provides a CSV file that contains Ledger-Master records. Follow the steps given underneath to import data from the CSV file into Tally 9 :-

STEPS:-
1) Download and unzip the ledger-master-csv.zip file.
The zip file contents are :-
a) Ledger-Master.csv (Can be directly opened in MS-Excel)
b) Ledger-Master.xml (Use Internet Explorer to view this file)

2) Next, start Tally and create/open any Dummy Company
3) Next, minimize Tally
4) Start UDIMagic Software
5) Select option "Excel to Tally"
6) Select option "Masters"
7) Next, select the CSV file by clicking on the Browse button. By default, only Excel-files are displayed in the list-box. You need to set the option "Files of Type" as "All Files" as shown below:-

Set option "Files of Type" as "All files"

After setting option "Files of Type" as "All files", select the CSV file named "Ledger-master".

8) Next, select the XML tags file "Ledger-Master.xml".
Remarks: The XML tags file is to be selected in the same screen in which you are prompted to select the Excel/CSV file

9) Next, click on the START button to import data into Tally.

If everything goes fine, then ONE Ledger-Master record (named Shweta Softwares) will be imported into Tally. You can view the same using option "Gateway of Tally >> Accounts Info >> Ledger >> Alter" and check for Ledger named "Shweta Softwares".


Remarks:-
1) The "Excel to Tally" feature can be used to import data from both MS-Excel files or CSV files.
2) For importing data from other sources like SQL-Server; MySQL; Access; DBF-files and popular databases, you must use the "Advanced Usage" option in UDIMagic software.
3) UDIMagic identifies data in the source-file (MS-Excel or CSV or Database-files) based upon the mapping given in the XML-file and constructs proper XML tags which are supported by Tally Software.

---

UDIMagic with Auto Run feature

UDIMagic v3.0 Release 1.60 comes with a new feature called Auto-Run.

What is Auto Run ?

The Auto Run feature allows you to setup UDIMagic to run automatically without any User-intervention.

Once this feature is enabled, you can add UDIMagic to "Windows Scheduler" to run UDIMagic at scheduled timings.

How to enable the Auto Run mode in UDIMagic ?

1) Start UDIMagic and follow the wizard instructions to import data as you normally do.
2) In the Settings screen, click on the "Enable Auto Run" check-box to enable it.
3) Next, click on the Start button to import data into Tally.

This now enables Auto-Run mode; and few lines are added to the UDIMagic.ini (configuration) file. You can also manually edit the UDIMagic.ini (configuration) to enable/disable the Auto-Run feature.

How do I add UDIMagic to Windows Scheduler ?

1) From the Windows Start menu, select "Settings >> Control Panel"
2) Next, select Scheduled Tasks
This displays all the currently scheduled tasks.
3) Next, select "File >> New >> Scheduled Task"
4) Give a name to the Task, say UDIMAGIC.
5) Next, double-click on UDIMAGIC scheduled task to modify the settings

Screen 1: Specify the UDIMagic.exe path

Screen 2: Specify the Schedule Time

This will auto-run UDIMagic at the schedule timings.

Remarks:-
1) In the Auto-Run mode, a file named "Autorun.log" is created which records the UDIMagic process activites. This is generally useful for keeping track of Data imported; or errors (if any).
2) When the Auto-Run mode is enabled, manually starting UDIMagic will display a AUTO-RUN Splash screen that allows you to Skip or Disable the Auto-Run mode.

---