Here are some Excel Sheets templates for importing MASTERs and
VOUCHERs into Tally Accounting Software using the UDIMagic utility.
A) Masters
B) Vouchers
|
Excel Sheet template & XML
tags (zip format) |
View /
Download |
Whether Separate file is used
for XML tags ? |
Remarks
|
|
Unit Master
|
View
Download |
No |
Additional References:-
UNIT Master tutorial
|
|
Stock Group Master
|
View
Download
|
No |
|
|
Stock Category Master |
View
Download |
No |
|
|
Godown Master |
View
Download |
No |
|
Stock Item Master
(with detailed write-up) |
View
Download |
No |
Includes Stock-item Alias; PartNo; Opening balance etc.
References:-
Understanding
XML tags used in this Excel sheet
|
|
Stock Items with Default Ledger
|
View
Download |
Yes |
Includes the default "Ledger Name" used for Accounting Allocation.
References:-
UDIMagic blogsite
|
|
Stock Item Master with multiple Locations
|
View
Download |
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
|
View
Download |
Yes |
Includes stock with Batch-expiry details.
The zip file includes a macro file.
References:-
UDIMagic blogsite
|
|
Stock Item Master with Price List
|
View
Download |
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 |
View
Download |
Yes |
Includes Price List and default "Ledger Name" for Accounting Allocation.
References:-
UDIMagic blogsite
|
|
Multiple Price Levels (Price List) |
View
Download |
Yes |
Allows import of Multiple Price Levels (Price List).
References:-
Import
Multiple Price Levels (Price List) data into Tally
|
|
Group Master |
View
Download |
No |
|
|
Ledger Master |
View
Download |
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) |
View
Download |
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
|
|
Ledger Master with Excise Info |
View
Download
|
Yes |
Party Masters (Suppliers and Customers) with Address, VAT/TIN, Sales Tax, Excise
No and other Excise Info |
|
Voucher Type |
Excel Sheet template & XML
tags & macro-file (zip format) |
View /
Download |
Whether Separate file is used
for XML tags ? |
Remarks |
|
Sales |
Sales Vouchers with Stock-items [1]*
|
View
Download |
No |
Sales Vouchers with Stock-items.
|
|
Sales |
Sales Vouchers without Stock-items [1]* |
View
Download |
No |
Sales Vouchers with Excise Duty; NCC Duty; EDU Cess; SHE Cess etc.
|
|
Sales |
Sales Vouchers with Cost Centres / Cost Categories
|
View
Download |
No |
Includes Cost Centre / Cost Category details.
References:-
Understanding
XML tags used in this Excel sheet
|
|
Sales |
Sales Vouchers with Salesman UDF
|
View
Download |
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
|
View
Download |
No |
Includes VAT |
|
Sales |
Sales Vouchers with VAT and other Taxes
|
View
Download |
No |
Includes Excise Duty; Educational Cess; VAT etc
|
|
Sales |
Sales Vouchers with mulitple VAT rates [2]* |
View
Download |
Yes |
Includes Stock-items with different VAT rates.
Uses macros.
References:-
UDIMagic blogsite |
|
Sales |
Sales Vouchers with mulitple currencies |
View
Download |
Yes |
References:-
UDIMagic blogsite |
|
Sales; Receipts |
Sales and Receipt Vouchers
|
Download |
Yes |
Sales with StockItems; multiple New References and multiple VAT-rates
Receipts with Against Reference (for Sales Invoices) |
|
Sales; Receipts |
Sales and Receipts Vouchers |
Download
|
Yes |
Sales with VAT & CST but without StockItems |
|
Sales |
Sales Vouchers [FMCG Distributor] |
Download
|
Yes |
Sales vouchers for FMCG distributor |
|
Sales |
Sales Vouchers with Cash,Scheme Discount |
Download
|
Yes |
Sales vouchers with Cash, Scheme Discount |
|
Sales; Purchase |
Shares sale / purchase transactions [2]*
[Simple format] |
View
Download |
Yes |
Contains Shares sales / purchase transactions which are to be imported into Tally
Uses macros. |
|
Sales; Purchase |
Shares sale / purchase transactions [Reliance Money format] |
View
Download |
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 |
Download |
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]* |
View
Download |
No |
Includes Payment; Receipt; Journal; Credit Note vouchers.
|
|
Purchase |
Purchase Vouchers with Stock-items [1]* |
View
Download |
No |
Contains Purchase Vouchers with Stock-items. |
|
Purchase |
Purchase Vouchers with VAT and discount |
View
Download |
No |
References:-
UDIMagic blogsite
|
|
Purchase |
Purchase Vouchers with multiple VAT rates [2]* |
View
Download |
Yes |
Includes Stock-items with different VAT rates.
Uses macros. |
|
Receipt |
Receipt Vouchers |
View
Download |
No |
References:-
UDIMagic blogsite
|
|
Receipt |
Receipt Vouchers with multiple Receipt Voucher Types |
View
Download |
No |
References:-
UDIMagic blogsite
|
|
Receipt |
Receipt Voucher entries (One entry for multiple parties) [2]* |
View
Download |
Yes |
References:-
UDIMagic blogsite
Uses macros. |
|
Journal |
Journal Vouchers with Service Tax [2]* |
View
Download |
Yes |
Illustrates use of Advanced macros with UDIMagic.
References:-
UDIMagic blogsite
Uses macros. |
|
Journal |
Journal Vouchers |
Download |
Yes |
|
|
Credit Notes |
Credit Notes Vouchers [2]* |
View
Download |
Yes |
References:-
UDIMagic blogsite
Uses macros. |
|
Debit Notes |
Debit Note vouchers |
Download |
Yes |
|