BoostExcel main content



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

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


Designer Invoicing Format with Bamboo Chinese Painting


This template is based on the c4030. It adds a bamboo Chinese painting image as the background.

This form layout includes a column of "Taxable" checkboxes that are placed in column B, i.e., outside the printable section. The checkboxes are form controls that are named "oknWidget_taxable1, oknWidget_taxable2, oknWidget_taxable3,...". Each tax box is linked to a hidden cell.

We then use an Excel array formula to calculate the taxable subtotal:

{=SUM ( oknTaxable_1:oknTaxable_6 * oknLineTotal_1:oknLineTotal_6 )}

And then the tax is calculated using a formula like this:

=ROUND ( IF ( oknTaxType=0,0, oknTax1Rate * ( oknLineTotalTaxable + IF ( oknTaxTotalIncludingShippingCost = 0, 0 , oknShippingCost))), 2 )

If all your items are taxable (or not taxable), you can safely delete all the "Taxable" checkbox controls and then modify the tax formula to simplify the tax calculation:

=ROUND ( IF ( oknTaxType=0,0, oknTax1Rate * ( oknSubtotal + IF ( oknTaxTotalIncludingShippingCost = 0, 0 , oknShippingCost))), 2 )

Format and Specification

Belongs to


Format (XLS or XLSX).xlsx
Line Height (Points)49.50
Print Area$F$3:$P$41
Papaer Size / OrientationPortrait
Default Margins (Points)
PriceFree (0.00USD)


Itemized Graphic Design Invoice
Designer Invoice Template (Red)
Designer Invoice Template (Gray)
Creative Invoice Sample
5.5 Inch X 8.5 Inch: 2 Invoices On One Template