Skip to main content
InvoicingTemplate.com main content

Handyman Invoice Template (Sales Tax)c5055

Handyman Billing Template (Sales Tax)

"Handyman Invoice Template (Sales Tax)" was found to be relative to Tax Preparation Invoice Template with the score grade of 99.

...(42) 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 Uniform Invoice Software.

...(14) To show/hide gridlines and row/column headers in Excel 2007, Excel 2010 and Excel 2013:

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

Job Invoice Sample (2 Taxes)c5056

Job Billing Sample (2 Taxes)

"Job Billing Sample (2 Taxes)" was found to be relative to Tax Preparation Invoice Template with the score grade of 98.

...(98) In case you need to further customize the tax system implemented by this job invoice template, InvoicingTemplate.com is providing you with other 2 variants two. First, if you need to move the Taxable checkbox column inside the printable invoicing form, please see Job Invoice Sample (Taxable Column); if you want to make it as detailed as possible and show the tax amount charged on each invoicing item, Job Invoice Sample (Tax Column). We're also providing another flavor of the job invoice template, which provides less fields on the heading section of the invoice form, at Job Invoice Template.

Lightweight Sales Invoice Templatec5070

Lightweight Sales Invoice Template

"Lightweight Sales Billing Form" was found to be relative to Tax Preparation Invoice Template with the score grade of 95.

...(236) If you prefer this lightweight invoice layout but still want a logo image on the form, it is easy to add one if you have the latest version of Uniform Invoice Software installed. To do this, simply click the "Replace logo image" command on the "Invoice" ribbon tab. This will open a dialog box that asks if you want to add a new logo image since there is no default logo image placeholder on the form. Confirm that you want to add a logo image, and then browse to and choose the your own logo image. The newly added logo image will be in design mode, which allows you to resize and move the image, and there are even more options you can use to adjust the image if you right-click the image and choose Properties. The options on the Properties pane are provided by Microsoft Excel, but not Uniform Invoice Software. As you can see, one of the advantages of Uniform Invoice Software, compared to other invoicing solutions, is that it utilizes the full power of Microsoft Excel, so that you can easily design / customize the invoice form with familiar tools. This lightweight sales invoice template, just like the other invoice templates available here on InvoicingTemplate.com, are just samples on how to customize the default invoice template shipped with the Uniform Invoice Software installation program, although they could be used directly without any modifications.

...(70) This template, Lightweight Sales Billing Form, does not uses custom fields, although you can easily add them with Uniform Invoice Software. With Excel Invoice Manager, which is our first generation of invoicing software based on Microsoft Excel, where custom fields (i.e. user-defined fields) should be defined using a standalone tool, Uniform Invoice Software integrates the "Custom Field Manager" into the main program itself and simplifies the use of custom field.

4-Column without Taxc4002

4-Column Invoice Template

"4-Column Invoice Template" was found to be relative to Tax Preparation Invoice Template with the score grade of 92.

...(21) This is a variant of the invoice template with 4 columns. The template is set with no tax and shipping address.

...(87) If you have Uniform Invoice Software installed, setting tax types is as easy as clicking several buttons. For example, if you find a template here on InvoicingTemplate.com interesting but don't need tax fields, you can set it to non-tax by firstly clicking the Settings button on the Invoice worksheet, and then go to the Taxes tab of the Settings dialog box. The Taxes tab offers 3 options, non-tax, one-tax and two-tax. Tax names and rates can also be set on the "Taxes" page of the Settings window.

ABN Tax Invoicec7028

ABN Tax Invoice Format

"ABN Tax Invoice Format" was found to be relative to Tax Preparation Invoice Template with the score grade of 87.

...(61) This template is a revised version of our original designs, Australian GST Invoice Template and Australian GST Invoice Template (2). With this new template, we move the ABN# field to the top of the invoice form, and also modify the layout of the form to make it looks better and works more smoothly with the latest version of Uniform Invoice Software.

, then the checkboxes should be named with "oknWidget_" prefix, such as oknWidget_taxtable1, oknWidget_taxable2, oknWidget_taxable3...

...(75) With this revised template we also removed all the "looking up" (magnifying glass icons) buttons from the template, since Uniform Invoice Software is now included a useful feature that is called "on-sheet picker", which provides a smart button that shown automatically whenever you click a supported field / cell - by using this button, you can easily pick-up a customer, a shipping address, one or several product items, a sales person, a payment term, etc.

Jamaica Tax Invoice Templatec5072

Jamaica Tax Invoice Template

"Jamaica Tax Invoice Template" was found to be relative to Tax Preparation Invoice Template with the score grade of 81.

...(228) When working with Uniform Invoice Software (UIS) version of Jamaica Tax Invoice Template, 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 Jamaica Tax Invoice Template 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.

UK Tax Invoice Templatec6005

UK Tax Billing Form

