Job Cost · Included in Twinn Reports
Over/Under Billings for Sage 100 Contractor
The two numbers that go on the balance sheet every month: billings in excess of costs and estimated earnings, and the reverse. Each job lands in one column or the other, as of the date you choose, and the figures equal the WIP report run with the same options.
It runs in your browser against your live Sage 100 Contractor data, through the Twinn service on your own network, and exports to Excel, PDF or CSV.
Who uses it
- Controllers posting the month-end WIP entry
- CPAs reviewing percentage-of-completion
- Owners watching cash against progress
The questions it answers
- Which jobs are underbilled right now?
- What is the total over/under billing for the balance sheet?
- Which jobs moved from under to overbilled since last month?
Ask Twinn · Early access
“Which jobs are underbilled as of today, largest first?”
Ask Twinn, the assistant inside Twinn, runs this same report to answer questions in plain English. It tells you which report it ran, with which criteria, as of when, so the answer always matches the report.
How Ask Twinn worksWhat’s in the report
Every column, and what it means.
- Job
- Job number.
- Job Name
- Job name.
- Status
- Job status.
- Contract
- Original contract amount on the job.
- Approved COs
- Approved prime change orders approved by the as-of date (0 when the contract already includes them).
- Revised Contract
- Contract including approved change orders.
- Estimated Cost
- Total estimated cost of the job.
- Est. Gross Profit
- Gross profit expected at completion.
- Est. GP %
- Expected gross margin.
- Cost to Date
- Job cost posted up to the as-of date.
- Complete %
- Percent complete by cost.
- Earned Revenue
- Revenue earned by the work done so far.
- Billed to Date
- Amount billed up to the as-of date, retention included, sales tax excluded.
- Over Billings
- Billings in excess of costs and estimated earnings (a liability).
- Under Billings
- Costs and estimated earnings in excess of billings (an asset).
- Gross Profit to Date
- Profit earned so far.
- Cost to Complete
- Estimated cost still to be spent; negative when costs have passed the estimate.
- Remaining to Bill
- Contract not yet billed (backlog).
Criteria you can set
Pick these before you run it. Twinn remembers your last run.
- As of
- Jobs
- Job
- Job type
- Supervisor
- Budget and contract already include change orders
- Permit costs to exceed estimate (Complete % over 100)
- Skip $0 jobs
How it’s calculated
The same notes Twinn shows beside the report, so anyone reading it knows what the numbers include.
- Percent complete is cost to cost: Cost to Date / Estimated Cost, capped at 100% unless you allow costs to exceed the estimate. Earned Revenue = Revised Contract x Complete %.
- Over Billings (billings in excess of costs and estimated earnings) and Under Billings (costs and estimated earnings in excess of billings) are in separate columns; a job has one or the other.
- Approved change orders approved on or before the as-of date add their approved amount to the contract and their budget to the estimated cost. Tick 'Budget and contract already include change orders' if your company posts approved COs into them.
- Budgets and contract amounts are today's values: Sage keeps no history of them. Only costs, billings and change orders are cut off at the as-of date.
- Leave 'As of' blank for everything posted. With the same as-of date and options, the figures equal Job Performance (WIP).
More Job Cost reports
Job Performance (WIP)
Per job: original budget and contract, approved change orders, revised estimate, costs and billings to date, percent complete, backlog and over/under billing.
Budget vs Actual by Cost Code
Per job, phase and cost code: budget against actual cost and hours, the variance and the percent used, optionally with a budget and actual column per cost type.
Job Profitability
Per job: contract and service revenue billed, cost by cost type (material, labor, equipment, subcontract, other), gross profit and margin, for a date or period range or to date.
Committed Costs
Open commitments per job and cost code from subcontracts and purchase orders: original, changes, committed, invoiced and remaining.
Job Cost Journal
Job cost records by job, phase and cost code.
Job Status Report
Job list with status, type, client, supervisor, key dates, contract, billed and cost to date.
See your own WIP in Twinn
Book a demo and we’ll set Twinn up on a test copy of your Sage 100 Contractor company, then walk you through your own WIP and over/under billings, and this report.
Book a demo