Skip to main content
InvoicingTemplate.com main content

Australian GST Invoice Templatec7018

Australian GST Billing Form

"Australian GST Invoice Template" was found to be relative to Tax Invoice Templates with the score grade of 97.

...(34) Australian GST Invoice Template is a sample of customization of the default sales invoice template. Australian GST Invoice Template implements the invoice layout and form according to Australian Government / Australian Taxation Office requirements.

  • the identity of the supplier, such as the business name at the top
  • the Australian business number (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, 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.

Multiple Tax Rates on One Invoicec5016

Multiple Tax Rates on One Invoice

"Multiple Tax Types on One Invoice" was found to be relative to Tax Invoice Templates with the score grade of 97.

...(52) This template was originally published on office-kit.com as C5-016, and here on InvoicingTemplate.com there were already customized layouts created based on C5-016, such as c5034 Mixed Tax Rates (5 Columns), and c5035 Mixed Tax Rates in an Invoice (7 Columns). For more samples and formats related to taxing, visit tax invoice template.

...(77) The default invoice template does allow you to choose tax-type with 3 options: no-tax, one tax and two taxes, but this option is applied to all the items on the invoice form. This slightly-customized invoice template differs from the default invoice template in that it allows you, on the single invoice form, to have some products with no tax, some products with one tax (such as GST) and some products with two (such as GST and PST).

Simple Invoice for Letterhead Paperc4074

Simple Invoice Format for Letterhead Paper

"Simple Invoice Format for Letterhead Paper" was found to be relative to Tax Invoice Templates with the score grade of 91.

...(41) This simple invoice template is suitable for printing on papers with letterhead. It contains both a "Bill To" and a "Ship To" sections, categorized as sales invoice template. The 4 columns on the detail section are Quantity, Description, Price and Amount.

  1. Click the Settings button on the "Invoice" ribbon tab. Note that if Excel does not show the "Invoice" ribbon tab, make sure Uniform Invoice Software is installed, which is our invoicing software that makes the invoice template a powerful invoicing and billing software program.
  2. Go to the "Taxes" tab.
  3. First choose the tax type - one tax, two taxes or non-tax. And then set the tax names and rates.
  4. Click "Apply". This command modifies the template by hiding / showing tax lines and set some hidden variables to control how the tax formulas calculating taxes. If you are using a heavily customized template, where the tax lines / formulas are modified / rearranged, this command may not work properly.

...(23) Once you have finished your design work for Simple Invoice for Letterhead Paper, click the Design Mode button again to exit design mode.

South Africa Tax Invoice Template (Sales)c4036

South Africa Tax Invoice Template (Sales)

"South Africa Tax Billing Format (Sales)" was found to be relative to Tax Invoice Templates with the score grade of 87.

...(42) To create a valid tax invoice that meets the requirements from South African Revenue Services (SARS), your invoice template should have formatted in a professional way. Download South Africa Tax Invoice Template (Sales) for free and start creating professional invoices in minutes.

  1. The value of the goods/services excluding VAT
  2. The VAT amount (calculated at 14% of the above amount)
  3. The value of the goods/services including VAT
  4. The name, address and VAT registration number of the person buying the goods/services
  5. And your own name, address and VAT registration number.

GST and PST Invoice Templatec7031

GST and PST Billing Form

"GST and PST Billing Form" was found to be relative to Tax Invoice Templates with the score grade of 82.

...(74) This template was originally published on office-kit.com as C7-006. Here on InvoicingTemplate.com there are several customized version for this format: c7006 Handyman Invoice Template, c5055 Handyman Invoice Template (Sales Tax), and Handyman Bill Sample (No Tax). If you charge HST (Harmonized Sales Tax), visit our sample invoice template in Excel format at Canadian Invoice Template with HST. All of our templates come with a PDF sample invoice which you can download for free too.

...(47) The "Is Service" field appears as a checkbox on the Product Edit window, and its underlying value stored in the backend database is an integer - For a service whose box is checked on the Product Edit window, its underlying value is 1; otherwise it is 0.

New Zealand Tax Invoice Templatec4038

New Zealand Tax Invoice Template

"New Zealand Tax Invoice Template" was found to be relative to Tax Invoice Templates with the score grade of 79.

...(86) As you can see from New Zealand Tax Invoice Template, one benefit of using Excel as your invoice creator, as compared to other template formats like Microsoft Word invoice template and PDF invoice template, HTML format or even Photoshop format, is that you can easily apply formulas to do calculations. This means that, once the basic figures are entered on the form, like Quantity and Unit Price, or Hours and Hourly Rate, or Days and Daily Rate, the calculation of totals and taxes is done automatically.

Excel Formula to Fix the Decimal Size Warningc5112

Excel Formula to Fix the Decimal Size Warning

"Excel Formula to Fix the Decimal Size Error" was found to be relative to Tax Invoice Templates with the score grade of 79.

...(92) When our invoicing program is called Excel Invoice Manager, a built-in feature automatically rounds decimal values to the size (or precision and scale) as what defined in the underlying Microsoft Access database. For example, the "Line total" is usually defined as "Decimal (10,2)", which means it allows up to 10 digits in the decimal value, and up to 2 digits after the decimal point. If the line total being saved is "10.123", it is automatically rounded to "10.12" and the invoice is successfully saved, plus a new invoice# is generated when needed.

Invoice Template with Tax Columnc5001

Billing Form with Tax Column

"Billing Form with Tax Column" was found to be relative to Tax Invoice Templates with the score grade of 67.

...(100) Although the invoice template includes fields for shipping information, the body part has columns titled with "Hours" and "Rate/Hour". If you don't like these two headings, you can easily change them to Quantity and Unit Price by simply unprotect the Invoice worksheet and then type in your own text labels. However these are not the interesting parts of this invoice template. The special point of this invoice template is that it includes a Tax column, which shows the tax amount calculated based on tax rate (specified on the bottom of the form), line total and status of the "Taxable" checkbox.

...(12) The Excel formula of the tax amount cells are like the following.

Hourly Service Bill Sample (Price Including Tax)c5068

Hourly Service Billing Statement (Price Including Tax)

"Hourly Service Billing Statement (Price Including Tax)" was found to be relative to Tax Invoice Templates with the score grade of 63.

...(95) A VAT sales invoicing format is also available here on InvoicingTemplate.com, at c6007 VAT Sales Invoicing Format - Price Including Tax. The VAT service billing design is located at c6013 VAT Service Billing Form - Price Including Tax. If you would like a version where prices excluding taxes, see c5069 Hourly Service (Price Excluding Tax). Or, the sales VAT version where the prices excluding taxes, is located at c6008 VAT Sales - Price Excluding Tax. Or, the service VAT version where the prices excluding taxes, is located at c6014 VAT Service - Price Excluding Tax.

Blank Service Invoice Template with Auspicious Clouds Borderc3020

Blank Service Invoice Template with Auspicious Clouds Border

"Blank Service Bill Format with Auspicious Clouds Border" was found to be relative to Tax Invoice Templates with the score grade of 49.

...(49) This blank invoice template adopted Chinese auspicious clouds borders to beautify the bill form. The borders does not show when you are creating or editing an invoice, but it is printable with the billing form, and will also be included in the PDF blank service invoice generated with UIS.

...(38) This form design, c3020 Blank Service Invoice Template with Auspicious Clouds Border / Blank Service Bill Format with Auspicious Clouds Border has exactly the same layout and fields as c3019, but with a different color schema and border.

South Africa Tax Invoice Template (Service)c4037

South Africa Tax Billing Format (Service)

"South Africa Tax Billing Format (Service)" was found to be relative to Tax Invoice Templates with the score grade of 42.

...(101) As SARS (South African Revenue Services) states, any person that carries on a business may register for VAT. The term person is not only limited to companies but also includes, amongst others, individuals, partnerships, trust funds, foreign donor funded projects and municipalities. In order to register, an application form must be completed and a specific process must be followed, both of which you can find on the SARS web site. It is mandatory for a person to register for VAT if the taxable supplies made or to be made is, in excess of R1 million in any consecutive twelve month period.

...(30) This invoice template, South Africa Tax Billing Format (Service), was created from South Africa Tax Billing Format (Sales), by moving the Shipping To address section out of the Print Area.

Hourly Service Invoice Template (Price Excluding Tax)c5069

Hourly Service Invoice Template (Price Excluding Tax)

"Hourly Service Invoice Template (Price Excluding Tax)" was found to be relative to Tax Invoice Templates with the score grade of 39.

...(82) The previous sample template, c5068 Hourly Service Bill Sample (Price Including Tax), is also based on Hourly Service Bill Sample, and also added a new Tax column. However with c5068, the prices include tax. In this template, c5069 Hourly Service Bill Sample (Price Excluding Tax) or Hourly Service Billing Statement (Price Excluding Tax), the definition of prices include no tax. If you want to change the currency symbol of these hourly service billing formats, see c4026 Hourly Service Bill Sample (UK Currency).

...(17) Since the prices in this template don't include tax, it uses the following formula to calculate tax,

ABN Tax Invoicec7028

ABN Tax Invoice Format

"ABN Tax Invoice" was found to be relative to Tax Invoice Templates with the score grade of 39.

...(61) This template is a revised version of our original designs, Australian GST Invoice Template and Australian GST Invoice Template (2). With this new template, we move the ABN# field to the top of the invoice form, and also modify the layout of the form to make it looks better and works more smoothly with the latest version of Uniform Invoice Software.

...(64) Once ABN Tax Invoice is unprotected and switched into design mode, you can now move the controls to the new location you like. To do this, click to select a control, or push the CTRL on your keyboard and then select all the controls you want to move using mouse. Then, drag (one of) the select controls to move them to the new location.

Hotel Receipt Format with Blue Gradient Designc7027

Hotel Receipt Format with Blue Gradient Design

"Hotel Receipt Format with Blue Gradient Design" was found to be relative to Tax Invoice Templates with the score grade of 34.

...(38) The design of this receipt template is based on is based on c7005 Hotel Receipt Template. This revised edition includes basically the same fields as the original design, but added several blue gradient elements to make it beautiful.

...(12) So to create this blue gradient bar, we followed the steps below.

...(59) With this template, we've changed the number of taxes to one. This is done by clicking the Settings button on the "Invoice" worksheet, and then on the "Taxes" tab choose the proper tax type, name and rate. Does your hotel need more complex taxing options? See our tax invoice template samples that show how the taxing could be customized.

Jamaica Tax Invoice Templatec5072

Jamaica Tax Billing Format

"Jamaica Tax Invoice Template" was found to be relative to Tax Invoice Templates with the score grade of 31.

...(110) Jamaica Tax Invoice Template adheres to the requirements detailed on Tax Administration Jamaica (TAJ). It implements the auto calculation of tax - GCT, i.e. General Consumption Tax. The GCT is a value added tax which is applied on the value added to goods and services at each stage in the production and distribution chain. It is a tax on consumption and is included in the final price the consumer pays for goods and services. As a Registered Taxpayer, you must issue a tax invoice for sale made to another Registered Taxpayer. In the case of sales to other persons, you should issue an invoice or a receipt for each transaction.

Simple Sample - Moving Taxable Controlsc5076

Simple Invoicing Format - Moving Taxable Controls

"Simple Sample - Moving Taxable Controls" was found to be relative to Tax Invoice Templates with the score grade of 30.

...(55) This simple invoicing template shows you how to create a billing format that exclude the taxable boxes from the printable form. This sample is based on the result of c5075 Simple Invoice Template - Moving Balance and Payment Cells. The customized template created in this tutorial could be downloaded for free from here on InvoicingTemplate.com.

...(64) Now let's see how to move the Taxable controls. There are in fact two forms of taxable controls implemented in the templates available here on InvoicingTemplate.com. Some of them are implemented as ActiveX controls, and some of them are implemented as Office form controls. No matter what the control types are, the steps required to move the controls are the same, as detailed below.

VAT Sales Invoice Template - Price Including Taxc6007

VAT Sales Invoicing Template - Price Including Tax

"VAT Sales Invoice Template - Price Including Tax" was found to be relative to Tax Invoice Templates with the score grade of 25.

...(87) As the name implies, the price on this template including tax, so that the total, which is calculated by "Price * Quantity", includes the VAT amount. The VAT amount column inside the printable invoicing form is calculated with the formula "Total (VAT) - Total (Net), where the "Total (Net)" is calculated with a formula like "Total including VAT / (1 + VAT Rate)" if the item that is being invoiced is taxable; or the "Total (Net)" equals to "Total (VAT)" if the current item is not taxable.

...(40) 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.

VAT Sales Invoicing Sample - Price Excluding Taxc6008

VAT Sales Invoicing Template - Price Excluding Tax

"VAT Sales Invoicing Template - Price Excluding Tax" was found to be relative to Tax Invoice Templates with the score grade of 25.

...(84) While all the free invoicing templates available here on InvoicingTemplate.com are results of customization samples of the default sales invoice format shipped with Uniform Invoicing Software, this spreadsheet template, VAT Sales Billing Format - Price Excluding Tax, use custom fields to implement the features that are not available in the default sales invoicing template. If you use the UIS version of this template, you can easily add new fields to the template and make sure they work with UIS with the "Custom Field Manager".

VAT Service Invoice Template - Price Including Taxc6013

VAT Service Invoice Template - Price Including Tax

"VAT Service Invoicing Template - Price Including Tax" was found to be relative to Tax Invoice Templates with the score grade of 25.

  • In Excel 2003 click the Design Mode button on the Control Toolbox toolbar. Tip: If the Control Toolbox toolbar is invisible, click Excel menu View > Toolbars > Control Toolbox.
  • In Excel 2007, Excel 2010 and Excel 2013, click the Design Mode button in the Controls group of the Developer tab.

    TIP: If the Developer tab is not available in Excel 2007, do the following to display it: a) Click Microsoft Office Button, and then click Excel Options; b) In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.

    Or in Excel 2010 and Excel 2013 to display the Developer tab: a) Click File > Options > Customize Ribbon; b) In the area on the right, ensure that the box next to Developer is checked; c) When you click OK, the Developer tab will appear in the ribbon.

