ThinkTWENTY20

  • HOME
  • ERIC'S BLOG
  • FORUM
  • ABOUT US
  • CONTACT US
  • REGISTER
      • ThoughtLeader Gateway
  • Home | 
  • ERIC'S BLOG | 
  • RPA – Good News and Bad News 

RPA – Good News and Bad News 

on 21 September 2020

In my last blog entry, I referenced a dear bookkeeper with whom I worked many ages ago, whose challenges interpreting a changing payroll report from the external provider; her challenge with getting the appropriate journal entries into the accounting system was a catalyst to my wanting to develop XBRL GL. So, I would like to discuss how RPA is like that bookkeeper, the good news and the bad news.

A number of vendors have emerged in the RPA space. You will often hear of three names in particular for solution providers: Automation Anywhere, Blue Prism and UiPath. These “overnight successes” have been around since 2003, 2001 and 2005 respectively. (Again, support for my statement in my last entry that this nothing new, just receiving more attention.)

I am going to focus on UiPath for our RPA proxy. Your choice between these three or another depend on the users who will be involved, the back office or consulting support available, certain architectural issues, and other considerations.

Let’s look at the bookkeeper’s situation:

1. Get the summary report.

2. Look in some specific places for the Net, withholdings, garnishes and other adjustments.

3. Write the numbers onto the template I provided.

4. Calculate the gross-up amount.

5. Calculate the company matches and other additional entries.

6. Create the journal entries by putting the payroll template numbers into the journal entry template.

7. Post

Guess what RPA can do?

1. Recognize when a file (for example, an email with an Excel or image file attached or a link to a web report) is recognized by monitoring the email.

2. Perform optical character recognition on the image if necessary and look in specific places in the spreadsheet, image or web page for the relevant information.

3. Pull out that information and write it into the payroll template.

4. Take the resulting totals and additional calculations and write them into the journal entry template.

…and so on.

If, however, there are any changes to the input, calculations or outgoing system, RPA will fail miserably.

Is RPA something a savvy business person can do? Or do you need to bring in a programmer? That’s the topic of my next entry.

Leave a comment

    Comments

    • No comments found
    Powered by Komento
    Forum Recent Posts
    Data Driven Sustainability Decisions
    Tuesday, 03 May 2022

    Gerald Trites, FCA, CISA

    While companies have traditionally viewed sustainability decisions as separate from monetary decisions, this is changing. It’s partly because of generational changes, with millennials now being the largest component of the workplace and partly considerations driven by customer demand, investor demand regulatory requirement and common-sense observation of the destruction caused by climate change. Compelling reasons.

    Companies have been moving more clearly to data driven decision making for several years. So it makes sense they would turn to data to drive their decisions in the sustainability area.  

    To accomplish this, they need to first define their sustainability goals. This usually begins with industry trends and information from stakeholders about their sustainability concerns and the development of a sustainability strategic plan. Second, begins the process of data modelling and analysis drawn from internal and external sources. Many organizations have well defined data gathering processes already in place, but these need to be modified to take into account sustainability goals. Finally, the adoption of data driven sustainability decision making requires the adoption of AI techniques to automate data gathering, modelling and reporting functions.

    Established enterprise systems are moving in this direction, the availability of which, as well as their compatibility with existing systems, is an important consideration.

    Overall, a creative combination of data management, analytics, AI and integration of sustainability processes with established corporate processes are crucial to a successful outcome – the creation of a truly sustainable enterprise.

    How All Accounting Reports Will be Digitized
    Thursday, 31 March 2022

    Gerald Trites, FCA

    The SEC was the major regulatory body that got the ball rolling in 2009, when it mandated rules for the use of the interactive data format (XBRL) for public company financial statements. Then several other countries and organizations got on the band wagon. There was a relatively quiet period for a few years, when the new electronic form of reporting seemed stalled. But then the EU stepped in and began requiring their ESEF filings in 2021. That meant most of the major companies in the world were using digitized reporting.

    For regulators and governments, digital filing of reports has been an opportunity to streamline the processing and analysis of the reports. Users such as investors, on the other hand, have often been unsure about what to do with these reports.

    The fact is, much attention has been given in recent years to the production of digital reports, but very little given to their consumption. True, there are utilities that can be purchased to enable people to read reports in digitized form, the SEC provides such a one, and the recent moves to inline XBRL mean the reports can be read in the conventional way, (ESEF is a variation on inline XBRL). But most of these attempts to render digital reports readable cater to the idea of sequential reading in the conventional sense. Most people do not read this way, unless perhaps they are reading a novel. When they want information, they tend to go to that information as fast as they can. This is the standard approach most people follow in using the internet. People don’t read the internet. Nor generally do they read a corporate website from beginning to end. That would be bizarre!

    But yet, we provide annual reports in paper or PDF form, which extend to around 150 pages and often more, of difficult, often technical, material and expect people to read them. It doesn’t happen. Professional analysts might, but they are more likely to employ analytical tools to get the information they need.

    There is an excellent article on the website of the International Federation of Accountants (IFAC) by Amir Ghandar, titled “The Accounting Revolution Will Be Digitized”.[1] In that article, Mr Ghandar points out that “A 2D, static annual report format in paper or pdf is not that different to the papyrus on which Egyptian scribes reported on the royal inventories more than 7,000 years ago.”

    Much more than this is needed in the modern world. Technology and complexity have advanced tremendously and the style of reporting needs to keep pace.

    Two areas need further work. One involves the steps necessary to encourage legislators and regulators in countries to adopt digital reporting. While a majority of countries have adopted it, there is still a number who haven’t. Then there is the need to take the steps to change digital reporting to make it more understandable and usable to the users. This means providing the resources for them to actually draw out the data they want. These resources need to be made available along with the reports themselves. Some companies in their websites have started doing this, through the provision of data banks and some analytical tools, however it needs to become commonplace and much more powerful and sweeping.

    Developing this approach to corporate reporting requires interaction and discussion between corporate reporters and users, regulators and standards-setters to address the issues.

    Those issues involve more than figuring out how to present digital information and how to use it. It involves determining what information to present, how to present it and when. It involves looking back at the basic tenets that have ruled accounting since its beginnings. The need for annual and other periodic reports. Can they be continuous? Can we eliminate the need for those pesky annual accounting judgements that cause so much trouble? Can we include the tools for analysis within the disclosures rather than relying on the software industry to deliver them? This cannot be accomplished within paper or pdf reports, but rather on the corporate websites. Most companies have moved their reporting to their websites. But they generally have ported over the old paper paradigm, rather than seriously adopting new and innovative ways to report in the information age. It’s well past time we did that.

    https://www.ifac.org/knowledge-gateway/contributing-global-economy/discussion/accounting-revolution-will-be-digitized

     

    [1] https://www.ifac.org/knowledge-gateway/contributing-global-economy/discussion/accounting-revolution-will-be-digitized

    ThinkTWENTY20 © 2022. Privacy Policy
    Login

    username / password