Excel to Tally - Versatile Tamplates

Excel to Tally Import : Versatile Templates for Voucher Entries

Excel to Tally - Versatile Tamplates

Columnar Voucher Register:

This is Commonly used template. This template is very Useful when data available in register format like Sales, Purchase or payment register etc. Using this template available voucher modes are: Sales, Purchase, Receipt, Payment, Contra, Journal. Also add-ons modes available like: Debit / Credit Notes, Purchase Order, Receipt Notes, Stock and Manufacturing Journal etc.

Sheet mapping is available for this template. Using mapping option user may map his existing sheet to this template. Mapping is one time process. User can save multiple copies of this template for each mode.

Features:
  • Maximum 81 Cols available, i.e. single voucher entry may contain 82 ledgers.
  • 65,000 rows can be imported in a batch
  • New ledgers and stock items detection and creation
  • Multiple Inventory with multiple ledgers allocation
  • Automated VAT Classification for existing ledgers.
  • Cost Centers Allocation
  • Multiple Currency (add-on) and much more…
Excel to Tally - Versatile Tamplates

Multi-Modes Voucher Register:

Very useful when data available in multiple ledgers in single row for a voucher. Using this template user may import multiple voucher modes at a time. Using this template available voucher modes are: Sales, Purchase, Receipt, Payment, Contra, Journal and Memo.

Sheet mapping is available for this template. Using mapping option user may map his existing sheet to this template. Mapping is one time process. User can save multiple copies for later use.

Features:
  • 5 Dr and 5 Cr Cols available, i.e. single voucher entry may contain 10 ledgers.
  • 65,000 rows can be imported in a batch
  • New ledgers detection and creation
  • Cost Centers Allocation (add-on)
  • And more…
Excel to Tally - Versatile Tamplates

Day-book Voucher Register:

Very useful when data available in unified format, like exported from a software, database or downloaded from a website etc. Using this template user may import multiple voucher modes at a time. Using this template available voucher modes are: Sales, Purchase, Receipt, Payment, Contra, Journal and Memo.

Sheet mapping is available for this template. Using mapping option user may map his existing sheet to this template. Mapping is one time process. User can save multiple copies of this template.

Features:
  • No limit for ledgers, i.e. single voucher entry may contain practically unlimited ledgers.
  • 65,000 rows can be imported in a batch
  • New ledgers and stock items detection and creation
  • Multiple Inventory with multiple ledgers allocation
  • Automated VAT Classification for existing ledgers.
  • Cost Centers Allocation
  • Service Tax and TDS Allocation (Add-on)
  • And much more…