Sending the Invoice: To send the invoice to your customer, simply print or convert it to a PDF and then email the PDF. Then, save a backup copy of the customized invoice to use whenever you need to create a new invoice. The tax is calculated from the subtotal of amounts listed in the invoice table, not the S&H or Discount.Ĭharging by the Hour: If you want to charge based on an hourly rate, you can enter a description such as 'Labor: 5 hours at $75/hour' and then in the Amount column you can enter the formula =5*75 or you can use a calculator and just enter the number 375.Ĭustomizing the Simple Invoice: Like any template, the idea is to customize the Simple Invoice by editing the company name (and perhaps inserting a logo), mailing address, and the footer info. Calculate subtotals, totals and tax easily using your smart Excel invoice template. With a template, you can easily customize and format your service invoice uniquely. Remember to enter the discount as a negative number. The fastest and easiest way of preparing a service invoice is by using a template.
S&H and Discounts: We've added a place to include a shipping and handling fee as well as a discount. Two Themes in One: The spreadsheet includes the Bold theme shown in the screenshot above, and also the Light theme shown in the preview to the right.
