Skip to main content
InvoicingTemplate.com main content
Sharing Is Caring! We do appreciate your efforts to let others know us!

Screenshots and Images

The printed version.

Hong Kong Service Invoice Template

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)

Hong Kong Service Invoice Template - UIS edition

Download - Hong Kong Service Invoice Template

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

91 KBDownload

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

338 KBDownload

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

2.81 MBDownload

Detail

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":

=oknSubTotal-oknInvDiscount

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.

Format and Specification

Template#c5114
NameHong Kong Service Invoice Template
CategoryService Invoice Template
Release DateWednesday, April 5, 2017
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Columns5
Lines8
Line Height (Points)37.50
Print Area$F$3:$M$38
Printable with Papaer Size / OrientationHong Kong Service Invoice Template - Portrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35