BoostExcel main content

Parts and Labor Invoicing Format

Template#: c4071

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

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

Screenshot

The screen shot for Parts and Labor Invoicing Format

Detail

This form in Excel spreadsheet format divides the detail section into two parts: one for labor, where the calculation of line totals is based on hours and rate, and another for parts and materials, where line total calculations are based on price and quantity.

For example, in the first section for labor and service, you itemize the work or job that you have done. The default tax name is "tax 1" in this part, with the calculation formula assigned like this:

=ROUND(oknTax1Rate*SUM(oknLinetotal_1:oknLinetotal_6),2)

The formula for the total charges for labor and service is calculated like this:

=ROUND(oknTax1+SUM(oknLinetotal_1:oknLinetotal_6),2)

The tax calculation methods differ completely from the template shipped with our app, where two taxes (if two taxes are all applied or enabled for the template) are applied to all the items listed on the template. Since this design breaks the assumption of the locations of tax cells, you cannot adjust the number of taxes using the features on the "Taxes" tab in the "Settings" window.

Another form that has a similar layout is the Contractor Billing Format (c3009).

Format and Specification

Template#c4071
Belongs to
Format (XLS or XLSX).xlsx
Columns4
Lines18
Line Height (Points)18.00
Print Area$D$2:$K$46
Papaer OrientationPortrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35
PriceFree

Related

Labor Invoicing Sample Thumbnail
Labor Invoice with Gradient Border Thumbnail
Sample Service Invoice Template: Using handwritten Signature Thumbnail
Independent Contractor Invoice Thumbnail
Hourly Invoice Template Thumbnail
Bricklayer Invoice Template Thumbnail
Engineering Invoice Template Thumbnail