Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

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

Service Bill with Profit and Taxable Column

Service Bill with Profit and Taxable Column (c5063)

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

Service Bill with Profit and Taxable Column - freeware edition

Service Bill with Profit and Taxable Column - freeware edition

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

Service Bill with Profit and Taxable Column - Uniform Invoice Software V3 edition

Service Bill with Profit and Taxable Column - Uniform Invoice Software V3 edition

Download Service Bill with Profit and Taxable Column (c5063)

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.

322 KBDownload

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

2.79 MBDownload

Detail

Service Bill with Profit and Taxable Column is the service edition of Sales Invoicing Sample with Profit and Taxable Column. It includes no shipping address section on the printable invoicing form, but adds a "taxable" and "profit" columns.

For a service bill template that includes no taxable column, see Service Invoicing Form with Profit Calculation, or in case you need to add shipping address to your invoices, visit Sales Invoicing Template with Profit Calculation. All these designs are based on the default template shipped with Uniform Invoice Software (UIS). And, each template available here on InvoicingTemplate.com comes with two editions - a freeware edition, and a UIS edition. The PDF format of each layout can also be downloaded for free.

Besides sales invoicing templates and service billing templates, we are also categorized some special templates into receipt templates for creating receipts, pro forma invoicing templates, consulting billing samples and other invoicing templates. Each template has detailed description and format specification. Our ideas is to let you find your desired forms and formats with easy and quick and at no price. If you are a technician and would like to know more about how to customizing the templates, download UIS and look into the electronic book come with the installer program. With UIS, you can not only create beautiful and professional invoices, estimates orders, but also manage inventory, payments, invoices and customers with a few simple mouse clicks. If you are offering service, such as plumbing or a handyman, or renting trucks, you may find this service billing template handy.

If you are a technician and would like to know how we create this Service Bill with Profit and Taxable Column from Sales Invoicing Sample with Profit and Taxable Column, read on.

This customization job could be done in 4 main steps. First, you have to unprotect the "Invoice" worksheet; secondly, switch the template into design mode, so that you can move the buttons and controls; third, move the cells and controls; and finally, you turn on protection and switch off design mode.

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 Service Bill with Profit and Taxable Column 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 Service Bill with Profit and Taxable Column 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 Service Bill with Profit and Taxable Column 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.

Once Service Bill 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...

For information on how to move the "taxable" column into the printable area, visit Sales Invoicing Sample with Profit and Taxable Column, or look into the help document of UIS. One thing not mentioned in the Sales Invoicing Sample with Profit and Taxable Column document is that, in order for UIS to include the taxable boxes on the extracted Excel spreadsheet format, you have to name the controls with "oknWidget_?" prefix, for example, oknWidget_taxable1, oknWidget_taxable2, oknWidget_taxable3, and so on. The orders in which the controls are named don't matter, but all controls without "oknWidget" prefix in their names will be removed from the extracted version of an invoice, which is archived by clicking the "Extract/Email" button on the "Invoice&qupt; worksheet.

Naming a control or an image is easy in Microsoft Excel. First make sure your template Service Bill with Profit and Taxable Column is in design mode. Right-click the control or image you want to assign it a name, choose Properties. On the Properties box, enter the name into the "name" field and press enter. Note that if you have several controls that you want to assign different names, you can do so by entering the name and then clicking to choose another control without closing the Properties window.

Service Bill with Profit and Taxable Column, 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 Service Bill with Profit and Taxable Column, 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.

While the free version of Service Bill with Profit and Taxable Column is simple, the result created by using this template is as beautiful and professional as many commercial invoicing software program, or even better. It is an ideal tool for small businesses and freelances who offer services and don't need a shipping section on their invoicing form. It is a good service bill creator, but if you need more features, like management of customers, products / service items, invoices and payments, just install Uniform Invoice Software to make all the buttons on Service Bill with Profit and Taxable Column work for you.

Like other form designs here on InvoicingTemplate.com, Service 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#c5063
NameService Bill with Profit and Taxable Column
CategoryService Invoice Template
Release DateSunday, September 21, 2014
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
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