Screenshots and Images
The printed version.
Open the template in Excel.
You are safe to download the resources. We've added our digital signatures to the files.
Download this if you have already installed the Microsoft Store edition of Invoice Manager for Excel, and are looking for additional customized templates.
Download this if you want this design to be set as the default template by the installer program.
Handman Invoice Template (Sales Tax) is another sample on customizing c7006 Handyman Billing Sample. It differs from the original template in that this template charges only one tax on the invoicing items.
You can also find another sample handyman billing sample created based on c7006 handyman billing format, c5054 Handyman Billing Template (No Tax). Each template here on InvoicingTemplate.com offers two edtion - a freeware edition, which you can download and use without installing Invoice Manager for Excel, and another Invoice Manager for Excel version, which makes a simple template in Excel spreadsheet format a powerful invoicing system, with the ability to manage customers, products, invoices and payments. As you may already know, the Invoice Manager for Excel version should be run with our invoicing software installed. Both the free edition and the Invoice Manager for Excel edition can be downloaded for free from the download page here on InvoicingTemplate.com.
In order to create this spreadsheet - Handyman Billing Template (Sales Tax), from the basic invoicing template, we first unprotect the "Invoice" worksheet, display gridlines and row / column headings in Excel, move out the GST and PST columns, expand the Description column to occupy the space left by moving out the GST / PST columns. The detailed explanation of this design process could be found at Handyman Invoicing Template (No Tax), which is also available here on InvoicingTemplate.com and you can download it for free.
Once we created the "No Tax" version, is easy to create this "Sales Tax" version. The secret behind this is to use the options available on the Taxes tab of the Settings window, which is functional after installing of Invoice Manager for Excel.
As a demonstration of the design, this handyman billing sample hosted on InvoicingTemplate.com also has the "Paid" and "Total Due" cells moved out of the printable invoicing form, to the new location that is outside the range defined by the Excel name "Print_Area". By moving the two cells, Payments and Balance Due, out of the printable invoicing form, we assumes all invoices are paid on receipt, and thus it is not necessary to detail the payments and balance on an invoice. However, if you still want to show the Payments and Balance Due cells on the printed (or extracted) invoices, or your PDF statements, it is in fact very easy to move back the "Paid" and "Total Due" cells.
With this customization sample, the template also has "Taxable" column (which appears as a checkbox column) moved into the printable invoice form, so that it is included on the printed invoices, the extracted Excel spreadsheet invoices, as well as the PDF invoices which you generate by using Excel.
Conclusion: As this sample handyman bill (sales tax) shows, it is easy to customize the layout and format of an existing template to create a new one that meets your business requirements. All templates hosted here on InvoicingTemplate.com, including the one that you create by customizing our samples, can work with Invoice Manager for Excel without problem as long as you adhere to the Creation and Design Guidelines that could be found in the Help file included in Invoice Manager for Excel.
Format and Specification
|Name||Handyman Invoice Template (Sales Tax)|
|Category||Service Invoice Template|
|Release Date||Tuesday, June 3, 2014|
|Format (XLS or XLSX)||.xlsx|
|Line Height (Points)||19.50|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|
|Price||Free (0.00 USD)|
|System||Windows 7 and later, and Excel 2007 and later.|
August 27, 2018
- This template was updated to be compatible with UIS 6.