rtslink.com
Home / Downloads / Excel Sheet templates

Excel-sheet templates


(for UDIMagic users)

Here are some Excel Sheets templates for importing MASTERs and VOUCHERs into Tally Accounting Software using the UDIMagic utility.

A) Masters
B) Vouchers

1) UDIMagic is a robust and scalable utility that can import all Masters and Vouchers from MS-Excel into Tally Software irrespective of the Excel sheet format. All we need to do is to tell UDIMagic "What data you have in the Excel sheet and where is it stored ?". This is done using XML tags.

2) In the sample Excel sheets given below, the XML tags have been written in two ways :-
a) Within the Excel sheet itself (in Comments section) or; 
b) In a separate plain text-file having xml extension


(A) Excel Sheet Templates for importing MASTERs into Tally Accounting Software


Download Excel Sheet template & XML tags (zip format) Whether Separate file is used for XML tags ? Remarks
Unit Master No
Additional References:-
UNIT Master tutorial
Stock Group Master No
Stock Category Master No
Godown Master No
Stock Item Master
(with detailed write-up)
No Includes Stock-item Alias; PartNo; Opening balance etc.

References:-
Understanding XML tags used in this Excel sheet
Stock Items with Default Ledger Yes Includes the default "Ledger Name" used for Accounting Allocation.

References:-
UDIMagic blogsite
Stock Item Master with multiple Locations No Includes location-wise Opening Stock.

You must manually enable the feature "Gateway of Tally >> F11 >> Inventory features >> Maintain Multiple Godown"
Stock Item Master with Batch expiry Yes Includes stock with Batch-expiry details.

The zip file includes a macro file.

References:-
UDIMagic blogsite
Stock Item Master with Price List No Includes the Price List details 

You must manually enable the  feature using "Gateway of Tally >> F11 >> Inventory features >> Use multple price levels"

References:-
UDIMagic blogsite
Stock Item Master with Advanced features Yes Includes Price List and default "Ledger Name" for Accounting Allocation.

References:-
UDIMagic blogsite
Group Master No
Ledger Master Yes This Excel sheet contains Ledger Master records for Parties with Address; Email; VAT TIN no; Opening balances etc.

References:-
UDIMagic blogsite
Ledger Master with Bill-by-Bill details    
(with detailed write-up)
No The Ledger Opening balances contain with Bill-by-Bill (B-Y-B) details.

The Bill due-dates specified in this Excel Sheet relate to period 07-08. Hence, to try out this Excel sheet you must keep the Financial Year as Apr'07-Mar'08.

References:-
Understanding XML tags used in this Excel sheet


 

(B) Excel Sheet Templates for importing VOUCHERs into Tally Accounting Software



Voucher Type Download Excel Sheet template & XML tags & macro-file (zip format) Whether Separate file is used for XML tags ? Remarks
Sales Sales Vouchers with Stock-items [1]* No Sales Vouchers with Stock-items.

Sales Sales Vouchers without Stock-items [1]* No Sales Vouchers with Excise Duty; NCC Duty; EDU Cess; SHE Cess etc.
Sales Sales Vouchers with Cost Centres / Cost Categories
No Includes Cost Centre / Cost Category details.

References:-
Understanding XML tags used in this Excel sheet
Sales Sales Vouchers with Salesman UDF

No Illustrates how to use UDF (user-defined-fields)created using TDL and import the same into Tally using UDIMagic.

References:-
Salesman TDL and other details
Sales Sales Vouchers with Stock-Items and VAT
No Includes VAT
Sales Sales Vouchers with VAT and other Taxes
No Includes Excise Duty; Educational Cess; VAT etc
Sales Sales Vouchers with mulitple VAT rates[2]* Yes Includes Stock-items with different VAT rates.

Uses macros.

References:-
UDIMagic blogsite
Sales Sales Vouchers with mulitple currencies Yes References:-
UDIMagic blogsite
Sales; Purchase Shares sale / purchase transactions [2]*
[Simple format]
Yes Contains Shares sales / purchase transactions which are to be imported into Tally

Uses macros.
Sales; Purchase Shares sale / purchase transactions [Reliance Money format] No References:-
Understanding XML tags used in this Excel sheet with detailed write-up
Sales; Purchase; Debit Note; Credit Note Different Voucher-types which include UDF (User defined field)

UDF for Singapore VAT
Yes Illustrates how to use UDF (user-defined-field) with UDIMagic. The UDF has been provided by Tally Solutions, Bangalore which adds a new field to Voucher object for storing Singapore VAT.  

Zip file includes 5 Excel sheets.

References:-
Understanding XML tags used in this Excel sheet with detailed write-up
Payment; Receipt; Journal; Contra Financial Vouchers [1]* No Includes Payment; Receipt; Journal; Credit Note vouchers.
Purchase Purchase Vouchers with Stock-items [1]* No Contains Purchase Vouchers with Stock-items.
Purchase Purchase Vouchers with VAT and discount No
References:-
UDIMagic blogsite
Purchase Purchase Vouchers with multiple VAT rates [2]* Yes Includes Stock-items with different VAT rates.

Uses macros.
Receipt Receipt Vouchers No References:-
UDIMagic blogsite
Receipt Receipt Vouchers with multiple Receipt Voucher Types No References:-
UDIMagic blogsite
Receipt Receipt Voucher entries (One entry for multiple parties) [2]* Yes References:-
UDIMagic blogsite

Uses macros.
Journal Journal Vouchers with Service Tax [2]* Yes Illustrates use of Advanced macros with UDIMagic.

References:-
UDIMagic blogsite

Uses macros.
Credit Notes Credit Notes Vouchers [2]* Yes References:-
UDIMagic blogsite

Uses macros.


Remarks:- 
[1] This Excel sheet is also available with the UDIMagic Demo version and gets automatically created  in  "c:\udi-magic" folder when UDIMagic is run for the first time

[2] A Macro-file is used. Refer this FAQ to know more about using macros (VBA) with UDIMagic.


Tags:
RTSlink DLL, UDIMagic, Tally Integration, Excel to Tally, Free Demo, Tally 7.2, Tally 9
Tally is a registered trademark of Tally Solutions FZ LLC.

Valid HTML 4.01 Transitional