Simple Invoice Template in Excel – Profession Design

This free simple invoice was designed to make it an easy invoice to use and to customize with Excel. It allows you to enter pretty much anything you want in the description part of the invoice. This simple invoice is also the first template to use our new Bold and Light themes. You can change the color theme in a matter of seconds by going to Page Layout > Themes. For other options, check out our original free invoice template.

With this free simple invoice template, you’ll have a very simple and organized document in which you can create an invoice for almost anything and send it to your customer upon purchasing.

Simple Invoice Template

Use for Excel, OpenOffice, and Google Sheets

DOWNLOAD

Description:

We designed our free invoice template to be compatible with nearly every spreadsheet program. It works with Google Spreadsheets, OpenOffice, and all versions of Excel. The Service Invoice form for Google Sheets, based on our original Excel invoice, is one of the most popular templates in the entire Google Templates gallery. This Simple Invoice is so-named because it is our most easy invoice to use, and doesn’t include any complicated features. It uses only two formulas: the calculation of the Subtotal and the Tax. If you don’t want to collect tax from the customer, then just leave the tax rate as 0%. This spreadsheet can be used as a very simple small business invoice system. You can bill for specific items or by the hour. The “Taxed” column lets you easily mark whether sales tax should be applied to a line item. This means that you can include charges for parts and other physical goods. (See you’re local and state laws to check on rules for taxation of labor and goods sold.)

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.

S&H and Discounts: We’ve added a place to include a shipping and handling fee as well as a discount. Remember to enter the discount as a negative number. The tax is calculated from the subtotal of amounts listed in the invoice table, not the S&H or Discount.

Charging 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.

Customizing 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. Then, save a backup copy of the customized invoice to use whenever you need to create a new invoice.

Sending the Invoice: To send the invoice to your customer, simply print or convert it to a PDF and then email the PDF.

We will be happy to hear your thoughts

Leave a reply