Sales Invoice Template

Vertex42's sales invoice template was designed with the small business owner in mind. It is a simple, professional, free solution for invoicing your customers or clients. Unlike our service invoice, the sales invoice includes shipping information and lets you specify the item number, quantity, and unit price. The calculations are done for you, and you can specify the tax rate, shipping and handling, or other fees.

Advertisement

Our sales invoice template is designed to go hand-in-hand with our purchase order template and packing slip template. They each use a similar design and layout.

categories:Invoices Business

Sales Invoice Template

for Excel, OpenOffice, and Google Sheets

Sales Invoice

Screenshots: 1 2

Download

For: Excel 2007 or later & Excel for iPad

Other Versions

License: Private Use (not for distribution or resale)

"No installation, no macros - just a simple spreadsheet" - by Jon Wittwer

Advertisement

Description

Vertex42's Sales Invoice Template consists of a single Excel workbook with multiple worksheet tabs, giving you the option of including a remittance slip or selecting items from a pre-defined price list.

Basic Sales Invoice: The primary invoice (Invoice 1a & 1b) is shown in the screenshot on the left and consists of the core set of features mentioned above.

Sales Invoice with Remittance: The second design (Invoice 2a & 2b) is the same as the first except for the addition of the remittance slip at the bottom.

Price List Option: If you want the ability to select products from a drop down list, you can use the "Sales Invoice with Price List" worksheets (Invoice 1b and Invoice 2b).

First, you define the list of products with their item #'s and unit prices in the PriceList worksheet. Then, when you select the items from the drop-down list, the Item # and Unit Price will be included automatically.

Update 12/27/2014: The newest .xlsx version now includes a column for indicating whether or not each item should be taxed.

Using the Sales Invoice Templates

Any value within [brackets] is meant to be replaced with your company or customer's information. Customize the spreadsheet by first entering your company name and address. Then save your customized spreadsheet as a template file so that you have ready-access to a pre-populated invoice when you need it. Below are descriptions of some fields used in sales invoices:

Sending the Invoice to a Customer:

The recommended way to send this invoice to a customer (other than by printing and mailing it) is to first convert the invoice worksheet to a PDF file and then email the PDF file. PDF conversion software often allows you to 'Print' to a PDF by selecting the PDF driver as if it were a separate printer (it would be listed along with your other printers in the Print window).

See our Invoicing article, which explains a method for managing your invoices.

Adding More Rows to the Invoice Template

If you need to insert more rows for additional items, then you need to insert the rows above the last row in the table so that the subtotal formula will stretch to include the new row. If you insert a row below the last item in the list, then the subtotal won't be updated correctly (you'd need to manually modify the formula).

After inserting the new row, you need to copy and paste from the row above so that the formatting, including the borders, ends up the same as the rest of the list.

Other Questions

For general information about sales invoices, see Invoice at wikipedia.com.

More Invoice Templates

Other Related Templates by Vertex42