Excel file type and Formats

• Check the Excel File Format for Voucher, such as file type, sheet name and etc..

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

• Invoice Mode and Voucher Mode
• Open GST Value for GST Ledgers (Only for voucher mode)
• Grouped Total and Line wise Total for GST Columnar
• Party Supplementary Details
• Additional Voucher Details
• Advanced details in Stock Item allocations

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.