Invoice Template / January 12, 2019 / Corrine Carney
You can personalize the invoice template by adding your business details right at the top like your business name and address contact details such as the cell phone numbers fax numbers and even the URL of your business website. Every business has its own needs. You should understand the needs of your business well and the invoice you create should serve the purpose and fulfill all your business needs. It does not matter which kind of business you are in throughout time you will need to create an invoice for goods or services. To keep track of your customers you will need a proper invoice system. Many companies will also require you to invoice them if they have hired you.
As said the benefits of using one will not only save you a considerable amount of time but also portray you as more professional in terms of overall presentation. Invoices are basically the records of your sales transactions. Creating a blank invoice template on excel is very easy. 1. In a blank Excel document type Invoice in caps across the top of the worksheet in Column B and Row 1 (B1). 2. Click Enter and in cell B2 type your company name mailing address telephone and fax numbers email address and website link. 3. Tab to cell E1 and type Date . 4. In cell E2 just below the date field type the Invoice No . 5. In cell A6 type Bill To .
Populate the customer s name and mailing address. 6. Tab to cell E6 and type Ship To . Populate the address to which the customer wants the item(s) to be shipped. 7. Create Product and Pricing Fields. Type Item Number in cell A12. 8. In cell B12 type Description . Populate the identification number and product type the customer who has made the purchase. 9. In cell C12 type Unit Price . Populate the cost of each item. 10. In cell E12 type Line Total . Calculate and show the total cost of the item(s). 11. If you require to broaden the column width highlight columns A through E. Click Format Columns and then Auto Fit Selection .