Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Australian GST Invoice Template (2). Double-click the downloaded file to extract all files.
  2. Open the template "australiangst2.xls" or "australiangst2-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.

Australian GST Invoice Template (2)

Australian GST Invoice Template (2) (c7019)

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

Australian GST Invoice Template (2) - freeware edition

Australian GST Invoice Template (2) - freeware edition

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

Australian GST Invoice Template (2) - Uniform Invoice Software V3 edition

Australian GST Invoice Template (2) - Uniform Invoice Software V3 edition

Download Australian GST Invoice Template (2) (c7019)

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.

417 KBDownload

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

2.71 MBDownload

Detail

Australian GST Invoice Template (2) is the second sample of how to customize the default sales invoice template, corresponding to the second example given on Australian Taxation Office web site.

Note: a revised version of this template could be found at ABN Tax Invoice Template.

The previous invoice template sample here on InvoicingTemplate.com, Australian GST Invoice Template (1), meets the layout and feature requirements of the first sample in the Examples of what they look like using the voluntary standards on the Australian Taxation Office web site, titled with "Goods or services that all include GST". This second invoice template sample is based on the previous invoice template, and meets the layouts and requirements as shown in the second sample in the Examples of what they look like using the voluntary standards on the Australian Taxation Office web site, titled with "Goods or services that don't all include GST".

As detailed on the Australian Taxation Office web site, the invoice layout should include sufficient information to ascertain:

  • The identity of the supplier, such as the business name at the top
  • The ABN of the supplier at the top, near the supplier's identity
  • The date of issue of the tax invoice at the top, on the right hand side
  • That the document is intended as a tax invoice, such as including the words 'tax invoice' at the top
  • An invoice number shown prominently alongside the words 'tax invoice'
  • The purchaser's identity such as a name or ABN, for goods or services costing $1,000 or more
  • A unit description of each good or service supplied, including quantities - it is optional to include item numbers
  • An indication of which goods or services don't include GST by showing a 'zero' in the GST amount column
  • An indication of which goods or services include GST by showing the GST amount in the GST payable column, and
  • The GST exclusive price, the GST amount and the GST inclusive price for each item, together with the totals for these, vertically in the bottom right hand corner.

Australian GST Invoice Template (2) generally has the same layout as Australian GST Invoice Template (2). The most important difference is that it shows a 0 (zero) if the item is not taxable. This requirements sounds not special, but in fact conflicts with one global options we set for almost all invoice templates available on InvoicingTemplate.com - to simply the output invoices, we choose not to shown zero values on the entire invoice form.

To resolve this problem Australian GST Invoice Template (2) a nice feature offered by Excel, conditional formatting. As always, Excel's powerful features on formatting data making it possible to draft invoices in the way your business likes.

To create the conditional formatting for the GST Amount cells in Excel 2013, here are the steps to follow.

First, you have to unprotect the Invoice worksheet and display gridlines row/column headers.

The protection of the "Invoice" worksheet in Australian GST Invoice Template (2) prevents accidental modifications to layouts and formulas. If you have Uniform Invoice Software installed, it could even display a warning message when you close a template without protecting the worksheet. However for the purpose of this sample, we should firstly unprotect the worksheet in Australian GST Invoice Template (2).

To show gridlines and row/column headers in Excel 2000 - 2003:

  1. Click and activate the worksheet you want to display gridlines and row/column headers for.
  2. On the Tools menu, click Options, and then click the View tab.
  3. Under Window options, check the Gridlines and Row & Column Headers check boxes.

After your customization, go back to the Tools menu, Options, View tab. Under Window options, REMOVE the checks you previously placed by the two check boxes to hide gridlines and row/column headers. This will restore the appearance of your template.

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

  1. Click and activate the worksheet you want to display gridlines and row/column headers for.
  2. Go to the View tab of the Ribbon.
  3. Click Show/Hide, and then check or uncheck the Gridlines and Headings options.

The gridlines and row/column headings could help a lot when design the layout of the form.

Now you can set the conditional formatting for the "GST Amount" cells. Click to select the first GST Amount Cell located on Q20, on Excel ribbon click "Conditional Formatting" in the Styles group, and then choose Manage Rules. Click "New Rule..." and then Click "Use a formula to determine which cells to format" on the "Select a Rule Type" list. In the "Format Values where this formula is true" box, enter the formula "=AND(P20<>0, Q20=0)" (without the quotation marks). This formula means that the conditional formatting applies only when the P20 cell (which is a "Subtotal excl. GST" cell) is not zero and the Q20 cell (which is a "GST Amount" cell) is zero. Click the Format button to open the "Format Cells" dialog box. Go to the Number tab, and then click "Custom" on the "Category" list, enter the custom format string ";;-;" (without the quotation marks). This custom format means that, if the value is zero, display a "-" symbol. Click OK button to close all dialog boxes.

We do the above steps for the second line on the invoice body. In the "Format Values where this formula is true" box, enter the formula "=AND(P21<>0, Q21=0)".

Now by using the Format Painter of Excel, you can easily copy the conditional formatting of the first GST Amount cells to the other GST Amount Cells on the invoice body.

It is possible to make the GST Amount cells show a "-" symbol when the value is zero, the advantage of using conditional formatting is that the GST Amount cells in this example are still editable.

As you can see from this example, even some expensive accounting software for small businesses cannot offer this type of flexibilities on customizing the billing forms.

Although it is easy to create the layout and format of Australian GST Invoice Template (2) with Microsoft Word or other Microsoft Office programs, or even with some PDF programs like Adobe Acrobat, the support for Excel formulas makes doing automated calculations easy to implement and modify. For example, Australian GST Invoice Template (2) uses Excel formulas extensively to do calculations whenever possible and necessary, such as the taxes, totals. If you use the Uniform Invoice Software version of Australian GST Invoice Template (2), Excel formulas are also used to create the relationship between several fields, such as one field should be the sum of two other fields.

While the free edition of Australian GST Invoice Template (2), which offers a budget-free edition for creating invoices, helps you create professional invoices with an intuitive billing form, like what the Adobe PDF version shows, with Uniform Invoice Software installed, it can even being the powerful invoicing software that helps you manage your customers, products, invoices and payments!

Like other form designs here on InvoicingTemplate.com, Australian GST Billing Form (2) is free (offered to you at a price of 0.00USD). It works on Windows XP and all newer versions of Windows, and Excel 2003, 2007, 2010, 2013 or 2016.

Format and Specification

Template#c7019
NameAustralian GST Invoice Template (2)
CategorySales Invoice Template
Release DateMonday, March 3, 2014
Format (XLS or XLSX).xls
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Columns7
Lines17
Line Height (Points)19.50
Print Area$G$1:$R$49
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)
Left24.48
Right18.72
Top68.03
Bottom70.87

Sample Templates