Monday, March 17, 2008

Import Credit Notes from Excel into Tally

UDI-Magic || Excel to Tally

Here's a sample Excel-sheet that contains Credit Note Vouchers of an Advertisement firm. Follow these steps to import the Excel-sheet data into Tally Software.

1) Download and unzip the files into "c:\udi-magic" folder.
2) Start the Tally software and create/open a Dummy Company.
3) Minimize Tally Software
4) Run UDIMagic utility, select option "Excel to Tally -> Voucher".
5) Next, select the Excel sheet and the XML-tags file when prompted. Note that the XML-tags file is to be selected in the same screen in which you are prompted to select the Excel-sheet.
6) Next, follow the instructions given in the wizard-screen to import data into Tally.

The ZIP file contains 3 files viz:-
a) circulation-credit-notes.xls (Excel-sheet)
b) circulation-credit-notes-xml-tags.xml (XML-tags file)
c) circulation-credit-notes-macro.txt (Macro file)

Normally, in the previous samples the XML tags were written in the Excel-sheet itself (i.e. in the comments section of cell A1). However, in this case the XML-tags are provided in a separate file, hence you must specify the XML-tags file when prompted in the UDIMagic wizard screen.

This sample contains a macro-file which does some calculations at run-time. This is required as the Voucher-totals are not manually added and are calculated at run-time. VBA (or Macros) is a very powerful feature in MS-Office applications that allows you to automate tasks. UDIMagic uses this feature to manipulate Excel-sheet data at run-time to perform calculations; add new columns etc.

No comments: