UniformSoftware main content

Designer Invoicing Format with Bamboo Chinese Painting

Template#: c4096

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

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

Screenshot

The screen shot for Designer Invoicing Format with Bamboo Chinese Painting

Detail

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

Template#c4096
Belongs to

Service

Format (XLS or XLSX).xlsx
Columns4
Lines6
Line Height (Points)49.50
Print Area$F$3:$P$41
Papaer OrientationPortrait
Default Margins (Points)
Left16.56
Right36.00
Top72.00
Bottom72.00
PriceFree