{"id":1317,"date":"2013-11-26T14:37:39","date_gmt":"2013-11-26T14:37:39","guid":{"rendered":"https:\/\/www.peeriosity.com\/shared-services\/articles\/?p=1317"},"modified":"2022-06-30T17:49:11","modified_gmt":"2022-06-30T17:49:11","slug":"using-big-data-to-redesign-the-expense-report-audit-process","status":"publish","type":"post","link":"https:\/\/www.peeriosity.com\/shared-services\/articles\/2013\/11\/using-big-data-to-redesign-the-expense-report-audit-process\/","title":{"rendered":"Using Big Data to Redesign the Expense Report Audit Process"},"content":{"rendered":"

The introduction of global processes for Travel Expenses, combined with new capabilities to collect and analyze data from multiple sources, creates new opportunities for companies to make dramatic changes to how the travel expense report process is designed and administered.\u00a0 <\/span>One of the most highly impacted areas is the expense report audit process<\/a>, where using data analytic techniques can dramatically reduce the need for traditional audits of expense reports.<\/span><\/p>\n

During a recent Peercast, a global manufacturing company with over $25B USD in annual revenue discussed its ten-year journey to move to a common T&E solution and standardize processes and procedures across the globe.\u00a0\u00a0 <\/span>Even after much time and effort, there remained significant problems with the current audit process, including:<\/span><\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span>Audit findings weren\u2019t significant, as compliance breaches were generally hidden from initial audits<\/span><\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span>The audit process did not include tools to identify fraud<\/span><\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span>Without detailed key words to review, moving to a global center for audit meant auditors didn\u2019t have familiarity with possible problem vendors <\/span><\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span>There was a need for an increased focus on \u201canti-bribery, anti-corruption\u201d risk, reputational risk, and ethical interactions, and less on insignificant and unintentional mistakes (for example, having a 6 Euro expense supported by a 5 Euro receipt).<\/span><\/p>\n

Our feature company created a three-step approach to Expense Report Audits in their redesign of the audit process:<\/span><\/p>\n

Step 1:\u00a0 <\/span>Manager Review<\/span><\/strong><\/p>\n

Using delegation of authority rules, 100% of expense reports are reviewed by an employee\u2019s manager.\u00a0 <\/span>To be effective, managers must be properly trained on the company\u2019s expense policy that all users agree to follow as part of the employee code of conduct.\u00a0 <\/span>Formal training was conducted through e-learning for all users, with a detailed module on how to review an expense report.\u00a0 <\/span><\/span><\/p>\n

In addition, the review process was streamlined based on feedback from reviewing managers; allowing for many line items to have summary totals, with the ability to drill down to review underlying details as necessary.<\/span><\/p>\n

Step 2:<\/span><\/strong>\u00a0 <\/span>Random audits at the Shared Service Center<\/span><\/p>\n

A small percentage of reports continue to be selected for audit to review scenarios that can\u2019t be reviewed through data analytics.\u00a0 <\/span>This includes identifying missing receipts, VAT review, looking for fake receipts, and out-of-pocket amounts that don\u2019t match the receipt.\u00a0 <\/span><\/span><\/p>\n

Step 3:<\/span><\/strong>\u00a0 <\/span>Data Analytics – Combining Data from Multiple Sources into a Single Database for Analysis<\/span><\/p>\n

In this step, 100% of expense reports are electronically analyzed each quarter against test questions to identify trends and patterns, with data from multiple systems (CRM<\/a>, HR, P2P) included.\u00a0 <\/span>For exceptions identified, a Local Compliance Officer located in each market follows up directly with the employee.\u00a0 <\/span>The savings from reducing staff to conduct audits have been reinvested in more sophisticated data analytics tools.\u00a0 <\/span><\/span><\/p>\n

A sample of test questions includes:<\/span><\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span>Dates where expenses were claimed when the employee was on vacation, sick, or where it was a public holiday<\/span><\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span>High-value expenses<\/span><\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span>A high cash spend<\/span><\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span>Repetitive charges to the same vendor<\/span><\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span>Duplicate expense amounts<\/span><\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span>Keywords or vendor names that might suggest personal expenses<\/span><\/p>\n

Based on the supporting iPoll1<\/sup>, while 41% of companies audit 10% or fewer expense reports, 17% are auditing 100% of them.\u00a0 <\/span>Here are the details: <\/span><\/p>\n

\u00a0<\/span>\"ipolling<\/p>\n

\u00a0<\/span><\/p>\n

The follow-up question asked, \u201cWhat is the status of performing a formal cost\/benefit analysis trading off the cost of the audit with the benefit of fraud detection to determine the optimum expense report audit level at your company?\u201d The results to this question were particularly interesting, with only 13% of companies reporting that they have completed such a review, and a full 50% have either not considered the idea, or they decided not to conduct an analysis.<\/span><\/p>\n

\u00a0<\/span>\"status<\/p>\n

\u00a0<\/span><\/p>\n

Comments from iPolling participants provide additional insight:<\/span><\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span>Audit annually selects approximately 10% of employee expense reports to review. In addition, Operations Accounting, in certain areas such as Latin America, the USA, and Canada reviews either a sample or many Expense Reports based on what has been “deemed” appropriate. Operations Accounting in the Eastern Hemisphere reviews 100% of employee expense reports. We are looking at a possible transformation in the T&E process to drive greater automation<\/a> and tools to facilitate random reviews. <\/span><\/em><\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span>We audit based on whether or not expense reports meet specific criteria rather than a set percentage. However, the average percentage is about 65%. <\/span><\/em><\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span>Our current 100% audit is not reasonable. We have begun the research<\/a> for determining what is the best practice for a company similar in size. <\/span><\/em><\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span>We built Internal Controls into our Travel & Expense System configuration and we hold our Managers accountable for approving an employee\u2019s expense report for payment that is not compliant with our Travel Policy. <\/span><\/em><\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span>In the U.S., we were auditing 10-13% of expense reports, but recently reduced the amount to 5% due to the number of low-risk items being found. <\/span><\/em><\/p>\n

\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span>We have our global T&E auditing centralized and some of our countries are at 100% audit. <\/span><\/em><\/p>\n

\u00a0<\/span><\/p>\n

Does your company have a global process owner for the Travel Expense Process?\u00a0 <\/span><\/span><\/p>\n

How does your Travel Expense Report audit process vary by country?\u00a0 <\/span>Have you evaluated the cost\/benefit trade-off between the cost of the audit with the benefits of fraud detection to determine the optimum expense report audit level at your company?<\/span><\/p>\n

Who are your<\/em><\/span> peers and how are you collaborating with them?<\/span><\/p>\n

\u201cPeercastsTM<\/sup>\u201d are private, professionally facilitated webcasts that feature leading member company experiences on specific topics as a catalyst for broader discussion.\u00a0 <\/span>Access is available exclusively to Peeriosity member company employees, with consultants or vendors prohibited from attending or accessing discussion content.\u00a0 <\/span>Members can see who is registered to attend in advance, with discussion recordings, supporting polls, and presentation materials online and available whenever convenient for the member.\u00a0 <\/span>Using Peeriosity\u2019s integrated email system, Peer MailTM<\/sup>, attendees can easily communicate at any time with other attending peers by selecting them from the list of registered attendees.\u00a0 <\/span><\/span><\/p>\n

1 <\/span><\/sup>\u201ciPolling\u201d is available exclusively to Peeriosity member company employees, with consultants or vendors prohibited from participating or accessing content. Members have full visibility of all respondents and their comments. Using Peeriosity\u2019s integrated email system, Peer MailTM<\/sup>, members can easily communicate at any time with others who participated in the iPoll. <\/span><\/p>\n

\u00a0<\/span><\/p>\n

\n

Peeriosity members are invited to login to <\/span>www.peeriosity.com\/shared-services\/<\/span><\/a><\/span> to join the discussion and connect with Peers.\u00a0\u00a0 <\/span>Membership is for practitioners only, with no consultants or vendors permitted. \u00a0<\/span>To learn more about Peeriosity <\/span>click here<\/span><\/a><\/span>.<\/span><\/p>\n<\/div>\n

<\/span><\/span><\/span><\/p>","protected":false},"excerpt":{"rendered":"

The introduction of global processes for Travel Expenses, combined with new capabilities to collect and analyze data from multiple sources, creates new opportunities for companies to make dramatic changes to how the travel expense report process is designed and administered.\u00a0 One of the most highly impacted areas is the expense report audit process, where using […]<\/p>\n

<\/span><\/span><\/span><\/p>","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[5],"tags":[],"acf":[],"yoast_head":"\nBig Data: Redesigning the Expense Report Audit Process | Peeriosity, LLC<\/title>\n<meta name=\"description\" content=\"Collecting and analyzing big data from multiple sources, and creating new opportunities to make changes to the travel expense report process.\" \/>\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.peeriosity.com\/shared-services\/articles\/2013\/11\/using-big-data-to-redesign-the-expense-report-audit-process\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using Big Data to Redesign the Expense Report Audit Process\" \/>\n<meta property=\"og:description\" content=\"Collecting and analyzing big data from multiple sources, and creating new opportunities to make changes to the travel expense report process.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.peeriosity.com\/shared-services\/articles\/2013\/11\/using-big-data-to-redesign-the-expense-report-audit-process\/\" \/>\n<meta property=\"og:site_name\" content=\"Peeriosity\" \/>\n<meta property=\"article:published_time\" content=\"2013-11-26T14:37:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-06-30T17:49:11+00:00\" \/>\n<meta name=\"author\" content=\"Peeriosity\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Peeriosity\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.peeriosity.com\/shared-services\/articles\/2013\/11\/using-big-data-to-redesign-the-expense-report-audit-process\/\",\"url\":\"https:\/\/www.peeriosity.com\/shared-services\/articles\/2013\/11\/using-big-data-to-redesign-the-expense-report-audit-process\/\",\"name\":\"Big Data: Redesigning the Expense Report Audit Process | Peeriosity, LLC\",\"isPartOf\":{\"@id\":\"https:\/\/www.peeriosity.com\/shared-services\/articles\/#website\"},\"datePublished\":\"2013-11-26T14:37:39+00:00\",\"dateModified\":\"2022-06-30T17:49:11+00:00\",\"author\":{\"@id\":\"https:\/\/www.peeriosity.com\/shared-services\/articles\/#\/schema\/person\/2f958fda27bcb7a0a07ed284f5d6b634\"},\"description\":\"Collecting and analyzing big data from multiple sources, and creating new opportunities to make changes to the travel expense report process.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.peeriosity.com\/shared-services\/articles\/2013\/11\/using-big-data-to-redesign-the-expense-report-audit-process\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.peeriosity.com\/shared-services\/articles\/2013\/11\/using-big-data-to-redesign-the-expense-report-audit-process\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.peeriosity.com\/shared-services\/articles\/2013\/11\/using-big-data-to-redesign-the-expense-report-audit-process\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.peeriosity.com\/shared-services\/articles\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using Big Data to Redesign the Expense Report Audit Process\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.peeriosity.com\/shared-services\/articles\/#website\",\"url\":\"https:\/\/www.peeriosity.com\/shared-services\/articles\/\",\"name\":\"Peeriosity\",\"description\":\"Peeriosity Research\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.peeriosity.com\/shared-services\/articles\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.peeriosity.com\/shared-services\/articles\/#\/schema\/person\/2f958fda27bcb7a0a07ed284f5d6b634\",\"name\":\"Peeriosity\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.peeriosity.com\/shared-services\/articles\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/246cadb9b3a1cd5f20797ba770c7b1e1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/246cadb9b3a1cd5f20797ba770c7b1e1?s=96&d=mm&r=g\",\"caption\":\"Peeriosity\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Big Data: Redesigning the Expense Report Audit Process | Peeriosity, LLC","description":"Collecting and analyzing big data from multiple sources, and creating new opportunities to make changes to the travel expense report process.","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.peeriosity.com\/shared-services\/articles\/2013\/11\/using-big-data-to-redesign-the-expense-report-audit-process\/","og_locale":"en_US","og_type":"article","og_title":"Using Big Data to Redesign the Expense Report Audit Process","og_description":"Collecting and analyzing big data from multiple sources, and creating new opportunities to make changes to the travel expense report process.","og_url":"https:\/\/www.peeriosity.com\/shared-services\/articles\/2013\/11\/using-big-data-to-redesign-the-expense-report-audit-process\/","og_site_name":"Peeriosity","article_published_time":"2013-11-26T14:37:39+00:00","article_modified_time":"2022-06-30T17:49:11+00:00","author":"Peeriosity","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Peeriosity","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.peeriosity.com\/shared-services\/articles\/2013\/11\/using-big-data-to-redesign-the-expense-report-audit-process\/","url":"https:\/\/www.peeriosity.com\/shared-services\/articles\/2013\/11\/using-big-data-to-redesign-the-expense-report-audit-process\/","name":"Big Data: Redesigning the Expense Report Audit Process | Peeriosity, LLC","isPartOf":{"@id":"https:\/\/www.peeriosity.com\/shared-services\/articles\/#website"},"datePublished":"2013-11-26T14:37:39+00:00","dateModified":"2022-06-30T17:49:11+00:00","author":{"@id":"https:\/\/www.peeriosity.com\/shared-services\/articles\/#\/schema\/person\/2f958fda27bcb7a0a07ed284f5d6b634"},"description":"Collecting and analyzing big data from multiple sources, and creating new opportunities to make changes to the travel expense report process.","breadcrumb":{"@id":"https:\/\/www.peeriosity.com\/shared-services\/articles\/2013\/11\/using-big-data-to-redesign-the-expense-report-audit-process\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.peeriosity.com\/shared-services\/articles\/2013\/11\/using-big-data-to-redesign-the-expense-report-audit-process\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.peeriosity.com\/shared-services\/articles\/2013\/11\/using-big-data-to-redesign-the-expense-report-audit-process\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.peeriosity.com\/shared-services\/articles\/"},{"@type":"ListItem","position":2,"name":"Using Big Data to Redesign the Expense Report Audit Process"}]},{"@type":"WebSite","@id":"https:\/\/www.peeriosity.com\/shared-services\/articles\/#website","url":"https:\/\/www.peeriosity.com\/shared-services\/articles\/","name":"Peeriosity","description":"Peeriosity Research","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.peeriosity.com\/shared-services\/articles\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.peeriosity.com\/shared-services\/articles\/#\/schema\/person\/2f958fda27bcb7a0a07ed284f5d6b634","name":"Peeriosity","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.peeriosity.com\/shared-services\/articles\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/246cadb9b3a1cd5f20797ba770c7b1e1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/246cadb9b3a1cd5f20797ba770c7b1e1?s=96&d=mm&r=g","caption":"Peeriosity"}}]}},"_links":{"self":[{"href":"https:\/\/www.peeriosity.com\/shared-services\/articles\/wp-json\/wp\/v2\/posts\/1317"}],"collection":[{"href":"https:\/\/www.peeriosity.com\/shared-services\/articles\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.peeriosity.com\/shared-services\/articles\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.peeriosity.com\/shared-services\/articles\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.peeriosity.com\/shared-services\/articles\/wp-json\/wp\/v2\/comments?post=1317"}],"version-history":[{"count":11,"href":"https:\/\/www.peeriosity.com\/shared-services\/articles\/wp-json\/wp\/v2\/posts\/1317\/revisions"}],"predecessor-version":[{"id":5421,"href":"https:\/\/www.peeriosity.com\/shared-services\/articles\/wp-json\/wp\/v2\/posts\/1317\/revisions\/5421"}],"wp:attachment":[{"href":"https:\/\/www.peeriosity.com\/shared-services\/articles\/wp-json\/wp\/v2\/media?parent=1317"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.peeriosity.com\/shared-services\/articles\/wp-json\/wp\/v2\/categories?post=1317"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.peeriosity.com\/shared-services\/articles\/wp-json\/wp\/v2\/tags?post=1317"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}