Job Cost · Included in Twinn Reports
Job Profitability for Sage 100 Contractor
Which jobs made money and which did not. Revenue billed, cost by type (material, labor, equipment, subcontract), gross profit and margin per job, for a period or to date, filtered by status, job type, client or salesperson, so you can see which kinds of work earn their margin.
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
- Owners deciding what work to chase
- Controllers reporting margin
- Operations managers reviewing supervisors
The questions it answers
- Which completed jobs lost money this year?
- What is our gross margin by job type?
- How does margin compare by salesperson?
Ask Twinn · Early access
“Which jobs completed this year had the lowest gross margin?”
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 name.
- Job Type
- Job type name.
- Salesperson
- Salesperson on the job.
- Client Name
- Client of the job.
- Contract Revenue
- Contract billings in the range, before sales tax.
- Service Revenue
- Service invoices on the job in the range, before sales tax.
- Total Revenue
- All revenue billed.
- Material
- Cost type 1.
- Labor
- Cost type 2.
- Equipment
- Cost type 3.
- Subcontract
- Cost type 4.
- Other
- Cost type 5.
- User Types
- User-defined cost types 6-9, and cost without a type.
- Total Cost
- All job cost in the range.
- Gross Profit
- Billed revenue less cost.
- Margin %
- Gross profit as a percent of revenue.
Criteria you can set
Pick these before you run it. Twinn remembers your last run.
- Date from
- Date to
- Posting year
- Period from
- Period to
- Include period zero
- Job status
- Job
- Job type
- Client
- Salesperson
- Include service invoices
- Skip jobs with no revenue or cost
How it’s calculated
The same notes Twinn shows beside the report, so anyone reading it knows what the numbers include.
- Revenue is what was billed in the range (AR invoices plus service invoices), excluding sales tax. Cost is job cost posted in the range. It is billed-basis profit, not earned (percent complete) profit: use Over/Under Billings for that.
- Leave the dates, year and periods blank for job-to-date figures. The year and periods are posting periods; period 0 (beginning balances) is left out of a period range unless you tick 'Include period zero'.
- User Types holds cost types 6-9 (user-defined) and any cost without a type.
- Use 'Group by' for subtotals by job type, salesperson, client or status.
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.
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