Skip to main content
InvoicingTemplate.com main content

VAT Invoicing Template with VAT Rate and Amount Columnc6003

VAT Invoicing Template with VAT Rate and Amount Column

"VAT Billing Template with VAT Rate and Amount Column" was found to be relative to Tax Invoice Template India with the score grade of 96.

...(53) The previous example, VAT Invoicing Template with VAT Rate and Amount Column (c6002), demonstrated how to create a new Excel invoicing template from c5005, which complies with the UK HMRC requirements of showing "the rate of VAT that applies to what's being sold". This sample Excel template shows the VAT amount column too.

...(22) This Excel template, just like the default template shipped with Uniform Invoice Software (UIS), has two taxes defined on the invoicing form.

...(21) In order to adhere to these rules and requirements, we added several custom fields to the default database shipped with UIS.

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 Template India with the score grade of 87.

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

  • 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 Invoice Template - Price Excluding Tax" was found to be relative to Tax Invoice Template India with the score grade of 82.

...(38) VAT Service Invoice Template - Price Excluding Tax is a sample invoice template demonstrating how to customize an existing invoice template, VAT Sales Invoice Template - Price Excluding Tax, to create a new design that meets your requirements.

...(40) In this serial of VAT invoice templates, InvoicingTemplate.com also offers you the other two VAT invoicing templates, where the prices include VAT, at VAT Sales Invoice Template - Price Including Tax, and VAT Service Invoice Template - Price Including Tax.

...(75) If you offer different product types that have different tax rates, it is better to details this fact on your invoices. InvoicingTemplate.com has designed such a template for you too, which is available at VAT Invoice Template with VAT Rate Column and VAT Invoice Template with 2 Separate Rates. If you need to show both the VAT rate and VAT amount for each invoicing item, visit VAT Invoice Template with VAT Rate and Amount Column.

VAT Service Invoice Template - Price Including Taxc6013

VAT Service Invoice Template - Price Including Tax

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

...(53) If you don't need the "Service Location" at all, as we did with many other service billing forms here on InvoicingTemplate.com, you can move the section completely out of the printable invoice form - i.e. the area named "Print_Area", you can easily do this by unprotecting the sheet and then dragging and dropping.

Note that if you use the Uniform Invoice Software and need to show the control on an extracted worksheet, then the control should be named with an "oknWidget_" prefix. For example, if you move the Taxable checkboxes into the

4-Column without Taxc4002

4-Column Invoice Template

"4-Column without Tax" was found to be relative to Tax Invoice Template India with the score grade of 57.

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

ABN Tax Invoicec7028

ABN Tax Invoice Format

"ABN Tax Invoice Format" was found to be relative to Tax Invoice Template India with the score grade of 51.

...(130) According to Australian Taxation Office, if your tax invoices meet the requirements for sales of $1,000 or more, you can also use them for sales of lesser amounts. So this template could be seen as a replacement of our original two formats. Furthermore, we redesigned the original "Taxable" checkboxes - in the original version, they are ActiveX controls; in this new version they are Excel / Office form controls. With the development of Microsoft Office / Excel, it seems that form controls get better support than old ActiveX controls. We've also moved all the "Taxable" controls into the printable forms, so that they will be included when printed (see the screenshot images below), or be included when you are generating PDF invoice (see all PDF invoice templates here on InvoicingTemplate.com).

Jamaica Tax Invoice Templatec5072

Jamaica Tax Invoice Template

"Jamaica Tax Billing Format" was found to be relative to Tax Invoice Template India with the score grade of 37.

...(34) As TAJ required, all Registered Taxpayers must issue a Tax Invoice to all other Registered Taxpayers to whom taxable goods or services are supplied. The tax invoice, which should be pre-numbered, must show the:

...(137) 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. Jamaica Tax Invoice Template 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.

UK Tax Invoice Templatec6005

UK Tax Billing Form

"UK Tax Invoice Template" was found to be relative to Tax Invoice Template India with the score grade of 33.

...(47) In certain trades (UK Construction, for example) it is customary for a list price to be given (on some, but not all products) and then a percentage discount to be applied. I.e. Quantity 1, List price of £81.57, discount of 65%, giving a line total of £28.55.

...(83) The taxable checkboxes were removed completely, assuming all the products are taxable, no matter whether the Taxable option is checked or not for each product. This avoids an occasionally happened mistake when a taxable product or item must be manually entered on the invoice body, as the Taxable checkbox is not checked by default. The template implements this feature by deleting all the Taxable checkboxes and assigning a value of 1 (TRUE) to all the oknTaxable cells located in the hidden column C.

Recipient Created Tax Invoices Formc4077

