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

/ ~ 2 minutes read

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.

Other News

Get our weekly newsletter for the latest insights