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.
409 KBDownload

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

Screenshot

screenshot for Hong Kong Service Invoice Template

Detail

This template for Hong Kong service businesses is built for translation services, but you can easily adapt it for other service businesses too. The form includes four columns, including a user-defined date column for you to detail the date when the service was performed.

At the bottom of the form, there is a discount field. This is an amount field. The following formula for the "oknDiscountedSubTotal" calculates the discounted total:

=oknSubTotal-oknInvDiscount

The formula for 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)

The tax cells on the worksheet were 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)

There is also a declaration attached to the bottom of the sheet, like this:

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 the translation is reserved until complete payment of the invoice amount.

Format and Specification

Template#c5114
Belongs to

Service

Format (XLS or XLSX).xlsx
Columns5
Lines8
Line Height (Points)37.50
Print Area$F$3:$M$38
Papaer OrientationPortrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35
PriceFree