Job Cost · Included in Twinn Reports

Job Status Report for Sage 100 Contractor

Job list with status, type, client, supervisor, key dates, contract, billed and cost to date.

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.

See it on your own data All 44 reports

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 works

What’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.
Client: Client number.
Client Name: Client name.
Supervisor: Job supervisor.
Phone: Job phone number (often a person's: the site or superintendent).
Contract Signed: Date the contract was signed.
Started: Project start date.
Completed: Project completion date.
Inactive: Yes when the job is marked Inactive.
Contract: Contract amount on the job.
Approved COs: Approved prime change orders (0 when the contract already includes them).
Revised Contract: Contract including approved change orders.
Billed to Date: Everything billed on the job, retention included, sales tax excluded.
AR Balance: What the client still owes on the job's invoices (retention and tax included).
Cost to Date: Job cost posted to the job.
Billed less Cost: Cash-basis margin so far.
Remaining to Bill: Contract not yet billed.

Criteria you can set

Pick these before you run it. Twinn remembers your last run.

Status
Include inactive and closed jobs
Job type
Client
Supervisor
Job
Contract already includes change orders
Sort by

How it’s calculated

The same notes Twinn shows beside the report, so anyone reading it knows what the numbers include.

Inactive jobs and Closed jobs are left out unless you tick 'Include inactive and closed jobs' (or pick status Closed).
Billed to Date excludes sales tax and void invoices; AR Balance is what the client still owes on those invoices (retention and tax included).
Cost to Date is every open job cost record, with no date cut-off.
Revised Contract adds approved prime change orders. Tick 'Contract already includes change orders' if your company posts them into the contract.

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