Job Billing - Functionality Overview
Billing Type Rate Rules
Depending on the billing type, billing rates are derived from different places.
Billing Type |
Rule |
---|---|
Cost |
If on the 'Job Master Use Payroll Billing Rates' or 'Use Equipment Billing Rates' boxes are checked then these rates will be used where possible to determine the billing amount for cost transactions generated in the Payroll or Equipment Costing 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, if this is entered 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 percent 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 Costing 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 but the transactions will be marked as billed, these transactions are also available for printing on the invoice. |
% 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 Costing 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 percent 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 × (Percent of Construction Value ÷ 100)) × (Percent Complete ÷ 100)). |
PU |
% Complete of Budgeted Units |
This method requires the user to enter the percent 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 percent of cost amount |
This method will sum the cost amount of the associated billing codes' cost transactions and then apply the required burden percent: ((Sum of Costs × Burden Percent) ÷ 100)). |
BPB |
Burdened billings percent of billing amount |
This method will sum the bill amount of the associated billing codes’ cost transactions and then apply the required burden percent: ((Sum of Bill Amounts × Burden Percent) ÷ 100)). |
BPU |
Burdened billings dollar 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 × Dollar Rate per Unit). |
MILESTONE BILLINGS Billing Types Overview
Milestone billings are manual billings triggered by percent 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. |
ME |
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 percent 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 percent 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. |
Billing Functionality
The system treats all billing types the same when calculating the next bill. The system always generates the billable amount up to and including the requested cutoff date then subtracts the previous billing to give the current billing.
Cost transactions are automatically picked up and marked as included on a specific draw or draw and revision when a new billing is created. Surcharges and minimum maximum transactions are also created at the time the billing is created. If there are any automatically released milestones, they will also be calculated at this time. A cost transaction entered in the job billing Create Cost Transaction pop-up window and that had the 'Auto-Reverse' box checked will automatically be reversed on the next billing.
You may mark transactions as either “Permanently Deferred” meaning that they are never to be billed, or “Temporarily Deferred” indicating that they should not be included on this current bill, but will be billed on the next bill.
The system allows the user to adjust the amount to bill on each transaction when the billing type is cost and the job is not using revenue generation. The job set up will read – “As Costs Incurred (Without GL)”.
Minimum Time Charges Functionality
Minimum time charges are mostly utilized in billing engineering work. The functionality allows for specific tasks to have minimum charges regardless of the time sheet hours. In order to utilize this function to its fullest, the category structure created in Job Costing must be quite task specific.
Minimum time charges only work if you are posting from Payroll to Job Costing with the job summary set to “Employee by Date”, and the charges are calculated and applied according to the following rules.
1: Minimums Not Met
Minimums are applied first at the specific category level, then at the overall level prorated by quantity.
Example 1:
Minimum time 8 hrs, maximum time 12 hrs, round up .50 hrs
Minimum Categories | – 1002 – No specific minimum |
– 1003 – No specific minimum | |
– 1004 – No specific minimum | |
– 1005 – No specific minimum |
Time charged is: | 3.75 hrs to category 1002 |
0.00 hrs to category 1003 | |
0.25 hrs to category 1004 | |
0.00 hrs to category 1005 |
Minimum 8.00 hrs minus time charged of 4.00 hrs = Adjustment of 4.00 hrs is required.
Time charged is: | 3.75 hrs to category 1002 + adjustment of 3.80 hrs |
0.00 hrs to category 1003 | |
0.25 hrs to category 1004 + adjustment of 0.20 hrs | |
0.00 hrs to category 1005 |
Example 2:
Minimum time 8 hrs, maximum time 12 hrs, round up .50 hrs
Minimum Categories | – 1002 – No specific minimum |
– 1003 – No specific minimum | |
– 1004 – Specific minimum of 1 hr | |
– 1005 – No specific minimum |
Time charged is: | 3.75 hrs to category 1002 |
0.00 hrs to category 1003 | |
0.25 hrs to category 1004 | |
0.00 hrs to category 1005 |
Minimum 8.00 hrs minus time charged of 4.00 hrs = adjustment of 4.00 hrs is required.
Time charged is: | 3.75hrs to category 1002 + adjustment of 3.25 hrs |
0.00 hrs to category 1003 | |
0.25 hrs to category 1004 + adjustment of 0.75 hrs | |
0.00 hrs to category 1005 |
NOTE: If a category minimum adjustment is required – it will not reuse that category for overall minimum adjustments.
2: Maximums Exceeded
Maximums exceeded are created by starting with every category where the category quantity is greater than the category minimum and reducing that category quantity until the category minimum or the maximum has been reached. Then it moves on to the next category. The procedure starts with the category with the largest quantity first.
If there are no category minimums, it will then prorate the adjustment according to the category quantities.
Example 1:
Minimum time 8 hrs, maximum time 12 hrs, round up .50 hrs
Minimum Categories | – 1002 – No specific minimum |
– 1003 – No specific minimum | |
– 1004 – No specific minimum | |
– 1005 – No specific minimum |
Time charged is: | 6.00 hrs to category 1002 |
4.00 hrs to category 1003 | |
0.25 hrs to category 1004 | |
3.50 hrs to category 1005 |
Maximum 12.00 hrs minus time charged of 13.75 hrs = adjustment of –1.75 hrs is required.
Time charged is: | 6.00 hrs to category 1002 adjustment of -0.80 hrs |
4.00 hrs to category 1003 adjustment of -0.50 hrs | |
0.25 hrs to category 1004 adjustment of -0.05 hrs | |
3.50 hrs to category 1005 adjustment of -0.40 hrs |
Example 2:
Minimum time 8 hrs, maximum time 12 hrs, round up .50 hrs
Minimum Categories | – 1002 – 2 hrs specific minimum |
– 1003 – 2 hrs specific minimum | |
– 1004 – 2 hrs specific minimum | |
– 1005 – 2 hrs specific minimum |
Time charged is: | 6.00 hrs to category 1002 |
4.00 hrs to category 1003 | |
0.25 hrs to category 1004 | |
3.50 hrs to category 1005 |
Maximum 12.00 hrs minus time charged of 13.75 hrs = adjustment of – 1.75 hrs is required.
Time charged is: | 6.00 hrs to category 1002 adjustment of – 1.75 hrs |
4.00 hrs to category 1003 | |
0.25 hrs to category 1004 | |
3.50 hrs to category 1005 |
Example 3:
Minimum time 8 hrs, maximum time 12 hrs, round up .50 hrs
Minimum Categories | – 1002 – 5 hrs specific minimum |
– 1003 – No specific minimum | |
– 1004 – No specific minimum | |
– 1005 – 2.75 hrs specific minimum |
Time charged is: | 6.00 hrs to category 1002 |
4.00 hrs to category 1003 | |
0.25 hrs to category 1004 | |
3.50 hrs to category 1005 |
Maximum 12.00 hrs minus time charged of 13.75 hrs = adjustment of – 1.75 hrs is required.
Time charged is: | 6.00 hrs to category 1002 adjustment of – 1.00 hr |
4.00 hrs to category 1003 | |
0.25 hrs to category 1004 | |
3.50 hrs to category 1005 Adjustment of – 0.75 hr |
Example 4:
Minimum time 8 hrs, maximum time 12 hrs, round up .50 hrs.
Minimum Categories | – 1002 – 5 hrs specific minimum |
– 1003 – No specific minimum | |
– 1004 – No specific minimum | |
– 1005 – No specific minimum |
Time charged is: | 6.00 hrs to category 1002 |
4.00 hrs to category 1003 | |
0.25 hrs to category 1004 | |
3.50 hrs to category 1005 |
Maximum 12.00 hrs minus time charged of 13.75 hrs = adjustment of –1.75 hrs is required.
Time charged is: | 6.00 hrs to category 1002 adjustment of –1.00 hrs |
4.00 hrs to category 1003 adjustment of -0.40 hrs | |
0.25 hrs to category 1004 adjustment of -0.05 hrs | |
3.50 hrs to category 1005 adjustment of –0.30 hrs |
3: Rounding
Rounding is only applied if minimums or maximums do not apply. Rounding is prorated by quantity.
Example 1:
Minimum time 8 hrs, maximum time 16 hrs, round up .50 hrs.
Minimum Categories | – 1002 – No specific minimum |
– 1003 – No specific minimum | |
– 1004 – No specific minimum | |
– 1005 – No specific minimum |
Time charged is: | 6.00 hrs to category 1002 |
4.00 hrs to category 1003 | |
0.25 hrs to category 1004 | |
3.50 hrs to category 1005 |
Time charged is: | 6.00 hrs to category 1002 adjustment is 0.10 hrs |
4.00 hrs to category 1003 adjustment is 0.10 hrs | |
0.25 hrs to category 1004 adjustment is –0.05 hrs | |
3.50 hrs to category 1005 adjustment is 0.10 hrs |
Surcharge Functionality
Surcharges create zero dollar cost transactions with billing dollar amounts. Each surcharge is created against a unique cost code/category combination. Surcharges are meant for situations where costs are accumulated during a billing period to specific cost code/categories where you know further costs not posted to the job have been incurred. Each contract may have multiple surcharge codes applied.
Surcharge billing rates are retrieved from the billing rate table associated with the job. Surcharges use the billing rate column of the rate table only.
Surcharges are always applied if entered; the surcharge is pro-rated according to the number of hours entered. Applied surcharges cannot be further increased/decreased by the minimum charge function.
Example 1:
Every 4 hours of tech time should create .25 hours of engineering time:
Units of Tech Time Posted = 8 Hours | Surcharge will be for .5 Hours |
Units of Tech Time Posted = 4 Hours | Surcharge will be for .25 Hours |
Units of Tech Time Posted = 3.75 Hours | Surcharge will be for .23 Hours |
Example 2:
Every 4 hours of tech time should create .25 hours of engineering time with roundup to .5 of an hour:
Units of Tech Time Posted = 8 Hours | Surcharge will be for .5 Hours |
Units of Tech Time Posted = 4 Hours | Surcharge will be for .5 Hours |
Units of Tech Time Posted = 3.75 Hours | Surcharge will be for .5 Hours |