Invoice Template / January 21, 2019 / Corrine Carney.
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 .
6. Payment Terms Clear agreement on payment terms should be written down on the invoice template. This helps prevent misunderstanding between the client and supplier. It also helps establish terms of payment in a clear concise manner. In order to create your own invoice template you can use a variety of existing software available today. Most widely used are Microsoft s Word and Excel which provides a basic customizable format for your invoice templates. When choosing to send the invoice through email you can change the file into a PDF format so that it can be sent over to the client.
Note that an invoice is a commercial document that a seller issues to the buyer. The invoice indicates what products or services are being sold and the prices of these products or services. Sellers have the obligation to provide invoices to customers. All together the invoice provides authorities data on the earnings of the seller or store owner or entrepreneur. These documents are also important for record-keeping and assessment purposes. For the buyer the invoice is the proof of purchase and ownership. Since it is an essential document an invoice should bear the right information about the products prices name of company/seller and name of buyer.
This provides for easy tracking as the assigned series is exclusive only to you and your client. 3. Dates There are only two dates that are important in an invoice template and these are the ones that reflect on the document. These are the date the invoice is raised and the date by which the payment is due. 4. Client Details Client details should include the client s name address and contact number. 5. Fees This is where the gross amount of the invoice made is reflected. Along with it the description of the item/s or type of service provided. Also included is the VAT number if available and the total amount due.
To help you keep track documents in the form of invoices or receipts are necessary. Here are the important things you need to include in you invoice template: 1. Company details This is the name of your company and includes the address contact number and in some instances the proprietor s name can also be placed. More importantly the company s VAT number should be placed. 2. Invoice number Assigning invoice numbers helps you keep track of the specific items shipped or purchased from which client. This unique number can actually be a combination of letters and numbers.