March 2, 2020

A Tool to Boost Business Intelligence

CPAs deal with volumes upon volumes of client information. Data analytics can help make sense of it.

Businesses and their advisors seek creative ways to make sense of enormous amounts of information, or “Big Data”, to solve inefficiencies, detect fraud and enhance profitability.


With many attest clients processing their transactions electronically, CPAs and other technical consultants are now getting involved in Data Analytics — the art and science of processing Big Data to discover and analyze patterns, identify anomalies, and extract other important information embedded in data through analysis, modelling and visualization relative to human behavior and interactions.


Data Analytics can be utilized to enhance many professional services, including audit and review engagements, forensic investigations, consulting engagements, and assisting clients in business decisions. For CPA firms, Data Analytics is a powerful tool because it can help auditors achieve 100% coverage in substantive testing, which decreases engagement risk while increasing efficiency and realization.


At the same time, demand is growing for Data Scientists, or individuals that have strong analytic abilities and are skilled in computer coding. Data Scientists understand how to use Data Analytics to process Big Data efficiently and aesthetically, blending form with function.


When data is received in a format that’s not user-friendly, for example, data analytics can make it easier to use. In one case, a CPA firm that’s a Collemi Consulting client was presented with more than 100 individual journal entries — necessary for substantive purposes — that were not only presented in PDF, but were structured in a variety of different formats. The CPA firm essentially had information but did not have an efficient way to use it, since manually converting the journal entries into a standard, usable format would be extremely time consuming.


Instead of reformatting each entry, we automated the process by devising a computer code that could electronically identify and extract information directly from the General Ledger, which already presented with a uniform format.


This enabled the external auditors to efficiently read and utilize the information; and as a bonus, the Collemi Consulting code also summarized the P&L and balance sheet effects of the 100-plus journal entries.


Integrating Data Analytics into their practice gives audit professionals an opportunity to provide additional value-added services to existing clients while potentially attracting new ones. Audit professionals who want to integrate Data Analytics into their practice generally have three options of doing so: devoting a lot of time to understanding third-party specialized computer aided audit tools (CAATs) software, some of which utilize Artificial Intelligence (A.I.); take on the long-term commitment of hiring a Data Scientist in-house to build custom applications, or outsource the task to a Data Lab.


Regardless of the approach they select, auditors will be able to harness the power of Data Analytics to automate numerous attest procedures, including tests for: non-standard journal entries, accounts receivable, accounts payable, payroll, travel and entertainment expense reimbursements, fixed assets, check registers and cash disbursements, and revenue recognition. Data Analytics can also enhance and digitize such activities as stratification, risk score assignments, multi-dimensional analysis of transactions, data joins, data appends, data aggregations, data visualization, and of course, taking on large data sets that previously could not be analyzed because of constraints like time and staff size.


As businesses continue to face more pressure to process transactions faster — with less staff and other resources — their vulnerability to fraud or errors continues to increase. An effective Data Analytics strategy can address this potential vulnerability, and Engagement Team Leaders — including Partners, Managers, and In-Charges — should consider the benefits of embracing automation while determining the approach that best fits their firm’s practice and budget.

Learn More
By Jennifer Ruf March 24, 2025
As audit season is in high gear, it’s important for auditors to step back and plan how they are going to audit a client’s books and records. What are the red flags you’re looking for when it comes time to throw open the books and look through a huge swath of journal entries to pluck out the ones that are questionable, and need to be questioned? First off, it’s important to understand how journal entries are created at the company being audited. For an auditor, that means looking at the internal control environment to understand how a journal entry is created: Who’s authorized to create one and who can create one. You have to understand the process. How does it start and how is the entry eventually recorded onto the financial reporting system? Once you know that, you can determine whether someone can come in and override the system, or if someone can pretend to be someone else and start recording journal entries onto the system. That will help you figure out what to look for to decide what entries to pull out and ask management to get back up information to support and validate those entries. Finding the needle The key here is not to just go through the mechanics, but to really go through the exercise so you can determine if management is playing games in the recording of those transactions. You have to be able to get comfortable with that, and that means you need to be able to document what you’re looking for. Because what the auditor is really doing is looking for a “needle in the haystack”, to identify the transactions that don’t look right, that don’t make sense in the ordinary course of business. For example, if the business is not open on weekends, are transactions being posted on a Saturday or Sunday, or even on holidays? If you see rounded numbers or accounts that are seldom used, those can be red flags as well. Sometimes it can be as simple as asking managers and others like accounting, data entry and IT personnel if they’ve observed any unusual accounting entries. Depending on the size of the company and scope of the work, you might need to use computerized audit software program — some of them with AI built in — that can scan the entries to identify anomalies. Red flags When an auditor is looking for evidence of management override of controls, they can look for some of these 12 red flags indicators: ● Top-side entries ● Entries made to unrelated, unusual or seldom-used accounts ● Entries made by individuals who typically don't make entries. ● Entries recorded at the end of the period ● Post-closing entries with no explanations ● Entries made before or during the preparation of financial statements with no account numbers ● Entries that contain rounded numbers or a consistent ending number ● Entries processed outside the normal course of business ● Accounts that contain transactions that are complex or unusual in nature ● Accounts that contain significant estimates and period-end adjustments ● Accounts that have been prone to errors in the past ● Accounts that contain intercompany transactions When testing non-standard journal entries and other adjustments, you should look for documentary evidence indicating that they were properly supported and approved by management. Finally, remember that while most fraudulent entries are made at the end of a reporting period, you shouldn't ignore the rest of the year  Collemi Consulting leverages nearly three decades of experience to provide trusted technical accounting and auditing expertise when you need it the most. We regularly work with CPA firm leadership to help them reduce risk and maximize efficiencies. To schedule an appointment, contact us at (732) 792-6101.
December 20, 2024
Are you prepared?
A woman's hands holding a microphone
December 9, 2024
Conquer your fear of public speaking and present like a pro
Man with hand by his ear straining to listen.
December 4, 2024
Boost your business by becoming adept at active listening.
More Posts