Contract Forecasting - Billing Type & Revenue Calculations

The revenue calculation is driven by the billing type assigned to the bill code. This section describes how the revenue is calculated when using each billing type.

Billing Type Rate Rules

Depending on the billing type, billing rates are derived from different places.

Billing Type	Rule
Cost	If on the Job Setup screen (standard Treeview path: Job Costing > Job > Enter Job), ‘Use Payroll Billing Rates’ box is checked on the Payroll tab or ‘Use Equipment Bill Rates’ box is checked on the Settings tab, then these rates will be used where possible to determine the billing amount for cost transactions generated in the Payroll or Equipment modules. All other billing amounts will be determined by using the Billing Rate table. There is one override to this rule. On the Job Setup screen, there is a Max Hourly Rate field on the Job Billing tab. If a value is entered in this field, then all transactions from Payroll will be compared to this max billing rate and altered if their billing rate is greater than this max.
Unit	Under this method, the billing rate used is the billing rate applied on the billing code line.
Phase Unit	Under this method, the billing rate used is the billing rate applied on the billing code line.
% Complete of Costs	Under this method, the billing amount is the Percent Complete of the costs to the Budgeted Costs for the billing code.
% Complete of Construction Value	Under this method, the billing amount is the Percent Complete of the % of the Construction Value.
% Complete of Units	Under this method, the billing amount is the Units Complete of the Billing Code times the Unit Rate of the Billing Code.
Milestone	Each Milestone indicates the exact amount to bill when the milestone is released either manually or automatically.
Non - Recoverable	This is a non-billing rate. Any item using this method will not be billed unless manually overridden.

Billing Types

Code	Billing Type	Calculation Method
COST	COST	This method will select all the cost transactions for a specific billing code and bill the calculated revenue amount associated with each transaction.
UNIT	UNITS	This method is calculated as the sum of the units associated with all cost transactions for a specific billing code multiplied by the billing rate on the contract.
UPHS	PHASE UNIT BILLING	This method will calculate as the sum of the amount entered via Job Cost Phase Quantity Completion multiplied by the rate on the billing code line.
NR	NON RECOVERABLE	This method is a non-billable method – any transactions associated with bill codes marked with this billing method will produce a zero bill.

%Complete Billing Types Overview

Percent Complete billings work against a fixed contract value, the Budgeted Cost, Budgeted Units or Contract Value. The Units and Costs are derived from the Job Cost Transactions.

Code	Billing Type	Calculation Method
PCCO	% Complete/Cost	With this method, the billing type used will depend on the billing contract budget lines. Where there is a budget on the billing line, then % COMPLETE billing type will be used. Where the billing budget line is null or zero, the billing type COST will be used.
PC	% Complete of Budgeted Costs	This method will automatically calculate the percent complete of currently asked for costs against the Budgeted Cost Amount of the billing code and create the Bill Amount as “(Budgeted Billing Amount * Percent Complete / 100)”.
PCV	% Complete of Construction	This method will automatically calculate the percent complete of currently asked for costs against the Construction Value of the billing code and create the Bill Amount as “((Construction Value* % of Construction Value / 100) * (Percent Complete/100))”.
PU	% Complete of Budgeted Units	This method requires the user to enter the % of Units Complete for each billing code. The system will then calculate the bill amount as “((Budgeted Units * Percent Complete)/100) * Unit Billing Rate”.

Burdened Billings - Billing Types Overview

Burdened billings are a method of billing a percent of a different billing line. For example, your site management fee may be 15% of all general conditions.

Code	Billing Type	Calculation Method
BPC	Burdened Billings % of Cost Amount	This method will sum the ‘COST’ amount of the associated billing codes cost transactions and then apply the required Burden %. ((Sum of Costs * Burden Percent) /100)
BPB	Burdened Billings % of Billing Amount	This method will sum the ‘BILL’ amount of the associated billing codes ‘Cost’ transactions and then apply the required Burden %. ((Sum of Bill Amounts * Burden Percent)/100)
BPU	Burdened Billings $ Rate per Unit	This method will take the Billing Units entered of the associated billing codes and then apply a rate per unit. (Sum of Units * $ Rate per Unit)

Milestone Billings - Billing Types Overview

Milestone billings are manual billings triggered by % complete, dates, and costs or manually released. All milestones except fixed fee allow for multiple releases of the milestone.

Code	Billing Type	Calculation Method
MC	Milestones Cost to Date	This method allows the user to define the amount to be billed every time the actual cost to date reaches an entered value.
MD	Milestone Date Based	This method allows the user to define the amount to be billed on specific dates.
MF	Milestone Fixed Fee	This method allows for a bill code to be billed only once, for a specified dollar amount. The user must manually release this milestone.
MU	Milestone User Defined	This method allows the user to define multiple milestones with fixed dollar values for a specific bill code. The user must manually release the milestones.
MPC	Milestone % Complete of Cost	This method allows the user to enter the amount to bill when the calculated % complete equals or is greater than the percent complete entered on the milestone.
MPCV	Milestone % Complete of Construction Value	This method allows the user to enter the amount to bill when the calculated % complete equals the percent complete of construction value entered on the milestone.
MPU	Milestone % Complete of Units to Date	This method allows the user to enter the amount to bill whenever the units complete equals the percent of budgeted units entered on the milestone.
MQ	Milestone Quantity to Date	This method allows the user to enter the amount to bill whenever the units to date equal the amount entered on the milestone.