Skip to main content main content
Sharing Is Caring! We do appreciate your efforts to let others know us!

Screenshots and Images

The printed version.

Australian GST Invoice Template (2)

Australian GST Invoice Template (2) (c7019)

c7019 now includes the customized invoice template for the latest version of Invoice Manager for Excel. This is what you will see when you open australiangst2.xlsx.

Australian GST Invoice Template (2) (IMFE Edition)

Australian GST Invoice Template (2) - IMFE edition


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.


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

3.46 MBDownload

Without database file. How to download and use

154 KBDownload

Download this if you have already installed IMFE, and are looking for additional customized templates; or if you want a template for Invoice Manager (Lite).

754 KBDownload


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

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.

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 Invoice Manager for Excel 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, 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 2007, 2010, 2013, 2016 or 2019.

Format and Specification

NameAustralian GST Invoice Template (2)
CategorySales Invoice Template
Release DateMonday, March 3, 2014
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016 / Excel 2019
Feature Gallery
Line Height (Points)19.50
Print Area$G$2:$R$50
Papaer Size / OrientationPortrait
Default Margins (Points)

Update History

September 27, 2018

  • Updated the "Customer Report" for australiangst2.xlsx.

May 13, 2019

  • All the report worksheets are updated with the reports from the standard invoice template.
  • Applied Excel themed colors.
  • All the "Taxable" boxes are now Excel form controls.