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.
This blank invoice template adopted Chinese auspicious clouds borders to beautify the bill form. The borders does not show when you are creating or editing an invoice, but it is printable with the billing form, and will also be included in the PDF blank service invoice generated with UIS.
On the bottom of the form, besides the usual "Subtotal", "Tax" and "Total" fields, it also adds space for "Cashier's Signature" (this is for printing purpose only - not a field saved to database), and "Guest's Signature", with a declaration like "I agree that my liability for this bill is not waived and agree to be held personally liable in the event that the indicated person, company or association fails to pay for any part or the full amount of the these charges".
We also narrow down the form. To do this, we moved out the "Ship Date" and "Ship Via" fields (i.e. the "oknShipDate" and the "oknShipVia" cells and their labels), which are likely not useful since it is a service invoice template.
For Excel gurus who like to know the details on how to create this general purpose sales invoicing sample from the default sales invoicing design: unprotect the Invoice worksheet, move out product#, quantity and unit price columns, and then remove the formula from the line total cells and unlock the line total cells.
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.
However the support for custom fields in Invoice Manager for Excel makes overcoming this limitation easy and quick. What you need to do is to add the custom field "Product Category" to the invoice body database table, and then name a column of cells where you want to display the category when creating an invoice - in this sample, we don't want to show product category on printed invoices, so the product category column is defined outside the printable area.
This Excel sheet is created based on c1002 House Rent Receipt Template. Like the original design, it has only one big column. There are no usual columns that are found on many other templates on InvoicingTemplate.com, such as "Quantity", "Unit Price" and "Line total". You will enter the amount to pay into the field titled with "Total amount to be received" on the bottom of the 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.
The logo image placed on the top-right corner of the form is a placeholder image that you should replace with your own logo image. To do this, with Invoice Manager for Excel (namely Uniform Invoice Software) installed all you need to do is to click the "Replace Logo Image" command on the "Customize and Design" group of the "Invoice" ribbon tab. If you don't see the "Invoice" ribbon tab after opening this blank service invoice template, make sure you have Invoice Manager for Excel (namely Uniform Invoice Software) installed.
Both Microsoft Word and Excel support ActiveX controls, and the Image control is one of those useful control, which provides a number of properties for adjust the behavior and effect of the image, for example, back color, back style, border color, border style, picture alignment, picture size mode, picture tiling, placement and special effect etc.
Note, as a service invoice template, it does not included the fields of shipping / delivery address.
However by installing Invoice Manager for Excel (namely Uniform Invoice Software), this simple pure Excel spreadsheet template becomes a powerful invoicing system. For example, it is able to do automatic invoice numbering - i.e. generate sequential and unique invoice numbers (sometimes we call it "InvoiceID"). This generator is based on a backend database, which can be either in Microsoft Access or SQL Server format. There are also handy and easy to use tools that help you manage your customer, invoices and payments data. Unlike those expensive accounting and book keeping software systems, our program is designed with easy to use in mind. With UIS, invoicing is as easy as filling a blank paper form. See blank forms for our billing samples in this topic.