DOWNLOAD GST invoice preparation 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.
Define Invoice series: Invoice series with prefix and suffix can be defined in the utility. Invoice number will be generated automatically with this information.
Maintain Client Master: Client / Customer code can be created and edited with all relevant details. When you select a client code while preparing the invoice, it will take all other information from the client master.
Update the collection details from the customers: Collection from customer can be updated with the amount, date and narration column. To update the collection, select a particular invoice and click on update collection button. Up to 5 records can be updated in collection details.
Debtors statement with aging: Based on the invoices prepared and collection details updated in the utility, debtors statement is automatically generated with aging statement.
Printing of invoices: you can print a professional invoice with all relevant information. Select the invoice and click on print invoice to see the printable invoice and you can also create a pdf invoice in this utility.
The excel invoice template can be downloaded from the below link. Enable the macros and click on generate system no. and submit this number while making the payment to get the activation code.
Terms and Conditions:
By using this utility you agree to be bound by this terms and conditions.
You further agree that your employees / any person you authorise to use the excel utility will also be bound by this terms and conditions.
This excel utility is prepared for Preparation of Invoice.
All due care has been taken while preparing the utility to meet the user requirement. But we will not be liable in any manner whatsoever for any loss or damage caused by using this excel utility.
This excel software utility is to be used only by the approved user of this utility and should not be shared or distributed to other people.
Also the user is not authorised to upload or share this in the online forums or in the internet.