Month End
-
Entering WIP (Summary)
Entering WIP (Summary) STEP 1: Enter Company Enter Department Verify Year and Month Page Down STEP 2: Select “Store Forecast” for any projects that Forecasts have not been stored for. STEP 3: Put all your entries in: Contract Override Projected Cost Override Unposted Costs, to true-up Spent if needed Unposted Billing, to true-up Billings if needed STEP 4: Post Unposted Costs and Billings if needed STEP 5: If you posted Unposted Costs and/or Unposted Billings then: Select “Populate WIP”, Select “Current” Select “Refresh”, Select “Current”, Select “No” If you didn’t post Unposted Costs and/or Unposted Billings then: Select “Refresh”, Select “Current”, Select “No” Select “Populate WIP”, Select “Current” STEP 6: Check Over/Under. If not correct go back and check figures in Step 3 above and repeat STEP 7: Select “Time Phased” Select “Synchronize” if needed Select “Accept” Make sure “Revenue Amt” matches against “Earned Revenue” STEP 8: Select Accept Check “Earned Revenue” on “WIP Adjustment” screen STEP 9: Go to “Post/Void WIP Adjustment”, Select the “Post” box and Select on “Process WIP”
-
WIP Processing
WIP Processing Overview: How To Process WIP WIP is processed monthly by the Financial Manager after the Project Manager has completed Contract Forecasting. STEP 1: Click Job Costing STEP 2: Click Forecasting STEP 3: Click Work-In-Process Adjustments STEP 4: Click Enter and Post Adjustments Storing the Forecast Ensure the Company is correct, then input the job number or select other filtering parameters (e.g. Jobs with or without Posted WIP). Note the current Period. Press Page Down and the job data appears. If the background color is grey, that indicates that the PM did not store the job forecast, so click the Store Forecast button. You will be prompted to select the appropriate Row or Rows. Since the cursor resides on the current row (see red box below), click the Current Row button. Notice that the grey background disappears. If the background color is not grey, which indicates that the PM stored the job forecast, click the Refresh button. If you need to change the Contract (Projected Revenue), input the gross amount in the Contract Override field. To revise the Projected Cost, input the gross amount in the Projected Cost Override field. If Spent (Actual Cost) or Billed must be adjusted, input the difference in the Unposted Cost or Unposted Billing fields, and proceed to the Overrides and Accruals/Deferrals section on page 6. Otherwise, please continue… Do not input in the Projected Profit Override, % Complete Override, or WIP Adjustment fields. If you input a Contract Override and/or Projected Cost Override, click the Refresh button, the click Current and No at the prompts. Processing WIP with no Accruals/Deferrals Click the Populate WIP button, and select Current.
-
Voiding WIP
Voiding WIP Overview: How to void posted WIP in CMiC If a WIP adjustment has been posted, the Void WIP process must be completed using the following steps. Not following these steps will result in the WIP reversal not being properly posted to the General Ledger. Only unposted WIP can be deleted using the remove button. Log into CMiC Enterprise 1) Click Job Costing 2) Click Forecasting 3) Click Work-In-Process Adjustments 4) Click Enter and Post Adjustments 5) Query Job · Year and Period will default to open period. Change the period if you are looking for WIP from a prior period. · If WIP is posted WIP, it record will be highlighted in blue. Do not use the remove button if WIP is posted. 6) Click Post/Void WIP Adjustment tab · Note: Even though you queried the job on the WIP Adjustment tab, you must query again on the Post/Void WIP Adjustment screen. 7) Place curser on first line and click F11, F12 and job will populate. You do not need to enter the job number.