Sales Invoice Template for Excel

How to use this spreadsheet?

Customizing template to your business needs.

Update all necessary fields with your company information.

1. Change all values in the square brackets [...] - values applicable to your company need to be replaced with your company information.

2. Company Logo - insert your company logo by going to your menu Insert > Picture > From File... (only available in unlocked version).

3. Company Name - Change it to the name of your company, this will automatically change "Make all cheques payable to [Your Company Name]" field below.

4. Salesperson - Change it to the name of the person responsible (Eg. Sales Manager), this will also change the name of the contact person.

5. Tax Rate - Change the tax rate to the required current rate.

6. Bank Account - Change your company business account number to the account that you want to receive your electronic payments.

7. Cheque Payments - this field is automated and will therefore change automatically once you change the name of the company at the top of the invoice. If the cheque needs to be payable to any other than your company name, you can manually override the formula in this field, but only in unlocked version.

8. Contact Information - Change your contact information (eg. Phone, Fax, e-mail, postal address).

9. Saving Template - Save the updated document as .xlt file in preferred folder on your computer (Eg. My Documents > Invoices).

Preparing the Invoice for your customers.

Update all necessary fields with your customer information.

Date - the date will change to today's date automatically each time you open your document, but you can manually override the formula in this field to show the date of issue.

Invoice Number - assign the number to your invoice that must be unique for each new invoice, you can start by using 00001 for the first customer. You must save the invoice with the same name as the invoice number (eg. if invoice # is 00001 than the saved file name must be 00001.xls), this will help you to keep track of your invoices

Customer ID - This cell is for unique customer number which will help to identify the customer and may contain full information about your customer (Eg. address, contact phone and fax number, e-mail).

Purchase Order Number - If your company uses the purchase orders for the customers to order from you, than you may want to specify the purchase order number on the invoice.

Bill To - Your customers name and address were the goods will be delivered and will also be used to issue the invoice.

Ship To - Name and address of alternative delivery location if different from Bill To address

Shipping Method - Here you can specify your courier service (Eg. DHL, UPS or other.

Shipping Terms - Here you can explain the terms of the shipping, it can be a discounted shipment term for goods over certain amount or similar.

Payment Terms and Due Date - here you should explain to your customer the terms of the payment (eg. immediate payment or within 30 days of issue) and the date when the payment is due.

Description, Quantity and Unit Price - Provide a short description of the Product (Eg. Printing Paper), assign unit price (per one unit) and quantity ordered.

Printing and sending your Invoice.

You can simply print your invoice on your standard printer on A4 size paper and send it by standard mail service, but the much quicker way is to convert it to a PDF and e-mail it to your customers.