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.

... Australian GST Invoice Template was designed according to the guidelines of Australian Taxation Office "How to set out tax invoices and invoices (NAT 11675)". While this is sample invoice template, like all the other blank invoice templates available here on InvoicingTemplate.com, is also created from the default sales invoice template shipped with Uniform Invoice Software, we've customize the template to meet the standards recommended by Australian Taxation Office.

... There are two editions of Australian GST Invoice Template here on InvoicingTemplate.com - the first is a budget-friendly freeware edition, which you can download and use for free; and another which must be used with Uniform Invoice Software installed. Uniform Invoice Software is our Excel invoicing software that turns a simple Excel spreadsheet billing template into a powerful invoicing system, making automated electronic invoice processing with Excel possible and easy to do.

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.

This simple invoice template is suitable for printing on papers with letterhead. It contains both a "Bill To" and a "Ship To" sections, categorized as sales invoice template. The 4 columns on the detail section are Quantity, Description, Price and Amount.

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

... 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 Invoice Template (Sales)" was found to be relative to Tax Invoice Templates with the score grade of 91.

To create a valid tax invoice that meets the requirements from South African Revenue Services (SARS), your invoice template should have formatted in a professional way. Download South Africa Tax Invoice Template (Sales) for free and start creating professional invoices in minutes.

... With this implementation of south Africa tax billing format, the shipping address is included on the format, so that the template is categorized as sales invoice template. With this tax invoice template, the prices defined on the form excluding VAT, i.e. VAT is added separated. As detailed on the SARS (South African Revenue Services) site, Value-Added Tax is commonly known as VAT. VAT is an indirect tax on the consumption of goods and services in the economy. Revenue is raised for government by requiring certain businesses to register and to charge VAT on the taxable supplies of goods and services. These businesses become vendors that act as the agent for government in collecting the VAT.

  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.

New Zealand Tax Invoice Templatec4038

New Zealand Tax Billing Form

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

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

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

Billing Form with Tax Column

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

This Invoice Template with Tax Column includes both the "Bill To" and "Shipping To" sections and has 5 columns that are description, Tax, Hours, Rate/Hour, and Amount.

... The heading part of the invoice form, including your own company/business information section, invoice#, invoice date, "Bill To" section and "Shipping To" section are similar to the default sales invoice template included in Uniform Invoice Software setup program, which you can download and try for free, and is able to upgrade a simple Excel formatted invoice template to a fully featured invoice program. With Uniform Invoice Software installed, your Excel invoice template will not be a simple invoice creator, it will be powerful invoicing that includes features for managing customers, products/items, invoices and payments.

... The Excel formula of the tax amount cells are like the following.

... This formula means that, if the "Taxable" checkbox is checked on the first line of the invoice body (identified by the " oknTaxable_1" cell value), it calculates tax amount based on line total and tax rate. If the "Taxable" checkbox is not checked, it shows either an empty string or the symbol "-" depending on whether the line total is zero.

Hourly Service Bill Sample (Price Including Tax)c5068

Hourly Service Billing Statement (Price Including Tax)

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

...Hourly Service Invoice Template (Price Including Tax), 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 Hourly Service Invoice Template (Price Including 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.

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.

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

... 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 South Africa Tax Invoice Template (Service) 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 South Africa Tax Invoice Template (Service) 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 South Africa Tax Invoice Template (Service) 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.

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.

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

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.

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

, 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 with Blue Gradient Bar

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

  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.

... 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 Sample - Moving Taxable Controls" was found to be relative to Tax Invoice Templates with the score grade of 39.

  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 Invoicing Template - Price Including Tax" was found to be relative to Tax Invoice Templates with the score grade of 34.

... (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 VAT Sales Invoice Template - Price Including Tax with your own image, follow the steps below:

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.

... When working with Uniform Invoice Software (UIS) version of VAT Sales Invoicing Sample - Price Excluding 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 VAT Sales Invoicing Sample - Price Excluding 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.

VAT Service Invoice Template - Price Including Taxc6013

VAT Service Invoice 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.

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

... While the free version of VAT Service Invoice Template - Price Including Tax 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 VAT Service Invoice Template - Price Including Tax work for you.

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.

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

... Mixed Tax Rates in an Invoice here is a sales invoicing sample, which means it includes shipping information on the form.

... This design, Mixed Tax Rates in an Invoice, has the "Product Type" and "Applied Tax Rate" placed outside of the printable area. What if you want to show these two columns on the printable invoicing form? It is easy actual to do - as mentioned above, all you need to do is to first adjust the existing columns to leave space for the two newly added columns, and then move in the two new columns.

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.

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

Recipient Created Tax Invoices Formc4077

Template for Purchaser Created Tax Invoices

"Template for Purchaser Created Tax Invoices " was found to be relative to Tax Invoice Templates with the score grade of 7.

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

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
c4077
Recipient Created Tax Invoices Form
Monday, July 4, 2016,
8
4
A4
Portrait
Sales

What Is Hot

Feature Galleries