Skip to main content
InvoicingTemplate.com main content

Australian GST Invoice Templatec7018

Australian GST Invoice Template

"Australian GST Invoice Template" was found to be relative to Tax Invoice Templates with the score grade of 97.

...(109) Why standardize the way tax invoices and invoices are set out? As Australian Taxation Office stated, the voluntary standards have been developed in consultation with small business, in response to feedback about their frustration with inconsistent tax invoice and invoice formats. The standards will help achieve greater consistency in the set out of tax invoices and invoices, making it easier for recipients to locate the necessary information for tax purposes. For more information about the specific requirements of a tax invoice, refer to Australian Taxation Office: Valid tax invoices and GST credits (NAT 12358), 'Section 03 - Issuing and obtaining tax invoices' in GST for small business (NAT 3014).

Simple Invoice for Letterhead Paperc4074

Simple Invoice Format for Letterhead Paper

"Simple Invoice for Letterhead Paper" was found to be relative to Tax Invoice Templates with the score grade of 97.

...(17) Click the "Design Mode" button on the "Invoice" ribbon tab to put the template into design mode.

...(23) Once you have finished your design work for Simple Invoice for Letterhead Paper, click the Design Mode button again to exit design mode.

...(136) In the design mode, you'll see that there are 3 empty lines on the top of this simple invoice form. You can adjust the height of these lines to make it suitable for printing on your letterhead paper. There are other templates here on InvoicingTemplate.com that use the same technique for letterhead papers, such as Simple Invoice Sample - Printing on Letterhead Paper. For a general invoice template that is not designed specifically for letterhead papers, you can adjust the margins to make it suitable to be printed on your papers. Page margins are the blank spaces between the worksheet data and the edges of the printed page. Top and bottom page margins can be used for some items, such as headers, footers, and page numbers. Generally, you have to do this by following these steps:

South Africa Tax Invoice Template (Sales)c4036

South Africa Tax Billing Format (Sales)

"South Africa Tax Billing Format (Sales)" was found to be relative to Tax Invoice Templates with the score grade of 91.

  1. The value of the goods/services excluding VAT
  2. The VAT amount (calculated at 14% of the above amount)
  3. The value of the goods/services including VAT
  4. The name, address and VAT registration number of the person buying the goods/services
  5. And your own name, address and VAT registration number.

...(37) It is of upmost importance to adhere to these valid tax invoice requirements. It is found that the South African Revenue Services (SARS) became very strict when they review or audit a Value added tax (VAT) period.

New Zealand Tax Invoice Templatec4038

New Zealand Tax Invoice Template

"New Zealand Tax Billing Form" was found to be relative to Tax Invoice Templates with the score grade of 87.

...(31) To make your invoice legally compliant it must show certain information. This template, designed by InvoicingTemplate.com, meets the requirements by New Zealand Inland Revenue and is capable of tax (GST) calculation.

...(26) This template, New Zealand Tax Invoice Template, or New Zealand Tax Billing Form, is implemented in a way so that the prices does not including tax.

...(28) If you don't need the shipping address section to appear on invoice form, it is easy to move the entire shipping address section out of the print area.

Invoice Template with Tax Columnc5001

Invoice Template with Tax Column

"Invoice Template with Tax Column" was found to be relative to Tax Invoice Templates with the score grade of 82.

...(100) Although the invoice template includes fields for shipping information, the body part has columns titled with "Hours" and "Rate/Hour". If you don't like these two headings, you can easily change them to Quantity and Unit Price by simply unprotect the Invoice worksheet and then type in your own text labels. However these are not the interesting parts of this invoice template. The special point of this invoice template is that it includes a Tax column, which shows the tax amount calculated based on tax rate (specified on the bottom of the form), line total and status of the "Taxable" checkbox.

Hourly Service Bill Sample (Price Including Tax)c5068

Hourly Service Bill Sample (Price Including Tax)

"Hourly Service Bill Sample (Price Including Tax)" was found to be relative to Tax Invoice Templates with the score grade of 79.

...(234) When working with Uniform Invoice Software (UIS) version of Hourly Service Invoice Template (Price Including Tax), 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 Hourly Service Invoice Template (Price Including Tax) 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.

Blank Service Invoice Template with Auspicious Clouds Borderc3020

Blank Service Invoice Template with Auspicious Clouds Border

"Blank Service Invoice Template with Auspicious Clouds Border" was found to be relative to Tax Invoice Templates with the score grade of 79.

