Invoice Template / January 18, 2019 / Mabel Cooke
Easily create forms for quotes work orders delivery orders and receipts of all types - all at with a click on the mouse. Having an invoice template plays an important role. Specifically you need to choose one that can cover your needs and allow you to get your work done effectively. It is an important tool you can use in many cases and you should choose the one that has the features you need. Most people use an invoice template for excel. The simple formatting makes it easy to use it and if you know how to use excel you will not face any problem as the environment is the same. For example replacing defaults lining format text alignment or moving and merging cells follows the exact same procedure. However if you are a new user there are some simple things you have to check before you start work. First of all you should know that the worksheet is protected.
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 .
The task of invoicing can be daunting but it is simplified by using a template appropriate for your industry. So how do you find the right template for your business and save money at the same time? First you should identify what your template needs. At a minimum your invoice should include certain elements such as your company s name and address customer s contact information description of services provided and the agreed cost for the services you provide. More advanced invoices may include your company s logo terms of payment and itemization of goods and services provided.