Invoice template in excel

Central Excise Invoice in excel - Excel Utility

The Manufacturer of excisable goods, who charge excise duty has to prepare invoice as per rule 11 of central excise rule 2002. This excel template is prepare to generate the invoice under central excise rule. The invoice can be prepared, saved and printed as per the requirement of central excise rule.

Following are the features of excise invoice utility.

• Update Company Master to print in invoices.
• Prepare invoice with up to 10 line items in an invoice.
• Define Invoice series for invoices.
• Maintain Customer Master.
• Printing of invoices.

Central Excise Invoice in excel

Update Company Master: Company Master is to be updated to print in invoice. This is to be updated one time with all registration numbers and contact details. Same will be printed in the invoice.

Central Excise Invoice in excel

Prepare invoice: Excise invoice is to be prepared by updating the details. In this sheet, the customer bill to and ship to code should be selected. Up to 10 line items can be updated in one invoice. Excise duty rate and sales tax rate will be updated from base rate, this can be modified. After saving the invoice the invoice line will be updated in home sheet and same can be printed as per rule 11. 

Central Excise Invoice in excel

Define Invoice series: Invoice number series with prefix and suffix is to be updated in this sheet. Invoice number will be generated automatically when the new invoice is saved.

Central Excise Invoice in excel

Maintain Customer Master: Customer master with address and registration numbers can be updated for each customers one time. It can be modified. 

Central Excise Invoice in excel

Printing of invoices: After saving a invoice invoice record will be created on home sheet. this invoice can be printed by selecting that invoice row and clicking print option. The invoice will be prepared as per central excise rule 11 with all required details. Same can be exported to PDF format.

Central Excise Invoice in excel

This excel invoice utility can be downloaded  for trial.

Invoice preperation utility in Excel

Preparing invoice, maintaining the record and keeping the track of receivable may be time consuming and difficult task. This invoice template in excel is prepared to make this easy for the service providers. Service providers can prepare invoice and also charge service tax in the invoice. Following are the features of the invoice template in excel: 

·         Prepare invoice with up to 5 line items in an invoice.

·         Define Invoice series.

·         Maintain Client Master.

·         Update the collection details from the customers.

·         Debtor’s statement with aging.

·         Printing of invoices.

invoice template in excel

Prepare invoice: In this invoice template in excel invoice can be created with detailed description up to 5 line items in one invoice. If service tax is not applicable on certain line item in the invoice, you can untick the check box to not to consider for service tax calculation. Job card No. or PO number can be mentioned in reference number field. When the invoice is created, the summary of invoice will appear in Home sheet.

More Details:

invoice format, invoice format in excel, invoice format in word, sample invoice format, invoice formats, invoice format excel, invoice format free, format of invoice, excel invoice format, format invoice,format for invoice, invoice excel format, sample invoice format in excel, invoice in excel format,invoice format word,invoices format, invoice formats in excel,free invoice format in excel,sample of invoice in excel format, free invoice format, sample of invoice format, format invoice excel,samples of invoices 

Billing and debtors management utility for CA's

New latest version of Invoice preperation utility in Excel 

July 31st is the last date for filing the Income tax return, when I requested my CA friend to file my tax return, in turn I received a request from him prepare a worksheet to prepare and maintain his billings. Based on his request I prepared the worksheet and I am sharing the same with you with brief note on how to use this.

This is a simple and free to use utility, you can make necessary changes as per your requirements.

Update the firm Profile which is to be printed on the bill. This is linked to the bill and the information will appear on the bill automatically.

Create customer or client master to whom you want to make the invoice. In this you can create up to 100 customer details. This is one time activity, whenever you have to make the invoice to new customer you can create a record. Customer code will be generated automatically, which can be selected at the time of entering the billing details.

After updating Firm profile and Customer Master, you can prepare the bill. To prepare the bill update the details in in BILLING DETAILS sheet. Customer code can be selected from the drop down list and other information is to updated to prepare the bill. This sheet also includes the collection details, updating the collection details will help in getting correct debtors statement.

To get the print of the bill, go to bill print sheet and select the invoice number to be printed. Based on the invoice number the information will be updated in the bill and invoice will be ready for print.

The collection status are to be updated in the BILLING DETAILS sheet. Based on this information the debtors statement with aging will be generated in the Debtors Aging Statement sheet.

This file is not password protected, you can make necessary changes to the sheet and use this. Request you to give your valuable suggestions.

More details