Job Cost · Included in Twinn Reports
Job Cost Totals for Sage 100 Contractor
Per job: budget, job cost for a range of posting years and periods split by cost type, and cost to date. Answers the largest job, cost by job, and this year against last year.
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.
Ask Twinn · Early access
Or just ask for it.
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.
- Budget
- Job budget.
- Material
- Cost type 1 in the range.
- Labor
- Cost type 2 in the range.
- Equipment
- Cost type 3 in the range.
- Subcontract
- Cost type 4 in the range.
- Other
- Cost type 5 in the range.
- User Types
- User-defined cost types 6-9, and cost without a type, in the range.
- Cost in Range
- All job cost posted in the range.
- Cost to Date
- All job cost posted, whatever the range.
- Budget Remaining
- Budget still to spend; negative when costs have passed it.
Criteria you can set
Pick these before you run it. Twinn remembers your last run.
- Jobs
- Job
- Posting year from
- Period from
- Posting year to
- Period to
- Sort
- Skip jobs with no budget or cost
How it’s calculated
The same notes Twinn shows beside the report, so anyone reading it knows what the numbers include.
- The range is posting periods: from a posting year and period to a posting year and period. Leave the periods blank for whole years, and every bound blank for job to date.
- Cost is open job cost records; voided records are left out. User Types holds cost types 6-9 (user-defined) and any cost without a type.
- Sort by cost in range to see the largest jobs first.
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.
Over/Under Billings
The WIP schedule: per job, revised contract, estimated cost, cost to date, percent complete, earned revenue, billed to date, over- and under-billings and gross profit to date, as of a date.
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.
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