Are spreadsheets hindering your indirect tax processes?  

Spreadsheets have their place, there’s no doubt about that. But the way they’re being used in the indirect tax world right now is a cause for concern.   

I’ve encountered many Tax Managers who happily lean on spreadsheets to prepare VAT returns, as their ‘Net’ VAT amount is low. However, what I’d urge any Tax Manager to consider is the number of transactions behind this ‘Net’ VAT amount.  

 Here’s a sobering scenario. As VAT is a transaction tax, consider a company that might have five million transactions annually. If they’re reliant on spreadsheets, from a volume perspective their indirect tax process may well be riddled with errors. 

With spreadsheet cell error rates potentially occurring in 90% of spreadsheets, and say around five people working on a return, the chances of formulas being overridden and data transformation errors are high.  

The errors due to large volumes are compounded by the problem that spreadsheet-altered data can lose its audit trail back to the source, which is concerning as ERP data is generally considered the source of truth by Tax Authorities.  

A spreadsheet was not designed to be a tool used to collate, prepare and review VAT returns. Using spreadsheets in this way may open up companies to significant indirect tax exposures.   

Keeping up with changes in indirect tax 

When it comes to complying with the reporting requirements of any tax authority where the company operates, the right automation software will have the most up to date GST/VAT return formats so that the onus is not on the company to make changes in their spreadsheets. 

Additionally, the company would not have to make changes to numerous calculation formulas in their spreadsheets to account for the change in reporting requirements.  

By virtue of their design and simplicity,  spreadsheets miss the critical content layer that automation software provides, which means they are not able to keep on top of changes in regulations, legislation, rules and standards. 

– Neha Mahindru, Indirect Tax Proposition Lead, Thomson Reuters

Pressure on the tax team 

The pressure is on the tax team to ensure that firstly the source data is being accurately captured in the spreadsheet, and that transaction data is not being omitted or changed in the process of transferring to the spreadsheet. This step may seem simple, but we have seen that a significant amount of errors actually happen at this initial step of the process. 

“The issue is, once the errors are initiated at this step, spreadsheets don’t offer a way to trace back to the source data which is troublesome when trying to explain discrepancies to the Tax Authority.”

Neha Mahindru, Indirect Tax Proposition Lead, Thomson Reuters

The right automation tool not only takes away the manual process involved with the extraction and transfer of the source data at the start of the indirect tax process; but also right to the end of the process where Tax Managers would find themselves ‘copying and pasting’ figures into the Tax Authority’s portal. 

Tax Authorities’ increasing governance pressures software adoption 

While indirect tax teams may be somewhat slow to move from spreadsheets to automation tools, tax authorities around the world appear to be increasingly embracing the value of technology as they look for more transaction information from companies as a way to assess indirect tax risks. Although not specifically mandating the automation of tax processes, Tax Authorities are arguably implying the need for it by increasing their level of governance.   

The fact is that the most common risk encountered by Tax Authorities is incorrect reporting from inadvertent errors. 

With the risk of hefty fines and penalties from manual errors in reporting or late submissions of returns, automation software provides enterprises a safe and reliable solution to reduce the risk and ensure compliance. 

Neha Mahindru, Indirect Tax Proposition Lead, Thomson Reuters

This is particularly the case when information requests are received from the Tax Authority and the indirect tax team is able to access all their transactional data, VAT returns, adjustments, etc at the click of a button! 

Improving the indirect tax process 

Here is an example of how our software product has improved the tax process of one of our customers at Thomson Reuters: 

Customer A came to us to look at ways of improving their VAT process. The current spreadsheet file had multiple tabs and links to different work papers. One of the links had been changed and this minor change took hours of work to update and correct. They decided to move to Thomson Reuters’ indirect tax compliance software to remove this risk going forward. This has also allowed them to do better testing on their data and to find discrepancies before the Tax Authority does! 

The greater benefits for the customer were not having to manage a spreadsheet with different versions and also to have the ability to run reports in real time. For our customer, gaining access to a solution on the cloud has been easier when working remotely compared to accessing spreadsheets on a server, which can be cumbersome.  

If manual spreadsheets are failing to keep up with your company’s growing demands, request a call back from a ONESOURCE specialist for a confidential consultation.   

Subscribe to Business Insight

Discover best practice and keep up-to-date with insights on the latest industry trends.