Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Simple 2-Column Sales Invoice Sample. Double-click the downloaded file to extract all files.
  2. Open the template "simple2columnsalesinvoice.xls" or "simple2columnsalesinvoice-uis.xlsx" with Microsoft Excel.
  3. Click "Design Mode" on the "Invoice" Excel ribbon tab to put it into design mode.
  4. Enter your business information and replace the default logo image to make it your own. (How?)
  5. Click "Design Mode" again to exit design mode.
  6. Create invoice (tutorial movie)!

Prefer to have a look at other samples? Try our Search tool!

Screenshots and Images

The printed version.

Simple 2-Column Sales Invoice Sample

Simple 2-Column Sales Invoice Sample (c2002)

This is how the template looks like when you open the freeware template in Microsoft Excel.

Simple 2-Column Sales Invoice Sample - freeware edition

Simple 2-Column Sales Invoice Sample - freeware edition

The following template was designed for Uniform Invoice Software version 3.

Simple 2-Column Sales Invoice Sample - Uniform Invoice Software V3 edition

Simple 2-Column Sales Invoice Sample - Uniform Invoice Software V3 edition

Download Simple 2-Column Sales Invoice Sample (c2002)

License: Private Use (not for distribution or resale). See our Terms of Use.

You are safe to download the resources. We've added our digital signatures to the files.

DescriptionSizeDownload

Download this if you have already installed UIS, but are looking for additional customized templates.

333 KBDownload

Download this if you want this design to be set as the default template by the installer program.

2.81 MBDownload

Detail

Simple 2-Column Sales Invoicing Template is a sample of customizing the default template shipped with Uniform Invoice Software. It has two columns, Description and Amount, on the printable invoice body.

The default template has 5 columns within the printable invoice body - product#, description, quantity, unit price, line total. This simple 2-column sales invoicing form, designed for general invoicing purpose, moved the product#, quantity, and unit price columns out of the printable area. The description and amount columns left inside the printable area are all manually editable, making it suitable for general invoicing needs.

This general template does not contains the section for shipping address fields, assuming shipping address are the same as the "bill to" address. However, "Ship Date", "Ship Method", and the field for you to enter shipping cost are still left on the invoice form, that's why we at InvoicingTemplate.com categorize it as sales invoicing forms, but not a template for services.

Unlike the default template, this simple 2-column sales invoicing format does not include taxes.

Simple 2-Column Sales Invoice Sample, 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.

If you use the Uniform Invoice Software version of Simple 2-Column Sales Invoice Sample, there are additional taxing options on the Taxes tab of the Settings window. The first is the option for choosing the number of tax items; you have 3 choices - no tax, one tax and two taxes. Secondly, you can set the names and rates in percentage for each tax, such as VAT, GST or PST, or simply Sales Tax. Thirdly, there are a group of checkbox options on the dialog box, including: "Tax invoice total including shipping cost", which adds the shipping cost to the taxable amount when checked; "Tax 2 is applied to tax 1", which adds the amount of "tax 1" to the taxable amount if checked; and "tax rate can be zero", which allows you to set any of the tax rates to be the value of zero. If you modify the options on this dialog box, the spreadsheet will be changed accordingly if needed.

The sample template has our logo placeholder image on it, which you should replace with your own logo image. To do this, simple unprotect the Invoice worksheet, and then switch to design mode.

The protection of the "Invoice" worksheet in Simple 2-Column Sales Invoice Sample 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 Simple 2-Column Sales Invoice Sample.

In design mode, Microsoft Excel allows you to move, add, or delete controls or images inside Simple 2-Column Sales Invoice Sample. 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.

  • In Excel 2003 click the Design Mode button on the Control Toolbox toolbar. Tip: If the Control Toolbox toolbar is invisible, click Excel menu View > Toolbars > Control Toolbox.
  • In Excel 2007, Excel 2010 and Excel 2013, click the Design Mode button in the Controls group of the Developer tab.

    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 Simple 2-Column Sales Invoice Sample, click the Design Mode button again to exit design mode.

(Note that if you have installed the latest version of our invoicing software, Uniform Invoice Software, which is able to upgrade a simple template in Microsoft Excel spreadsheet format into a complete invoicing system, you don't have to replace the logo image manually - you can replace the default logo image by clicking the "Replace Logo Image" button on the ribbon tab in Excel 2007, Excel 2010 and Excel 2013). To replace the default LOGO image in Simple 2-Column Sales Invoice Sample with your own image, follow the steps below:

  • Right click the Logo image, and then select Properties from the menu.
  • Click the Picture property, and then click the "..." button.
  • Browse to the folder containing your icon file. Select and open the icon file.
  • Close the Properties dialog box.
  • Drag the border of the image object to resize it, if needed.

If you don't need the LOGO image and want to delete it, simply hit the DEL key on your keyboard after you selected it with your mouse key. Deleting the LOGO image leaves an empty area to the left of the Company Information section. You may like to move the entire Company Information section to fill in the empty area. To do this: Drag your mouse to select the entire Company Information area, including Company Name, Street Address, City, ST Zip Code, etc.; Push your mouse key on the border of the selected area; drag it to the new location.

Feel free to download and try Uniform Invoice Software along with this template. Installing Uniform Invoice Software, our Excel Invoice Software, will also install the help documents for the invoicing program, which includes detailed instruction on how to customize the template.

Like other form designs here on InvoicingTemplate.com, Simple 2-Column Sales Invoice Form is free (offered to you at a price of 0.00USD). It works on Windows XP and all newer versions of Windows, and Excel 2003, 2007, 2010, 2013 or 2016.

Format and Specification

Template#c2002
NameSimple 2-Column Sales Invoice Sample
CategorySales Invoice Template
Release DateMonday, February 24, 2014
Format (XLS or XLSX).xls
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Columns2
Lines12
Line Height (Points)19.50
Print Area$G$1:$P$43
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)
Left36.00
Right36.00
Top72.00
Bottom72.00

Sample Templates