skip to Main Content
+91-9551052100 info@tallymaster.in

Basics for Excel file type and Formats

  1. Check the excel file as per the prescribed Excel file types, such as sheet name and file type.
  2. Excel Sheet name, should be as Voucher Type or Form Name on software menu.
    1. Example, for sales vouchers, sheet name should be “Sales”
    2. For purchase vouchers, sheet name should be “Purchase”
    3. For Debit Note vouchers, sheet name should be “DebitNote”
  3. Check the Mandatory headers are in Green and Blue color in sample excel template, and which are not case sensitive.
  4. Header, VoucherNumber, shall be not be used, if voucher numbers are not followed in excel and vouchers are single line and unique vouchers.
  5. Header, VoucherTypeName, shall be used, where multiple voucher type entries are imported using single excel file to Tally.

Invoice Template Models

There are 5 variety of excel formats are available, which is common for the below voucher types.

  • Outward Type Vouchers, such as Sales, Credit Note, Delivery Note, Rejection In, Sales Order
  • Inward Type Vouchers, such as Purchase, Debit Note, Receipt Note, Rejection Out, Purchase Order

Variety of Templates

  1. Simple Columnar – Voucher or Invoice Mode (without Inventory)
  2. Invoice Columnar (with Inventory)
  3. Invoice Columnar with Single Ledger and auto multi column – without Inventory
  4. GST Columnar with auto multi column – without Inventory
  5. GST Columnar with auto multi column – with Inventory

Additional Template Features

1. Simple Columnar – Voucher or Invoice Mode (without Inventory)

Simple Excel files can be used for simple columnar, without inventory in voucher mode or invoice mode for all invoices.

2. Invoice Columnar (with Inventory)

3. Invoice Columnar with Single Ledger and auto multi column – without Inventory

4. GST Columnar with auto multi column – without Inventory

  • This is a standard type of format where GST details are filled in defined formats, which can be converted to columnar with split tax ledger and sales/purchase ledger by tax rate.

5. GST Columnar with auto multi-column – with Inventory

  • In addition to using the above GST columnar, stock items are used in this template.

Back To Top