InvoicingTemplate.com main content

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

Download this if you have already installed the Microsoft Store edition of Invoice Manager for Excel, and are looking for additional customized templates.

487 KBDownload

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

5.81 MBDownload

Screenshots and Images

The printed version.

VAT Invoicing Sample with 2 Separate Rates

Open the template in Excel.

VAT Invoicing Sample with 2 Separate Rates (IMFE Edition)

Detail

VAT Invoice Template with 2 Separate Rates was originally published on office-kit.com as a sample on customizing the default template included in Invoice Manager for Excel and a sample on using custom fields. It applies one of the defined VAT rates to each product / item depending on its tax category.

Unlike the previously released c5005 VAT invoicing sample, InvoicingTemplate.com revised this template and add the default LOGO image back to the invoicing template, at the top center of the spreadsheet. In case you don't need it, you can move it out of the printable area, or delete it completely. To do this, you'll have to first unprotect the spreadsheet, and then switch to design mode.

Once the worksheet is unprotected and switched to design mode, you can move the logo image by dragging and dropping. Or to delete it completely, click to select it and hit DEL key on your keyboard.

To use the template

  1. Set VAT tax rates.

    Open the template in Excel. Click the Settings button. On the Taxes tab specify the tax rates for the two VAT taxes. Click Apply.

  2. Create new customer accounts.

    New customers can be added by either clicking the Save As New Customer button on the Excel spreadsheet form, or by using the New Customer window that can be opened by clicking the Customers button on the Invoice worksheet.

    In either way, you can enter the VAT ID (VAT #) of the customer.

    When creating invoices, you pick up a customer by clicking the icon button, the VAT ID of the customer is retrieved along with other customer information. If a VAT ID is present, the invoice is VAT free.

  3. Create product/service items.

    To add new products, click the Products button on the Invoice worksheet, and then click Add Product. On the New Product window, you can find a TaxCategory field on the Custom Fields tab; with this field you can specify the tax category of the current product or service item. Please make sure the tax category you enter here matches the tax name you enter on the Settings window.

Custom fields

This sample uses several custom fields to implement the feature that are not found in the default template shipped with Invoice Manager for Excel.

This template added custom fields to Customer, Product, Invoice Header and Invoice Body database tables.

If your items have two VAT rates, download this template for free and test it to see if it meets your business requirements, or use it as a starting point of creating your own invoicing form. Remember that Microsoft Excel already provides all the tools you need to customize the template.

Format and Specification

Template#c5005
NameVAT Invoicing Sample with 2 Separate Rates
CategorySales Invoice Template
Release DateSaturday, April 26, 2014
Format (XLS or XLSX).xlsx
Feature Gallery
Columns5
Lines12
Line Height (Points)19.50
Print Area$F$2:$N$42
Papaer Size / OrientationPortrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35
PriceFree (0.00 USD)
SystemWindows 7 and later, and Excel 2007 and later.

Update History

August 27, 2018

  • This template was updated to be compatible with UIS 6.

Samples

Thumbnail for VAT Service Invoice Template - Price Including Tax
Thumbnail for Service VAT Invoice Template
Thumbnail for VAT Service Invoice Template - Price Excluding Tax
Thumbnail for VAT Invoice Template with VAT Rate Column
Thumbnail for VAT Invoicing Template with VAT Rate and Amount Column
Thumbnail for VAT Sales Invoice Template - Price Including Tax
Thumbnail for VAT Sales Invoicing Sample - Price Excluding Tax