Download our amazing looking blank invoice templates and billing samples in Excel format (".xls" or ".xlsx") for free, which enable you to easily create invoices and bills as easy as filling in a paper form. No hard learning curve like dealing with some complex and expensive accounting / bookkeeping systems. All the templates are printable with either Excel or Invoice Manager for Excel (namely Uniform Invoice Software), or you can choose to generate PDF invoices and then send electronically with email.
The blank templates offer a what-you-see-is-what-you-get experience on creating invoices. The layouts mimic paper sheet forms. For example, if you want to fill in customer information, simply click one of the empty cells inside the "Bill To" section, and then start typing (or choose an existing customer by clicking the on-sheet picker button to bring up a list of all customers).
We choose to create the templates in Microsoft Excel spreadsheet format, instead of Word (".doc" or ".docx") format, for the reasons explained here.
The empty cells (fields) that you should fill in are identified by names. This enables you to move the cells (fields) around the form within the printable area without breaking the relationship defined by using Excel formulas. This means that, our blank invoicing forms are customizable by dragging and dropping. See this document for more details.
Here are our templates closely related to Blank Invoice Templates - 20 Results Found.
The blank bill template includes a logo image on the top form. To replace with your own image, click the "Replace Logo Image" button on the ribbon tab.
This blank service invoice template is a redesigned version of c3008 Blank Service Invoicing Template. This customized version keeps most of the fields found in the original design, but have a complete new look and feel due the addition of the image borders.
The template has two taxes set on the bottom of the form, GST and PST. You can modify the tax names and rates easily by simply type in what meets your suitation once the spreadsheet is unprotected. If you need only one tax or need no tax, install UIS, and modify the taxing rules by several simple mouse clicks.
When you click the "Clear & New" button on the "Invoice" worksheet, the entire "Invoice" was cleared, making it a blank invoice form. This makes it ready for you to create the Next invoice. Note that the "Invoice#" cell is not filled at this time. An invoice# is generated automatically when you click "Save To DB". See automatic numbering for more discussions and samples on this topic.
To express the theme of United States, a watermark image if added to the background of the sheet. The watermark is a PNG image with the opacity set to 10%. This makes sure the foreground text is visible and clear. Since you'll be creating invoices and bills, it is important to make sure the text is readable and never causing dispute.
This Sales Invoice Form with Discount Amount invoice template in Excel spreadsheet format, and as the name implies it is a sales invoice template that has shipping fields inside the printable area. To do this, we simply move the shipping fields back into the printable area, including Shipping Name, Shipping Address, Shipping City State Zip, Shipping Country and Shipping Contact. The controls, such as the text labels of the shipping fields, the "select a shipping address" icon button, the "Same As Bill To" button should also be move into the printable area. Moving an ActiveX control on an Excel spreadsheet is easy if you know the trick - before you can move a control, first switch to design mode. In design mode, even if you have Invoice Manager for Excel installed, it won't response to your click event. If you browse our invoice template gallery, you may see many of the invoice template samples are created by moving the fields in or out of the print area.
However before using the commercial invoice template to create your first commercial invoice, there are some one-time job you should do, that is to enter your own company information and replace the default logo image. Before you can do this type of customization, you have to firstly unprotect the invoice form, and then switch to design mode.
This template uses the same database structure and field definition as the original version, but changes the meaning of the fields. The 5 prices field in the original database definition are decimal (15,6) which is enough for storing a percentage value. In this implementation offered by InvoicingTemplate.com, the first price custom field (Discount Price A) is used as the base price, and the other 4 prices (from Discount Price B to Discount Price E) are used to store discount percentage values. For example, in the sample database attached with this template, product "ABC-01" has 5 custom fields defined for prices, named from "Discount Price A" to "Discount Price E", and the values are 19.00, 0.11, 0.21, 0.31 and 0.41. If the discount level of a customer is 1 and he purchases the product "AB-01", the base price (19.00) will be applied; If the customer's discount level is 3, the discount will be 0.21 (i.e. 21%), the applied price will be 19 * (1-0.21) = 15.01. You can find more examples at standard invoice templates and blank invoice templates.
With this customization applied, the "invoice form with 5 price levels (sales)" invoice template here on InvoicingTemplate.com allows you to define 5 prices for each product. When creating an invoice, Invoice Manager for Excel shows both base and discounted price per item on invoice form whenever you choose a product. For each customer, you can assign it a discount level, ranging from 1 to 5. When you pick up a customer, Invoice Manager for Excel will apply the correct price based on the discount level of the customer.
If you use the freeware edition of this invoice template, you may find there is no much difference between this invoice template and the default sales invoice template shipped with Invoice Manager for Excel. The only difference appears outside the printable area on the center of the form, where you can find a Product Category column near the invoice body. Visit the gallries at Simple Invoice Template and Blank Invoice Templates for more information.
This is a blank service invoice template features two columns on the detail section. Both are editable. The means that, unlike many other templates here on InvoicingTemplate.com, the "line total" cells in this template have no formulas and therefore are not locked. Invoice Manager for Excel (namely Uniform Invoice Software) allows you to edit the cells manually on creating invoices.
This form design does not distinguish materials and labor. If you need such a design where materials and labor are put into different sections on the sheet, visit our parts and labor invoice sample. For service-only formats visit our category page at service invoices. Our templates are itemized, which allow you to fill items line by line; but there are also non-itemized designs like c1001 Construction Proposal Template and c1005 Construction Contract Template with Watermark of Urban Buildings.
This template has two columns - "Description" and "Line Total", both are manually editable when the sheet is protected. A "Taxable" checkbox is also provided for each of the invoicing item, which allows you to control separately whether each item is taxable. If all your items are taxable (or not taxable), you may not need the "Taxable" options. If this is your situation, you can easily remove the "Taxable" options and then modify the tax formula to ignore this option.