FRG Transaction Testing Project | General ledger (LAP) data quality testing and audit readiness​

Client Needs & Objectives

As required by external auditors, our client, a major global CIB, needed to perform a quality check of data in LAP at the transactional level and ensure that the correct source documents for any given transaction could be provided in a timely manner to an auditor.

Our client required assistance to determine the process for and implementation of transaction testing,  including source document retrieval, data validation and checking of any potential discrepancies.

The objective of the Transaction Testing Project were as follows:

  • To identify inaccuracies in LAP
  • To provide our client with clear transaction testing documentation
  • To issue recommendations for correction or process improvement
  • To define procedure for reaction to future testing or transaction audit

Our Approach

Our approach was structured in 4 steps : ​

  1. Testing Population: Definition of the templates to be used for documentation and tracking as well as selection of population for analysis.​
  2. Coordination & Analysis: Contact stakeholders to determine attributes of interest and obtain source documentation. Verification of data quality.​
  3. Follow-up: Discussion of findings with product owners, follow-up of outstanding discrepancies, determination of recommendations.​
  4. Documentation & Training: Documentation of testing including results and walk-through and training sessions for our client’s personnel.

Main Deliverables

Download

Client Benefits & Main Results

Through the Transaction Testing Project, our client fulfilled the auditor’s requirements for a review of the data quality stored in LAP and the establishment of a process for further testing

Following the testing, training sessions were organized to instruct our client’s existing personnel on the implementation of the transaction testing process

Our financial and project management expertise enabled us to define and execute the plan necessary to perform testing at a transactional level. Our methodical approach, relying on our understanding of the transactions booked in LAP and our attention to the interests of the different our client's stakeholders, enabled us to deliver the project