You are safe to download the resources. We've added our digital signatures to the files.
Download this if you have already installed the Microsoft Store edition of Invoice Manager for Excel, and are looking for additional customized templates.
Download this if you want this design to be set as the default template by the installer program.
Screenshots and Images
The printed version.
Open the template in Excel.
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.
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!
Format and Specification
|Name||Australian GST Invoice Template (2)|
|Category||Sales Invoice Template|
|Release Date||Monday, March 3, 2014|
|Format (XLS or XLSX)||.xlsx|
|Line Height (Points)||19.50|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|
|Price||Free (0.00 USD)|
|System||Windows 7 and later, and Excel 2007 and later.|
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.