BoostExcel.com main content

Download

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

You are safe to download the resources. We've added our digital signatures to the files.

DescriptionSizeDownload

Download this if you have already installed the Microsoft Store edition of Invoice Manager for Excel, and are looking for additional customized templates.

483 KBDownload

Download this if you want this design to be set as the default template by the installer program.

6.00 MBDownload

Screenshots and Images

The printed version.

Contractor Billing Format

Open the template in Excel.

Contractor Billing Format (IMFE Edition)

Detail

Contractor Billing Format differs from other templates here in that it itemizes "service" and "expense" in two separate sections on the invoice detail section. Each section has a different tax (including tax name and tax rate) applied.

Take a look at the screenshot of this invoice template, you'll easily find the differences between this template and other templates available here on InvoicingTemplate.com. There are 18 lines on the detail section, but these lines are grouped into two sections - the "Services" section and the "Expenses" section, with each section identified by a blue title bar. You can use 6 lines on each section to itemize the service and expense. The other lines are reserved for taxes and amounts.

To make this template work with Invoice Manager for Excel, Contractor Billing Format adopts tricks. First, the most left column on the visible (and printable) area was a custom field "ItemLine", which was continuously named from "oknItemLine_1" to "oknItemLine_18", to tell Invoice Manager for Excel that there are 18 lines on the invoice detail section. The other columns, such as "DATE", "DETAILS" and "AMOUNT", has an interruption in their name serials. For example, "oknItemDate_1" to "oknItemDate_6" are put onto same column, "oknItemDate_7" to "oknItemDate_12" are put onto another column outside the printable area, and "oknItemDate_13" to "oknItemDate_18" are put onto the same column as "oknItemDate_1" to "oknItemDate_6". This is necessary because the space for "oknItemDate_7" to "oknItemDate_12" is used by the tax and amount cells.

This template has two taxes like the default template shipped with Invoice Manager for Excel. 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.

In this Contractor Invoicing Layout, we use the "Bill To" found on the original invoice template for "Contractor", including name, Address, City State and ZIP, Phone, Email and Contractor#; and, we use the "Shipping To" section for "Client", including its Name, Address, City State and ZIP, as well as contact information.

The two custom fields added to this template, "Service Amount" and "Expense Amount", calculate the sum amount of each section. These two fields are also added to the "Sales Report", with the name "oknRsServiceAmount" and "oknRsExpenseAmount".

While there are many invoicing software apps that are able to handle simple and regular invoicing forms, Invoice Manager for Excel is designed with flexibility in mind. This, with the help of Microsoft Excel, especially its formulas that allows us to define the relationship between cells (for example, how one cell is calculated from the value of the other cells), makes it possible for Invoice Manager for Excel to handle complex invoicing forms and layouts. You may be still invoicing in the traditional paper way because there is no invoicing software app is able to handle the complex formats you need. Invoice Manager for Excel helps you turn to electronical invoicing with easy and quick.

Format and Specification

Template#c3009
NameContractor Billing Format
CategoryService Invoice Template
Release DateSaturday, October 17, 2015
Format (XLS or XLSX).xlsx
Feature Gallery
Columns3
Lines18
Line Height (Points)18.00
Print Area$D$2:$K$46
Papaer Size / OrientationPortrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35
PriceFree (0.00USD)
SystemWindows 7 and later, and Excel 2007 and later.