...(50) In the previous billing sample c3019 Blank Service Invoice Template with Image Border, we demonstrates how to use an image as a border of your invoices and bills. The image border used with c3019 is some abstract lines with a pair of big quotations on the top-left and bottom-right corners.

...(29) This template has one tax by default on the bottom of the invoicing form, which is suitable for most states inside U.S., as currently there is no National Sales

...(89) Tax in the U.S. There are no overriding legal requirements for an invoice in the US; there is no specific provision in the UCC regarding the format or process for issuing an invoice. However if you have to collect local sales tax, you can set the number of taxes appear on the form by clicking the "Settings" button and then go to the "Taxes" tab. Consult municipal and county statute to find applicable local sales tax rates. See more samples for tax invoices in the tax invoice template topic.

South Africa Tax Invoice Template (Service)c4037

South Africa Tax Billing Format (Service)

"South Africa Tax Invoice Template (Service)" was found to be relative to Tax Invoice Templates with the score grade of 67.

...(101) As SARS (South African Revenue Services) states, any person that carries on a business may register for VAT. The term person is not only limited to companies but also includes, amongst others, individuals, partnerships, trust funds, foreign donor funded projects and municipalities. In order to register, an application form must be completed and a specific process must be followed, both of which you can find on the SARS web site. It is mandatory for a person to register for VAT if the taxable supplies made or to be made is, in excess of R1 million in any consecutive twelve month period.

Hourly Service Invoice Template (Price Excluding Tax)c5069

Hourly Service Billing Statement (Price Excluding Tax)

"Hourly Service Invoice Template (Price Excluding Tax)" was found to be relative to Tax Invoice Templates with the score grade of 63.

...(32)Hourly Service Invoice Template (Price Excluding Tax) is a variant format of Hourly Service Bill Sample. This sample template demonstrates how we add a new Tax column to create a new template.

...(63)Hourly Service Invoice Template (Price Excluding Tax) is provided in two editions - a freeware editions of Hourly Service Invoice Template (Price Excluding Tax), and a Uniform Invoice Software (UIS) edition of Hourly Service Invoice Template (Price Excluding Tax). Both editions can be downloaded for free from the download page. A PDF edition is also provided at the right section of this page.

...(35) Note that like most other templates here on InvoicingTemplate.com, this templates includes a default logo image on the top of the form. This is a placeholder image which you should replace with your own image.

ABN Tax Invoicec7028

ABN Tax Invoice Format

"ABN Tax Invoice" was found to be relative to Tax Invoice Templates with the score grade of 49.

...(40) If all your items are taxable or not taxable, you may not want to include the "Taxable" controls on the form. Don't worry. You can easily move ActiveX controls or Excel / Office form controls by following the steps below.

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 , then the checkboxes should be named with "oknWidget_" prefix, such as oknWidget_taxtable1, oknWidget_taxable2, oknWidget_taxable3...

Hotel Receipt Format with Blue Gradient Designc7027

Hotel Receipt Format with Blue Gradient Design

"Hotel Receipt with Blue Gradient Bar" was found to be relative to Tax Invoice Templates with the score grade of 42.

...(62) With this revised template, we added a blue gradient bar to the top of the invoice / receipt form. Excel is able to applied gradient fill effect to a single cell or several cells that are merged into single unit. So in this layout, we merge all cells on the top line into one and place the hotel name (motel name) there.

  1. Backup the template (as always).
  2. Switch to design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab. All the template here on Invoicing Template are protected by default, but with no password set. The purpose of enabling protection is to prevent end users from altering the design of the template accidently.
  3. Select all the cells on the top line that we'll marge, in this case, $D$3:$N$3.
  4. On Excel "Home" ribbon tab, click "Merge and Center".
  5. Right-click the merged cell and choose "Format Cells".
  6. Switch to the "Fill" tab.
  7. Click "Fill Effects".
  8. From "Colors" section, choose "Two colors", make the "color 1" is white and "color 2" is blue.
  9. From "Shading Style" section choose "From corner".
  10. Click one of the fill effect from the "Variants" section.
  11. Click OK to close the "Fill Effects" dialog box.
  12. Click OK to close the "Format Cells" dialog box.
  13. "Your Hotel Name" is a placeholder for your hotel / business name. Before you can create your first invoice, you need to replace it with your business name.
  14. The "RECEIPT" title is now implemented as a text box. Compared to regular text on the spreadsheet form, adding text and label using text box gives you more options on formatting and placing text. Click to select the "RECEIPT" title, the "DRAWING TOOLS / Format" ribbon tab appears, where you have full control over the style and appearance of the text box. In this sample, we simply choose one of preset WordArt Style.
  15. Once you've done customization on the hotel receipt template, click "Design Mode" button again on the "Invoice" ribbon tab to exit design mode. This protect the "Invoice" worksheet and hide gridlines and row/column headings.
  16. Click the Save button on Excel quick access toolbar to save the template.

