Excel to Tally - Sample Excel sheet formats

The following sample Excel sheet format is now available for UDIMagic users :-

Employee Master - For Payroll

Excel to Tally - Sample Excel sheet formats

The following sample Excel sheets formats are now available for UDIMagic users :-

1) Sales Vouchers with StockItems and Multiple Sales Ledgers
2) Sales Vouchers without StockItems, with multilple VAT rates
3) Point of Sale vouchers with Sales Return, Cancelled vouchers
4) Purchase Vouchers with VAT and CST (Local Purchase and CST Purchase)
5) Purchase Vouchers with StockItems and multiple VAT rates
6) Purchase Vouchers without StockItems, with multiple VAT rates

Excel to Tally - Sample Excel Sheet formats

The following sample Excel sheets formats are now available for UDIMagic users :-

UPDATED : 2018-02-10
New Templates available at :
https://www.rtslink.com/products/udimagic/standard-templates/

***************************************************************************

The templates shown below are now discontinued.

Import Masters from Excel into Tally

1) StockItem Master (only Sale Price)
2) StockItem Master (only Purchase Price)
3) StockItem Master (only Sale & Purchase Price)
4) Ledger Master (Party Masters with different parent Groups)
5) Ledger Master (Party Masters with contact details)

Import Vouchers from Excel into Tally

1) Sales Vouchers with StockItems (including VAT; Additional VAT; CST; Excise etc)
2) Sales Vouchers without StockItems (including VAT; Additional VAT; CST; Excise etc)
3) Sales Vouchers with StockItems (including Service Tax; Order Number)
4) Purchase Vouchers (including VAT; Additional VAT)
5) Financial Vouchers in Single-line format (Payment; Receipt; Contra; Journal)
6) Stock Journal vouchers (Manufacturing Jounal)
7) Cash and Bank Vouchers( Receipt; Payment; Contra)

To view/download all sample Excel sheet formats, please visit http://www.rtslink.com/download-excel-sheets.html

---

Sales Vouchers with Cash, Scheme Discounts

Excel to Tally

Sample Excel-sheet format for Sales vouchers containing :-

a) Cash discount
b) Scheme discount

Download the Excel Sheet and XML tags

Journal Vouchers

Excel to Tally

Sample Excel-sheet format for Journal (JV) vouchers

Download the Excel Sheet and XML tags

Sales vouchers of a FMCG distributor-firm

Excel to Tally

Sample Excel-sheet format for Sales vouchers of a FMCG distributor-firm.


Download the Excel Sheet and XML tags

Sales and Receipt Vouchers in a single file

Excel to Tally

Sample Excel-sheet format for Sales & Receipt vouchers containing :-

a) Multiple-VAT Rates (i.e. Sales 4%, Sales 12.5%, Sales Exempt
b) CST Sales
c) Freight, Postage and other charges
d) Receipt Voucher entries (Auto-posting for Cash Sales)

Download the Excel Sheet and XML tags

Sales and Receipt Vouchers

Excel to Tally

Sample Excel-sheet format for Sales & Receipt vouchers containing :-

a) Stock-Items
b) Multiple-VAT Rates
c) Multiple BYB References

Download the Excel Sheet and XML tags

---