RPA for Developers: How to automate ETL process with Quickbooks + OCR

Get our weekly newsletter for the latest insights

    After considering all the benefits for business that automation of ETL processes can bring it is time to move on to development. Automating invoicing in Quickbooks can be as simple as making these 3 steps:

    1. Read scan files and extract necessary data
    2. Log in QuickBooks website
    3. Cycle through all the data and create invoices
    3 step process Automating invoicing in Quickbooks
    3 step process

    On a screenshot above we can see each of these steps as a reusable subprogram. That allows keeping bot logic visually clean and readable. Also, subprograms can be reused in other processes.

    Let’s take a closer look at subprograms. In the first one we read invoice files from directory, cycle through them, recognize text with OCR and store recognized data for later use.

    Step 1 - Read files and recognize data
    Step 1 – Read files and recognize data

    On next step bot will open browser, enter credentials and log into QuickBooks website.

    Step 2 - Log In into QuickBooks
    Step 2 – Log In

    And finally on the last step bot will cycle through the data collected on step 1, fill the forms and create invoices in QuickBooks.

    Step 3 - Create Invoices in QuickBook
    Step 3 – Create Invoices

    RPA implementation allows you to optimize numerous of business processes including data entry from scanned invoices. To decide which procedure you need to automate first, reach out to our automation expert.