VAT Service Invoice Template - Price Excluding Taxc6014

VAT Service Invoicing Template - Price Excluding Tax

"VAT Service Invoicing Template - Price Excluding Tax" was found to be relative to Tax Invoice Templates with the score grade of 7.

...(138) The VAT service invoice template helps you to create invoices associated with both professional and non-professional services: legal, medical or accounting, freelance work, consulting, handyman work, housecleaning and babysitting, landscaping and gardening, auto repairs, catering, child care, pet care, tutoring, and other services. It is a simple, easy to use, free Excel invoice template that can be customized to fit your specific circumstance. If you work as an independent contractor or own a small company that performs a specialized service, the odds are that you will need to learn how to write an invoice for services rendered to acquire your due payment. This VAT invoice template could be a handy tool for you to get the job done. If you are a UK-based business, InvoicingTemplate.com has another VAT service invoice template for you at Service VAT Invoice Template.

Specifications

Template#
Title
Release Date
Lines
Columns
Paper
Orientation
Category
c7018
Australian GST Invoice Template
Saturday, March 1, 2014,
17
7
A4
Portrait
Sales
c5016
Multiple Tax Rates on One Invoice
Friday, March 17, 2017,
12
5
A4
Portrait
Sales
c4074
Simple Invoice for Letterhead Paper
Sunday, June 26, 2016,
20
4
A4
Portrait
Sales
c4036
South Africa Tax Invoice Template (Sales)
Saturday, August 1, 2015,
12
4
A4
Portrait
Sales
c7031
GST and PST Invoice Template
Monday, March 20, 2017,
12
7
A4
Portrait
Sales
c4038
New Zealand Tax Invoice Template
Tuesday, August 4, 2015,
12
4
A4
Portrait
Sales
c5112
Excel Formula to Fix the Decimal Size Warning
Sunday, April 2, 2017,
12
5
A4
Portrait
Sales
c5001
Invoice Template with Tax Column
Tuesday, November 5, 2013,
12
5
A4
Portrait
Sales
c5068
Hourly Service Bill Sample (Price Including Tax)
Tuesday, September 30, 2014,
12
5
A4
Portrait
Service
c3020
Blank Service Invoice Template with Auspicious Clouds Border
Tuesday, December 5, 2017,
8
3
A4
Portrait
Service
c4037
South Africa Tax Invoice Template (Service)
Sunday, August 2, 2015,
12
4
A4
Portrait
Service
c5069
Hourly Service Invoice Template (Price Excluding Tax)
Wednesday, October 1, 2014,
12
5
A4
Portrait
Service
c7028
ABN Tax Invoice
Sunday, July 3, 2016,
17
7
A4
Portrait
Sales
c7027
Hotel Receipt Format with Blue Gradient Design
Wednesday, June 29, 2016,
12
7
A4
Portrait
Receipt
c5072
Jamaica Tax Invoice Template
Monday, August 3, 2015,
12
5
A4
Portrait
Sales
c5076
Simple Sample - Moving Taxable Controls
Wednesday, January 27, 2016,
12
5
A4
Portrait
Sales
c6007
VAT Sales Invoice Template - Price Including Tax
Monday, May 26, 2014,
18
6
A4
Portrait
Sales
c6008
VAT Sales Invoicing Sample - Price Excluding Tax
Tuesday, May 27, 2014,
18
6
A4
Portrait
Sales
c6013
VAT Service Invoice Template - Price Including Tax
Wednesday, May 28, 2014,
18
6
A4
Portrait
Service
c6014
VAT Service Invoice Template - Price Excluding Tax
Thursday, May 29, 2014,
18
6
A4
Portrait
Service

What Is Hot

Feature Galleries