CPA Practice Advisor

AUG 2018

Today's Technology for Tomorrow's Firm.

Issue link:

Contents of this Issue


Page 41 of 43

42 AUGUST 2018 ■ TECHNOLOGY IN PRACTICE ROMAN H. KEPCZYK, CPA.CITP Director of Consulting Xcentric, LLC. APIs and RPA Tools Automate Client Services While much of the profession is trying to figure out the impacts and opportunities of bleeding edge technologies such as Blockchain and AI (Artificial Intelligence), their distant technological “cousins,” APIs and RPA are providing leading edge solutions that are making client services more productive today. APIs (Application Programming Interfaces) and RPA (Robotic Process Automation) are software tools and capabilities that can automate or replace traditional manual data entry done by accountants. Whether it is capturing data from credit card receipts, reconciling bank statements, reimbursing expense reports, or automatically updating IRS tax statuses, these tools utilize a combination of machine learning, Optical Character Recognition (OCR), and custom scripts that emulate or automate the actions of their human counterparts. The benefits of using API and RPA tools include faster data capture, far fewer input errors, lower cost of processing, and reducing the volume of tedious work which in turn frees up accountants to do higher value advisory work with clients. Firms can begin their search for these tools by asking their client service personnel what data they are currently entering or manually re-keying from other data sources to see if those other sources already have applications with APIs developed to integrate into the client’s accounting product and if not, decide if it would warrant a switch in applications. Accounting API Opportunities: Firms that utilize cloud-based accounting products can immediately benefit from the hundreds of vendors with APIs that are already integrated with cloud accounting products such as QuickBooks Online (, Xero (, and Sage Business Cloud ( Expensify and HubDoc are examples of web-based applications that have APIs linking their data into accounting products and are being utilized by firms to automate manual data entry: ■ Expensify: Expense report management is often one of the more manually intensive processes from both an employee and firm reimbursement perspective. Expensify has built a solid following of users who can capture and process business receipts with their smartphone camera. Images go through Expensify’s SmartScan OCR tool to help create an expense report that can be finalized and then automatically forwarded to the appropriate approver. Once approved, the API automatically integrates with the firm’s accounting system to make all necessary entries and can even reimburse the employee within 24 hours, replacing many traditional manual entries and processes that are subject to human error. ■ Hubdoc: This digital assistant has the ability to go out and “auto-fetch” documents such as the client’s bank statements, utility bills, and telecom invoices, as well as documents from other online vendors. Hubdoc then uses OCR to capture relevant data from these documents and create digital entries which can be imported via the API into online accounting products. Hubdoc uses machine learning to recognize if invoices are either autopay and automatically imported or have a due date and automatically sends an email alert regarding the due date. The API streamlines the collection of documents from multiple vendors, eliminates manual keying of relevant data, and reduces monthly bank reconciliation time. Accounting RPA Opportunities: While many small and medium firms have been utilizing applications with integrated APIs to move data between applications, the largest firms have also been automating the more complex processes that humans perform with RPA. According to the Institute for Robotic Process Automation and Artificial Intelligence, RPA is defined as “the application of technology that allows employees in a company to configure computer software or a “robot” to capture and interpret existing applications for processing a transaction, manipulating data, triggering responses, and communicating with other digital systems.“ These tools allow for automation of single use or specialized process robots which can operate in the cloud and perform at the local end-user level. Automation Anywhere is the most recognized RPA tool utilized by each of the Big Four accounting firms to build custom “bots,” but a new generation of special purpose RPA tools such a Telerik are also being utilized by other firms. Continued online at 12423175 If you're buying from anyone else… You're Paying Too Much. REQUEST A FREE CATALOG 1-800-888-5803 • •

Articles in this issue

Links on this page

Archives of this issue

view archives of CPA Practice Advisor - AUG 2018