Download our printable billing templates and invoice makers for free. Create invoices and bills by filling in blank forms, print out with single click of mouse.
If you use the UIS edition, there are advanced options you can use to improve the printing experience, in addition to all those provided by Excel.
It is fair to say that Microsoft Excel has extensive options for controlling the printed result of a spreadsheet - most of them could be found on the Page Setup dialog box, but with a UIS-enabled template, you have more that are applied to only invoicing forms - i.e. they will not affect your general worksheets.
All templates here are printable. The following are the top 10 we picked up for you to test how we control invoice printing experience in various ways.
Although we at InvoicingTemplate.com names this invoice template as a service invoice template, it actually includes a shipping information - but unlike most other templates designed by us at InvoicingSoft.com, the shipping information section is moved to the invoice body section and titled with "Delivery to". This is not a usual design but we hope this gives you an inspiration on how the invoice template can be customized.
Packing list and invoice are closely related business documents, yet there are significant differences between the two, in both the recipients of the document, the contents each document show include. A packing list is designed to aid recipients of the shipment in confirming that all items that were supposed to be included in the shipment have actually arrived. While slip designs vary somewhat, most will include a description of each item included, as well as the quantity of each item shipped. On the other hand, an invoice goes to the person responsible for paying the bill. The invoice is the bill for purchasing from your company and the notice to the customer to pay you.
The following tutorial takes c2005 print shop invoice template as a sample, and add non-empty default value to the first "Description".
With Uniform Invoice Software installed, there are several ways you can pick items on creating invoices.
The second way to quickly fill in items into the invoice or bill is that you can enter the product# (this could be your SKU# or barcode retrieved with a scanner) into the "Product ID" field, which is put outside the printable form.
This maintenance bill format in Excel is a variant of c4014 Five Price Percentage Levels (Sales). For each invoiced item (product), you can set 5 prices. On creating a bill or receipt, you pick items by clicking the "select product / item" button, all prices are retrieved from database and shown on the Excel sheet (but outside the printable area). You can then enter the "discount level" value, which is highlighted with bright-yellow background color, and is also designed to not show on the printable form. More downloadable free samples could be found at blank invoice samples. You choose the discount level according to client type (whether it is a VIP etc.), an Excel formula like the following will pick correct prices and show it on the printable section.
This itemized invoicing sample is based on c5008 Form with Product Category. In this customized spreadsheet we keep the "Category" column outside of the printable area (see printable invoice templates for more information), which means the "category" column is not included in the invoices you print or send to clients using email for payment.
Many templates here on InvoicingTemplate.com put the "Summary" section on the bottom of the spreadsheet. But this is not necessarily to be that. With c5003 "One Tax Column, Summary on Top", we demonstrates how to move the "Summary" to top of the form.
If you are in the constructionc or masonry industry, your services may not limited to building houses. You may also help to beautify client's yard and landscape, etc. This billing form is suitable for all these situations.
To make it suitable for your company letterhead paper, the invoicing template includes an empty line on the top of form. Click the "Design Mode" button on the "Invoice" ribbon tab, adjust the height of row $3 (marked with the text "Adjust the height of this row to make it suitable for your company letterhead paper"), click the "Print" button to test the print result. You may have to print several times to make it perfect for your paper design. To see another sample here on printing with letterhead papers, see Simple Invoice Sample - Printing on Letterhead Paper. To see more simple and lightweight invoice designs, visit simple invoice templates here on InvoicingTemplate.com.
The itemized section allows you to detail the materials used and service performed. The line totals are calculated using Excel formulas. By default these columns are titled with "Quantity" and "Unit Price", but if you are working on an hourly rate basis (not project-based), such as face painting for salon and parlor people, you can easily change the titles to be "Hours" and "Hourly Rate", to do this, simply put the template into design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab (If you don't see the "Invoice" ribbon tab, make sure you have Uniform Invoice Software installed), and then type in your new column headings to replace the existing ones. You can also try our invoice templates for hours and rates.
The value of the "Quantity" is calculated using an Excel formula like this, where "_?" is the line number:
On the bottom of the form, you'll find the usual "Subtotal", "Discount" and "Total" fields. There is also the "Last Balance" field and the "Total Due" cell. The "Last Balance" cell has its field name set to "oknAccountBalance", which is filled whenever you fill in the quotation form / estimation form with an existing client by using the on-sheet picker button, you by enter the client# into the "Customer#" cell (also located outside of the printable quotation form, at $U$2). See Invoice with Previous Balance (Sales) and Invoice with Previous Balance (Service) for more information on how to show previous balance on the form. The "Total Due" is the sum of the previous account balance and the total of the current quotation.
The standard invoice template is a sales invoice template that is designed to be flexible and basic. The design contains only one logo image placeholder, some solid fill effects on the text titles. Adding decorations to this existing template could change the look and feel of the template quickly. Want your invoices differ from others like your business? Microsoft Excel provides powerful and easy to use tools for you to make your very own invoice formats.
Now when you click Print to print an invoice, Uniform Invoice Software will print two documents, one invoice and one packing list. However the "Extract" feature will encounter problems if you choose the exact an Excel-format worksheet - but the PDF formatted invoice and packing list work just fine. Feel free to take a look of our pdf invoice template gallery too.
Most template available here on InvoicingTemplate.com using "Portrait" paper orientation / print orientation. In the real business world, there is no one template fits all. Different businesses have very different requirements regarding their invoicing forms. Some businesses need relatively long content on each field, such as address, description etc., and they need less lines on the invoice detail section. This tutorial, based on the result of c4051 Simple Invoice Template - Discount Amount Field, demonstrates how to change the orientation option of the invoicing form to "Landscape".