Job Cost · Included in Twinn Reports
Job Cost Journal for Sage 100 Contractor
Job cost records by job, phase and cost code.
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 (a grouping level).
- Phase
- Phase number (0 = no phase).
- Cost Code
- Cost code (a decimal code such as 9310.002).
- Cost Code Name
- Cost code description.
- Cost Type
- Cost type name (1 Material, 2 Labor, 3 Equipment, 4 Subcontract, 5 Other, 6-9 user-defined).
- Record#
- Job cost record number.
- Trans#
- Transaction number (invoice, check or timecard reference).
- Date
- Transaction date.
- Year
- Posting year.
- Period
- Posting period (0 = beginning balance).
- Source
- Source journal the cost came from.
- Description
- Record description.
- Vendor/Equipment/Employee
- Who the cost is from: the vendor, else the equipment, else the employee.
- Hours
- Hours (mostly labor).
- Cost Amount
- Cost posted to the job.
- Status
- Open or Void.
Criteria you can set
Pick these before you run it. Twinn remembers your last run.
- Job
- Cost code from
- Cost code to
- Cost type
- Vendor
- Employee
- Posting year
- Period from
- Period to
- Date from
- Date to
- Include voided records
How it’s calculated
The same notes Twinn shows beside the report, so anyone reading it knows what the numbers include.
- Only Open records are shown unless you include voided ones (the same default as Sage's saved report).
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 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