{"id":328,"date":"2016-06-07T13:09:00","date_gmt":"2016-06-07T13:09:00","guid":{"rendered":"http:\/\/obscure-representative.flywheelsites.com\/?p=328"},"modified":"2019-11-27T20:48:42","modified_gmt":"2019-11-27T20:48:42","slug":"journal-entry-testing-made-simple","status":"publish","type":"post","link":"https:\/\/www.audimation.com\/journal-entry-testing-made-simple\/","title":{"rendered":"Journal Entry Testing Made Simple"},"content":{"rendered":"<h4>IDEA Smart Analyzer Financial Simplifies Tests as Recommended in Center for Audit Quality Practice Aid for Testing Journal Entries <\/h4>\n<p>&nbsp;<\/p>\n<p>The Center for Audit Quality (CAQ), affiliated with the American Institute of Certified Public Accountants, issued an informative publication titled, &ldquo;Practice Aid for Testing Journal Entries and Other Adjustments Pursuant to AU Section 316.&rdquo; Prepared by representatives from the member firms of the CAQ, the practice aid is part of an overall effort to help audit firms and internal audit departments of public companies develop more effective methods of fraud prevention and detection.<\/p>\n<p>It is intended as a reference source for those applying certain sections of AU Section 316 of the Public Company Accounting Oversight Board\u201fs (PCAOB) Interim Auditing Standards, Consideration of Fraud in a Financial Statement Audit. The practice aid focuses on the auditor\u201fs testing of journal entries and other adjustments for evidence of possible material misstatements, which may help detect fraud. The complete publication, released on Dec. 8, 2008, may be viewed at: <a href=\"https:\/\/www.thecaq.org\/resources\/\">The Center for Audit Quality<\/a>.<\/p>\n<p>Section 5.5 (pages 23-24) &ldquo;Using CAAT for Journal Entry Testing&rdquo; addresses the use of computer-assisted audit techniques (CAAT) to identify journal entries and other adjustments to be tested. IDEA&reg; &ndash; Data Analysis Software is noted as one of the select data analysis software tools designed to evaluate large sets of financial data. The practice aid also lists a menu of CAAT queries that may be performed by data analysis software to extract journal entry data, which is then investigated to determine if they are appropriate and supported.<\/p>\n<p>The CAAT queries listed in the CAQ&#8217;s practice aid may be performed using IDEA functions. IDEA Smart Analyzer Financial, an add-on component of IDEA, offers pre-defined tests to further simplify the process as demonstrated in the table below: January 16, 2009<\/p>\n<p>&nbsp;<\/p>\n<h4>CAQ Recommended CAAT Queries<\/h4>\n<p>&nbsp;<\/p>\n<ul>\n<li>Find journal entries that do not balance Summarization<\/li>\n<li>Find gaps in journal entry number sequence<\/li>\n<li>Find high-dollar journal entries Equation Editor<\/li>\n<li>Find possible duplicate account entries<\/li>\n<li>Find round-dollar journal entries<\/li>\n<li>Show journal entry information by employee<\/li>\n<li>Find all entries made by a specific employee<\/li>\n<li>Show values for the &#39;journal entry type&#39;&nbsp;code<\/li>\n<li>Find manual entries<\/li>\n<li>Sample journal entries (random or high dollar)<\/li>\n<li>Find specific journal entries (by month, day or JE#)<\/li>\n<li>Find all entries containing specific account(s)<\/li>\n<li>Find all entries within a range of accounts<\/li>\n<li>Find entries with unusual (non-standard) description<\/li>\n<li>Find entries posted on weekends<\/li>\n<\/ul>\n<p>By following the recommendations as outlined in the CAQ\u201fs practice aid, auditors can develop a more uniform approach to search for and identify fraud.<\/p>\n<p>IDEA Smart Analyzer Financial tests may be run on any client\u201fs general ledger data by following three simple steps: import GL data into IDEA; tag the fields so the test routines know which fields to use; select the tests to perform. This process allows the audit team to perform more efficient and effective audits with a high return on investment. Easy to use and implement, IDEA Smart Analyzer docks to IDEA&#39;s Analysis menu and comes with full online help and easy-to-follow dialog boxes, making it simple to deploy within the firm or audit department.<\/p>\n<p><img decoding=\"async\" alt=\"Screenshot of General Ledger Analysis Dialog Box\" src=\"https:\/\/i0.wp.com\/www.audimation.com\/wp-content\/uploads\/2019\/10\/jetesting.jpg?ssl=1\" style=\"width: 676px; height: 335px;\" data-recalc-dims=\"1\" \/><\/p>\n<p>In addition to General Ledger Analysis, IDEA Smart Analyzer Financial offers many other audit tests and reports that can be run on accounts receivable, accounts payable, fixed assets and inventory data files using the same three-step process. Below are a few of the tests available:<\/p>\n<p>&nbsp;<\/p>\n<h4>Accounts Receivable<\/h4>\n<p>&nbsp;<\/p>\n<ul>\n<li>Accounts with Balances or Transactions Exceeding Credit Limits<\/li>\n<li>Transactions Around a Date Range<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h4>Accounts Payable<\/h4>\n<p>&nbsp;<\/p>\n<ul>\n<li>Duplicate Invoices or Payments<\/li>\n<li>Creditors with Net Debit Balance<\/li>\n<li>Invoices Without Purchase Orders<\/li>\n<li>Transactions with Rounded Amounts<\/li>\n<li>Duplicate Field Search<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h4>Fixed Assets<\/h4>\n<p>&nbsp;<\/p>\n<ul>\n<li>Fixed Assets Additions<\/li>\n<li>Asset Category Summary<\/li>\n<li>Recalculations of Depreciation<\/li>\n<li>Depreciation Exceeding Cost<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h4>Inventory<\/h4>\n<p>&nbsp;<\/p>\n<ul>\n<li>Aging by Receipt Date<\/li>\n<li>Zero or Negative Unit Cost<\/li>\n<li>Inventory Received Around a Specific Date<\/li>\n<li>Compare Sales Price with Unit Cost<\/li>\n<\/ul>\n<p>By using IDEA and IDEA Smart Analyzer Financial, auditors can perform more comprehensive audits with less effort. Furthermore, IDEA Smart Analyzer Financial can be used on every audit engagement to improve audit quality and consistency to assist in meeting today\u201fs audit standards, including standards related to fraud such as SAS 99.<\/p>\n<p>For additional information, and to obtain product profiles for IDEA and IDEA Smart Analyzer Financial, visit www.audimation.com or call 888-641-2800. IDEA is a registered trademark of CaseWare International Inc<\/p>\n","protected":false},"excerpt":{"rendered":"<p>IDEA Smart Analyzer Financial Simplifies Tests as Recommended in Center for Audit Quality Practice Aid for Testing Journal Entries &nbsp; The Center for Audit Quality (CAQ), affiliated with the American Institute of Certified Public Accountants, issued an informative publication titled, &ldquo;Practice Aid for Testing Journal Entries and Other Adjustments Pursuant to AU Section 316.&rdquo; Prepared [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":3893,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31,22,19],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Journal Entry Testing Made Simple | Audimation<\/title>\n<meta name=\"description\" content=\"IDEA Smart Analyzer Financial Simplifies Tests as Recommended in Center for Audit Quality Practice Aid for Testing Journal Entries\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.audimation.com\/journal-entry-testing-made-simple\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Journal Entry Testing Made Simple | Audimation\" \/>\n<meta property=\"og:description\" content=\"IDEA Smart Analyzer Financial Simplifies Tests as Recommended in Center for Audit Quality Practice Aid for Testing Journal Entries\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.audimation.com\/journal-entry-testing-made-simple\/\" \/>\n<meta property=\"og:site_name\" content=\"Audimation\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/CaseWareInternational\" \/>\n<meta property=\"article:published_time\" content=\"2016-06-07T13:09:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-11-27T20:48:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i0.wp.com\/www.audimation.com\/wp-content\/uploads\/2019\/10\/finger-touch-digital-screen.png?fit=400%2C267&ssl=1\" \/>\n\t<meta property=\"og:image:width\" content=\"400\" \/>\n\t<meta property=\"og:image:height\" content=\"267\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Sarah Palombo\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@Audimation\" \/>\n<meta name=\"twitter:site\" content=\"@Audimation\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.audimation.com\/journal-entry-testing-made-simple\/\",\"url\":\"https:\/\/www.audimation.com\/journal-entry-testing-made-simple\/\",\"name\":\"Journal Entry Testing Made Simple | Audimation\",\"isPartOf\":{\"@id\":\"https:\/\/www.audimation.com\/#website\"},\"datePublished\":\"2016-06-07T13:09:00+00:00\",\"dateModified\":\"2019-11-27T20:48:42+00:00\",\"author\":{\"@id\":\"https:\/\/www.audimation.com\/#\/schema\/person\/e42c0529c350e64c1aa1fabf3aba6c68\"},\"description\":\"IDEA Smart Analyzer Financial Simplifies Tests as Recommended in Center for Audit Quality Practice Aid for Testing Journal Entries\",\"breadcrumb\":{\"@id\":\"https:\/\/www.audimation.com\/journal-entry-testing-made-simple\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.audimation.com\/journal-entry-testing-made-simple\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.audimation.com\/journal-entry-testing-made-simple\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.audimation.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Journal Entry Testing Made Simple\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.audimation.com\/#website\",\"url\":\"https:\/\/www.audimation.com\/\",\"name\":\"Audimation\",\"description\":\"Putting Data Analytics to Work\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.audimation.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.audimation.com\/#\/schema\/person\/e42c0529c350e64c1aa1fabf3aba6c68\",\"name\":\"Sarah Palombo\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.audimation.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b5d719cc109f9b0602b29799e3e7b9ef?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b5d719cc109f9b0602b29799e3e7b9ef?s=96&d=mm&r=g\",\"caption\":\"Sarah Palombo\"},\"description\":\"Sarah Palombo founded Avery Public Relations in 2007 and took on Audimation Services as her first client. She has more than 20 years of experience developing communications programs and creating content.\",\"sameAs\":[\"http:\/\/www.averypr.com\"],\"url\":\"https:\/\/www.audimation.com\/author\/sarahaverypr-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Journal Entry Testing Made Simple | Audimation","description":"IDEA Smart Analyzer Financial Simplifies Tests as Recommended in Center for Audit Quality Practice Aid for Testing Journal Entries","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.audimation.com\/journal-entry-testing-made-simple\/","og_locale":"en_US","og_type":"article","og_title":"Journal Entry Testing Made Simple | Audimation","og_description":"IDEA Smart Analyzer Financial Simplifies Tests as Recommended in Center for Audit Quality Practice Aid for Testing Journal Entries","og_url":"https:\/\/www.audimation.com\/journal-entry-testing-made-simple\/","og_site_name":"Audimation","article_publisher":"https:\/\/www.facebook.com\/CaseWareInternational","article_published_time":"2016-06-07T13:09:00+00:00","article_modified_time":"2019-11-27T20:48:42+00:00","og_image":[{"width":400,"height":267,"url":"https:\/\/i0.wp.com\/www.audimation.com\/wp-content\/uploads\/2019\/10\/finger-touch-digital-screen.png?fit=400%2C267&ssl=1","type":"image\/png"}],"author":"Sarah Palombo","twitter_card":"summary_large_image","twitter_creator":"@Audimation","twitter_site":"@Audimation","twitter_misc":{"Written by":false,"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.audimation.com\/journal-entry-testing-made-simple\/","url":"https:\/\/www.audimation.com\/journal-entry-testing-made-simple\/","name":"Journal Entry Testing Made Simple | Audimation","isPartOf":{"@id":"https:\/\/www.audimation.com\/#website"},"datePublished":"2016-06-07T13:09:00+00:00","dateModified":"2019-11-27T20:48:42+00:00","author":{"@id":"https:\/\/www.audimation.com\/#\/schema\/person\/e42c0529c350e64c1aa1fabf3aba6c68"},"description":"IDEA Smart Analyzer Financial Simplifies Tests as Recommended in Center for Audit Quality Practice Aid for Testing Journal Entries","breadcrumb":{"@id":"https:\/\/www.audimation.com\/journal-entry-testing-made-simple\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.audimation.com\/journal-entry-testing-made-simple\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.audimation.com\/journal-entry-testing-made-simple\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.audimation.com\/"},{"@type":"ListItem","position":2,"name":"Journal Entry Testing Made Simple"}]},{"@type":"WebSite","@id":"https:\/\/www.audimation.com\/#website","url":"https:\/\/www.audimation.com\/","name":"Audimation","description":"Putting Data Analytics to Work","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.audimation.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.audimation.com\/#\/schema\/person\/e42c0529c350e64c1aa1fabf3aba6c68","name":"Sarah Palombo","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.audimation.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b5d719cc109f9b0602b29799e3e7b9ef?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b5d719cc109f9b0602b29799e3e7b9ef?s=96&d=mm&r=g","caption":"Sarah Palombo"},"description":"Sarah Palombo founded Avery Public Relations in 2007 and took on Audimation Services as her first client. She has more than 20 years of experience developing communications programs and creating content.","sameAs":["http:\/\/www.averypr.com"],"url":"https:\/\/www.audimation.com\/author\/sarahaverypr-com\/"}]}},"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.audimation.com\/wp-content\/uploads\/2019\/10\/finger-touch-digital-screen.png?fit=400%2C267&ssl=1","_links":{"self":[{"href":"https:\/\/www.audimation.com\/wp-json\/wp\/v2\/posts\/328"}],"collection":[{"href":"https:\/\/www.audimation.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.audimation.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.audimation.com\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.audimation.com\/wp-json\/wp\/v2\/comments?post=328"}],"version-history":[{"count":4,"href":"https:\/\/www.audimation.com\/wp-json\/wp\/v2\/posts\/328\/revisions"}],"predecessor-version":[{"id":4111,"href":"https:\/\/www.audimation.com\/wp-json\/wp\/v2\/posts\/328\/revisions\/4111"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.audimation.com\/wp-json\/wp\/v2\/media\/3893"}],"wp:attachment":[{"href":"https:\/\/www.audimation.com\/wp-json\/wp\/v2\/media?parent=328"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.audimation.com\/wp-json\/wp\/v2\/categories?post=328"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.audimation.com\/wp-json\/wp\/v2\/tags?post=328"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}