InvoicingTemplate.com main content

Download

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

Download this if you have already installed the Microsoft Store edition of Invoice Manager for Excel, and are looking for additional customized templates.

539 KBDownload

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

5.79 MBDownload

Screenshots and Images

The printed version.

Hong Kong Service Invoice Template

Open the template in Excel.

Hong Kong Service Invoice Template (IMFE Edition)

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.

Format and Specification

Template#c5114
NameHong Kong Service Invoice Template
CategoryService Invoice Template
Release DateWednesday, April 5, 2017
Format (XLS or XLSX).xlsx
Columns5
Lines8
Line Height (Points)37.50
Print Area$F$3:$M$38
Papaer Size / OrientationPortrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35
PriceFree (0.00 USD)
SystemWindows 7 and later, and Excel 2007 and later.

Samples

Thumbnail for Customer Invoice Template
Thumbnail for Green Gradient Service Invoice
Thumbnail for Hourly Invoice Template
Thumbnail for Vehicle Rental and Travel
Thumbnail for HVAC Service Invoice
Thumbnail for Limousine Service Invoice with Notes
Thumbnail for Television Service