{"id":936,"date":"2020-04-02T14:50:26","date_gmt":"2020-04-02T14:50:26","guid":{"rendered":"https:\/\/alminawi.com\/?p=936"},"modified":"2025-12-07T18:21:08","modified_gmt":"2025-12-07T18:21:08","slug":"tts-series-e-internal-audit-evaluation-conclusion-techniques-episode-05-analytical-procedures-identify-trends-anomalies-or-variances","status":"publish","type":"post","link":"https:\/\/e.americanpro.org\/?p=936","title":{"rendered":"T&#038;Ts Series E, Internal Audit, Evaluation &#038; Conclusion Techniques, Episode 05\u2014 Analytical Procedures \u2013 Identify trends, anomalies, or variances."},"content":{"rendered":"<p data-start=\"149\" data-end=\"667\"><strong data-start=\"149\" data-end=\"190\">1. Introduction to the Tool\/Technique<\/strong><br data-start=\"190\" data-end=\"193\" \/>Analytical procedures are a powerful internal audit technique used to evaluate financial or operational data by studying plausible relationships between data sets. Auditors use these procedures to detect anomalies, outliers, or unexpected trends that could indicate errors or misstatements. These procedures are especially useful in the evaluation and conclusion phase of the audit, allowing the auditor to focus on high-risk areas without needing to test every transaction.<\/p>\n<p data-start=\"669\" data-end=\"703\">Analytical procedures may include:<\/p>\n<ul data-start=\"704\" data-end=\"904\">\n<li data-start=\"704\" data-end=\"755\">\n<p data-start=\"706\" data-end=\"755\">Trend analysis over time (e.g., revenue by month)<\/p>\n<\/li>\n<li data-start=\"756\" data-end=\"794\">\n<p data-start=\"758\" data-end=\"794\">Ratio analysis (e.g., profit margin)<\/p>\n<\/li>\n<li data-start=\"795\" data-end=\"858\">\n<p data-start=\"797\" data-end=\"858\">Comparison against budgets, forecasts, or industry benchmarks<\/p>\n<\/li>\n<li data-start=\"859\" data-end=\"904\">\n<p data-start=\"861\" data-end=\"904\">Identifying sudden or unexplained variances<\/p>\n<\/li>\n<\/ul>\n<hr data-start=\"906\" data-end=\"909\" \/>\n<p data-start=\"911\" data-end=\"1152\"><strong data-start=\"911\" data-end=\"984\">2. Fictitious Dataset: ACME Corp Monthly Profit Review (Jan\u2013Jun 2025)<\/strong><br data-start=\"984\" data-end=\"987\" \/>To illustrate the use of analytical procedures, we created the following dataset of ACME Corp\u2019s revenue, expense, and profit trends for the first six months of 2025:<\/p>\n<div class=\"_tableContainer_16hzy_1\">\n<div class=\"_tableWrapper_16hzy_14 group flex w-fit flex-col-reverse\" tabindex=\"-1\">\n<table class=\"w-fit min-w-(--thread-content-width)\" data-start=\"1154\" data-end=\"2016\">\n<thead data-start=\"1154\" data-end=\"1260\">\n<tr data-start=\"1154\" data-end=\"1260\">\n<th data-start=\"1154\" data-end=\"1166\" data-col-size=\"sm\">Month<\/th>\n<th data-start=\"1166\" data-end=\"1176\" data-col-size=\"sm\">Revenue<\/th>\n<th data-start=\"1176\" data-end=\"1186\" data-col-size=\"sm\">Expense<\/th>\n<th data-start=\"1186\" data-end=\"1199\" data-col-size=\"sm\">Net Profit<\/th>\n<th data-start=\"1199\" data-end=\"1218\" data-col-size=\"sm\">Revenue Variance<\/th>\n<th data-start=\"1218\" data-end=\"1237\" data-col-size=\"sm\">Expense Variance<\/th>\n<th data-start=\"1237\" data-end=\"1260\" data-col-size=\"sm\">Net Profit Variance<\/th>\n<\/tr>\n<\/thead>\n<tbody data-start=\"1369\" data-end=\"2016\">\n<tr data-start=\"1369\" data-end=\"1476\">\n<td data-start=\"1369\" data-end=\"1381\" data-col-size=\"sm\">Jan 2025<\/td>\n<td data-col-size=\"sm\" data-start=\"1381\" data-end=\"1391\">50,000<\/td>\n<td data-col-size=\"sm\" data-start=\"1391\" data-end=\"1401\">30,000<\/td>\n<td data-col-size=\"sm\" data-start=\"1401\" data-end=\"1414\">20,000<\/td>\n<td data-col-size=\"sm\" data-start=\"1414\" data-end=\"1433\">&#8211;<\/td>\n<td data-col-size=\"sm\" data-start=\"1433\" data-end=\"1452\">&#8211;<\/td>\n<td data-col-size=\"sm\" data-start=\"1452\" data-end=\"1476\">&#8211;<\/td>\n<\/tr>\n<tr data-start=\"1477\" data-end=\"1584\">\n<td data-start=\"1477\" data-end=\"1489\" data-col-size=\"sm\">Feb 2025<\/td>\n<td data-col-size=\"sm\" data-start=\"1489\" data-end=\"1499\">52,000<\/td>\n<td data-col-size=\"sm\" data-start=\"1499\" data-end=\"1509\">31,000<\/td>\n<td data-col-size=\"sm\" data-start=\"1509\" data-end=\"1522\">21,000<\/td>\n<td data-col-size=\"sm\" data-start=\"1522\" data-end=\"1541\">+2,000<\/td>\n<td data-col-size=\"sm\" data-start=\"1541\" data-end=\"1560\">+1,000<\/td>\n<td data-col-size=\"sm\" data-start=\"1560\" data-end=\"1584\">+1,000<\/td>\n<\/tr>\n<tr data-start=\"1585\" data-end=\"1692\">\n<td data-start=\"1585\" data-end=\"1597\" data-col-size=\"sm\">Mar 2025<\/td>\n<td data-start=\"1597\" data-end=\"1607\" data-col-size=\"sm\">54,000<\/td>\n<td data-start=\"1607\" data-end=\"1617\" data-col-size=\"sm\">29,000<\/td>\n<td data-start=\"1617\" data-end=\"1630\" data-col-size=\"sm\">25,000<\/td>\n<td data-start=\"1630\" data-end=\"1649\" data-col-size=\"sm\">+2,000<\/td>\n<td data-start=\"1649\" data-end=\"1668\" data-col-size=\"sm\">-2,000<\/td>\n<td data-start=\"1668\" data-end=\"1692\" data-col-size=\"sm\">+4,000<\/td>\n<\/tr>\n<tr data-start=\"1693\" data-end=\"1800\">\n<td data-start=\"1693\" data-end=\"1705\" data-col-size=\"sm\">Apr 2025<\/td>\n<td data-start=\"1705\" data-end=\"1715\" data-col-size=\"sm\">53,000<\/td>\n<td data-start=\"1715\" data-end=\"1725\" data-col-size=\"sm\">33,000<\/td>\n<td data-start=\"1725\" data-end=\"1738\" data-col-size=\"sm\">20,000<\/td>\n<td data-start=\"1738\" data-end=\"1757\" data-col-size=\"sm\">-1,000<\/td>\n<td data-start=\"1757\" data-end=\"1776\" data-col-size=\"sm\">+4,000<\/td>\n<td data-start=\"1776\" data-end=\"1800\" data-col-size=\"sm\">-5,000<\/td>\n<\/tr>\n<tr data-start=\"1801\" data-end=\"1908\">\n<td data-start=\"1801\" data-end=\"1813\" data-col-size=\"sm\">May 2025<\/td>\n<td data-start=\"1813\" data-end=\"1823\" data-col-size=\"sm\">53,500<\/td>\n<td data-start=\"1823\" data-end=\"1833\" data-col-size=\"sm\">28,000<\/td>\n<td data-start=\"1833\" data-end=\"1846\" data-col-size=\"sm\">25,500<\/td>\n<td data-start=\"1846\" data-end=\"1865\" data-col-size=\"sm\">+500<\/td>\n<td data-start=\"1865\" data-end=\"1884\" data-col-size=\"sm\">-5,000<\/td>\n<td data-start=\"1884\" data-end=\"1908\" data-col-size=\"sm\">+5,500<\/td>\n<\/tr>\n<tr data-start=\"1909\" data-end=\"2016\">\n<td data-start=\"1909\" data-end=\"1921\" data-col-size=\"sm\">Jun 2025<\/td>\n<td data-start=\"1921\" data-end=\"1931\" data-col-size=\"sm\">48,000<\/td>\n<td data-start=\"1931\" data-end=\"1941\" data-col-size=\"sm\">29,000<\/td>\n<td data-start=\"1941\" data-end=\"1954\" data-col-size=\"sm\">19,000<\/td>\n<td data-start=\"1954\" data-end=\"1973\" data-col-size=\"sm\">-5,500<\/td>\n<td data-start=\"1973\" data-end=\"1992\" data-col-size=\"sm\">+1,000<\/td>\n<td data-start=\"1992\" data-end=\"2016\" data-col-size=\"sm\">-6,500<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<div class=\"sticky end-(--thread-content-margin) h-0 self-end select-none\">\n<div class=\"absolute end-0 flex items-end\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<hr data-start=\"2018\" data-end=\"2021\" \/>\n<p data-start=\"2023\" data-end=\"2194\"><strong data-start=\"2023\" data-end=\"2092\">3. Practical Template: Analytical Procedures Matrix (Excel-based)<\/strong><br data-start=\"2092\" data-end=\"2095\" \/>Auditors can use an Excel-based <em data-start=\"2127\" data-end=\"2157\">Analytical Procedures Matrix<\/em> that includes the following columns:<\/p>\n<ul data-start=\"2195\" data-end=\"2334\">\n<li data-start=\"2195\" data-end=\"2206\">\n<p data-start=\"2197\" data-end=\"2206\"><strong data-start=\"2197\" data-end=\"2206\">Month<\/strong><\/p>\n<\/li>\n<li data-start=\"2207\" data-end=\"2241\">\n<p data-start=\"2209\" data-end=\"2241\"><strong data-start=\"2209\" data-end=\"2241\">Revenue, Expense, Net Profit<\/strong><\/p>\n<\/li>\n<li data-start=\"2242\" data-end=\"2276\">\n<p data-start=\"2244\" data-end=\"2276\"><strong data-start=\"2244\" data-end=\"2276\">Variance from Previous Month<\/strong><\/p>\n<\/li>\n<li data-start=\"2277\" data-end=\"2299\">\n<p data-start=\"2279\" data-end=\"2299\"><strong data-start=\"2279\" data-end=\"2299\">Auditor Comments<\/strong><\/p>\n<\/li>\n<li data-start=\"2300\" data-end=\"2334\">\n<p data-start=\"2302\" data-end=\"2334\"><strong data-start=\"2302\" data-end=\"2334\">Flag for Investigation (Y\/N)<\/strong><\/p>\n<\/li>\n<\/ul>\n<p data-start=\"2336\" data-end=\"2443\">This format helps auditors not only monitor performance but also flag and comment on anomalies efficiently.<\/p>\n<hr data-start=\"2445\" data-end=\"2448\" \/>\n<p data-start=\"2450\" data-end=\"2794\"><strong data-start=\"2450\" data-end=\"2504\">4. Real-Life Application: ACME Corp Audit by Auren<\/strong><br data-start=\"2504\" data-end=\"2507\" \/>Internal Auditor Auren used the Analytical Procedures Matrix to assess the monthly profit trend at ACME. CEO Liora was concerned about unpredictable fluctuations in profitability, while Project Manager Aven was responsible for overseeing marketing expenses, which had recently increased.<\/p>\n<p data-start=\"2796\" data-end=\"2821\">Findings from the matrix:<\/p>\n<ul data-start=\"2822\" data-end=\"3357\">\n<li data-start=\"2822\" data-end=\"3082\">\n<p data-start=\"2824\" data-end=\"3082\">In <strong data-start=\"2827\" data-end=\"2841\">April 2025<\/strong>, although revenue only dipped by $1,000, expenses increased by $4,000, leading to a $5,000 drop in net profit. Auren flagged this anomaly and found it was due to a one-time marketing campaign that Aven hadn\u2019t logged in the expense forecast.<\/p>\n<\/li>\n<li data-start=\"3083\" data-end=\"3357\">\n<p data-start=\"3085\" data-end=\"3357\">In <strong data-start=\"3088\" data-end=\"3101\">June 2025<\/strong>, revenue unexpectedly dropped by $5,500, which was not aligned with seasonal trends. Auren flagged the record and noted it might be due to delays in client invoicing or decreased project acquisition. He recommended immediate follow-up with the sales team.<\/p>\n<\/li>\n<\/ul>\n<p data-start=\"3359\" data-end=\"3486\">Auren presented these insights to Liora and Aven in a short dashboard format, prompting both corrective and preventive actions:<\/p>\n<ul data-start=\"3487\" data-end=\"3652\">\n<li data-start=\"3487\" data-end=\"3545\">\n<p data-start=\"3489\" data-end=\"3545\">Aven agreed to better document planned marketing spends.<\/p>\n<\/li>\n<li data-start=\"3546\" data-end=\"3652\">\n<p data-start=\"3548\" data-end=\"3652\">Liora instructed the finance team to reconcile billing timelines and ensure sales targets are met in Q3.<\/p>\n<\/li>\n<\/ul>\n<p data-start=\"3654\" data-end=\"3805\">These findings helped focus the audit\u2019s conclusion section on areas where controls or communication broke down\u2014not just where the numbers didn\u2019t match.<\/p>\n<p>__________<\/p>\n<p>Upon reading the <a href=\"https:\/\/americanpro.org\/?page_id=105\">Disclaimer<\/a>, a reader may click the link below to download an example of a relevant tool.<\/p>\n<p><a href=\"https:\/\/americanpro.org\/wp-content\/uploads\/2020\/04\/TTs-Series-E-Internal-Audit-Evaluation-Conclusion-Techniques-Episode-05\u2014-Analytical-Procedures.xlsx\">T&amp;Ts Series E, Internal Audit, Evaluation &amp; Conclusion Techniques, Episode 05\u2014 Analytical Procedures<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. Introduction to the Tool\/TechniqueAnalytical procedures are a powerful internal audit technique used to evaluate financial or operational data by studying plausible relationships between data sets. Auditors use these procedures to detect anomalies, outliers, or unexpected trends that could indicate errors or misstatements. These procedures are especially useful in the evaluation and conclusion phase of [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":786,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[22],"tags":[],"class_list":["post-936","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tt-internal-audit"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/e.americanpro.org\/wp-content\/uploads\/2025\/06\/Eye-3.gif","_links":{"self":[{"href":"https:\/\/e.americanpro.org\/index.php?rest_route=\/wp\/v2\/posts\/936","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/e.americanpro.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/e.americanpro.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/e.americanpro.org\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/e.americanpro.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=936"}],"version-history":[{"count":1,"href":"https:\/\/e.americanpro.org\/index.php?rest_route=\/wp\/v2\/posts\/936\/revisions"}],"predecessor-version":[{"id":1294,"href":"https:\/\/e.americanpro.org\/index.php?rest_route=\/wp\/v2\/posts\/936\/revisions\/1294"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/e.americanpro.org\/index.php?rest_route=\/wp\/v2\/media\/786"}],"wp:attachment":[{"href":"https:\/\/e.americanpro.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=936"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/e.americanpro.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=936"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/e.americanpro.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=936"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}