Template for Purchaser Created Tax Invoices

"Template for Purchaser Created Tax Invoices " was found to be relative to Tax Invoice Template India with the score grade of 33.

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

Blank Sales Invoice Layout (Two-tax)c2020

Blank Sales Invoice Sample (Two-tax)

"Blank Sales Invoice Layout (Two-tax)" was found to be relative to Tax Invoice Template India with the score grade of 20.

...(75) All templates that work with Uniform Invoice Software should be protected. This is highly recommended because without the protection, it is very easy to overwrite the static text labels (such as your company name, the column headings etc.) For this reason, Uniform Invoice Software even prompts on closing a template - if a template is not protected and you try to close it, it will prompt and ask you whether you want to protect it.

...(23) The default sales invoice template shipped with Uniform Invoice Software also has two taxes set by default, which are named GST and PST.

Mixed Tax Rates (5 Columns)c5034

Mixed Tax Rates in an Invoicing Form (5 Columns)

"Mixed Tax Rates in an Invoicing Form (5 Columns)" was found to be relative to Tax Invoice Template India with the score grade of 13.

...(138) 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. Mixed Tax Rates (5 Columns) 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.

Basic Blank Service Format (No-tax)c2012

Basic Blank Service Layout (No-tax)

"Basic Blank Service Format (No-tax)" was found to be relative to Tax Invoice Template India with the score grade of 10.

...(84) For an edition that supports one tax, please see Basic Blank Service Invoice Format (One-tax). For an edition that supports two taxes, please see Basic Blank Service Invoice Format (Two-taxes). If you need less lines but more space for each item description on your blank service invoice template, see Basic Blank Service Billing Format (No-tax, Long Description), and the one tax format at Basic Blank Service Invoicing Format (One-tax, Long Description), and the two-tax layout at Basic Blank Service Bill Format (Two-taxes, Long Description).

General Service Invoicec5012

General Service Invoice

"General Service Bill" was found to be relative to Tax Invoice Template India with the score grade of 7.

...(98) The "Date" column links to the "DateCompleted" field in the back end database. This database filed is not included in the default database packaged with Uniform Invoice Software setup program, so it is a custom field (or user-defined field). The custom field feature, combined with Microsoft Excel formulas, allows as to create many complex invoicing forms without breaking the support from Uniform Invoice Software. With Excel Invoice Manager, adding and updating custom fields should be done with a separate program called Custom Field Manager. With Uniform Invoice Software, it is now a built-in feature of the main program.

...(63) The "Amount" column is calculated automatically using Excel formulas from the "Quantity" and "Unit Price" columns. As you can see "Quantity" and "Unit Price" are the general column headings we used with many template here on InvoicingTemplate.com. If you wish, you can easily change them to "Hours" and "Rate". For more samples on this topic, visit free invoice template for hours and rate.

Simple Sample - Adding Discount Columnc4061

Simple Invoicing Sample - Discount Column

"Simple Sample - Adding Discount Column" was found to be relative to Tax Invoice Template India with the score grade of 6.

