Job Costing - Available Reports for Job Costing

  Job Costing Standard Reports
Report Name Code Description
Job Cost Transaction Report JC2000 A job cost transaction report based on the job, cost code, or category.
Cost Projection Report JC2300 This report shows the cost information for job snapshots. A snapshot for the job is required in order to generate this report. For details on creating and deleting job snapshots, see Job Costing - Snapshot.
Contract Status Report JC7006 A contract status report for change orders and billing invoices/checks.
Project Labor Report JC9000 A project labor report to compare the category unit budgeted cost, the actual cost, and the forecast.
Project Budget Report JC_JOB_BUDGET A project budget report for the cost code costs and hours.
Cash Flow Report JC7001 A report for the current AP/AR cost and cash flow for a job.
Cost Summary Report JC7000 A cost/billing summary by category for a job.
Cost Budget Report JC1000 A report for cost budget to date amounts by job, cost code, and category.
Cost Management Report JCCSTMGMT A report for job cost budget details.
Transaction Edit List JC215 After transactions have been entered through any of the transaction entry screens, this report can be printed to verify balances, verify that correct G/L accounts have been selected, and that correct distributions have been entered.
Earned Revenue Report JC6003 A report for contract revenue details for jobs.
Cost Detail Report JC260 A report that shows the details for the cost budget of a job by quantities, hours, productivity, and cost to date.
Period End Cost Report JC1003 A report for cost and cost budget details by period.
Period End Cost Report-No Ranges JC1004 A report that shows cost and cost budget details by period.
WIP Report JCWIP A report that displays work-in-process details.
Work In Process Report JC6004 A report that displays work-in-process details broken down to phase level.
Work In Process Detail Report JC6005 A report that shows work-in-process details broken down to category level.
Cost Status Report JC_JOB_STATUS_QRY A report that shows cost and forecast details which also shows OCO and invoice information.
Job Listing Report JC6001 A report that shows the full list of jobs.
Expense Distribution Report JC2200 A report that shows the cost transactions with the originating application code, source/reference, grouped by cost code/category. The report summary shows the General Ledger transaction summary amounts for cost & billing transactions posted to the expense and revenue accounts.
User Defined Reports JC0000 The User Defined Reports screen is used to create custom reports. See Job Costing - Reports for more details.
Billings By Job Report JC7002 This report shows all billing invoices and void per job contract.
Job Costing Unit Detail Report JC8002 A report that shows the budgeted units and posted units with total cost amount against each cost code/category and compares the current completion rate with the previous week's completion rate.
Job Costing Unit Summary Report JC8001 This report shows the cost code unit budget and actual cost details. The Suppress checkbox suppress $0 actual cost lines, not $0 budget lines.
Cost Code Cost Report JC4000 This report shows the budgeted and spent information for the unit/prod type budgeting. It requires unit/prod type budgeting and spent amounts against those cost codes. It also requires both budgeted units and completed units.
Job Cost Code Yield Report JC5000 This report requires unit/prod type budgeting and spent amounts against those cost codes.
Job Analysis Report JC4001 A report that shows the budget cost and variance details for a job.
Field Productivity Report JC4002

This produces a productivity report that require a budgeted quantity for the cost code and category, posted quantities completed to date, and to and from dates.

Note This will only run only when a controlling job is placed in the From Job field.

Weekly Production Input Sheet JC261 This report shows To date details for budgeted units and hours.
Job/Phase/Cat Listing JC6006 This report lists all cost code categories per job.
Phase Template Listing JC6000 This report lists all cost code categories per template.
WBS Code Listing JC6002 This report lists the WBS codes and their details for the specified company.
Interbranch Report JC3000 This report shows the inter-branch Payroll transactions for employee time postings.
Job Status Reports JCJOBSTATUS This report shows data similar to the Cost Status Query in the CMiC Field application. The columns include original budget, pending/pre-pending changes, current budget, Spent/Committed, Calculated Projection, etc.
Invoice Summary Report JC7100 This report shows invoice details for the Job Billing contract.
Job Cost Variance Report JC_VARIANCE This report shows budget and cost variance details.
Job Cost Variance Report 2 JC_VARIANCE_2 This report shows budget and cost variance details with the category summary.
Job Cost Transaction - Master Phase Summary Report JC2000_MST_PHS This report shows the cost code billing and cost summary per job.
Work in Progress Aging Report JCWIPAGEREP This report shows work-in-progress aging details that can be sorted in various ways.
Small Business Plan By Job JCSBP This report shows the subcontractor based on specific business partner classifications and the JCJOB user extensions created by CMiC for this purpose. The report columns show numbers based on the classifications such as LB, SB, WOSB, VOSB, and so on. As an example, WOSB stands for Women Owned Small Business and VOSB stands for Veteran Owned Small Business. The report shows the subcontract amounts against each vendor by classifications and is run by controlling job(s)
Job Status Detail Report JCCFCRED

This report shows the cost billing and fee details per bill code. For this report to generate data, a forecast must be stored for the specified year/period.

Note The Year/Period fields are mandatory.

Monthly Detailed Job Cost Report JSR_JC_COST_FCAST_QTY_AMT A job cost report by amount and quantity. Using the available report parameters, users have the option to selectively print values for categories associated with the job (with the ability to display one cost type at a time) by entering a value in the Category field. If a category is selected, all other categories will print as zeros, and the Total column will have the same values as the selected Category column.