1 / 17

Continuous Auditing Process using Cross References and Key Performance Indicators

Continuous Auditing Process using Cross References and Key Performance Indicators. Washington Lopes da Silva. 16th World Continuous Auditing Symposium. Agenda. Objective Current Situation Proposed Situation Cross References Key Performance Indicators Conclusion Recommendation.

zoie
Download Presentation

Continuous Auditing Process using Cross References and Key Performance Indicators

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. Continuous Auditing Process using Cross References and Key Performance Indicators Washington Lopes da Silva 16th World Continuous Auditing Symposium

  2. Agenda • Objective • Current Situation • Proposed Situation • Cross References • Key Performance Indicators • Conclusion • Recommendation 16th World Continuous Auditing Symposium

  3. 1 Objectives 16th World Continuous Auditing Symposium

  4. Objectives • To propose Improvements in the Continuous Auditing Process • To reduce the number of false positives • To facilitate the auditing analysis • To provide a more intelligent Continuous Auditing routine • To monitor the credit risks associated to clients with total negative balance 16th World Continuous Auditing Symposium

  5. 2 Current Situation 16th World Continuous Auditing Symposium

  6. Current Situation • Data extraction from the legacy systems is processed in the mainframe environment, using a special software to create reports (FOCUS) • It reads the sequential files from the “current account system” • Exceptions are analyzed, checked and sent by e-mail to the audited areas who are responsible for finding the proper solutions • Exceptions can only be detected 5 days after they happen • We can only define one parameter to capture the exceptions 16th World Continuous Auditing Symposium

  7. 3 Proposed Situation 16th World Continuous Auditing Symposium

  8. Proposed Situation • Data extraction from the legacy systems is processed in the Data Warehouse environment, using a new flexible IT architecture • Creation of a Data Mart with clients credit information • Creation of a cross reference between clients credit information and “the current account system” • Reduction of the number of false positives as well as the time for auditing analysis • Detection of exceptions only 1 day after they happen • Definition of many parameters to make the cross reference and capture the exceptions • Creation of Key Performance Indicators 16th World Continuous Auditing Symposium

  9. 4 Cross Reference Parameters 16th World Continuous Auditing Symposium

  10. Cross References Cross References Credit System Behaviour Scoring System Renegotiation System Investment System CLIENT´S NET BALANCE Mortgage System Current Account System Cross References 16th World Continuous Auditing Symposium

  11. 4 Key Performance Indicators 16th World Continuous Auditing Symposium

  12. Key Performance Indicators by branch a) Excess amount b) The least, average, the highest and total excess amount c) Excess index / Result d) Excess index / clean portfolio e) Excess index / bad debts accrual f) Excess index monthly growth (amounts and quantities) g) Excess index / Limit h) Excess index / Excess total loss (amounts) i) Excess index / total loss 16th World Continuous Auditing Symposium

  13. 5 Conclusion 16th World Continuous Auditing Symposium

  14. Conclusion The improvements of this new process will impact tremendously the Continuous Auditing, bringing up: a) More effectiveness in controlling frauds and financial losses b) Timeless of auditing analysis c) Increase in the assertive auditing actions through a more effective risk mapping d) More independence to the auditors performance in their analysis e) Increase in the confidence of auditing data handling 16th World Continuous Auditing Symposium

  15. 6 Recommendation 16th World Continuous Auditing Symposium

  16. Recommendation Continuous Auditing Implementation process should be spread all over the organization until reaching all risk areas, as Accounting, Treasury, Credit, and others where there is a possibility of no compliance. 16th World Continuous Auditing Symposium

  17. Thank You! Washington Lopes Washington.lopes@unibanco.com.br 16th World Continuous Auditing Symposium

More Related