BoostExcel main content

Invoice Template with 4 Pages

Template#: c5083

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

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

Screenshot

The screen shot for Invoice Template with 4 Pages

Detail

This form contains 84 lines and is printable on 4 pages of A4 paper.

The form has five columns in the detail section: "Part Number", "Description", "Quantity", "Unit Price", and "Line Total".

Related templates:

The form also contains a "Taxable" column in the detail section, implemented as a series of checkboxes. Each checkbox controls whether the current line is taxable.

If all your items are taxable and you don't want to show the "Taxable" checkboxes, you can remove all the taxable option boxes by following the steps detailed below:

  1. In Windows Explorer, copy the template file to backup it.
  2. Open the template in Excel.
  3. Click the "Design" button on the ribbon.
  4. Click to select one "Taxable" checkbox object, or push down the CTRL key on your keyboard and then click several "Taxable" controls one by one to select multiple controls.
  5. Release the keyboard CTRL key. Hit the DEL key on the keyboard. This deletes the selected objects.
  6. Repeat the above steps to delete all the other Taxable controls.
  7. The default formula for calculating tax looks like this:

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

    where "oknLineTotalTaxable" is the name of a hidden cell that calculates the taxable amount using Excel's array formula. Here, since all the items are taxable, you modify it to be:

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

    If you want to include the labor expenses (implemented as custom fields that calculate labor costs), then change the formula to:

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

  8. Once done, exit design mode.
  9. Save the template.

Format and Specification

Template#c5083
Belongs to
Format (XLS or XLSX).xlsx
Columns5
Lines84
Line Height (Points)15.75
Print Area$D$3:$K$122
Papaer OrientationPortrait
Default Margins (Points)
Left18.00
Right18.00
Top36.00
Bottom36.00
PriceFree

Related

1/2 Page Invoice Template Thumbnail
2-Page Invoice Template Thumbnail
3-Page Invoice Template Thumbnail
Invoice Design for Personal Trainer or Fitness Instructor Thumbnail
Medical Invoice Template (1) Thumbnail
Medical Invoice Template (2) Thumbnail