Excel Utility for Excise Invoices
The Excel utility is developed to prepare excise invoices as per the provisions of the excise rule. You can prepare an invoice, edit it if needed, and print the invoice.
Updating Company Master Data
Update the company master data in the Home sheet. This information will be printed on the invoice. You can also update the invoice number prefix, suffix, and starting number. The invoice number will be updated each time you create one.
Invoice Preparation Options
Options are available on the Home sheet to prepare an invoice, edit an invoice, print an invoice, and update the customer master.
Creating Customer Code
First, the customer code needs to be created with customer details. The customer code will be displayed automatically.
Preparing and Updating Invoice Details
In the prepare invoice screen, you can select the customer code and update all other invoice details. The date and time of the invoice will be updated automatically, and you can change these details.
Saving and Printing the Invoice
When you click save, the invoice will be generated. You can print the invoice by clicking the print button on the Home sheet and selecting the invoice number from the dropdown list.
Adding Company Logo and Saving Invoice Details
In the invoice print screen, the company's logo can be added using the insert picture option. The details of all invoices created will be saved in the utility. Details of up to 5 items can be included in the invoice.
The Excel utility is developed to prepare excise invoices as per the provisions of the excise rule. You can prepare an invoice, edit it if needed, and print the invoice.
Updating Company Master Data
Update the company master data in the Home sheet. This information will be printed on the invoice. You can also update the invoice number prefix, suffix, and starting number. The invoice number will be updated each time you create one.
Invoice Preparation Options
Options are available on the Home sheet to prepare an invoice, edit an invoice, print an invoice, and update the customer master.
Creating Customer Code
First, the customer code needs to be created with customer details. The customer code will be displayed automatically.
Preparing and Updating Invoice Details
In the prepare invoice screen, you can select the customer code and update all other invoice details. The date and time of the invoice will be updated automatically, and you can change these details.
Saving and Printing the Invoice
When you click save, the invoice will be generated. You can print the invoice by clicking the print button on the Home sheet and selecting the invoice number from the dropdown list.
Adding Company Logo and Saving Invoice Details
In the invoice print screen, the company's logo can be added using the insert picture option. The details of all invoices created will be saved in the utility. Details of up to 5 items can be included in the invoice.
1 Attachment(s) [Login To View]