Jamaica Tax Invoice Templatec5072

Jamaica Tax Billing Format

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

...(137) 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. Jamaica Tax Invoice Template 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.

Simple Sample - Moving Taxable Controlsc5076

Simple Sample - Moving Taxable Controls

"Simple Invoicing Format - Moving Taxable Controls" was found to be relative to Tax Invoice Templates with the score grade of 39.

...(55) This simple invoicing template shows you how to create a billing format that exclude the taxable boxes from the printable form. This sample is based on the result of c5075 Simple Invoice Template - Moving Balance and Payment Cells. The customized template created in this tutorial could be downloaded for free from here on InvoicingTemplate.com.

  1. First of all, back up your template. It is always recommended to back up the template before modifying the layout and format. This way, you could easily return to a working state in case something goes wrong during customization.
  2. Now click to push down the "Design Mode" button on the "Invoice" ribbon tab. This switch the spreadsheet into design mode, showing gridlines and column / row headings, unprotecting the sheet, as well as push down the "Design" button on Excel "Developer" ribbon tab (The "Developer" ribbon tab is not visible by default).
  3. Now push down the CTRL key on your keyboard. Without releasing the CTRL key, click the taxable boxes one by one with your mouse. This select the taxable controls that you click.
  4. Once all the taxable boxes are selected, release the keyboard CTRL key.
  5. Click and drag one of the taxable box. Drop it outside the printable area - in this sample, we put it on $C10. By dragging and dropping one of the selected controls, all the selected controls are moved to the new location.
  6. If you want to delete the controls completely, with all the controls still selected, hit DEL key on your keyboard. If you want to leave them there, skip this step.
  7. You can also modify the formulas of the tax fields to have them ignore the value of the taxable boxes completely. If all your products or items are always taxable, modify the formula of the first tax cell to " =ROUND( IF ( oknTaxType =0 ,0, oknTax1Rate * ( oknSubTotal + IF( oknTaxTotalIncludingShippingCost =0,0, oknShippingCost ))),2)"; and modify the formula of the second tax cell to " =ROUND ( IF( oknTaxType <> 2,0, oknTax2Rate * ( oknSubTotal + IF ( oknTaxTotalIncludingShippingCost = 0,0, oknShippingCost )+IF( oknTax2IsAppliedToTax1= 0 ,0, oknTax1 ))),2) ". If all your products / items are not taxable, simply choose "No-tax" from the "Taxes" page of the Settings dialog box that could be opened by clicking the "Settings" button on the "Invoice" ribbon tab.
  8. Now modify the column heading of the original "#/Taxable" column. To do this, simply replace the text "#/Taxable" with something like "Item#" or simply "#".
  9. Exit design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab again.
  10. Once done, save the template by clicking the Save button on Excel quick access toolbar.

VAT Sales Invoice Template - Price Including Taxc6007

VAT Sales Invoicing Template - Price Including Tax

"VAT Sales Invoice Template - Price Including Tax" was found to be relative to Tax Invoice Templates with the score grade of 34.

  • 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.

VAT Sales Invoicing Sample - Price Excluding Taxc6008

VAT Sales Invoicing Template - Price Excluding Tax

"VAT Sales Invoicing Sample - Price Excluding Tax" was found to be relative to Tax Invoice Templates with the score grade of 31.

...(122) Effective invoicing procedures are crucial to the financial health of all businesses. Making sure that all details are correct and reflect the terms of your contract 鈥?with no room for query to delay payment. It is no doubt that a professional design invoice will help you get payment faster. Browse our free invoicing templates gallery to find out the one that meets your business requirements. In case you can't find the one that meets your business requirements exactly, you can still use our templates as a starting point. Remember that Microsoft Excel already provides all the powerful tools you need to further customize the invoicing form, including the use of formulas to define the new relationship between the fields you need.

VAT Service Invoice Template - Price Including Taxc6013

