UniformSoftware main content

VAT Invoicing Sample with Two Separate Rates

Template#: c5005

Download

DescriptionSizeDownload

The template works with both the Microsoft Store edition and the desktop edition of the app. Make sure you have installed one of them.

How to use:

  1. Download the EXE package.
  2. Double-click to extract the files into a folder. Make sure you have full access privileges to the folder, such as a subfolder inside “My Documents”.
  3. Open the template.
449 KBDownload

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

Screenshot

The screen shot for VAT Invoicing Sample with Two Separate Rates

Detail

This form implements a feature that applies one of the defined VAT rates to each product depending on its tax category.

Follow the steps described below to use this 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 sheet or by using the "New Customer" window that can be opened by clicking the "Customers" button on the worksheet.

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

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

  3. Create product or service items.

    To add new products, click the "Products" button on the 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 in the "Settings" window.

Format and Specification

Template#c5005
Belongs to

Sales

Format (XLS or XLSX).xlsx
Columns5
Lines12
Line Height (Points)19.50
Print Area$F$2:$N$42
Papaer OrientationPortrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35
PriceFree