The printed version.
Hong Kong Service Invoice Template (c5114)
c5114 now includes the customized invoice template for the latest version of Uniform Invoice Software. This is what you will see when you open hong-kong-service-invoice-template-uis.xlsx.
Hong Kong Service Invoice Template - UIS edition
You are safe to download the resources. We've added our digital signatures to the files.
Without database file. How to download and use
Download this if you have already installed UIS, but are looking for additional customized templates.
Download this if you want this design to be set as the default template by the installer program.
This template for Hong Kong service businesses is built for translation service, but you can easily adapt it for other service business too. The form includes 4 columns, including a user-defined date column for you to detail the date when the service was performed.
On the form of the form, there is also a discount field. This is a discount amount, which is deducted from subtotal using the following Excel formula on calculating invoiced total, as shown in the formula assigned to the "oknDiscountedSubTotal":
The formula of the "Total" cell is also modified, which uses "oknDiscountedSubtotal" to replace the usual "oknSubtotal":
=ROUND(oknDiscountedSubtotal + oknShippingCost + IF(oknTaxType=0,0,IF(oknTaxType=1,oknTax1,oknTax1+oknTax2)),2)
By default this template shows no tax. If you pay tax, you can use the "Settings" dialog box to modify the template layout and design. Simply click the "Settings" button on the "Invoice" ribbon tab, then activate the "Tax" tab. Set tax type to "One tax", fill in tax name and rate properly. Visit Tax Rates on Hong Kong Inland Revenue Department for more information.
The tax cells on the worksheet is modified to use the discounted subtotal too. For example, this is the formula for the first tax cell:
=ROUND(IF(oknTaxType=0,0, oknTax1Rate*(oknDiscountedSubtotal+ IF(oknTaxTotalIncludingShippingCost=0,0, oknShippingCost))),2)
As you can see from the above formula, it now uses "oknDiscountedSubtotal" to calculate "oknTaxableSubtotal". This means all invoiced items are seen as taxable, no matter whether the "Taxable" option is checked or not on the "Product Edit" window.
On the bottom of the form, note there are annotation text -- " Unless otherwise agreed, all invoices are payable within 10 days by wire transfer to our bank account. (Bank account name and account number). Copyright of translation reserved until complete payment of the invoice amount. You may like to change the text according to your business requirements, especially if you are not running a translation service business.
The line total and total cells on the printable form are labeled with currency "HKD". If you are outside Hong Kong but still want to use this invoice form design, you may need to change the "HKD" currency symbol too. This change will not affect how the template does its calculations. You may also like to visit our Tax Invoice Templates.
Like other form designs here on InvoicingTemplate.com, Hong Kong Service Billing Form 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.
|Name||Hong Kong Service Invoice Template|
|Category||Service Invoice Template|
|Release Date||Wednesday, April 5, 2017|
|Format (XLS or XLSX)||.xlsx|
|Excel Version||Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016|
|Line Height (Points)||37.50|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|