Job Costing - WIP OS Report

Pgm: JCWIP_OS – WIP OS Report; standard Treeview path: Job Costing > Reports > WIP OS Report

The WIP OS report is based off of the standard JCWIP report so users can view the amounts for Costs, Gross Margin, Revenue, etc. broken down by current and prior years. Similar to the standard JCWIP report, this report will display total amounts for each department under the company for which the report is being run. It has the same report parameters as the standard JCWIP report. For more details, see Job Costing - WIP Report.

This report will display amounts based on the existing standard JCWIP report except for the modifications stated below.

The following columns are removed:

  • Cost to Complete

  • GM Earned Curr Period

  • GM Earned YTD

  • Earned Revenue Curr Period

  • Current Period Cost

The following columns from the existing standard JCWIP report distribute amounts to current and prior years. These columns will be divided into two new columns such that one column will show the amount from the current year and the other column shows the amount as per the last period of the prior year.

  • Gross Margin: The report will display amounts for the current year and prior years in the following two columns in addition to also displaying the Gross Margin amount as per the standard JCWIP report.

    • Gross Margin Prior Years: Gross Margin amount from the standard JCWIP Report in period 12 of the immediate year prior to the current year in which the JCWIP_OS report is run.

      NOTE: Since the JCWIP_OS report also displays the Gross Margin amount like the standard JCWIP report, this amount should match that of the standard report.

    • Gross Margin Current Year: Calculated as the difference between the Gross Margin amount and the Gross Margin Prior Years amount.

  • Actual Cost To Date: The report will not display the Actual Cost To Date amount as in the standard JCWIP report but instead will display amounts for the current year and prior years in the following two columns.

    • Actual Cost Prior Years: Actual Cost To Date amount from the standard JCWIP Report as of period 12 of the immediate year prior to the current year in which the JCWIP_OS report is run.

    • Actual Cost Current Year: Calculated as the difference between the Actual Cost To Date amount from the standard JCWIP Report for the same year and period the JCWIP_OS report is run and the Actual Cost Prior Years amount.

  • Earned Revenue: This report will not display the Earned Revenue amount as in the standard JCWIP report but instead will display the amount for the Earned Revenue Prior Years.

    The Earned Revenue amount from the standard JCWIP report as of period 12 of the immediate year prior to the current year in which the JCWIP_OS report is run. This should equal the difference between the Earned Revenue amount from the standard JCWIP Report for the same year and period the JCWIP_OS report is run and the corresponding Earned Revenue YTD amount.

  • Current YTD Billing: This report will not display the Current Period Billing amount as in the standard JCWIP report but instead will display the billing amount for the current year up to the date/period in which the report is being run. This is calculated as the difference between the Billed To Date amount from the standard JCWIP Report for the same year and period the JCWIP_OS report is run and the Billed To Date amount as of period 12 of the immediate prior year.