Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Plumbing Service Invoice Template (Landscape). Double-click the downloaded file to extract all files.
  2. Open the template "plumbingserviceinvoicetemplate2.xlsx" or "plumbingserviceinvoicetemplate2-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.

Plumbing Service Invoice Template (Landscape)

Plumbing Service Invoice Template (Landscape) (c4023)

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

Plumbing Service Invoice Template (Landscape) - freeware edition

Plumbing Service Invoice Template (Landscape) - freeware edition

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

Plumbing Service Invoice Template (Landscape) - Uniform Invoice Software V3 edition

Plumbing Service Invoice Template (Landscape) - Uniform Invoice Software V3 edition

Download Plumbing Service Invoice Template (Landscape) (c4023)

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.

299 KBDownload

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

2.78 MBDownload

Detail

Plumbing Service Billing Template (Landscape), as the name implies, is a customization sample of Plumbing Service Billing Template (Sales Tax) (c4022). This sample invoice layout changed the original paper orientation to Landscape. It contains less lines on the detail section, but each line is able to hold more text.

Plumbing Service Billing Template (Landscape) includes exactly the same number of fields as the original version. Unlike the other 2-column samples, Plumbing Contractor Bill Sample (c2008) and Plumbing Contractor Billing Format (Landscape) (c2009), this plumber template defines sales tax, instead of VAT tax. Like Plumbing Service Billing Format (Sales Tax) (c4022), this service template for plumber also has the Taxable column moved into the printable invoice form. This layout design is suitable for those businesses who have both taxable and non-taxable items. Bill your customers with this plumbing bill design if you have relatively long description for your invoicing items.

Checkboxes can not only be used as in a column value, but also could be on the invoice header and invoice bottom. For another example of using checkboxes, refer to Medical Bill Sample (1) and Medical Bill Design (2). One thing to note for the Uniform Invoice Software version is that, if you extract an invoice, the taxable checkboxes will be kept on the extracted version. This is implemented by naming the checkboxes with "oknWidget_" prefix. All the other objects that don't have "oknWidget_" prefix in their names, like the command buttons on the plumbing service invoice form, will be deleted when being extracted.

Please go to the download page to download the Plumbing Service Bill Sample (Landscape) in the format you like. If you are interested in the implementation details of Plumbing Service Billing Template (Landscape), read on.

While the free version of Plumbing Service Invoice Template (Landscape) 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 Plumbing Service Invoice Template (Landscape) work for you.

Like most free Excel templates available here on InvoicingTemplate.com, this plumbing service bill sample (Landscape) has a logo image on the top-left corner. You should replace it with your own image before you can use the template for your own business.

(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 Plumbing Service Invoice Template (Landscape) 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.

This template uses custom fields that are not defined in the default database shipped with Uniform Invoice Software. For example, underneath the "Bill To" section there is an oknJobAddress cell, which is a custom field.

Uniform Invoice Software support custom fields or user-defined fields, which is a unique feature that allows you to add new fields to the backend database as well as to the spreadsheet form. Plumbing Service Invoice Template (Landscape) uses custom fields to implement the features that are not available in the default template shipped with the invoicing program. With the support for custom fields in the database, Uniform Invoice Software has the ability to manipulate the newly added fields in database, includes adding them to reports. With the support for custom fields in the Excel worksheet, our invoicing app has the ability to create the relationship between fields - for example, one field should be the sum of the other fields, or the value of one field should be calculated only when another field value equals a certain value.

The support for custom fields makes it possible for even an end user who does not know programming at all, could add new features to her/his invoicing creator such as Plumbing Service Invoice Template (Landscape) without writing one line of programming code. Feel free to Search and download more samples. Sometimes our customization samples are offered in two editions here on InvoicingTemplate.com, that are one freeware edition, and another edition that works only with our invoicing software installed.

When working with Uniform Invoice Software (UIS) version of Plumbing Service Invoice Template (Landscape), how does UIS know to which cell when a field value write to when loading data from the database, and to which field a cell value must save when saving an invoice record, a customer or a product item? That is, how does UIS create the map or relationship between Excel cells on the template Plumbing Service Invoice Template (Landscape) and database fields? The answer is by using names. For example, if the field name in the Product table in a database is "ProductType", it is writing to a cell named "oknProductType_?" (where ? is the line number of the invoicing item) when you pick up a product or item on creating an invoice, and when saving an invoice, all cells with the name "oknProductType_?" are saved to the "ProductType" field in the "InvBdy" database table. By using cell names, UIS allows you to move a cell on the form without breaking the feature depending on the field / cell. You can place the "Product Type" column either inside the printable area, which is printed when you issue the Print command in Excel or click the Print command on the "Invoice" worksheet form; or place the Product Type column outside the printable area, which will be included when you print or extract an invoice or receipt.

Note that custom fields is a powerful feature introduced by previous version of Uniform Invoice Software (UIS), i.e. Excel Invoice Manager. The support for custom fields in Excel Invoice Manager requires a database definition file ("FDINFO10.rst") to be present in the folder where the database file was installed. With UIS, using custom fields is much simpler than in Excel Invoice Manager, and the database definition file is no longer required.

Like other form designs here on InvoicingTemplate.com, Plumbing Service Billing Template (Landscape) 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#c4023
NamePlumbing Service Invoice Template (Landscape)
CategoryService Invoice Template
Release DateFriday, May 16, 2014
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Columns4
Lines6
Line Height (Points)15.75
Print Area$F$2:$N$42
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Landscape
Default Margins (Points)
Left36.00
Right36.00
Top36.72
Bottom25.20

Sample Templates