[ad_1]
accounts are basically lists of sales your business. To create a blank invoice template in Excel is very easy.
1. In a blank Excel document, type “Account” in the caps over the top of the worksheet in column B and row 1 (B1).
2. Click the ‘Enter’ and in field B2, enter your company name, address, phone and fax numbers, email and website link.
3. Tab to cell E1 and type ‘Date’.
4. In cell E2, just below the date field, enter “Invoice no.”
5. In cell A6, type “Bill To ‘. Build the name and address of the customer.
6. Tab to cell E6 and type ‘ship’. Build address the customer wants the item (s) to be shipped.
7. Create Product and pricing. Making ‘Item Number’ in cell A12.
8. In cell B12, type “Description”. Build and identification products enter customer who has made the purchase.
9. In cell C12, type “Unit Price.” Building on the cost of each item.
10. In cell E12, type “Total Line ‘. Calculate and display the total cost of the item (s).
11. If you need to expand the column width, highlight columns A to E. Click ‘Format’, ‘Columns’ and then,’ Auto Fit Selection “.
12. To bold or underline headings, highlight the column heading signal; click ‘Format’, ‘Cells’,’ Font ‘and select’ bold ‘and’ underlined.
13. At the bottom of the invoice in cell A35, type “Notes”.
14. Tab to cell D30 and type “aggregate. Type” Tax “in Row 31 just below the” Total “. Type” Shipping & Handling charges “in line 32. Type” Total “in line 33. Type ‘Total Due “in Row 34. This creates a blank invoice template form.
The next step in the blank invoice template form would perform the final calculations for the necessary additions and deductions.
[ad_2]