The taxable checkboxes were removed completely, assuming all the products are taxable, no matter whether the Taxable option is checked or not for each product. This avoids an occasionally happened mistake when a taxable product or item must be manually entered on the invoice body, as the Taxable checkbox is not checked by default. The template implements this feature by deleting all the Taxable checkboxes and assigning a value of 1 (TRUE) to all the oknTaxable cells located in the hidden column C.
This template is created based on c4018 the third sample of consulting invoice. The template now features an abstract background image with 15% opacity that shows a programming scene with several smart devices around, including mobile phone, tablet and desktop computer (keyboard).
The 2-page billing summary template has 55 lines on the detail section; whereas the 1-page billing summary format offers only 19 lines. The 1-page template was created by simply hiding the line 20 to line 56 of the 2-page template. Both templates connect to the same Microsoft Access database "c5122.mdb". For more samples on multiple-page templates, click here.
This template has two taxes like the default template shipped with Invoice Manager for Excel (namely Uniform Invoice Software). However unlike the default template, where the two taxes applied to all taxable items added to the invoice detail section, Contractor Billing Format applies each tax to one section. In this implementation, "Tax 1" was applied to the "Service" section, and "Tax 2" was applied to the "Expense" section. All the tax-calculation formulas are modified according to this design requirement.
This formula means that, if the "Taxable" checkbox is checked on the first line of the invoice body (identified by the " oknTaxable_1" cell value), it calculates tax amount based on line total and tax rate. If the "Taxable" checkbox is not checked, it shows either an empty string or the symbol "-" depending on whether the line total is zero.
In order to implement the taxing rules, InvoicingTemplate.com added 3 custom fields to the "InvBdy" database table - "GST", "PST" and "IsService". The "IsService" field is corresponding to the "IsService" field defined in the Product database table, however with the default template it is not added to the Invoice Body, because the on-form calculation of taxes and totals does not depending on this field. However with this invoicing template designed for handyman business, calculating the taxes requires to know the type of the invoicing item. When creating invoices and bills, filling in the "IsService" with the value 1 means the current item is a service, and thus only one tax will be applied on it. If you installed UIS, which can be downloaded for free from our invoicing software page, the type of the invoicing items will be filled in automatically when you pick up items.