{"id":4793,"date":"2022-03-04T16:23:39","date_gmt":"2022-03-04T16:23:39","guid":{"rendered":"https:\/\/www.peeriosity.com\/shared-services\/articles\/?p=4793"},"modified":"2022-08-23T13:37:41","modified_gmt":"2022-08-23T13:37:41","slug":"using-tableau-dashboards-and-sharepoint-for-global-ar-tracking","status":"publish","type":"post","link":"https:\/\/www.peeriosity.com\/shared-services\/articles\/2022\/03\/using-tableau-dashboards-and-sharepoint-for-global-ar-tracking\/","title":{"rendered":"Using Tableau Dashboards and SharePoint for Global AR Tracking"},"content":{"rendered":"

Introduction<\/strong><\/p>\n

An efficient and effective Order-to-Cash (O2C) process is vital to every company\u2019s business with a direct impact on revenue and cash flow.\u00a0 With processes that include the onboarding of new customers<\/a> and creating new customer records, receiving and recording orders, creating and processing invoices, collecting and posting payments and credits, and resolving disputes and outstanding invoices, multiple stakeholders depend on accurate and timely O2C information.\u00a0 To be effective, this information needs to include more than a few key high-level summaries, with details that are only visible to individual work teams.<\/p>\n

Peeriosity member companies are increasingly skilled at automating Accounts Receivable reporting requirements to eliminate data collection and manipulation tasks to best support efforts to resolve individual issues and understand root causes.\u00a0 This allows the Accounts Receivable team to spend more time on value-added activities, and it provides other interested parties in the company with the information they need in a format that can be customized to meet their business requirements.<\/p>\n

Company Experiences<\/strong><\/p>\n

A Peercast discussion in Peeriosity\u2019s Accounts Receivable (O2C) research area<\/a> featured a global company with over $20B in annual revenue and operations in 20 countries discussing the transformation of their Bill to Collect process by leveraging SharePoint and Tableau Dashboards.\u00a0 The goal of the transformation was to provide a centralized location to access Accounts Receivable data and to automate the data collection and presentation processes by eliminating time-intensive Excel reports, manual reports, and mass emails to send out information.<\/p>\n

Users of the SharePoint portal with Tableau Dashboards include Accounts Receivable analysts, business unit and regional Finance, Credit Management and Treasury, Order Management, and the Field Service Organization.\u00a0 The Dashboards are used to track open Accounts Receivable balances by the customer, region, business unit, and other segmentations of interest to users. The Dashboards also track Promise to Pays and dispute details and are the sources for customer analysis<\/a> and quarterly reporting.<\/p>\n

For details, Peeriosity members are encouraged to sign into the members\u2019 area to view the complete presentation and listen to the recorded Peercast.<\/p>\n

iPolling Results Review<\/strong><\/p>\n

Peeriosity\u2019s iPolling was used to provide insight into the effectiveness of processes that Peeriosity member companies use for Accounts Receivable tracking in terms of timeliness, accuracy, and meaningfulness of the data provided, with additional insight to the degree that Accounts Receivable tracking is automated.<\/p>\n

Regarding the effectiveness of Accounts Receivable tracking processes, 6% indicated that the processes were excellent with 38% reporting that the processes were very good, with needs generally met with few exceptions.\u00a0 An additional 31% reported that the processes were good but could be improved.\u00a0 Finally, 25% reported that the effectiveness of tracking processes was disappointing, where the processes are not adequately meeting the needs of internal users or customers.<\/p>\n

\"ipolling<\/p>\n

With regards to the level of automation, 6% report processes that are highly automated with little to no manual intervention, and 50% report processes that are automated with a limited amount of manual intervention, with an additional 19% reporting that processes are an even mix between automated and manual.\u00a0 Finally, 25% report that their processes are best characterized as being manual with little to no automation<\/a>.\u00a0 Here are the details:<\/p>\n

\"how<\/p>\n

\u00a0<\/em>Closing Summary<\/strong><\/p>\n

For many companies, automation and process redesign have dramatically improved Accounts Receivable processes by allowing the Accounts Receivable team to focus on resolving problems with less time on work tasks required to collect and manipulate data for reporting to various internal stakeholders.\u00a0 And, because reports are more likely to be intuitive and available, there is less re-work as internal stakeholders can take direct action without needing specialized support and assistance from the Accounts Receivable team.<\/p>\n

How effective is the process for Accounts Receivable tracking at your company?\u00a0 What steps have you taken to simplify and automate the Accounts Receivable tracking process, and how confident are you that internal customers and stakeholders are getting the information they need?<\/p>\n

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

________________________________________________________________________<\/p>\n

\u201cPeercasts\u201d are private, professionally facilitated webcasts that feature leading member company experiences on specific topics as a catalyst for broader discussion.\u00a0 Access is available exclusively to Peeriosity member company employees, with consultants or vendors prohibited from attending or accessing discussion content.\u00a0 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 Using Peeriosity\u2019s integrated email system, Peer Mail, attendees can easily communicate at any time with other attending peers by selecting them from the list of registered attendees.<\/p>\n

\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 Mail, members can easily communicate at any time with others who participated in iPolling.<\/p>\n

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

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

Introduction An efficient and effective Order-to-Cash (O2C) process is vital to every company\u2019s business with a direct impact on revenue and cash flow.\u00a0 With processes that include the onboarding of new customers and creating new customer records, receiving and recording orders, creating and processing invoices, collecting and posting payments and credits, and resolving disputes and […]<\/p>\n

<\/span><\/span><\/span><\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[],"acf":[],"yoast_head":"\nTableau Dashboards & SharePoint for Global AR Tracking | Peeriosity, LLC<\/title>\n<meta name=\"description\" content=\"Peeriosity studies the transformation of a company on their process by leveraging SharePoint and Tableau Dashboards for AR tracking.\" \/>\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\/2022\/03\/using-tableau-dashboards-and-sharepoint-for-global-ar-tracking\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using Tableau Dashboards and SharePoint for Global AR Tracking\" \/>\n<meta property=\"og:description\" content=\"Peeriosity studies the transformation of a company on their process by leveraging SharePoint and Tableau Dashboards for AR tracking.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.peeriosity.com\/shared-services\/articles\/2022\/03\/using-tableau-dashboards-and-sharepoint-for-global-ar-tracking\/\" \/>\n<meta property=\"og:site_name\" content=\"Peeriosity\" \/>\n<meta property=\"article:published_time\" content=\"2022-03-04T16:23:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-23T13:37:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.peeriosity.com\/shared-services\/articles\/wp-content\/uploads\/2022\/03\/AR-Tracking-Chart1.jpg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 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\/2022\/03\/using-tableau-dashboards-and-sharepoint-for-global-ar-tracking\/\",\"url\":\"https:\/\/www.peeriosity.com\/shared-services\/articles\/2022\/03\/using-tableau-dashboards-and-sharepoint-for-global-ar-tracking\/\",\"name\":\"Tableau Dashboards & SharePoint for Global AR Tracking | Peeriosity, LLC\",\"isPartOf\":{\"@id\":\"https:\/\/www.peeriosity.com\/shared-services\/articles\/#website\"},\"datePublished\":\"2022-03-04T16:23:39+00:00\",\"dateModified\":\"2022-08-23T13:37:41+00:00\",\"author\":{\"@id\":\"https:\/\/www.peeriosity.com\/shared-services\/articles\/#\/schema\/person\/06131ee5ca35862440ab2ed1ade7cc4a\"},\"description\":\"Peeriosity studies the transformation of a company on their process by leveraging SharePoint and Tableau Dashboards for AR tracking.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.peeriosity.com\/shared-services\/articles\/2022\/03\/using-tableau-dashboards-and-sharepoint-for-global-ar-tracking\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.peeriosity.com\/shared-services\/articles\/2022\/03\/using-tableau-dashboards-and-sharepoint-for-global-ar-tracking\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.peeriosity.com\/shared-services\/articles\/2022\/03\/using-tableau-dashboards-and-sharepoint-for-global-ar-tracking\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.peeriosity.com\/shared-services\/articles\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using Tableau Dashboards and SharePoint for Global AR Tracking\"}]},{\"@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\/06131ee5ca35862440ab2ed1ade7cc4a\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.peeriosity.com\/shared-services\/articles\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f40a0d8493f8ff51d8560c30b5fa9933?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f40a0d8493f8ff51d8560c30b5fa9933?s=96&d=mm&r=g\",\"caption\":\"admin\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Tableau Dashboards & SharePoint for Global AR Tracking | Peeriosity, LLC","description":"Peeriosity studies the transformation of a company on their process by leveraging SharePoint and Tableau Dashboards for AR tracking.","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\/2022\/03\/using-tableau-dashboards-and-sharepoint-for-global-ar-tracking\/","og_locale":"en_US","og_type":"article","og_title":"Using Tableau Dashboards and SharePoint for Global AR Tracking","og_description":"Peeriosity studies the transformation of a company on their process by leveraging SharePoint and Tableau Dashboards for AR tracking.","og_url":"https:\/\/www.peeriosity.com\/shared-services\/articles\/2022\/03\/using-tableau-dashboards-and-sharepoint-for-global-ar-tracking\/","og_site_name":"Peeriosity","article_published_time":"2022-03-04T16:23:39+00:00","article_modified_time":"2022-08-23T13:37:41+00:00","og_image":[{"url":"https:\/\/www.peeriosity.com\/shared-services\/articles\/wp-content\/uploads\/2022\/03\/AR-Tracking-Chart1.jpg"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.peeriosity.com\/shared-services\/articles\/2022\/03\/using-tableau-dashboards-and-sharepoint-for-global-ar-tracking\/","url":"https:\/\/www.peeriosity.com\/shared-services\/articles\/2022\/03\/using-tableau-dashboards-and-sharepoint-for-global-ar-tracking\/","name":"Tableau Dashboards & SharePoint for Global AR Tracking | Peeriosity, LLC","isPartOf":{"@id":"https:\/\/www.peeriosity.com\/shared-services\/articles\/#website"},"datePublished":"2022-03-04T16:23:39+00:00","dateModified":"2022-08-23T13:37:41+00:00","author":{"@id":"https:\/\/www.peeriosity.com\/shared-services\/articles\/#\/schema\/person\/06131ee5ca35862440ab2ed1ade7cc4a"},"description":"Peeriosity studies the transformation of a company on their process by leveraging SharePoint and Tableau Dashboards for AR tracking.","breadcrumb":{"@id":"https:\/\/www.peeriosity.com\/shared-services\/articles\/2022\/03\/using-tableau-dashboards-and-sharepoint-for-global-ar-tracking\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.peeriosity.com\/shared-services\/articles\/2022\/03\/using-tableau-dashboards-and-sharepoint-for-global-ar-tracking\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.peeriosity.com\/shared-services\/articles\/2022\/03\/using-tableau-dashboards-and-sharepoint-for-global-ar-tracking\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.peeriosity.com\/shared-services\/articles\/"},{"@type":"ListItem","position":2,"name":"Using Tableau Dashboards and SharePoint for Global AR Tracking"}]},{"@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\/06131ee5ca35862440ab2ed1ade7cc4a","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.peeriosity.com\/shared-services\/articles\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f40a0d8493f8ff51d8560c30b5fa9933?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f40a0d8493f8ff51d8560c30b5fa9933?s=96&d=mm&r=g","caption":"admin"}}]}},"_links":{"self":[{"href":"https:\/\/www.peeriosity.com\/shared-services\/articles\/wp-json\/wp\/v2\/posts\/4793"}],"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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.peeriosity.com\/shared-services\/articles\/wp-json\/wp\/v2\/comments?post=4793"}],"version-history":[{"count":4,"href":"https:\/\/www.peeriosity.com\/shared-services\/articles\/wp-json\/wp\/v2\/posts\/4793\/revisions"}],"predecessor-version":[{"id":5775,"href":"https:\/\/www.peeriosity.com\/shared-services\/articles\/wp-json\/wp\/v2\/posts\/4793\/revisions\/5775"}],"wp:attachment":[{"href":"https:\/\/www.peeriosity.com\/shared-services\/articles\/wp-json\/wp\/v2\/media?parent=4793"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.peeriosity.com\/shared-services\/articles\/wp-json\/wp\/v2\/categories?post=4793"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.peeriosity.com\/shared-services\/articles\/wp-json\/wp\/v2\/tags?post=4793"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}