VAT Service Invoicing Template - Price Including Tax

"VAT Service Invoice Template - Price Including Tax" was found to be relative to Tax Invoice Templates with the score grade of 30.

...(135) In design mode, Microsoft Excel allows you to move, add, or delete controls or images inside VAT Service Invoice Template - Price Including Tax. 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.

VAT Service Invoice Template - Price Excluding Taxc6014

VAT Service Invoicing Template - Price Excluding Tax

"VAT Service Invoicing Template - Price Excluding Tax" was found to be relative to Tax Invoice Templates with the score grade of 25.

...(38) VAT Service Invoice Template - Price Excluding Tax is a sample invoice template demonstrating how to customize an existing invoice template, VAT Sales Invoice Template - Price Excluding Tax, to create a new design that meets your requirements.

...(75) If you offer different product types that have different tax rates, it is better to details this fact on your invoices. InvoicingTemplate.com has designed such a template for you too, which is available at VAT Invoice Template with VAT Rate Column and VAT Invoice Template with 2 Separate Rates. If you need to show both the VAT rate and VAT amount for each invoicing item, visit VAT Invoice Template with VAT Rate and Amount Column.

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 Invoice Templates with the score grade of 25.

...(163) If you use the Uniform Invoice Software version of Mixed Tax Rates (5 Columns), 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.

4-Column without Taxc4002

4-Column Invoice Template

"4-Column without Tax" was found to be relative to Tax Invoice Templates with the score grade of 25.

...(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.

UK Tax Invoice Templatec6005

UK Tax Billing Form

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

...(30) This template might be ideal for UK (United Kingdom) based stores or limited companies. The template shows postcode on a separate line, and an extra column was added for discounting.

...(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.

Specifications

Template#
Title
Release Date
Lines
Columns
Paper
Orientation
Category
c7018
Australian GST Invoice Template
Saturday, March 1, 2014,
17
7
A4
Portrait
Sales
c4074
Simple Invoice for Letterhead Paper
Sunday, June 26, 2016,
20
4
A4
Portrait
Sales
c4036
South Africa Tax Invoice Template (Sales)
Saturday, August 1, 2015,
12
4
A4
Portrait
Sales
c4038
New Zealand Tax Invoice Template
Tuesday, August 4, 2015,
12
4
A4
Portrait
Sales
c5001
Invoice Template with Tax Column
Tuesday, November 5, 2013,
12
5
A4
Portrait
Sales
c5068
Hourly Service Bill Sample (Price Including Tax)
Tuesday, September 30, 2014,
12
5
A4
Portrait
Service
c3020
Blank Service Invoice Template with Auspicious Clouds Border
Tuesday, December 5, 2017,
8
3
A4
Portrait
Service
c4037
South Africa Tax Invoice Template (Service)
Sunday, August 2, 2015,
12
4
A4
Portrait
Service
c5069
Hourly Service Invoice Template (Price Excluding Tax)
Wednesday, October 1, 2014,
12
5
A4
Portrait
Service
c7028
ABN Tax Invoice
Sunday, July 3, 2016,
17
7
A4
Portrait
Sales
c7027
Hotel Receipt Format with Blue Gradient Design
Wednesday, June 29, 2016,
12
7
A4
Portrait
Receipt
c5072
Jamaica Tax Invoice Template
Monday, August 3, 2015,
12
5
A4
Portrait
Sales
c5076
Simple Sample - Moving Taxable Controls
Wednesday, January 27, 2016,
12
5
A4
Portrait
Sales
c6007
VAT Sales Invoice Template - Price Including Tax
Monday, May 26, 2014,
18
6
A4
Portrait
Sales
c6008
VAT Sales Invoicing Sample - Price Excluding Tax
Tuesday, May 27, 2014,
18
6
A4
Portrait
Sales
c6013
VAT Service Invoice Template - Price Including Tax
Wednesday, May 28, 2014,
18
6
A4
Portrait
Service
c6014
VAT Service Invoice Template - Price Excluding Tax
Thursday, May 29, 2014,
18
6
A4
Portrait
Service
c5034
Mixed Tax Rates (5 Columns)
Sunday, November 24, 2013,
12
5
A4
Portrait
Sales
c4002
4-Column without Tax
Saturday, November 2, 2013,
12
4
A4
Portrait
Service
c6005
UK Tax Invoice Template
Monday, March 20, 2017,
15
6
A4
Portrait
Sales

What Is Hot

Feature Galleries