ThinkTWENTY20

  • HOME
  • ERIC'S BLOG
  • FORUM
  • ABOUT US
  • CONTACT US
  • REGISTER
      • ThoughtLeader Gateway
  • Home | 
  • ERIC'S BLOG | 
  • RPA – But Eric, What About Python?

RPA – But Eric, What About Python?

on 03 October 2020

Back in May, I had a Blog entry on Python, and whether financial professionals should know how to code in Python. See https://thinktwenty20.com/index.php/blog/478-should-financial-professionals-know-how-to-program-or-data-analytics-accountants-should-understand-them-and-have-toolsets-to-perform-them for a refresher. I mentioned the use of Jupyter Notebook as a means of storing and conveying the code and documentation and facilitating writing, testing and executing the code.

So what does Python have to do with RPA? 

With RPA, I have tools to automate tasks. Python, too.

With RPA, I have the means to get information from Excel, PDFs and other external sources and work with the data automatically. Python, too.

The use of UiPath Studio for “smaller” purposes is free. The use of Python is essentially free.

Python has tons of “libraries” that add additional functionality to work with just about anything. RPA tools are gaining more and more libraries, and often permit the invoking of code just-in-case.

So, what can RPA solutions do that Python can’t? 

  • Provide a limited/no-code environment in which to operate, particularly focused on screen scraping.
  • Integrate with larger suites for collecting business requirements, moving to the field and managing
  • Minimize programming errors with components tuned for purpose

What can Python do that RPA can’t?  

  • There are few limitations to Python; there’s even an RPA library for Python (imaginatively named RPA for Python or RPA-Python) which simplifies website automation, OCR, and interaction with people on the keyboard and mouse. But, 
  • Python is a general purpose tool, so you aren’t starting off with a user-friendly user interface to get the work done.

With UiPath being available for free for smaller uses, it is up to you whether to begin implementing automation within your organization with Python or with UiPath.

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