Overview of totals in 6-1-7-21 Over/Under Billing report

Summary

How Sage 100 Contractor calculates each total in the menu 6-1-7-21 Over/Under Billing report.

Resolution

Costs

Costs equal the total of all open 6-3 Job Costs records.
This amount matches the 6-1-2-21 Job Cost Journal report.

Budget

Budget equals the 6-2 Budget plus approved 6-4-1 Change Orders on Budget and Sub Change Details.

Include change orders only when all conditions apply:

  • Header Status shows 1-Approved.
  • A date exists in the Approved box.

If lines affect a subcontract, also require:

  • Row Status shows 1-Approved.

Percentage

% equals Costs divided by Budget.
This value represents job progress based on incurred costs.

Contract

Contract equals the value in Contract on the 3-5 Job window plus approved prime change orders.

Include change orders only when all conditions apply:

  • Header Status shows 1-Approved.
  • A date exists in the Approved box.
  • The Approved column contains a value.

Earned

Earned equals the % value multiplied by the Contract amount.
This total reflects earned revenue based on progress.

Billed

Billed equals all 3-2 Receivable Invoices/Credits with Invoice Type set to 1-Contract.
Subtract any sales tax amounts from this total.

Over/Under

Over/Under equals Earned minus Billed.
This result indicates overbilling or underbilling.

To reach zero at job completion:

  • Costs must equal the budget.
  • Contract must equal Billed.

Overbilling and underbilling definitions

Overbilling and underbilling describe billing status compared to completed work.

Overbilling occurs when you invoice for more than the completed work. This creates a liability on your balance sheet.

Underbilling occurs when you complete work but haven't invoiced it. This creates an asset on your balance sheet.

 

More information

The report shows only budgeted costs in the Cost column when actual costs exceed the budget.

Select Permit Costs to Exceed Budget to display both budgeted and unbudgeted costs in the Cost column.

Related Solutions

Source of the numbers on the 6-1-7-31 Over/Under Billing Extended version report

Solution Properties

Solution ID
230629152406463
Last Modified Date
Fri Jun 26 21:04:34 UTC 2026
Attributes
Product Details
Integrated Product: Chatbot
Views
0