"UK Tax Invoice Template" was found to be relative to Tax Preparation Invoice Template with the score grade of 64.

...(83) The taxable checkboxes were removed completely, assuming all the products are taxable, no matter whether the Taxable option is checked or not for each product. This avoids an occasionally happened mistake when a taxable product or item must be manually entered on the invoice body, as the Taxable checkbox is not checked by default. The template implements this feature by deleting all the Taxable checkboxes and assigning a value of 1 (TRUE) to all the oknTaxable cells located in the hidden column C.

Recipient Created Tax Invoices Formc4077

Template for Purchaser Created Tax Invoices

"Recipient Created Tax Invoices Form" was found to be relative to Tax Preparation Invoice Template with the score grade of 61.

...(134) The detail section of the form provides 4 columns, Description, Value, GST and Price, exactly like the PDF sample provided by Australian Taxation Office, where "Value" is the total amount of the invoicing item excluding GST, and "Price" equals to "Value" plus "GST". Since this template does not calculates "Value" from "Quantity" and "Unit Price", like what Australian GST Invoice Template and ABN Tax Invoice Template do, we've placed "Quantity" and "Unit Price" outside the printable form (which you can use to do the calculation, but will not be printed). The amount of GST will also be calculated automatically using Excel formulas based on the "Value" and tax rate, which can be set on the "Taxes" tab of the "Settings" window. To open the "Settings" window, click the "Settings" button on the "Invoice" worksheet.

...(58) As you can see, while PDF formatted documents has advantages in the business world, on creating invoices Excel formatted invoice template is much easier and saves time by doing automated calculations using formulas. And, with Uniform Invoice Software, you can simply click the "Extract/Email" button within the Excel spreadsheet to send PDF invoices using email in electronic format.

Blank Sales Invoice Layout (Two-tax)c2020

Blank Sales Invoice Layout (Two-tax)

"Blank Sales Invoice Sample (Two-tax)" was found to be relative to Tax Preparation Invoice Template with the score grade of 46.

...(163) If you use the Uniform Invoice Software version of Blank Sales Invoice Layout (Two-tax), 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.

Mixed Tax Rates (5 Columns)c5034

Mixed Tax Rates in an Invoicing Form (5 Columns)

"Mixed Tax Rates (5 Columns)" was found to be relative to Tax Preparation Invoice Template with the score grade of 44.

...(98) Adding a custom field to the Product table in the database makes it possible to save the field value to database along with the other data of a product. For example, adding the custom field "Product Type" to the Product database table allows you to save the type, such as "General" or "Labor", to the database when you save a product or item. If you use Uniform Invoice Software version template Mixed Tax Rates (5 Columns) and add the custom field to the spreadsheet, the value is retrieved whenever you pick up a product on creating an invoice.

...(25) The next step is to move the new columns added for this template, i.e. "Product Type" and "Applied Tax Rate" to the printable invoicing form.

Basic Blank Service Format (No-tax)c2012

Basic Blank Service Layout (No-tax)

"Basic Blank Service Format (No-tax)" was found to be relative to Tax Preparation Invoice Template with the score grade of 35.

...(130) This template, "Basic Blank Service Format (No-tax)", which you could download for free, calculates subtotal and total automatically using Excel formulas. It has no tax field set. If you have Uniform Invoice Software installed, it would be easier if you have the need to change its taxing rules - firstly, open this template Basic Blank Service Format (No-tax) as usually. And then, click the Settings button on the "Invoice" ribbon tab. And then, on the Taxes tab of the Settings window, you'll find option for "no-tax", "One tax" and "Two taxes". There are also options for tax names and rates too. Once you've finished settings up these preferences, click the "Apply" button on the button of the "Taxes" tab to have Uniform Invoice Software adjust the template automatically for you.

Invoicing Template with Watermark of New Yorkc4101

Invoicing Format with Watermark of New York

"Invoicing Template with Watermark of New York" was found to be relative to Tax Preparation Invoice Template with the score grade of 26.

...(79) The added image of the New York City is inserted into the form header section so that it is not visible when you are creating invoice - i.e. editing the Excel form. The New York watermark is visible on the printed version (see the screenshots below), as well as on the PDF invoice generated with Uniform Invoice Software, which you can send to your customer electronically with email (see invoice template to email for more samples on this topic).

...(64) The "Paid" and "Balance Due" cells, which are put inside the printable form in the default template shipped with Uniform Invoice Software, were now moved out of the "Print_Area" section. This simplifies the form layout. If you need to keep these fields on the printed bills or the PDF version, move them back by following the instructions detailed in the "Create Invoice Template" document.

Sample Service Invoice Template: Using Line Number Instead of Item#c5037

Service Template with Line Number

"Sample Service Invoice Template: Using Line Number Instead of Item#" was found to be relative to Tax Preparation Invoice Template with the score grade of 26.

