Assuming you have downloaded and installed Uniform Invoice Software:
Prefer to have a look at other samples? Try our Search tool!
The printed version.
Basic Sales Invoice Template (Light Blue) (c3001)
c3001 now includes the customized invoice template for the latest version of Uniform Invoice Software. This is what you will see when you open basicsalesinvoicetemplate-uis.xlsx.
Basic Sales Invoice Template (Light Blue) - UIS edition
You are safe to download the resources. We've added our digital signatures to the files.
Download this if you have already installed UIS, but are looking for additional customized templates.
Download this if you want this design to be set as the default template by the installer program.
Basic Sales Invoice Template (Light Blue) is a slightly modified version of the standard Excel sales template shipped with Uniform Invoice Software installer program. The main features include a "Bill To" section, a "Shipping To" section, 3 columns on invoice body, no sales tax.
The ready-to-use Excel invoicing template can be downloaded from the "download" page. If you are interested in the details on how to create this template design from the default template, read on. To easily change the tax options, install Uniform Invoice Software, click the Settings button and then go to the Taxes tab, where you can choose taxing type (no tax, one tax and two taxes, tax names, tax rates, as well as other taxing options).
This basic sales invoicing 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 bill formats, the sales invoice includes shipping information.
The difference between sales and service here on InvoicingTemplate.com is simple - if a template contains the "Ship To" section on the printable section, we call it sales invoice. If it does not contain the "Ship To" section, it is categorized as service invoice. If the form has a very special design in its layout, such as Tax bill for Printing Shop, which moves the "Ship To" section (titled with "Delivery To") to the body of the spreadsheet form, we add the template to both the sales and service category. Basic Sales Invoice Template (Light Blue) adheres to this rule too.
In order to create this basic sales invoice design (light blue) from the template, we moved the item#, unit price and quantity column out of the printable area, removed the formulas from the line total cells, and set the tax type to "no tax" with the help of Uniform Invoice Software.
Before doing these types of customizations on the default sales invoice layout, you'll have to unprotect the spreadsheet and put the template into design mode.
The protection of the "Invoice" worksheet in Basic Sales Invoice Template (Light Blue) prevents accidental modifications to layouts and formulas. If you have Uniform Invoice Software installed, it could even display a warning message when you close a template without protecting the worksheet. However for the purpose of this sample, we should firstly unprotect the worksheet in Basic Sales Invoice Template (Light Blue).
In design mode, Microsoft Excel allows you to move, add, or delete controls or images inside Basic Sales Invoice Template (Light Blue). Note that if you have our invoicing program installed, and you are running Excel 2007, Excel 2010 and Excel 2013, it already provides a Design Mode button on the ribbon tab, so that you don't have to switch to design mode manually. Our invoicing software is able to turn a simple spreadsheet into a powerful invoicing system, with the ability to manage customers, products, bills and payments, it also includes various tools that could help you configure the layout of your form, such as the number of taxes and tax names and rates. If you don't have our invoicing program installed, here are how you can switch to design mode manually.
TIP: If the Developer tab is not available in Excel 2007, do the following to display it: a) Click Microsoft Office Button, and then click Excel Options; b) In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.
Or in Excel 2010 and Excel 2013 to display the Developer tab: a) Click File > Options > Customize Ribbon; b) In the area on the right, ensure that the box next to Developer is checked; c) When you click OK, the Developer tab will appear in the ribbon.
Once you have finished your design work for Basic Sales Invoice Template (Light Blue), click the Design Mode button again to exit design mode.
One the Excel spreadsheet is unprotected and put into design mode, you can move the Unit Price, Quantity and Item# columns out of the printable area.
Moving a cell or a group of cells is easy in Excel. First, you click to select the cell or drag your mouse to select all the cells you want to move. And then, drag the border of the selected area to move it to the new location where you want to place the cell or cells. The moving content will overwrite the content in the target location, so make sure the target range is empty (not used) in Basic Sales Invoice Template (Light Blue) before doing the movement. And, if the target location contains merged cells, sometimes the movement fails. So it is also helpful to make sure the target location does not contain merged cell. If the target location Basic Sales Invoice Template (Light Blue) is overlapping the original range and the original range contains merged cells, the movement could also fail because you cannot change part of merged cell - if this happens, you need to first move the cells to a temporal location in Basic Sales Invoice Template (Light Blue) that are empty (i.e. not used), unmerge cells, and then move the cells from the temporal location to the desired location. If you need to unmerge a cell, first select it and then click the "Merge and Center" command on the Format toolbar in Excel 2003; or click the "Merge and Center" command on the Home ribbon tab in Excel 2007, 2010 and Excel 2013.
To adjust the width of one column for Basic Sales Invoice Template (Light Blue), drag the boundary on the right side of the column heading until the column is the width that you want. To change the width of multiple columns for Basic Sales Invoice Template (Light Blue), select the columns that you want to change, and then drag a boundary to the right of a selected column heading. To change the width of columns to fit the contents for Basic Sales Invoice Template (Light Blue), select the column or columns that you want to change, and then double-click the boundary to the right of a selected column heading.
During the design of this invoicing spreadsheet, the "Merge and Center" command is also useful to set up the item description column.
Merge and Center works by merging the selected cells into one and then centering the data in the new combined cell. While design a template layout like Basic Sales Invoice Template (Light Blue), Merge and Center could be a handy tool if used properly. One thing to note, however, since Uniform Invoice Software (UIS) relies on cell names (or field names) to create the relationship between the Excel form cells and the database fields, you should make sure the cell that contains a field name is the first one in the group of cells that are to be merged. This way, UIS will work with the merged cell by reading from or writing to the named cell.
Unlick the default sales template shipping with Uniform Invoice Software, this template has no tax set.
Basic Sales Invoice Template (Light Blue), like the default template, has two tax items on the bottom of the worksheet, which are applied to all the items, and a column of Taxable checkboxes to the left of the form body, which are corresponding to each invoicing item. You can change the tax names and rates on the bottom of the form by typing in whatever meet your requirements. These are the supported features implemented in both the freeware version and the Uniform Invoice Software version.
That's it! You've now seen the key steps involved in design this Template. Download this template for free and see if it meets your billing requirements!
Like other form designs here on InvoicingTemplate.com, Basic Sales Invoice Design (Light Blue) is free (offered to you at a price of 0.00USD). It works on Windows XP and all newer versions of Windows, and Excel 2007, 2010, 2013 or 2016.
|Name||Basic Sales Invoice Template (Light Blue)|
|Category||Sales Invoice Template|
|Release Date||Tuesday, April 22, 2014|
|Format (XLS or XLSX)||.xlsx|
|Excel Version||Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016|
|Line Height (Points)||19.50|
|Printable with Papaer Size / Orientation||A4 (210 mm x 297 mm) - Portrait|
|Default Margins (Points)|
August 24, 2016
Almost all invoice templates here on InvoicingTemplate.com include a logo image, which in many case is implemented as an ActiveX control. This blank service invoice template sample shows how to use the "Picture" illustration to add the invoice logo.
While it's easy enough to customize the tax options with the help of Uniform Invoice Software form design tools, "Basic Blank Service Invoice Format (One-tax)" has this already set based on " c2012 Basic Blank Service Format (No-tax)", so that you can use directly without installing Uniform Invoice Software.
A basic and blank service invoice format could be served for many different types of businesses. While we've already published two layouts in this topic, "c2012 Basic Blank Service Format (No-tax)" and "c2013 Basic Blank Service Invoice Format (One-tax)", this format "Basic Blank Service Invoice Format (Two-taxes)" has two taxes set by default.
Basic Blank Service Billing Format (No-tax, Long Description) is a general purpose, service-oriented invoicing template that includes two editable columns (Description, Amount) and up to 5 items on the invoice detail section. Each row allows you to enter multiple lines of text.
This service invoice template offers a basic and blank invoicing form that is able to do auto calculation of one-tax. It has two editable columns. The invoice detail section allows to fill up to 5 items.
This basic sales invoicing sample has an abstract blue-violet gradient painting in the background that looks like brushed with a liquid. This design sample also has the stripes background on the detail section removed.
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.
With this blank service invoice template we applied green gradient effects to various titles and headings on the invoice form, resulting in a pastel and sophisticated design. The invoice layout support Excel themes so you can change the colors easily.
Basic Blank Service Format (No-tax), or Basic Blank Service Layout (No-tax), provides a simple yet professional and beautiful invoicing form for general service businesses. It contains no fields for specific service business, has two editable columns, no tax.