You are safe to download the resources. We've added our digital signatures to the files.
Download this if you have already installed the Microsoft Store edition of Invoice Manager for Excel, and are looking for additional customized templates.
Download this if you want this design to be set as the default template by the installer program.
Screenshots and Images
The printed version.
Open the template in Excel.
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.
Format and Specification
|Name||Hong Kong Service Invoice Template|
|Category||Service Invoice Template|
|Release Date||Wednesday, April 5, 2017|
|Format (XLS or XLSX)||.xlsx|
|Line Height (Points)||37.50|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|
|Price||Free (0.00 USD)|
|System||Windows 7 and later, and Excel 2007 and later.|