Excel to Tally.ERP 9 | Download Free Excel templates for Importing data in Tally 9 Accounting Software

Home / Downloads / Excel Sheet templates

Excel-sheet templates for importing Masters & Vouchers in Tally.ERP 9, Tally 9 Accounting Software

(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 to import MASTERs into Tally.ERP 9, Tally 9 Accounting Software

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
Stock Item with BOM (sample 1)	Download	Yes	Allows import of StockItem with BOM
Stock Item with BOM (sample 2)	Download	Yes	Allows import of StockItem with BOM
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
Stock Item Master (only Sale Price)	Download	Yes	Import Stock Item details into Tally (PartNo, Name, Sale Price / Effective Date)
Stock Item Master (only Purchase Price)	Download	Yes	Import Stock Item details into Tally (PartNo, Name, Purchase Price / Effective Date)
Stock Item Master (Sale;Purchase Price)	Download	Yes	Includes Partno; Name; Location; Opening Stock; Sale Price and Purchase Price
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
Ledger Master (Party Masters)	Download	Yes	Party Masters (with Address; Alias; Group-Name)
Ledger Master (Party Masters)	Download	Yes	Party Masters (with Address; other contact details)
VAT Classification Master	Download	Yes	VAT Class Statutory Masters
Employee Master (Payroll)	Download	Yes	Employee Master details for Payroll

(B) Excel Sheet Templates to import VOUCHERs into Tally.ERP 9, Tally 9 Accounting Software

Voucher Type	View / Download	Whether Separate file is used for XML tags ?	Remarks
Sales	View Download	No	Sales Vouchers with Stock-items.
Sales	View Download	No	Sales Vouchers without Stock-items [1]* Includes Excise Duty; NCC Duty; EDU Cess; SHE Cess etc.
Sales	View Download	No	Sales Vouchers with Stock-items Includes Cost Centre / Cost Category details. References:- Understanding XML tags used in this Excel sheet
Sales	View Download	No	Sales Vouchers with Stock-items Includes UDF for Salesman. 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	View Download	No	Sales Vouchers with Stock-Items For MobilePhone distributor / reseller. Includes VAT
Sales	View Download	No	Sales Vouchers without Stock-items Includes VAT; Excise Duty; Educational Cess; VAT etc
Sales	View Download	Yes	Sales Vouchers with Stock-Items [2]* Includes different VAT rates. Uses macros. References:- UDIMagic blogsite
Sales	Download	Yes	Sales Vouchers with StockItems Includes VAT; Additional VAT; Excise Duty; Service Tax and other levies
Sales	Download	Yes	Sales Vouchers with StockItems, VAT, Addl VAT Sample format of Landmark Honda Dealer
Sales	Download	Yes	Sales Vouchers without StockItems Includes VAT; CST; Excise duty and other levies
Sales	View Download	Yes	Sales Vouchers with multiple currencies References:- UDIMagic blogsite
Sales	Download	Yes	Sales Vouchers with StockItems [2]* Includes multiple Sales ledgers. Uses macro file.
Sales	Download	Yes	Sales Vouchers without StockItems Includes multiple VAT Rates
Sales	Download	Yes	Point of Sale Vouchers Includes Sales Return, and Cancelled Voucher
Sales	Download	Yes	Sale Vouchers for Ashok Leyland Dealers Includes Sales 5%, Sales 13.5% and Sales 14%
Sales	Download	Yes	Sale Vouchers for Focus ERP users. Includes Excise, VAT, Amortization of Expenses etc
Sales; Receipts	Download	Yes	Sales with StockItems; multiple New References and multiple VAT-rates Receipts with Against Reference (for Sales Invoices)
Sales; Receipts	Download	Yes	Sales with VAT & CST but without StockItems. Receipt vouchers
Sales; Receipts	Download	Yes	Sales and Receipts Vouchers Sales without Stock-items but with VAT; CST.
Sales	Download	Yes	Sales vouchers with multiple Sales Ledgers but without Items
Sales	Download	Yes	Sales vouchers for FMCG distributor
Sales	Download	Yes	Sales vouchers for FMCG distributor
Sales	Download	Yes	Sales vouchers with Cash, Scheme Discount
Sales	Download	Yes	Sales Vouchers with Items; Service Tax; Order Number
Sales	Download	Yes	Sales Vouchers with Stock-items Includes Multiple-Godown; BatchNumber; but without VAT.
Sales	Download	Yes	Sales Vouchers with Stock-items and VAT Format to import from Wings Software to Tally
Sales; Purchase	View Download	Yes	Shares sale / purchase transactions [2]* [Simple format] Contains Shares sales / purchase transactions which are to be imported into Tally Uses macros.
Sales; Purchase	View Download	No	Shares sale / purchase transactions [Reliance Money format] References:- Understanding XML tags used in this Excel sheet with detailed write-up
Sales; Purchase; Debit Note; Credit Note	Download	Yes	Different Voucher-types which include UDF (User defined field) for Singapore VAT 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	View Download	No	Financial Vouchers [1]* Includes Payment; Receipt; Journal; Credit Note vouchers.
Payment; Receipt; Jounal; Contra	Download	Yes	Financial Vouchers Single line entry format for Payment; Receipt;Contra; Journal vouchers
Payment; Receipt; Journal; Contra	Download	No	Financial Vouchers with Cost Category and Cost Centres Includes Payment; Receipt; Journal; Contra vouchers.
Payment; Receipt; Contra	Download	Yes	Cash and Bank tansactions Includes Payment; Receipt; Contra vouchers
Payment	Download	Yes	Payment vouchers with Cost Centres
Purchase	Download	No	Purchase Vouchers for Focus ERP users Includes Excise, VAT etc.
Purchase	View Download	No	Purchase Vouchers with Stock-items [1]* Contains Purchase Vouchers with Stock-items.
Purchase	View Download	No	Purchase Vouchers with VAT and discount References:- UDIMagic blogsite
Purchase	View Download	Yes	Purchase Vouchers with multiple VAT rates [2]* Includes Stock-items with different VAT rates. Uses macros.
Purchase	Download	Yes	Purchase Vouchers with VAT Includes VAT; Additional VAT; Excise duty and other levies
Purchase	Download	Yes	Purchase vouchers without Stock-items Includes VAT.
Purchase	Download	Yes	Purchase vouchers without Stock-items. [2]* Includes VAT, CST. Uses macro file
Purchase	Download	Yes	Purchase vouchers with Stock-items. [2]* Includes multiple VAT rates. Uses macro file
Purchase	Download	Yes	Purchase vouchers without Stock-items Includes multiple VAT rates
Receipt	View Download	No	Receipt Vouchers References:- UDIMagic blogsite
Receipt	View Download	No	References:- UDIMagic blogsite
Receipt	View Download	Yes	Receipt Voucher entries (One entry for multiple parties) [2]* References:- UDIMagic blogsite Uses macros.
Receipt	Download	Yes	Receipt Voucher entries with Bank/Instrument details [2]* Uses macros.
Receipt; Payment	Download	Yes	Cash Vouchers (receipts and payments) Format to import from Wings Software to Tally
Receipt; Payment	Download	Yes	Cash Vouchers (receipts and payments) with multiple Party Names Format to import from Wings Software to Tally
Journal	View Download	Yes	Journal Vouchers with Service Tax [2]* Illustrates use of Advanced macros with UDIMagic. References:- UDIMagic blogsite Uses macros.
Journal	Download	Yes	Journal Vouchers
Journal	Download	Yes	Journal Vouchers with Cost Category and Cost Centres
Journal	Download	Yes	Journal Vouchers with Cost Centres
Credit Notes	View Download	Yes	Credit Notes Vouchers [2]* References:- UDIMagic blogsite Uses macros.
Credit Notes	Download	Yes	Credit Notes (Sales Return) with StockItems, with Godown, without VAT
Debit Notes	Download	Yes	Debit Note vouchers
Stock Journal	Download	Yes	Stock Journal Manufacturing Voucher [2]*. Uses macro file.
Sales Order	Download	Yes	Sales Order [2]* Uses macro file. Refer Instructions PDf file provided within the zip-file
Purchase Order	Download	Yes	Purchase Order [2]* Uses macro file which must be always kept in the "udi-magic" folder.

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.

Home \| RTSLink \| Downloads \| Contact Us \| Buy \| FAQ
Designed by Indiatimes Webuild - vSplash	© 2008. Shweta Softwares. All rights reserved.

Excel to Tally 9 | Excel to Tally.ERP 9 | Free Download Tally Masters Templates | Free Download Tally Vouchers templates

Excel-sheet templates for importing Masters & Vouchers in Tally.ERP 9, Tally 9 Accounting Software

(A) Excel Sheet Templates to import MASTERs into Tally.ERP 9, Tally 9 Accounting Software

(B) Excel Sheet Templates to import VOUCHERs into Tally.ERP 9, Tally 9 Accounting Software