Impact of GL Coding on financial reporting and audits

Find out interesting insights with John Silverstein, VP of FP&A at Extreme Reach

Moderated by Emily, Digital transformation consultant at Hyperbots

Don’t want to watch a video? Read the interview transcript below.

Emily: Hi, everyone. This is Emily. I’m a digital transformation consultant at Hyperbot Sync, and I’m pleased to have John, who is the VP of FP&A at Extreme Reach, on the call with me. So thank you so much for joining us today, John, really appreciate it.

John Silverstein: No problem. Thank you for having me.

Emily: Of course. So, John, the topic that we’d be discussing today is the impact of GL coding on financial reporting and auditing and I want to begin things by asking why GL coding is so important for financial reporting and auditing.

John Silverstein: Yeah, GL coding is critical for your financial reporting and audit, otherwise it becomes very difficult to report correctly, and you have to go to the transaction level, and then it defeats the purpose of the GLs. So it’s critical. It’s also extremely hard to audit something when it’s mixed, and you’re also generally not compliant if you’re not coding things properly in the financials. So it is critical both from a reporting and audit perspective and also for management to make proper decisions and everything to make sure that selling and marketing expenses are selling and marketing expenses and then it’s easily tracked. And you know who the owners are, and you know what it is.

Emily: Got it. So let me ask you this, how does a well-structured GL coding scheme enhance decision-making for the management?

John Silverstein: Yeah, if you well structure the GL coding, the decision-making, you have to align your GL coding to not only align from an accounting and GAAP standpoint, but also to make sure that you can make proper decisions on pricing or do proper ratios and things like that based on how you break your financials out. GL coding allows you to get segment reporting and figure out how profitable certain areas, products, or service lines are. If you don’t break it out and you don’t have the right granularity, it gets complicated to figure out the important information to make decisions in the business.

Emily: Got it. So just out of curiosity, John, can you provide an example of how GL coding affects compliance with regulatory and tax requirements?

John Silverstein: Yeah, GL coding is critical. If your transactions aren’t accurately classified with GAAP, it can affect your tax calculations, anything from sales tax to VAT to corporate income tax. You can end up overpaying or facing audit issues on the tax side as well. You must follow proper accounting, have the right GL coding, and minimize penalties for noncompliance. If VAT is consistently coded under a specific GL account, it becomes much easier to prepare accurate VAT returns and comply with local tax authorities.

Emily: Got it. So what are some of the common mistakes that organizations make with their GL coding schemes, and how can they be avoided?

John Silverstein: The biggest mistake is over-complication of the GL, where you start making GL codes for everything. But then there’s the opposite side, where you don’t break things out at all, and it’s all lump amounts, which makes decision-making hard. It’s critical to find a balance between detail and summary-level data. Make sure you have proper hierarchies so you can go more granular if needed and have a proper roll-up. There are also tools now that help with different ways of reporting from a management perspective that can help this as well.

Emily: Understood. Also, John, how can a GL coding scheme be designed to provide real-time or near-real-time financial reporting?

John Silverstein: If your GL coding is proper, then as transactions are happening in your GL, ERP, or even CRM, you can see that data at the right levels in near real-time. This allows you to see where you might end up from a financial standpoint and make decisions like ramping up production or slowing down sales based on live data. It’s important to align GL coding with ERP, CRM, and procurement systems to get live financial analysis instead of waiting for month-end close.

Emily: Got it. John, would you provide an example of how GL coding alignment with business strategy can improve performance monitoring?

John Silverstein: Sure. If a company aligns its GL coding schema with key performance indicators, it can monitor and optimize these metrics more effectively. For instance, a SaaS company might use specific GL codes for different components of customer acquisition costs and retention expenses, which gives insights into performance against goals. By doing this, you can generate financial reports focusing on metrics like customer acquisition costs, helping to make more strategic decisions in real time.

Emily: Makes sense. So a little bit about the audit process, John. How does a well-structured GL coding scheme simplify the audit process?

John Silverstein: A well-structured GL coding scheme simplifies the audit process by providing a clear and consistent trail of the transactions. This allows auditors to quickly trace entries, verify accuracy, and ensure compliance with accounting standards. For example, if an organization uses separate GL codes for office supplies at HQ and regional offices, auditors can efficiently sample and analyze expenses related to different locations. However, you need to be careful to ensure your schema isn’t overly complicated.

Emily: Got it. Just to wind things up, one last question, John. What would be your key recommendations for organizations looking to optimize their GL coding scheme?

John Silverstein: First, design a hierarchical structure that goes down to a detailed level but allows summarization. Use multi-dimensional analysis so you can get different insights like company roll-ups, cost centers, departments, and product lines without mixing everything into the GL. Balance granularity and simplicity, and align with the business strategy because strategies evolve. It’s important that GL coding reflects the current business direction. Integrate with other systems like ERP to avoid silos, and regularly review your coding schema to ensure it complies with current regulations and organizational structures.

Emily: Got it. Thank you so much, John, for sharing your insights on the critical role of GL coding in financial reporting, auditing, and decision-making. Your examples and recommendations will certainly help organizations better structure their GL coding schemes to achieve more actionable financial reports. Thank you so much for being here.

John Silverstein: No problem. Glad to be here.