Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Sales Invoice with Profit and Taxable Column. Double-click the downloaded file to extract all files.
  2. Open the template "salesinvoiceprofittaxable.xlsx" or "salesinvoiceprofittaxable-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.

Sales Invoice with Profit and Taxable Column

Sales Invoice with Profit and Taxable Column (c5062)

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

Sales Invoice with Profit and Taxable Column - freeware edition

Sales Invoice with Profit and Taxable Column - freeware edition

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

Sales Invoice with Profit and Taxable Column - Uniform Invoice Software V3 edition

Sales Invoice with Profit and Taxable Column - Uniform Invoice Software V3 edition

Download Sales Invoice with Profit and Taxable Column (c5062)

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.

327 KBDownload

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

2.80 MBDownload

Detail

This invoicing template, Sales Invoice with Profit and Taxable Column, adds a printable "Taxable" checkbox column to the default sales invoice template, and a non-printable Profit column outside the print area.

Compared to c5060 Sales Invoice with Profit Calculation, this invoice template adds a column of "taxable" checkbox. Each checkbox tells Excel / Uniform Invoice Software that whether the current invoicing item is taxable - if the checkbox is checked, this amount of this selling item is included when calculating taxes. In the original invoice template (and many other invoicing forms that are available here on InvoicingTemplate.com), this taxable checkbox column is placed outside the printable area, which means it is not included when you are printing an invoice, or generating an electronic invoice. By moving the group of checkboxes into the print area, your customers and clients will see the whether each item is taxable.

You can download both the Excel and PDF version of this template here on InvoicingTemplate.com - no agreement and contracts to sign, just download and use. If this template does not meet your business requirements exactly, you can also use it as a starting point or sample of creating your own template. All the designs available here on InvoicingTemplate.com are created based on the default sales invoicing template included in Uniform Invoice Software. The description on how to do customizations is detailed in the electronic book come with Uniform Invoice Software. If you are not a technician and still want to do some customizations on our templates, so that you can bill your customers and clients with your very own style, contact us to get your job done. While we name the program Uniform Invoice Software, it is possible to manage your estimates, orders and receipts.

This is a sales invoicing template, meaning that it includes the shipping address section on the printable form. If you are offering services, such as plumbing or as a handyman, and don't need the shipping address section, see Service Invoicing Form with Profit and Taxable Column. If you don't want to have the Taxable checkboxes to appear on the printable invoicing form, visit Service Invoicing Form with Profit Calculation. While this invoicing template, Sales Invoice with Profit and Taxable Column, is offered as both a freeware edition at no price and a Uniform Invoice Software edition, the Uniform Invoice Software edition provides more powerful features such as managing products and inventory, invoices and payments reporting, etc.

Now we look at the ideas of how to move the taxable checkbox column into the printable form. To do this, you first have unprotect the Invoice worksheet, switch the template to design mode, and then drag and drop the Taxable checkbox column to the target location.

The protection of the "Invoice" worksheet in Sales Invoice with Profit and Taxable Column 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 Sales Invoice with Profit and Taxable Column.

In design mode, Microsoft Excel allows you to move, add, or delete controls or images inside Sales Invoice with Profit and Taxable Column. 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 Sales Invoice with Profit and Taxable Column, click the Design Mode button again to exit design mode.

Once Sales Invoice with Profit and Taxable Column is unprotected and switched into design mode, you can now move the controls to the new location you like. To do this, click to select a control, or push the CTRL on your keyboard and then select all the controls you want to move using mouse. Then, drag (one of) the select controls to move them to the new location.

Note that if you use the Uniform Invoice Software and need to show the control on an extracted worksheet, then the control should be named with an "oknWidget_" prefix. For example, if you move the Taxable checkboxes into the printable form, then the checkboxes should be named with "oknWidget_" prefix, such as oknWidget_taxtable1, oknWidget_taxable2, oknWidget_taxable3...

While the free version of Sales Invoice with Profit and Taxable Column is simple, the result created by using this Microsoft Excel spreadsheet template is as beautiful and professional as many commercial invoicing software program, or even better. It is an ideal tool for small businesses and freelancers who sales products and do need a shipping section on their invoicing form. It is a good invoice generator, but if you need more features, like management of customers, products / items, invoices and payments, just install Uniform Invoice Software to make all the buttons on Sales Invoice with Profit and Taxable Column work for you.

One thing to note is that InvoicingTemplate.com tested the templates, including Sales Invoice with Profit and Taxable Column, on Microsoft Windows (with Excel, not Word) only, and the testing on Mac was usually not performed. If you need to run Sales Invoice with Profit and Taxable Column on Mac, test it with Mac version of Microsoft Excel before you apply it for production purpose.

Like other form designs here on InvoicingTemplate.com, Sales Invoicing Form with Profit and Taxable Column 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.

Format and Specification

Template#c5062
NameSales Invoice with Profit and Taxable Column
CategorySales Invoice Template
Release DateSunday, September 21, 2014
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Columns5
Lines12
Line Height (Points)19.50
Print Area$F$2:$N$44
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35

Sample Templates