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.
From India, Bangalore
Acknowledge(0)
Amend(0)
6The 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.
From India, Bangalore
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Advanced Excel 2003.pdf
Invoice Format.doc
Competancy--exc el---mts___smts _289.xls