Skip to main content
InvoicingTemplate.com main content

Australian GST Invoice Templatec7018

Australian GST Billing Form

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

...(105) Although it is easy to create the layout and format of Australian GST Invoice Template 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 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, Excel formulas are also used to create the relationship between several fields, such as one field should be the sum of two other fields.

Simple Invoice for Letterhead Paperc4074

Simple Invoice Format for Letterhead Paper

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

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

South Africa Tax Invoice Template (Sales)c4036

South Africa Tax Billing Format (Sales)

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

...(65) In order to comply with VAT regulations, for any sale of more than R50, you have to issue a tax invoice, with the word "tax invoice" printed on it. This is the most important document in the VAT system. The VAT Act prescribes that a tax invoice must contain certain details about the taxable supply as well as the parties to the transaction. This includes:

  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.

New Zealand Tax Invoice Templatec4038

New Zealand Tax Billing Form

"New Zealand Tax Billing Form" was found to be relative to Tax Invoice Templates with the score grade of 87.

...(90) (Note that if you have installed the latest version of our invoicing software, Uniform Invoice Software, which is able to upgrade a simple template in Microsoft Excel spreadsheet format into a complete invoicing system, you don't have to replace the logo image manually - you can replace the default logo image by clicking the "Replace Logo Image" button on the ribbon tab in Excel 2007, Excel 2010 and Excel 2013). To replace the default LOGO image in New Zealand Tax Invoice Template with your own image, follow the steps below:

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

...(27) This Invoice Template with Tax Column includes both the "Bill To" and "Shipping To" sections and has 5 columns that are description, Tax, Hours, Rate/Hour, and Amount.

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

...(61) This formula means that, if the "Taxable" checkbox is checked on the first line of the invoice body (identified by the " oknTaxable_1" cell value), it calculates tax amount based on line total and tax rate. If the "Taxable" checkbox is not checked, it shows either an empty string or the symbol "-" depending on whether the line total is zero.

Hourly Service Bill Sample (Price Including Tax)c5068

Hourly Service Billing Statement (Price Including Tax)

"Hourly Service Bill Sample (Price Including Tax)" was found to be relative to Tax Invoice Templates with the score grade of 79.

...(140) Uniform Invoice Software support custom fields or user-defined fields, which is a unique feature that allows you to add new fields to the backend database as well as to the spreadsheet form. Hourly Service Invoice Template (Price Including Tax) uses custom fields to implement the features that are not available in the default template shipped with the invoicing program. With the support for custom fields in the database, Uniform Invoice Software has the ability to manipulate the newly added fields in database, includes adding them to reports. With the support for custom fields in the Excel worksheet, our invoicing app has the ability to create the relationship between fields - for example, one field should be the sum of the other fields, or the value of one field should be calculated only when another field value equals a certain value.

Blank Service Invoice Template with Auspicious Clouds Borderc3020

Blank Service Bill Format with Auspicious Clouds Border

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

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

...(29) This template has one tax by default on the bottom of the invoicing form, which is suitable for most states inside U.S., as currently there is no National Sales

...(89) Tax in the U.S. There are no overriding legal requirements for an invoice in the US; there is no specific provision in the UCC regarding the format or process for issuing an invoice. However if you have to collect local sales tax, you can set the number of taxes appear on the form by clicking the "Settings" button and then go to the "Taxes" tab. Consult municipal and county statute to find applicable local sales tax rates. See more samples for tax invoices in the tax invoice template topic.

South Africa Tax Invoice Template (Service)c4037

South Africa Tax Invoice Template (Service)

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

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

...(146) The printable area, or print area, is the area with white background on the center of the South Africa Tax Invoice Template (Service) spreadsheet. By default Microsoft Excel prints the entire worksheet when you issue the print command, but if the worksheet has a print area defined, such as what we do for South Africa Tax Invoice Template (Service), only the print area will print. You can add cells to expand the print area as needed, and you can clear the print area to print the entire worksheet again. If you need to recreate the print area definition, here are what to do: On the "Invoice" worksheet of the South Africa Tax Invoice Template (Service), select the cells that you want to define as the print area; On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set 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 63.

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

...(10) And, the Line Totals are calculate using this Excel formula:

  • Right click the Logo image, and then select Properties from the menu.
  • Click the Picture property, and then click the "..." button.
  • Browse to the folder containing your icon file. Select and open the icon file.
  • Close the Properties dialog box.
  • Drag the border of the image object to resize it, if needed.

ABN Tax Invoicec7028

ABN Tax Invoice

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

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

...(75) With this revised template we also removed all the "looking up" (magnifying glass icons) buttons from the template, since Uniform Invoice Software is now included a useful feature that is called "on-sheet picker", which provides a smart button that shown automatically whenever you click a supported field / cell - by using this button, you can easily pick-up a customer, a shipping address, one or several product items, a sales person, a payment term, etc.

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

  1. Backup the template (as always).
  2. Switch to design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab. All the template here on Invoicing Template are protected by default, but with no password set. The purpose of enabling protection is to prevent end users from altering the design of the template accidently.
  3. Select all the cells on the top line that we'll marge, in this case, $D$3:$N$3.
  4. On Excel "Home" ribbon tab, click "Merge and Center".
  5. Right-click the merged cell and choose "Format Cells".
  6. Switch to the "Fill" tab.
  7. Click "Fill Effects".
  8. From "Colors" section, choose "Two colors", make the "color 1" is white and "color 2" is blue.
  9. From "Shading Style" section choose "From corner".
  10. Click one of the fill effect from the "Variants" section.
  11. Click OK to close the "Fill Effects" dialog box.
  12. Click OK to close the "Format Cells" dialog box.
  13. "Your Hotel Name" is a placeholder for your hotel / business name. Before you can create your first invoice, you need to replace it with your business name.
  14. The "RECEIPT" title is now implemented as a text box. Compared to regular text on the spreadsheet form, adding text and label using text box gives you more options on formatting and placing text. Click to select the "RECEIPT" title, the "DRAWING TOOLS / Format" ribbon tab appears, where you have full control over the style and appearance of the text box. In this sample, we simply choose one of preset WordArt Style.
  15. Once you've done customization on the hotel receipt template, click "Design Mode" button again on the "Invoice" ribbon tab to exit design mode. This protect the "Invoice" worksheet and hide gridlines and row/column headings.
  16. Click the Save button on Excel quick access toolbar to save the template.

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

...(228) When working with Uniform Invoice Software (UIS) version of Jamaica Tax Invoice Template, how does UIS know to which cell when a field value write to when loading data from the database, and to which field a cell value must save when saving an invoice record, a customer or a product item? That is, how does UIS create the map or relationship between Excel cells on the template Jamaica Tax Invoice Template and database fields? The answer is by using names. For example, if the field name in the Product table in a database is "ProductType", it is writing to a cell named "oknProductType_?" (where ? is the line number of the invoicing item) when you pick up a product or item on creating an invoice, and when saving an invoice, all cells with the name "oknProductType_?" are saved to the "ProductType" field in the "InvBdy" database table. By using cell names, UIS allows you to move a cell on the form without breaking the feature depending on the field / cell. You can place the "Product Type" column either inside the printable area, which is printed when you issue the Print command in Excel or click the Print command on the "Invoice" worksheet form; or place the Product Type column outside the printable area, which will be included when you print or extract an invoice or receipt.

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

...(110) The idea to exclude the taxable boxes from printing is to move the controls out of the printable invoicing form which is identified by the special Excel range name "Print_Area". To find out what area on your template is defined as the print area, pull down the name list that is located on the left side of the formula bar, and on the bottom of the name list choose "Print_Area". Excel selects the area defined as the printable form on the current worksheet. You may need to switch the worksheet in to design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab if the worksheet is protected.

...(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 Invoicing Template - Price Including Tax" was found to be relative to Tax Invoice Templates with the score grade of 34.

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

...(14) To show/hide gridlines and row/column headers in Excel 2007, Excel 2010 and Excel 2013:

...(16) The gridlines and row/column headings could help a lot when design the layout of the form.

VAT Sales Invoicing Sample - Price Excluding Taxc6008

VAT Sales Invoicing Template - Price Excluding Tax

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

...(81) The support for custom fields makes it possible for even an end user who does not know programming at all, could add new features to her/his invoicing creator such as VAT Sales Invoicing Sample - Price Excluding Tax without writing one line of programming code. Feel free to Search and download more samples. Sometimes our customization samples are offered in two editions here on InvoicingTemplate.com, that are one freeware edition, and another edition that works only with our invoicing software installed.

VAT Service Invoice Template - Price Including Taxc6013

VAT Service Invoicing Template - Price Including Tax

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

...(69) Once VAT Service Invoice Template - Price Including Tax 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.

...(105) While the free version of VAT Service Invoice Template - Price Including Tax is simple, the result created by using this template is as beautiful and professional as many commercial invoicing software program, or even better. It is an ideal tool for small businesses and freelances who offer services and don't need a shipping section on their invoicing form. It is a good service bill creator, but if you need more features, like management of customers, products / service items, invoices and payments, just install Uniform Invoice Software to make all the buttons on VAT Service Invoice Template - Price Including Tax work for you.

VAT Service Invoice Template - Price Excluding Taxc6014

VAT Service Invoice 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 25.

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

Mixed Tax Rates (5 Columns)c5034

Mixed Tax Rates in an Invoicing Form (5 Columns)

"Mixed Tax Rates (5 Columns)" was found to be relative to Tax Invoice Templates with the score grade of 25.

...(84)Mixed Tax Rates (5 Columns), like the default template, has two tax items on the bottom of the worksheet, which are applied to all the items, and a column of Taxable checkboxes to the left of the form body, which are corresponding to each invoicing item. You can change the tax names and rates on the bottom of the form by typing in whatever meet your requirements. These are the supported features implemented in both the freeware version and the Uniform Invoice Software version.

4-Column without Taxc4002

4-Column Invoice Template

"4-Column without Tax" was found to be relative to Tax Invoice Templates with the score grade of 25.

...(87) If you have Uniform Invoice Software installed, setting tax types is as easy as clicking several buttons. For example, if you find a template here on InvoicingTemplate.com interesting but don't need tax fields, you can set it to non-tax by firstly clicking the Settings button on the Invoice worksheet, and then go to the Taxes tab of the Settings dialog box. The Taxes tab offers 3 options, non-tax, one-tax and two-tax. Tax names and rates can also be set on the "Taxes" page of the Settings window.

Recipient Created Tax Invoices Formc4077

Template for Purchaser Created Tax Invoices

"Recipient Created Tax Invoices Form" was found to be relative to Tax Invoice Templates with the score grade of 7.

...(145) This invoice template for purchaser created tax invoices mimics the fields defined in the Australian Taxation Office pdf sample (NAT 73657), with only one field addition - the "Invoice#", placed above the "Invoice Date" field, as we believe it is a useful field / information for both parties (the seller and the buyer) involved in the transaction. If you have Uniform Invoice Software installed, the automatic invoice numbering feature is able to generate invoice numbers for you. The invoice generator works when you click the "Save Invoice" command and leave the "Invoice#" field empty. The sequential numbering generator provides several options that you can use to control how it works, including the next start number, the prefix text added to each invoice#, the number of digits in each invoice# (for example, "INV003" has 3 digits in the invoice#). See simple invoice templates for more samples.

...(40) On the upper-side of the invoice form you will find two sections "From Recipient" and "To-Supplier", where you, the buyer and the creator of the RCTI invoice, should provide detailed information about both businesses, both including Australian Business Number (ABN).

Specifications

Template#
Title
Release Date
Lines
Columns
Paper
Orientation
Category
c7018
Australian GST Invoice Template
Saturday, March 1, 2014,
17
7
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
c4038
New Zealand Tax Invoice Template
Tuesday, August 4, 2015,
12
4
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
c5034
Mixed Tax Rates (5 Columns)
Sunday, November 24, 2013,
12
5
A4
Portrait
Sales
c4002
4-Column without Tax
Saturday, November 2, 2013,
12
4
A4
Portrait
Service
c4077
Recipient Created Tax Invoices Form
Monday, July 4, 2016,
8
4
A4
Portrait
Sales

What Is Hot

Feature Galleries