...(64) This tutorial differs from others in that it focus on the steps that we followed to add the "Discount" column. The basic template that we used as the origin and starting point of this tutorial already has a "Discount" field added, which is a manually fillable custom field. After adding the "Discount" column, we'll also use Excel formula for automated calculation of discount amount.

  1. First, back up the Excel invoice template and database file. In this sample, we'll need to modify the database, so creating a backup of the database is necessary.
  2. Open the template.
  3. Push down the "Design Mode" button on the "Invoice" ribbon tab.
  4. This is not a required step - but you may like to try it. Go to Excel "Page Layout" tab. In the "Themes" group, click to open the "Colors" list, choose "Blue".

    As you can see, the whole invoice form now has a new color theme now. Like the themes feature in Microsoft Word, this is the quick and best (easy) way to change the look & feel of the form.

  5. Drag your mouse to select all cells on the "Description" column, including the heading, ranging from $D$21 to $D$33. Click the "Merge and Center" button on Excel "Home" ribbon tab. This unmerges all the cells on the "Description" column.
  6. Drag your mouse to select all the cells on the "Quantity" column, including the heading, ranging from $I$21 to $I$33. Push the mouse key on the border of the selected area. Without releasing the mouse key, move the entire selected area on column left (Destination: $H$21:$H$33).
  7. Now select the entire "Unit Price" column, including the heading. Drag the select area one column left. The new location of the "Unit Price" column is now $I$21:$I$33.
  8. With the new "Unit Price" column still selected, click the "Format Painter" button on Excel "Home" ribbon tab.
  9. Click the first empty cell left by moving out the "Unit Price" column, i.e. $J$21. This applies the format of the "Unit Price" column to the empty column.
  10. Drag your mouse to select all the cells on the empty column, except the heading cell, ranging from $J$22 to $J$33. Right-click one of the selected cell, choose "Format Cells" from the shortcut menu. On the "Format Cells" dialog box, go to the "Protection" tab, make sure the "Locked" property is cleared. Click OK to close the dialog box. This makes sure that the "Discount" column is manually fillable when the sheet is protected.
  11. Click to select heading cell of the empty column, i.e. $J$21. Enter the column heading text "Discount".
  12. Name the following empty cells. The names should be "oknItemDiscount_1" ($J$22), "oknItemDiscount_2" ($J$23), "oknItemDiscount_3" ($J$24) ... "oknItemDiscount_12" ($J$33).
  13. Drag your mouse to select all the cells on the "Description" heading, ranging from $D$21 to $G$21. Click "Merge and Center" on Excel "Home" ribbon tab.
  14. Repeat the above step for each line of the "Description" field. For example, select $D$22:$G$22, click "Merge and Center"; select "$D$23:$G$23", click "Merge and Center", and so on. If you are very familiar with Microsoft Excel, you can also use "Format Painter" to speed up the processing of merging.
  15. Select all the "Description" cells, ranging from $D$22 to $G$33. Click "Align Left" icon button in the "Alignment" group on Excel "Home" ribbon.

    Click to select the "Discount (Amount)" cell, $K$35. Enter a formula for this cell, "=sum (J22:J33)". Right-click the same cell $K$35 again, and choose "Format Cells" from the dialog box. Go to the "Protection" tab, checked the "Locked" property. This makes sure that the cell is not manually fillable once the sheet is protected.

  16. Now we need to create the definition of the custom field "ItemDiscount" in the database. To do this, we need to use the "Custom Field Manager" provided by Uniform Invoice Software. In order to use this tool, we have to first exit design mode by clicking the "Design Mode" button again on the "Invoice" ribbon.
  17. Click "Invoices" on the ribbon.
  18. Click "Custom Fields".
  19. From the "Database table" list, choose "Invoice Body".
  20. Click "Add Field".
  21. Enter the field definition as follows - Name: ItemDiscount; Type: Decimal; Precision: 10; Scale: 2.

    The map between an Excel cell and a database field is established by using names. For the invoice body section, all "oknItemDiscount_*" fields are mapped to the "ItemDiscount" field defined in the "Invoice Body" database table. That is, a cell should be named with "okn + Database Field Name", where we call "okn" is a prefix of the cell name.

  22. Save the template by clicking the "Save" button on Excel quick access toolbar.
  23. Now you can test the template to see if it works in the way met our plan.

Specifications

Template#
Title
Release Date
Lines
Columns
Paper
Orientation
Category
c6003
VAT Invoicing Template with VAT Rate and Amount Column
Monday, May 12, 2014,
12
6
A4
Portrait
Sales
c6007
VAT Sales Invoice Template - Price Including Tax
Monday, May 26, 2014,
18
6
A4
Portrait
Sales
c6014
VAT Service Invoice Template - Price Excluding Tax
Thursday, May 29, 2014,
18
6
A4
Portrait
Service
c6013
VAT Service Invoice Template - Price Including Tax
Wednesday, May 28, 2014,
18
6
A4
Portrait
Service
c4002
4-Column without Tax
Saturday, November 2, 2013,
12
4
A4
Portrait
Service
c7028
ABN Tax Invoice
Sunday, July 3, 2016,
17
7
A4
Portrait
Sales
c5072
Jamaica Tax Invoice Template
Monday, August 3, 2015,
12
5
A4
Portrait
Sales
c6005
UK Tax Invoice Template
Monday, March 20, 2017,
15
6
A4
Portrait
Sales
c4077
Recipient Created Tax Invoices Form
Monday, July 4, 2016,
8
4
A4
Portrait
Sales
c2020
Blank Sales Invoice Layout (Two-tax)
Sunday, November 22, 2015,
12
2
A4
Portrait
Sales
c5034
Mixed Tax Rates (5 Columns)
Sunday, November 24, 2013,
12
5
A4
Portrait
Sales
c2012
Basic Blank Service Format (No-tax)
Sunday, November 15, 2015,
12
2
A4
Portrait
Service
c5012
General Service Invoice
Saturday, March 18, 2017,
12
5
A4
Portrait
Service
c4061
Simple Sample - Adding Discount Column
Sunday, February 7, 2016,
12
4
A4
Portrait
Sales

What Is Hot

Feature Galleries