ThinkTWENTY20

ThinkTWENTY20

  • HOME
  • ERIC'S BLOG
  • FORUM
  • ABOUT US
  • CONTACT US
  • 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
    Where Will Technology Progress Take The Accounting Profession?
    Monday, 29 March 2021

    By Ricardo Rodil
    Ricardo Rodil leads the capital markets advisory services division at Crowe Macro (Brazil).

    Every time I try to understand or analyze a very complex event,  I usually try to reduce the problem to its essential elements – a sort of inverted zoom lens. I know that the devil is in the details, but I need to have some distance from them. So, I formulate extreme hypotheses, thinking about all the possible/plausible results (from 8 thru 8,000, as we say in Brazil). And, of capital importance, I know I need to keep my mind open to all possibilities. Today, I want to share with you where my latest thoughts have led me, about where and how technology is progressing and how that is transforming our lives.

    The Tele-Everything World
    Saturday, 20 March 2021

    In a non-random survey of some 915 innovators, developers, business and policy leaders, researchers and activists were asked by Pew Research to consider what life will be like in 2025 in the wake of the outbreak of the global pandemic. Overall they saw life being made worse for many people because of the spread of mis-information and authoritarianism and the fact people will become a lot more reliant on technology, which will serve to widen the economic divide.

    ThinkTWENTY20 © 2021. Privacy Policy