...(251) 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 Sample Service Invoice Template: Using Line Number Instead of Item# 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 Sample Service Invoice Template: Using Line Number Instead of Item# 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 Sample Service Invoice Template: Using Line Number Instead of Item# 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.

General Waybillc3010

General Packing Slip

"General Packing Slip" was found to be relative to Tax Preparation Invoice Template with the score grade of 15.

...(129) Thirdly, you can install Uniform Invoice Software, and then add this waybill template and an invoicing template. This way, in additional to the benefits described above, you can also convert an invoice to a packing slip with several simple clicks of mouse. A brief description of the working procedure is as following. You draft the invoice as usual, and once finished click the "Save Invoice" command to save it to database. And then, you open this waybill template. Click the Invoices button on the Excel ribbon, find the invoice in question and click "Edit In Excel" - all information available on the invoice are now retrieved to the waybill. Then you can just supplement the information that available only on the waybill to quickly create the document you need.

...(49) One thing to note is that, if you wish to use this template with Uniform Invoice Software, then don't rename the "Invoice" worksheet. Uniform Invoice Software determines the type of worksheet based on its name. Renaming the worksheet will cause the invoicing program stop working with the waybill template.

Handyman Invoice Templatec7006

Handyman Invoice Template

"Handyman Invoice Template" was found to be relative to Tax Preparation Invoice Template with the score grade of 11.

...(84) Adding a custom field to the "InvBdy" database table makes it possible to save the data on the invoice spreadsheet to database when the "Save To DB" button is clicked. For example, adding the custom field "Product Type" to the "InvBdy" database table allows save the type value on the invoicing form, such as "General" or "Labor", to database when you save an invoice by clicking the "Save To DB" button. This feature is not supported in the freeware edition of Handyman Bill Sample.

Bill Format for Integrated Security Servicec4088

Invoicing Template for Integrated Security Service

"Bill Format for Integrated Security Service" was found to be relative to Tax Preparation Invoice Template with the score grade of 1.

...(142) The detail section is itemized so you can list your charges one by one. For example, "Hours Labour Only At Above Job Address", " Days Labour Only At Above Job Address", "Installation of CCTV System", "Installation & Commissioning Of Intruder Alarm System At Above Job Address", "Service Call Out", "Supply & Install Replacement VCL 8" Orbitor Gold Dome", "Camera Repair Returns Cost", "Annual Service to CCTV System", "Replacement Acrylic Dome Cover", "Installation Of Alarm System At Above Job Address", "Installation Of Chubb Monitored Lock (Labour Only )". Note that if you have our invoicing software program installed, each product could have an ID, which allows you to quickly enter the product description and unit price into the printable invoicing form by entering the product ID. This feature is called in-cell lookup. All the Excel invoice templates here on InvoicingTemplate.com support this functionality.

Specifications

Template#
Title
Release Date
Lines
Columns
Paper
Orientation
Category
c5055
Handyman Invoice Template (Sales Tax)
Tuesday, June 3, 2014,
12
5
A4
Portrait
Service
c5056
Job Invoice Sample (2 Taxes)
Wednesday, September 17, 2014,
12
5
A4
Portrait
Service
c5070
Lightweight Sales Invoice Template
Tuesday, July 21, 2015,
16
5
A4
Portrait
Sales
c4002
4-Column without Tax
Saturday, November 2, 2013,
12
4
A4
Portrait
Service
c7028
ABN Tax Invoice
Sunday, July 3, 2016,
17
7
A4
Portrait
Sales
c5072
Jamaica Tax Invoice Template
Monday, August 3, 2015,
12
5
A4
Portrait
Sales
c6005
UK Tax Invoice Template
Monday, March 20, 2017,
15
6
A4
Portrait
Sales
c4077
Recipient Created Tax Invoices Form
Monday, July 4, 2016,
8
4
A4
Portrait
Sales
c2020
Blank Sales Invoice Layout (Two-tax)
Sunday, November 22, 2015,
12
2
A4
Portrait
Sales
c5034
Mixed Tax Rates (5 Columns)
Sunday, November 24, 2013,
12
5
A4
Portrait
Sales
c2012
Basic Blank Service Format (No-tax)
Sunday, November 15, 2015,
12
2
A4
Portrait
Service
c4101
Invoicing Template with Watermark of New York
Wednesday, November 30, 2016,
6
4
A4
Portrait
Sales
c5037
Sample Service Invoice Template: Using Line Number Instead of Item#
Wednesday, December 18, 2013,
12
5
A4
Portrait
Service
c3010
General Waybill
Saturday, November 14, 2015,
20
3
A4
Portrait
Other
c7006
Handyman Invoice Template
Sunday, June 1, 2014,
12
7
A4
Portrait
Service
c4088
Bill Format for Integrated Security Service
Saturday, October 15, 2016,
12
4
A4
Portrait
Service

What Is Hot

Feature Galleries