Search Tips
Available Reports for Job Costing
Job Cost Transaction Report (JC2000)
This screen is used to generate the Job Cost Transactions Report based on the job, cost code, or category.
Cost Projection Report (JC2300)
This screen is used to generate the Cost Projection Report which displays 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)
This screen is used to generate the Contract Status Report for change orders and billing invoices/checks and includes the original contract amount, the change order total amount, and contract total amount.
Project Labor Report (JC9000)
This screen is used to generate the Project Labor Report to compare the category unit budgeted cost, the actual cost, and the forecast.
Project Budget Report (JC_JOB_BUDGET)
This screen is used to generate the Job Cost Budget Report for the cost code costs and hours in companies.
Cash Flow Report (JC7001)
This screen is used to generate the Job Cash Flow Report for the current AP/AR cost and cash flow for a job.
Cost Summary Report (JC7000)
This screen is used to generate the Cost Summary Report which includes a cost/billing summary by category for jobs.
Cost Budget Report (JC1000)
This screen is used to generate the Job Budget Report for the cost budget to date amounts in companies.
Cost Management Report (JCCSTMGMT)
This screen is used to generate the Cost Management Report which includes cost budget details in companies.
Transaction Edit List (JC215)
This screen is used to generate the Transaction Edit List which can be used to verify transaction batch details. 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)
This screen is used to generate the Earned Revenue Report which includes contract revenue details for jobs.
Cost Detail Report (JC260)
This screen is used to generate the Detail Cost Report which includes the details for the cost budget of a job by quantities, hours, productivity, and cost to date.
Period End Cost Report (JC1003)
This screen is used to generate the Period End Cost Report which includes cost and cost budget details by period.
Period End Cost Report – No Ranges (JC1004)
This screen is used to generate the Period End Cost Report which includes cost and cost budget details by period.
WIP Report (JCWIP)
This screen is used to generate the WIP Report which includes work-in-process details for selected year and periods in companies.
Work In Process Report (JC6004)
This screen is used to generate the Work In Process Report which includes work-in-process details broken down to phase level for selected years and periods in companies. For more information, please refer to Job Costing - WIP Processing.
Work In Process Detail Report (JC6005)
This screen is used to generate the Work In Process Detail Report Report which includes work-in-process details broken down to category level for selected years and periods in companies. For more information, please refer to Job Costing - WIP Processing.
Cost Status Report (JC_JOB_STATUS_QRY)
This screen is used to generate the Contract Cost Status Report which includes cost and forecast details with OCO and invoice information.
Job Listing Report (JC6001)
This screen is used to generate the Job Listing report for companies. This report includes job details, statuses, bid information, and contract amounts.
Expense Distribution Report (JC2200)
This screen is used to generate the Expense Distribution Report for companies. This report includes 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 – Screen (JC0000)
The User Defined Reports screen is used to create custom reports.
Job Costing – Invoice Summary Report (JC7100)
This screen is used to generate the Invoice Summary Report for companies. This report includes invoice details for the Job Billing contracts.
Billings By Job Report (JC7002)
This screen is used to generate the Billings By Job Report for companies. This report includes all billing invoices and gross totals for the selected parameters.
Job Costing Unit Detail Report (JC8002)
This screen is used to generate the Job Costing Units Report – Detail for companies. This report includes 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 screen is used to generate the Expense Distribution Report for companies. This report includes the cost code unit budget and actual cost details. The Suppress Zero (Phase Level) field suppresses $0 actual cost lines, not $0 budget lines.
Cost Code Cost Report (JC4000)
This screen is used to generate the Cost Code Cost Report for companies. This report includes 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.
Phase Yield Report (JC5000)
This screen is used to generate the Job Cost Code Yield Report in companies. This report requires unit/prod type budgeting and spent amounts against those cost codes.
Job Analysis Report (JC4001)
This screen is used to generate the Job Cost Analysis Report which includes the budget cost and variance details for a job.
Field Productivity Report (JC4002)
This screen is used to generate the Field Productivity Report for companies. This productivity report requires a budgeted quantity for the cost code and category, posted quantities completed to date, and to and from dates.
Weekly Production Input Sheet (JC261)
This screen is used to generate the Weekly Production Input Sheet for companies. This report includes details for budgeted units and hours to date for the selected parameters.
Job Listing (JC6001)
This screen is used to generate the Job Listing report for companies. This report includes job details, statuses, bid information, and contract amounts.
Job/Phase/Category Listing (JC6006)
This screen is used to generate the Job/Phase/Category Listing for companies. This report lists all cost code categories per job.
Phase Template Listing (JC6000)
This screen is used to generate the Phase Template Listing for companies. This report lists all cost code categories per template.
WBS Code Listing (JC6002)
This screen is used to generate the WBS Code Listing which lists the WBS codes and their details for the specified company. For more information, please refer to Job Costing - Using WBS Capabilities.
Inter-Branch Report (JC3000)
This screen is used to generate the Inter-Branch Report for companies. This report includes the inter-branch Payroll transactions for employee time postings.
Job Status Reports (JCJOBSTATUS)
This screen is used to generate the Job Status Query Report similar to the Cost Status Query in the CMiC Field application. The report includes columns with original budget, pending/pre-pending changes, current budget, Spent/Committed, Calculated Projection, etc.
Job Cost Variance Report (JC_VARIANCE)
This screen is used to generate the Variance Report for companies. This report shows budget and cost variance details.
Job Cost Variance Report 2 (JC_VARIANCE_2)
This screen is used to generate the Variance Report 2 for companies. This report shows budget and cost variance details with the category summary.
Job Cost Unit Yield Report (JC5000)
This screen is used to generate the Job Cost Code Yield Report in companies. This report requires unit/prod type budgeting and spent amounts against those cost codes.
Job Cost Transaction – Master Phase Summary Report (JC2000_MST_PHS)
This screen is used to generate the Job Cost Transaction Report –Phase Summary for companies. This report shows the cost code billing and cost summary per job.
Work-In-Progress Aging Report (JCWIPAGEREP)
This screen is used to generate the Work-In-Progress Aging Report for companies. This report shows work-in-progress aging details that can be sorted in various ways.
Small Business Plan By Job (JCSBP)
This screen is used to generate the Small Business Plan By Job – Detail report for companies. 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 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 screen is used to generate the Job Status Detail Report for companies. 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.
Weekly Job Cost Report (JSR_JC_WEEKLY_JOB_COST)
This screen is used to generate the Weekly Job Cost Report for companies. This report includes budgeted costs, to date costs, and remaining costs for the selected jobs.