Skip to main content
InvoicingTemplate.com main content

VAT Sales Invoice Template - Price Including Tax - Screenshots and Images

The printed version.

VAT Sales Invoice Template - Price Including Tax

VAT Sales Invoice Template - Price Including Tax (c6007)

This is how the template looks like when you open the freeware template in Microsoft Excel.

VAT Sales Invoice Template - Price Including Tax - freeware edition

VAT Sales Invoice Template - Price Including Tax - freeware edition

The following template was designed for Uniform Invoice Software version 3.

VAT Sales Invoice Template - Price Including Tax - Uniform Invoice Software V3 edition

VAT Sales Invoice Template - Price Including Tax - Uniform Invoice Software V3 edition

Download

License: Private Use (not for distribution or resale). See our Terms of Use.

You are safe to download the resources. We've added our digital signatures to the files.

DescriptionSizeDownload

Without database file. How to download and use

78 KBDownload

Download this if you have already installed UIS, but are looking for additional customized templates.

917 KBDownload

Download this if you want this design to be set as the default template by the installer program.

2.81 MBDownload

Detail

This sales VAT invoice template in Microsoft Excel format includes 6 columns on the printable invoicing form, that are Description, Price (Including Tax), Quantity, Total (Net), VAT Amount, Total VAT.

This VAT invoicing template, VAT Sales Invoice Template - Price Including Tax, was originally publish on office-kit.com, at VAT Invoice Template - Price Including Tax, and also our company web site, Uniform Invoice Software, Excel Date Picker - Uniform Software LTD, at VAT Invoice (Price including Tax).

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.

A counter partner of this free VAT invoice template is also available here on InvoicingTemplate.com, at VAT Sales Invoice Template - Price Excluding Tax, which defines the price in the way that does not include VAT. Choose any template that suits your business requirements and download it for free.

Like many other invoicing templates here on Invoicing Templates, VAT Sales Invoicing Template - Price Including Tax has a default logo image on the top of the invoice form. To replace it with your default logo image, you need to first unprotect the invoice worksheet, and then put the spreadsheet into design mode.

The protection of the "Invoice" worksheet in VAT Sales Invoice Template - Price Including Tax 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 VAT Sales Invoice Template - Price Including Tax.

To show gridlines and row/column headers in Excel 2000 - 2003:

  1. Click and activate the worksheet you want to display gridlines and row/column headers for.
  2. On the Tools menu, click Options, and then click the View tab.
  3. Under Window options, check the Gridlines and Row & Column Headers check boxes.

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:

  1. Click and activate the worksheet you want to display gridlines and row/column headers for.
  2. Go to the View tab of the Ribbon.
  3. Click Show/Hide, and then check or uncheck the Gridlines and Headings options.

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

In design mode, Microsoft Excel allows you to move, add, or delete controls or images inside VAT Sales Invoice Template - Price Including Tax. Note that if you have our invoicing program installed, and you are running Excel 2007, Excel 2010 and Excel 2013, it already provides a Design Mode button on the ribbon tab, so that you don't have to switch to design mode manually. Our invoicing software is able to turn a simple spreadsheet into a powerful invoicing system, with the ability to manage customers, products, bills and payments, it also includes various tools that could help you configure the layout of your form, such as the number of taxes and tax names and rates. If you don't have our invoicing program installed, here are how you can switch to design mode manually.

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

Once you have finished your design work for VAT Sales Invoice Template - Price Including Tax, click the Design Mode button again to exit design mode.

(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 VAT Sales Invoice Template - Price Including Tax with your own image, follow the steps below:

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

If you don't need the LOGO image and want to delete it, simply hit the DEL key on your keyboard after you selected it with your mouse key. Deleting the LOGO image leaves an empty area to the left of the Company Information section. You may like to move the entire Company Information section to fill in the empty area. To do this: Drag your mouse to select the entire Company Information area, including Company Name, Street Address, City, ST Zip Code, etc.; Push your mouse key on the border of the selected area; drag it to the new location.

The VAT invoicing template (prices including tax) helps you get paid quickly and look stylish with its professional design. A PDF version of this free invoice template is also available here on InvoicingTemplate.com, which can be downloaded by clicking the PDF link on the right hand of this page. Our sleek, simple free invoice templates are created especially for freelancers, contractors and small business owners. These templates will work great for sole traders and limited companies alike. In case you are needing a more complete invoicing solution, and has the need of managing your customers, products or services, invoices and payments in an easy way, download and install Uniform Invoice Software.

VAT invoicing template (prices including tax) is a sales invoice template, meaning that it includes a shipping address section on the printable invoicing form. If you are running a service business, such as a consultant, you may like to see the service version, at VAT Service Invoice Template - Price Including Tax. If your prices are excluding taxes, then please download the free invoice template at VAT Service Invoice Template - Price Excluding Tax.

Like other form designs here on InvoicingTemplate.com, VAT Sales Invoicing Template - Price Including Tax 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 or 2016.

Format and Specification

Template#c6007
NameVAT Sales Invoice Template - Price Including Tax
CategorySales Invoice Template
Release DateMonday, May 26, 2014
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Columns6
Lines18
Line Height (Points)15.75
Print Area$G$1:$Q$139
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)
Left19.44
Right23.04
Top68.03
Bottom57.60