Download
Description | Size | Download |
---|---|---|
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:
| 438 KB | Download |
License: Private Use (not for distribution or resale). See our Terms of Use.
Detail
This tutorial shows how to move the Taxable checkbox column out of the printable area.
This template is based on the Moving Balance and Payment Cells (c5075).
- First, backup your template, and then open it.
- Push down the "Design Mode" button on the "Invoice" ribbon tab.
- Push down the CTRL key on the keyboard. Without releasing the CTRL key, click the taxable boxes one by one. This selects the taxable controls.
- Release the keyboard CTRL key.
- Click and drag one of the taxable boxes. Drop it outside the printable area.
- If you want to delete the controls completely with all the controls still selected, hit the DEL key on your keyboard. If you want to leave them there, skip this step.
- You can also modify the formulas of the tax fields to have them ignore the value of the taxable boxes completely.
If all of your products are taxable, modify the formula of the first tax cell to:
=ROUND( IF ( oknTaxType =0 ,0, oknTax1Rate * ( oknSubTotal + IF( oknTaxTotalIncludingShippingCost =0,0, oknShippingCost ))),2)
Modify the formula of the second tax cell to:
=ROUND ( IF( oknTaxType <> 2,0, oknTax2Rate * ( oknSubTotal + IF ( oknTaxTotalIncludingShippingCost = 0,0, oknShippingCost )+IF( oknTax2IsAppliedToTax1= 0 ,0, oknTax1 ))),2)
If all of your products (items) are not taxable, simply choose "No-tax" from the "Taxes" page of the Settings dialog box that could be opened by clicking the "Settings" button on the ribbon tab.
- Now update the column heading of the original "#/Taxable" column. To do this, simply replace the text "#/Taxable" with something like "Item#" or simply "#".
- Exit design mode.
- Save the template.
Format and Specification
Template# | c5076 |
Belongs to | |
Format (XLS or XLSX) | .xlsx |
Columns | 5 |
Lines | 12 |
Line Height (Points) | 18.00 |
Print Area | $D$4:$K$48 |
Papaer Orientation | Portrait |
Default Margins (Points) | |
Left | 22.68 |
Right | 22.68 |
Top | 45.35 |
Bottom | 45.35 |
Price | Free |