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

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

Tally ERP 9 tips & tricks |
                            Download Free Tally 9 & 7.2 add-ons


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 Alternate Units; UDF Download Yes StockItem with Alternate Units; UDF etc

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
Cost Centre Master
Download  Yes Cost Centre Master


 

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



Voucher Type View /
Download
Whether Separate file is used for XML tags ? Remarks
Sales
Download
No Sales Vouchers without Stock-items. Supports multiple VAT / CST rates

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; Journal; Contra

Download
No Financial Vouchers with Reference

Includes Payment; Receipt; Journal; Credit Note vouchers.
Payment; Receipt; Journal; Contra

Download
No Financial Vouchers with UNICODE

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
Download
No Receipt Vouchers with multiple REFERENCES

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.
Busy - Payment Vouchers
Download   Yes Payment Vouchers [2]*

Busy Accounting Software format.
Busy - Receipt Vouchers Download   Yes Receipt Vouchers [2]*

Busy Accounting Software format.


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