Initiating a Best Practices Conversation
Today’s CFO needs to work closely with the controller to ensure the organization gets the full benefit of the controller’s talents and knowledge. Is the controller's office operating at the highest levels of efficiency and accuracy?
Ask your controller the following five questions to initiate a conversation around best practices.
#1 How many manual journal entries are we making during the closing process?
An excessive number of manual journal entries needlessly extends a closing period and can be a leading indicator of lurking problems. It can conceal anomalies and errors that have broad, systemic roots. You may be plagued with variable accounting processes or a level of complexity that calls for revised standards.
To optimize the closing process and reduce the incidence of manual journal entries, consider these best practices:
• Integrate the item catalogs between Salesforce.com and your financial system: Having integrated billing and revenue recognition from the line items in your Salesforce.com orders can immediately assign dimensions to orders that make automated journal entries for you.
• Formalize the process of manual journal entries: You won’t eliminate manual journal entries—nobody can—but you may reduce them by formalizing the process. Part of the answer is automation, which will help enormously. But you should also devise rigorous processes that discourage manual entries and ask your team to seek alternative ways to account for recurring period-end adjustments.
• Store documentation with manual entries: Require that the accounting team capture and store supporting documentation alongside each manual entry, particularly with new subscription contracts when you will need to track your execution on your performance obligations. Months later when questions about long-ago transactions arise, you’ll be able to quickly, efficiently retrieve answers boosting your auditors’ confidence.
Key takeaway: Use audit difficulties and exceptions to identify areas needing policy definition, process improvement, and automation.
#2 Have you reviewed compliance with local jurisdictions?
As one of the few people with a direct role in virtually every transaction that flows through the corporate accounting structure, the controller can—and should—play a central role in identifying and minimizing the company’s risk exposure. This is especially critical for growing technology companies whose regulatory compliance risks steadily increase in magnitude and quantity over time. The following best practices can help steer your company clear of unnecessary risks.
• Create a risk framework: Assemble a team to identify the most likely sources of risk, including regulatory compliance with ASC 606 and GDPR. Develop plans and processes to limit exposure and mitigate the effects of a failure. Give the controller a leadership role and review this plan together often.
• Conduct regular risk reviews: Create a series of checkpoints, duties, and regular meetings to stay apprised of the above framework. Review new and evolving compliance requirements and related financial controls. For instance, you can review everything from insurance policies to contract sizes in a regular meeting. Every person in the company has some role to play in safeguarding the company against risk. Operate under the principle of “trust but verify”.
• Ensure local jurisdiction compliance: As your organization expands to multiple jurisdictions through international expansion, acquisitions, and changes of control, the complexities multiply. The primary challenges involve both corporate and payroll taxation.
An international presence adds still more complexity. You and your controller must give careful thought to how local entities are created and operated so you can minimize tax impacts and ensure proper compliance.
Key takeaway: Create a central review process to ensure the right controls are in place.
# 3 How long does it take to close our books? What’s holding things up?
The best measure of controller efficiency is how quickly and accurately the team closes the books. Start with strong planning and preparation such as handling all billing and expense issues prior to the period-end. Automation is also essential—it provides the desired speed, efficiency, and accuracy without increasing staffing levels.
A fast close enables the accounting and finance team to move beyond merely reporting results and into forward-looking activities that can shape future outcomes. The executive team needs financial information as soon as possible to make necessary course corrections. This information includes traditional financial statements as well as SaaS metrics, operational reports, detailed analyses of business results, forecasting, and what-if FP&A analysis.
• Create a closing scorecard: In addition to tracking the number of manual journal entries, monitor the number of expense reports, accruals, bills, and invoices that your finance team must process. Consider creating a simple scorecard to measure your progress and to understand where the bottlenecks are occurring.
• Create a flash close report: To buy the team a little time and appease investors, lenders, and executives’ need for immediate results, consider creating a one-page “flash close report”. This report can cover 10-12 key metrics and balances, such as revenue, bookings, CLTV, CAC, CMRR, AP, AR, DSO, cash balance and burn, key customer adds and churn, and others.
• Automate for speed: In general, manual entries and workarounds are red flags for auditors because they are an open invitation to policy deviations. Automated processes enforce your accounting policies while also increasing closing speed and reducing errors.
• Know the forecast: Knowing the next quarter’s forecast better enables the controller to spot errors and issues. Unexpected actual results (positive or negative) will stand out, particularly in times of growth, whether organic or inorganic. The controller can then investigate and provide commentary prior to closing the books. When the accounting team detects problems early, it simplifies matters for the finance executives and the board.
Key takeaway: Create a repeatable close process that all stakeholders are bought into.
#4 Are we still using Excel? If so, why?
The continued use of Excel may reflect a sort of “inertia” based on inexperience with other tools, or just plain comfortable familiarity. While there are many reasons to limit Microsoft Excel use in corporate accounting—such as its inherently breakable models, security issues, and lack of shareability—it can still be useful to controllers in certain situations. Love it or hate it, Excel has been one of the go-to components in every accountant’s toolkit. Just make sure you’re clear on why you are using it.
Some of the best practices for using Excel include:
• For isolated tasks: No company should rely on Excel as its financials backbone. However, for tasks such as manual journal entries, sub-ledgers, prepaid expenses, deferred revenue, and support schedules, Excel can serve a limited purpose as long as you base these activities on data from your primary financial system.
• As an ad hoc reporting tool: It’s OK to use Excel as an ad hoc tool to accept data exports from your financial system for some off-program analyses, modeling, and simulations. But a company’s financial “truth” should always come from a system that stores all data. When a colleague emails you a spreadsheet that has conflicting or outdated data, you’ll spend more time reconciling the numbers than acting on the information.
• For ancillary reporting: Multi-user corporate accounting systems have their own native reporting facilities. Sometimes controllers prefer the familiarity of Excel for reconciliation reports, creating flash reports at period end, modeling various forecast scenarios, and similar forward-looking reports.
Key takeaway: Excel can be a valuable tool for specific, limited purposes.
#5 Can we integrate our financial information and operating metrics?
Because many financial systems can now accommodate analyses of operating metrics from statistical accounts to create a richer, fuller picture of the business, the controller is assuming a role as the provider of financial visibility—once the domain of financial planning and analysis teams or the CFO.
Merging financial data and operational metrics could help your organization in the following ways:
• Spot the opportunities: By virtue of their intimate involvement in virtually every accounting transaction, controllers have a unique perspective on corporate performance to identify subtle (and not-so-subtle) opportunities to maximize revenue and minimize expenses.
• Emphasize operational metrics: The rising importance of operational metrics gives controllers the ability to collaborate with other areas of the company to manage their functions in non-financial terms. Examples include CLTV, the Rule of 40, CMRR, customer acquisition cost, churn, and more. Ultimately, these operational metrics reconcile 100-percent with GAAP financials.
• Establish the financial truth: A single, merged reporting system across Salesforce.com and your financial system ensures everyone works from the same playbook. If you have two or more reporting systems, you will spend unproductive time reconciling differences and untangling conflicting definitions. Revenue may be reported differently for GAAP, sales compensation, and board reporting purposes but should all be sourced from the same system.
Key takeaway: Implement a single reporting system to eliminate unproductive reconciliation time.
Exploring the answers to these five questions with your controller will help create a stronger, more effective financial structure. In fact, your entire organization will benefit from a finance team that understands and controls sources of financial risk, implements more efficient processes, and develops deeper insight into both the financial and operational metrics of the business to drive better decision making, better informed board meetings, and better executed strategy.
To learn more about how Sage Intacct can help you achieve your mission more efficiently, fill out the following information and DeRosa Mangold will be in touch.
![DMC team DMC team](https://www.derosamangold.com/wp-content/uploads/DMC-team.png)
DeRosa Mangold Consulting is a trusted team dedicated to partnering with you in a logical fashion to help you make the best decision for your company’s future growth. On average throughout multiple industries, startups to mid-sized organizations begin to see a return on investment in about 6 months. We will personally sit down with you and crunch the numbers, so you know when to expect your own ROI. We won’t tell anything but the truth so that you can make the best decision for your organization.
To learn more about DeRosa Mangold Consulting or Sage Intacct visit:
If you would like to take a quick look at the software, you can take part in one of the daily Coffee Break Demos we offer.