Selecting the Right Tax Provision Software

By John O’Rourke
This article originally appeared on the OneStream blog. Used with permission.

Many processes and groups within the Finance function have benefited from purpose-built software solutions over the past 20+ years – payroll, accounts payable, general ledger accounting, financial planning, reporting and other processes.  Meanwhile, the tax accountants have been toiling away in obscurity, mostly relying on homegrown Excel spreadsheets to accomplish the complex task of tax provisioning and reporting. But that situation is changing.

Challenges with Spreadsheets

In the report, Mr. Kugel cites a 2017 Ventana Research survey that indicated that most organizations use spreadsheets to support their tax provision and reporting process, while only 10% rely solely on dedicated third-party applications.  He cites three issues inherent in relying on spreadsheets for these critical processes.

One of the issues is that spreadsheets, and the manual data collection and calculation processes that go with them, are time-consuming.  Second is that spreadsheets are a black-boxes that are difficult to control and are prone to errors.  And the third is the two-dimensional nature of spreadsheets and the challenge of applying them to a multi-dimensional problem.

Aligning Tax with Financial Reporting

Mr. Kugel then goes on to highlight the capability of purpose-built tax application software to increase the speed and accuracy of the tax provision and reporting process.  The speed and accuracy gains come from having a central database of all tax information, powerful data collection and calculation capabilities to eliminate errors, and more dimensionality available to organize and analyze the data – by time periods, regions, currency, and entity.

Furthermore, Mr. Kugel highlights that most companies will find that they can achieve a consistently high degree of accuracy, auditability and visibility by having their tax provision application share the same platform as their financial consolidation and reporting system. Using the same data source ensures that the data used in the tax provision process is always reliable and up-to-date. This, in turn, can shorten the close process.

This was the case with OneStream customer Victaulic, who automated 86% of the tax provision process by extending the OneStream XF platform to support their tax provision and reporting requirements.

Learn More

The good news for tax departments is that there are a growing number of purpose-built software solutions available to replace spreadsheets and improve the tax provision and reporting process.  However, those who implement tax applications that are aligned with financial consolidation and reporting will see reduced points of risk and chance for errors, and a more streamlined process.

To learn more, download the Ventana Research Perspective “Make Tax Provision the Solution, Not the Problem.”

Ventana Tax Provision Report


John O’Rourke is Vice President of Product Marketing at OneStream Software. With a background in accounting and finance, John has over 30 years of experience in the software industry, including 20 years of experience in product marketing at Hyperion Solutions, Oracle and Host Analytics. He has worked with many customers and partners on financial reporting and planning initiatives and has spoken and written on many topics in corporate performance management. John has also held positions in strategic marketing and product marketing at Dun & Bradstreet Software, Kenan Systems and Decisyon.