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
“I have been particularly impressed with the way Prōject have conducted this assignment. They have taken the time to explain fairly complex issues to a variety of stakeholders within the business in a clear and concise manner.”
Lead Project and Capital Accountant