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. |