1 / 61

State of Connecticut

State of Connecticut. Project Costing (PC) and Customer Contracts (CA) Reporting. Agenda. Introduction: Sue Maheux Project Costing Reports: Tom Vaughan/Bonnie Soucy Customer Contracts Reports: Vanessa Hoang EPM Reports: Barbara Jacius.

benjaminellis
Download Presentation

State of Connecticut

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. State of Connecticut Project Costing (PC) and Customer Contracts (CA) Reporting

  2. Agenda • Introduction: Sue Maheux • Project Costing Reports: Tom Vaughan/Bonnie Soucy • Customer Contracts Reports: Vanessa Hoang • EPM Reports: Barbara Jacius

  3. Projects: identifiers for cost collection and for monitoring status of a product or service • Customer Contracts: agreements between a state agency and the customer that they are billing

  4. Analysis Types: identify different types of transactions, such as budget amounts, actual costs, and billed costs.

  5. Analysis Types

  6. Commonly Used Analysis Types

  7. Analysis Groups: Analysis Types are grouped to define relationships in order to analyze project costs

  8. Notice the Analysis Group Options – Perform MultiplicationThe CTENC (Encumbrance) example shows the PO Encumbrance (COM) less the Commitment Reversal or Voucher payment (CRV) less Commitment Adjustments or PO Closed balance of Commitment (CCA). Example: a PO is created for $100; a voucher is created from the PO Receipt for $75; later the PO is closed. COM= $100, ACT= $75, CRV= $75, CCA= $25. Based on the CTENC Analysis Group Multipliers the encumbrance balance is:minus $25 (CCA) plus $100 (COM) minus $75 (CRV) = $0

  9. Project Transaction Table (PROJ_RESOURCE): the main record that gets populated by feeder modules with transactional data. Transaction rows contain the quantity and amounts associated with each transaction and all of the identifying information that accompanied those costs. • Summary Table (CT_PC_RPO): custom summary record of PROJ_RESOURCE to help with performance. This is the main record used for most of the Project Costing Core-CT Reports.

  10. Transaction Data on PROJ_RESOURCErefreshed daily: displayed by day Transaction Data on CT_PC_RPOrefreshed daily: summarized by month

  11. Project Data by Analysis Group(s) Report: displays project financial data by one or several analysis groupsFlexible Analysis: analyzing a project’s costs at different levelsPC and GL Reconciliation Report: displays any discrepancies between Project Costing and General Ledger expenses PC and KK Reconciliation Report: displays any discrepancies between Project Costing and Commitment ControlProject Payroll Costs Report: displays project payroll data by employee and accounting date Recommended PC Reports

  12. Project Data by Analysis Group Report Project Costing> Core-CT Reports> Project Data by Analysis Group

  13. Project Data by Analysis Group Report

  14. Project Data by Analysis Group Report

  15. PDF Format

  16. CTAVL Analysis Group – w/o REV

  17. CTAVL Analysis Group – with REV

  18. Project Data by Analysis Group Report including REV rows

  19. Project Data by Analysis Group: by Project Tree Click the project tree folder to view DOT Project Trees and Tree Levels.

  20. Project Data by Analysis Group using CT_Account to Capture Expenditures

  21. Project Data by Analysis Group showing CT_Account Tree results

  22. Project Data by Analysis Group: Date Impact

  23. Project Data by Analysis Group-CRV date issue

  24. Project Data by Analysis Group-CRV date issue resolved by dating to end of fiscal year

  25. Flexible Analysis Project Costing > Flexible Analysis Template

  26. Flexible Analysis Template

  27. Flexible Analysis Project Costing> Interactive Reports> Flexible Analysis

  28. Flexible Analysis

  29. Flexible Analysis

  30. Flexible Analysis

  31. Flexible Analysis

  32. Flexible Analysis

  33. PC to GL Reconciliation Report Project Costing> Core-CT Reports> PC v/s GL Reconciliation Select Summary Record

  34. CSV Version of PC to GL report

  35. PDF Version of PC to GL report

  36. PC to GL Reconciliation EPM queries • CT_PC_TO_GL_LEDGER • CT_PC_TO_GL_PROJ_RES • Use these EPM queries to produce transaction details. Compare results and isolate differences to resolve discrepancies found in the PC to GL Reconciliation Report.

  37. CT_PC_TO_GL_LEDGER

  38. CT_PC_TO_GL_PROJ_RES

  39. PC to KK (Commitment Control) Reconciliation Report Project Costing> Core-CT Reports> PC v/s KK Reconciliation There is no Project Table Selection for this report. It runs off the Summary (CT_PC_RPO) record.

  40. PDF Version of PC to KK report Type: ENC PC Amount: 0.00 KK Amount: 1750.00 Difference: -1750.00

  41. PC to KK ReconciliationCSV Format

  42. PC to KK Reconciliation-Research Tips Commitment Control> Review Budget Activities> Budgets Overview: select ledger, appropriate chartfield combinations, drill down into each account.Purchase Orders> Reports> PO Balance Report: compare the Purchase Order to the Commitment Control LedgerEPM Query: CT_CORE_FIN_PO_DSTRB_KK_AUDIT

  43. Project Payroll Costs Report

  44. Project Payroll Costs Project Costing> Core CT Reports> Project Payroll Costs

  45. Project Payroll Costs

  46. Recommended Customer Contracts Reports • Project Billable Summary • Active Contracts Limit Management Report

  47. Project Billable Summary Project Costing> Core-CT Reports> Project Billable Summary

  48. Project Billable Summary

  49. Project Billable Summary: Non-DOT Specific

  50. Project Billable Summary: Non-DOT Specific

More Related