This extensive text, drawn from a book on forensic analytics, provides a comprehensive overview of methods and techniques used in forensic accounting investigations. It details the practical application of software like Microsoft Access, Excel, and PowerPoint for data analysis and reporting, emphasizing queries as a fundamental tool in Access for filtering, grouping, and joining data across tables. A significant portion is dedicated to Benford's Law, explaining its application in detecting anomalies and biases through tests like the first-two digits, second-order, and summation analysis. The text also introduces other techniques such as the Relative Size Factor (RSF) test for identifying disproportionately large amounts within subsets, the Same-Same-Different (SSD) test for finding potentially split transactions, and the use of correlation and time-series analysis to identify irregular patterns and predict future trends. Finally, the document explores risk-scoring methodologies as a means of continuous monitoring and fraud detection, illustrating their application in various scenarios including financial statement analysis and purchasing card audits.
Full podcast episode available here:
YouTube: https://www.youtube.com/playlist?list=PLMvxvfJimu-2cR6odLKtjn99EHQ8EmR_v //
Spotify: https://open.spotify.com/show/3Z75bmdxiaHuXCsZNrIEvF //
Apple Podcasts: https://podcasts.apple.com/us/podcast/busy-auditor-the-best-books-reviews/id1808857923 —
Follow us for more insights & updates:
Instagram: https://www.instagram.com/busy_proffesional/ —
TikTok: https://www.tiktok.com/@busyprofessional
Popular Podcasts
Stuff You Should Know
If you've ever wanted to know about champagne, satanism, the Stonewall Uprising, chaos theory, LSD, El Nino, true crime and Rosa Parks, then look no further. Josh and Chuck have you covered.
The Joe Rogan Experience
The official podcast of comedian Joe Rogan.
True Crime Tonight
If you eat, sleep, and breathe true crime, TRUE CRIME TONIGHT is serving up your nightly fix. Five nights a week, KT STUDIOS & iHEART RADIO invite listeners to pull up a seat for an unfiltered look at the biggest cases making headlines, celebrity scandals, and the trials everyone is watching. With a mix of expert analysis, hot takes, and listener call-ins, TRUE CRIME TONIGHT goes beyond the headlines to uncover the twists, turns, and unanswered questions that keep us all obsessed—because, at TRUE CRIME TONIGHT, there’s a seat for everyone. Whether breaking down crime scene forensics, scrutinizing serial killers, or debating the most binge-worthy true crime docs, True Crime Tonight is the fresh, fast-paced, and slightly addictive home for true crime lovers.