The printed version.
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
Australian GST Invoice Template (2) - IMFE edition
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.
Without database file. How to download and use
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).
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:
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!
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 2007, 2010, 2013, 2016 or 2019.
|Name||Australian GST Invoice Template (2)|
|Category||Sales Invoice Template|
|Release Date||Monday, March 3, 2014|
|Format (XLS or XLSX)||.xlsx|
|Excel Version||Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016 / Excel 2019|
|Line Height (Points)||19.50|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|
September 27, 2018
May 13, 2019