Embarrassed Executive

September 8, 2017 | Iowa companies learn how data can help drive their business Matthew Johnson, CPA, CFE, CliftonLarsonAllen, matthew.johnson@CLAconnect.com

Q. I keep hearing that “Big Data” can help me run my business, but my accountants just keep giving me overly complicated spreadsheets and financial information that is looking to the past, not the future, months after the information would have been useful. How can I use data I already have to influence decisions I should be making today that will impact my business immediately?

A. The power of data and data analytics has the potential to revolutionize how businesses interact with accounting systems to make decisions, and this revolution has already begun. The accounting and finance department of the future is going to be composed of professionals capable of providing more forward-looking analysis. To make this happen, accountants should start thinking like data managers.

Accountants as data managers

The average smartphone today can tell us when our flight is delayed before we even ask. Our map apps can find alternative routes in real time when there is a traffic jam. We can receive restaurant recommendations when visiting a new city based on our history of dining out. Smartphones gather data, report to you, and offer rudimentary analysis. Processing data is similar in accounting departments.

1. Data is entered into the accounting system.
2. The information is used for board/owner reports, reporting to banks, and management reports.
3. The data and reports are analyzed to understand the information and make better decisions.

Many accounting departments spend all their time on the first two steps, but not nearly enough time providing insight into what the data means to stakeholders. One key to transforming data into decision-making is to automate all three phases of the accounting and finance departments.

Reduce manual data input

This section may make decision makers want to take a nap, as it deals with accounting details, but minimizing manual entries is a very important risk management and efficiency tool. How many manual journal entries does your business post on a monthly basis? Most accounting systems have several modules that are designed to make accounting jobs easier. Think of your accounting system’s cash and bank reconciliation module. Often this module helps record bank fees and interest without ever having to post a journal entry. The data is entered into a field while doing the reconciliation, and the system automatically posts the journal entries. If your department is still managing manual journal entries, review your data entry process to identify opportunities to better utilize the accounting system—it may require some training and learning.

Here are some other ways to reduce total input time:

• Identify modules in your accounting system that are not being fully utilized or those additional modules that may be purchased to save time.
• Review manual journal entries to identify where the accounting department may not be utilizing the ac- counting system.
• Review reports that require significant manual manipulation once exported and determine how these reports can be run directly from the system.

Good input equals more efficient reporting

Reporting is only as good as the data entered. If your business has industry-specific accounting software, the basic reports are generally very robust—but they only work if the data is properly entered into the modules designed to capture that information. If your reports are not working, your first step is to confirm that the data is being entered properly. The next step is to figure out if the software needs updating or if the users need training.

Here are some ways to reduce reporting time:

• Review reports that require additional data once outside the accounting system and identify how this data can be captured in the accounting system.
• Include more data, rather than less, when designing reports. It is easier to delete unnecessary data than to create entirely new reports.
• Eliminate manual manipulation of accounting data outside of the accounting system.

Automating the analysis of your data

Data analysis is often the area where finance professionals do not fully use their tools and training to truly have an impact on a business. This is not only because they have spent all of their time on input and reporting, but because in-depth analysis takes time. However, even basic reports can highlight important issues.

For instance, imagine if your accounting system provided a report every morning that listed vendors who exceeded a procurement threshold. What if the accounts payable manager in your department received a daily report of all invoices entered that were more than three times larger than the average invoice for that vendor? Identifying invoice anomalies is a simple step in identifying high-risk transactions that may need special attention. This type of analysis doesn’t need to wait on your staff; it can be generated automatically on a daily basis.

Here are more ideas for automating analysis:
• Create exception reports that identify anomalies in the data.
• Include operational data in the accounting system to help with analyzing data.
• To create more timely analysis and increase the number of users of the data, set reports to run on a recurring basis and disperse them to interested parties.

In summary, data analytics are here to stay. Start the conversation with your internal and external accounting teams as to how the analytics can help you and your team make decisions in a more timely and informed manner.