Assuming you have downloaded and installed Uniform Invoice Software:
Prefer to have a look at other samples? Try our Search tool!
The printed version.
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
The following template was designed for Uniform Invoice Software version 3.
Australian GST Invoice Template (2) - Uniform Invoice Software V3 edition
You are safe to download the resources. We've added our digital signatures to the files.
Download this if you have already installed UIS, but are looking for additional customized templates.
Download this if you want this design to be set as the default template by the installer program.
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.
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:
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:
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.
|Name||Australian GST Invoice Template (2)|
|Category||Sales Invoice Template|
|Release Date||Monday, March 3, 2014|
|Format (XLS or XLSX)||.xls|
|Excel Version||Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016|
|Line Height (Points)||19.50|
|Printable with Papaer Size / Orientation||A4 (210 mm x 297 mm) - Portrait|
|Default Margins (Points)|
In Australia tax invoices are usually issued by the supplier or seller. However Australian Taxation Office also allows the purchaser or recipient of the goods or services to issue tax invoice for the purchases, knowns as recipient-created tax invoices (RCTI).
Basic Sales Invoice Template (Light Blue) is a slightly modified version of the standard Excel sales template shipped with Uniform Invoice Software installer program. The main features include a "Bill To" section, a "Shipping To" section, 3 columns on invoice body, no sales tax.
VAT Invoice Template with 2 Separate Rates was originally published on office-kit.com as a sample on customizing the default template included in Uniform Invoice Software and a sample on using custom fields. It applies one of the defined VAT rates to each product / item depending on its tax category.
Simple Sales Invoice Template without Item Description is a variant of Simple Service Invoice Template without Item Description. It differs from the original invoice format by including shipping fields inside the printable invoice form.
Sales Invoice Template with Discount Amount Column is a sample invoice template that adds a discount amount column to the default sales invoice template shipped with Uniform Invoice Software.