Job Billing T&M Basics

Overview:

T&M Billings pull costs from the AP, EM, IN, JC, MS and PR modules and bills them based on what the T&M Bill says. When the bill is initialized, all of the costs gets pulled from Job Cost (where the cost from all modules are stored) and sent to different Line Sequences based on how the template is set up.

Below we will look briefly at the main programs the makeup T&M Billing - JB T&M Template, JB Bill Initialization and JB T&M Bill Edit.

JB T&M Template:

The T&M Template consists of 2 sections. The header and the line sequences. The header contains information that will effect everything that gets pulled into the bill when it gets initialized. In the header you can define many things like in what order you would like your costs to show on your bill, if you will be using labor and equipment rates and what these rates will be. The line sequences only effect certain costs that fall into the parameters defined by the sequence. Here is an example based on the picture above:

Sequence 1 is a Source Sequence (will pull costs from other modules) and will include all costs with a

source of AP with whatever Cost Type is defined in the Cost Types Tab. These costs will be pulled in with a Sum Option of 1 and a Sort Level of 1. These costs will be billed based on the actual cost with a mark- up rate of 3.25%. There are many ways to customize this. When you are unsure what a field does, select

the field and use the F1 key to bring up the help screen for a detailed overview of the field.

JB Bill Initialization:

This program is used to initialize a bill, T&M or Progress. This will pull all of the costs from a Job Cost (defined by the form), run the costs through the T&M Template (to allocate each cost to the correct line sequence) and create a bill. Here you can select which type of bill you want to initialize (more information on the initialization options can be found here), the contract you would like to create the bill for, and which range of costs you would like to pull in. If there are costs that have a problem going through the template, they will show up on the JB T&M Error List report for the new bill.

In the picture to the right, the user is creating a T&M and Progress Bill (the costs will filter through the T&M Template and will put the billed amount to the correct Contract Items in the Progress Bill).

The bill being initialized is going to be toward contract 1002- with an invoice date of 2/27/15 using all of the costs between 2/23/15 and 2/27/15. There are more fields that could be used. The F1 help screen is a great tool to sort through these fields.

NOTE: Jobs without any costs will not initialize a bill for the associated contract.

JB T&M Bill Edit

The T&M Bill Edit Program is used to review or modify a bill that was created using the JB Bill Initialization Program (see below). The Info tab is used to do change the invoice number, dates, addresses, etc. The Bill Lines button will bring up the T&M Bill Lines Sequences page. This page contains the Lines on the bill and the Line Sequences (what makes up those lines). The top portion of the page contains the Bill Lines. This will show every line on the bill (which is defined in the template) including the Billing Amount Basis, Markups, Retainage and Total. Below, the Line Sequence show the sequences costs) that make up each Bill Line. Here you adjust the units, hours, markups, ect on a cost level. If you would like further detail about the cost in the Line Sequence, you can select the JCDetail button. This will show all of the costs the make up the Line Sequence (each day worked, JC Transactions numbers, etc.). You can also mark certain costs as non-billable and add costs to the bill in this page.