Assuming you have downloaded and installed Uniform Invoice Software:
Prefer to have a look at other samples? Try our Search tool!
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.
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|
|Printable with Papaer Size / Orientation||A4 (210 mm x 297 mm) - Portrait|
|Default Margins (Points)|
This classic hourly invoice template is a service invoice template with 5 columns. It is a work hours invoice template that calculates totals from hours worked and rate using Excel formulas for freelancers and other service providers. An hourly billing form in PDF format is also provided.
This UK VAT invoice template for service added a VAT rate drop down list to c4010 Service VAT Invoice Template. This allows you to pick a vat rate from the list on creating invoices, instead of type in manually. The drop down is implemented using Excel data validation feature.
This child care billing template or babysitting receipt template is a revisited version of the Parenting Service Invoice Template (c4-007) originally published on office-kit.com. Use this free printable Excel format to create and print bills and receipts for your babysitting, day care or childminder services.