System and Business Process Improvements for Foreign and Commonwealth Office – Project Reconciliation Reporting Pack

System and Business Process Improvements for Foreign and Commonwealth Office – Project Reconciliation Reporting Pack

Requirement

  • Create a project costing and revenue reporting pack to help reconcile revenue, UER/UBR, expenditure and provide invoice interface exception information
  • Replace existing project expenditure items (EI) report to capture additional and relevant information to include cost distribution line (CDL) information for project use and reconciliation to AP/GL
  • Create summary and detailed versions of a revenue distributions lines (RDL) report with appropriate information for project use and reconciliation to GL
  • Develop a custom unearned revenue and unbilled receivables report to monitor project billing patterns
  • Create a supplier invoice interface exception report to help understand issues with AP to Projects integration

Solution

Reporting pack to resolve immediate requirements and provide information for:

  • Expenditure Items and Cost Distributions Report
  • Revenue Distributions Summary and Detailed Report
  • UER and UBR Summary Report
  • AP Supplier Invoice Exception Interface to PA Report
  • Detailed EI and CDL report providing rich project data for analysis. Solution also provided a transaction data reconciliation process between Projects and AP/GL
  • RDL detailed report to assist in reconciling project revenue to GL revenue accounts for project related transactions as well as provide project analysis and trends for project teams
  • CDL and RDL detailed report fusion opportunity to provide complete revenue reconciliation for work related expenditure
  • AP Invoice exception report covering all integration error possibilities in a more logical and granular format with extensive detail compared to the standard EXC: Transaction Exception Detail period (GL and PA) reports.
  • White paper detailing reporting pack usage and reconciliation approach
  • Continuous knowledge/skills transfer and training for report use and reconciliation approach
  • Full project, change and delivery management of all work package items