In this training you will learn:
- How to complete improved risk assessments to assess financial risk in the organization, using data
- Prioritize the top red flags of financial statement fraud and misappropriation, based on research culled from recent surveys
- Improve audit planning by using general ledger, financial statement, and journal entry analysis (Excel worksheet provided to participants for ratio analysis)
- See how in Excel to run key proactive fraud tests in the areas of the general ledger overall, manual journal entries to the ledger, and completing other financial statement analysis.
- Graphing the ledger activity, and trial balance data for multiple periods to paint a picture of change in the organization using Excel conditional formatting
- Search for key words within the data (and providing scripts to participants to help their key word searches) for financial statement and FCPA compliance, as well as, better understanding the business
- How fraud scoring can use a customized weighting system to flag suspicious transactions in the general ledger.
This is a previously recorded 2-hour webinar from AuditNet® with Jim Kaplan and Rich Lanza.
Delivery Method: Self-Study
AuditNet® is the Global Resource for Auditors, and serves the global audit community as the primary communications resource with an online digital network where auditors share resources, tools, and experiences including audit work programs and other audit documentation.
As the first online portal for the global audit community, AuditNet® has been at the forefront of audit websites dedicated to promoting the use of technology. http://www.auditnet.org/
Jim Kaplan, the founder of AuditNet®, became a Certified Internal Auditor in 1984. He has continuously promoted and encouraged the use of technology and the Internet for audit productivity.
As an active member of the IIA, he has held many positions at the local and International level. He is a founding member of the Northern Virginia Chapter and served as Chapter President in 1989. He retired from his government audit director position in 2005. He is the founder and President of AuditNet®, the global resource for auditors, and has been identified as an Internet for Auditors pioneer. Jim's contributions to the profession were recognized by the IIA (2007 Bradford Cadmus award) and the Association of Local Government Auditors (Lifetime Achievement Award). In addition to the IIA, he is a member of the Association of Local Government Auditors and the Association of Certified Fraud Examiners.