1 / 10

Excel Tips and Tricks to Find Improper Payments Jim Davidson Bob Lehmann

Excel Tips and Tricks to Find Improper Payments Jim Davidson Bob Lehmann. Bureau of State Expenditures. Audits state expenditures prior to payment Conducts post audits. Environment. 450 Agencies 4 million payments $80 billion. Other payments. Bureau of State Expenditures.

clodia
Download Presentation

Excel Tips and Tricks to Find Improper Payments Jim Davidson Bob Lehmann

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. Excel Tips and Tricks to Find Improper Payments Jim Davidson Bob Lehmann

  2. Bureau of State Expenditures • Audits state expenditures prior to payment • Conducts post audits Office of Operations 2009 Fall Conference

  3. Environment • 450 Agencies • 4 million payments • $80 billion Office of Operations 2009 Fall Conference

  4. Other payments Office of Operations 2009 Fall Conference

  5. Bureau of State Expenditures 4 million payments worth $80 billion in 254 business days annually 16,000/$315 million payments a day!!! 50 auditors - 320/$6.3 million payments each day Office of Operations 2009 Fall Conference

  6. Bureau of State Expenditures Office of Operations 2009 Fall Conference

  7. Data Analysis Data analysis is a process of systematically applying statistical and logical techniques to summarize, compare, and describe data. We use data analysis to evaluate risk and determine where to best focus our audit efforts. Office of Operations 2009 Fall Conference

  8. Data Analysis Tools Office of Operations 2009 Fall Conference

  9. Course Objectives • Import text files • Verify data (using sum/count/sort) • Basic & advanced filters • Summarizing data • Basic & advanced formulas/functions • Pivot Tables • Identify Duplicates and Gaps • Benford’s Analysis Office of Operations 2009 Fall Conference

  10. To obtain a copy of the supporting documents used in this presentation, send an email to the Outreach Training Program – Outreach@osc.state.ny.us Office of Operations 2009 Fall Conference

More Related