Hong Kong Service Invoice Template

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.