Skip to content

RPA in an Accounts Department

    RPA Category: Copy and Paste – Data Retrieval and Input


    The Finance Director of a Financial Services company was struggling to keep graduate entrants. Even though graduates were joining a growing business with a good starting salary and career prospects (CIMA sponsorship and later progression), the daily monotony of Accounts Payable was putting graduates off and triggering resignations. Accordingly, it became clear that this mundane, but important accounting activity was a good candidate for automation.

    Process Overview:

    Like many other businesses, the accounts payable process for this company involved many manual steps, including:

    • Opening supplier emails with PDF invoice attachments
    • Opening the accounting application, Sage50, and accompanying spreadsheets
    • Saving PDF documents to a supplier folder by month and supplier
    • Copy-and-paste data from the PDF and enter data into Sage50
    • Gain authority to pay the supplier from the internal departmental owner

    All in all, the process was repetitive, mundane, and also prone to error.

    Automation Challenges

    Although Accounts Payable is a common application of RPA, it was only important to prove the robot could accurately read the PDF supplier invoice and select the correct fields. Accordingly, a Proof-Of-Concept (POC) for OCR was developed to prove the bot could read the relevant data from supplier invoices such as supplier name, invoice date, invoice number and subtotal.

    The capability was proven by integrating AWS Textract into the RPA workflow.

    Systems Involved

    • Microsoft Outlook
    • Sage 50
    • Microsoft Excel
    • AWS Textract (OCR)

    Process Flow Map

    RPA Bot Steps

    Triggered manually from the Desktop

    • Automatically login into Sage50
    • Open supplier PDF invoices attached to email
    • Read the PDF’s data accurately including supplier, date, invoice# and subtotal
    • Saved PDF invoices to appropriate folders by month and supplier
    • And input invoice data into Sage50 on the batch invoice screen

    Process as % of Employees Time


    Other Benefits

    Redeployment of finance clerks, and future graduates to less mundane, more demanding and valuable roles for the business.