“It was the best of times, it was the worst of times.” So begins A Tale of Two Cities, Charles Dickens’ famous novel of the French Revolution. With the new revenue recognition criteria (ASC 606 compliance), it may seem like the worst of times for financial planning and analysis
Part of the stress is a time crunch. For public companies, the deadline for implementing the new rev-rec rules (as we call them) is past. Private companies have less than a year—not much time in the finance world! Restructuring your accounting processes to accommodate the new guidelines within that time frame is only half the battle. Finance teams need to accurately show what the financial forecast looks like with the new standards in place, so executive teams can make better and more informed strategic decisions regarding the future prospects of the company.
However, professionals have focused mostly on the accounting side of the equation and paid very little heed to the impact that the rev-rec rules will have on the FP&A function, Robert Kugel, senior VP and research director at Ventana Research, notes in an April 2017 Linkedin article. He adds, “Planning and budgeting will become more complex because of the divergence in the timing of accounting and ‘real’ events. FP&A organizations in these corporations need to prepare now to cope with the new environment.”
Au revoir, spreadsheets
The now that Kugel speaks to has come and gone, but the obligation to adhere to the new regulations remains. If you’re still scrambling to implement the new criteria, spreadsheets will only hold you back.
In fact, Kugel writes: “ finds that two-thirds or more companies use [spreadsheets] to manage their budgets and other functions that can impact revenue recognition planning. Their planning models and data reside in desktop spreadsheets scattered across individual computers and file servers. In some cases, the information may also be in one or more enterprise applications. Manually pulling together these individual strands in spreadsheets on a regular basis is time-consuming and error-prone.”
Tell a tale with active planning
Instead, Kugel recommends what he calls a “dedicated planning application,” software that:
We would go further and recommend a system that enables, one that:
Kugel concludes: “Our research shows that companies that use a dedicated application more often have a process that works well or very well than those that use spreadsheets (60% vs. 47%). A dedicated application is essential to support complex planning processes.”
No matter how far along you are in adopting the revenue recognition criteria, your FP&A team can bring real value through leveraging cloud technology and your strategic insights. The future is yours, and with the right tools, you can tell a tale of success.
3 Challenges You’ll Need to Overcome to Use Spreadsheets for Revenue Recognition Criteria Compliance
Metrics reporting: Why SaaS is different from traditional software reporting