Editorial & Advertiser Disclosure Global Banking And Finance Review is an independent publisher which offers News, information, Analysis, Opinion, Press Releases, Reviews, Research reports covering various economies, industries, products, services and companies. The content available on globalbankingandfinance.com is sourced by a mixture of different methods which is not limited to content produced and supplied by various staff writers, journalists, freelancers, individuals, organizations, companies, PR agencies Sponsored Posts etc. The information available on this website is purely for educational and informational purposes only. We cannot guarantee the accuracy or applicability of any of the information provided at globalbankingandfinance.com with respect to your individual or personal circumstances. Please seek professional advice from a qualified professional before making any financial decisions. Globalbankingandfinance.com also links to various third party websites and we cannot guarantee the accuracy or applicability of the information provided by third party websites. Links from various articles on our site to third party websites are a mixture of non-sponsored links and sponsored links. Only a very small fraction of the links which point to external websites are affiliate links. Some of the links which you may click on our website may link to various products and services from our partners who may compensate us if you buy a service or product or fill a form or install an app. This will not incur additional cost to you. A very few articles on our website are sponsored posts or paid advertorials. These are marked as sponsored posts at the bottom of each post. For avoidance of any doubts and to make it easier for you to differentiate sponsored or non-sponsored articles or links, you may consider all articles on our site or all links to external websites as sponsored . Please note that some of the services or products which we talk about carry a high level of risk and may not be suitable for everyone. These may be complex services or products and we request the readers to consider this purely from an educational standpoint. The information provided on this website is general in nature. Global Banking & Finance Review expressly disclaims any liability without any limitation which may arise directly or indirectly from the use of such information.

NAVIGATING THE WORLD OF WORKPAPER MANAGEMENT

How can tax and accounting professionals manage their workpapers?

By, Stephen McGerty, Head of ONESOURCE Income Tax, Provision & Workflow, for the
Tax & Accounting business of Thomson Reuters

Did you know…?

  • Tax is the primary cause of control deficiencies.
  • Managing risk through the adherence of controls is a key objective of a tax professional.
  • A recent study of nearly 400 tax departments from public and private corporations revealed numerous concerns around workpaper efficiency and controls.
  • Tax professionals spend 30% to 60% of their time just pulling, organizing and preparing data, leaving little time for analysis.
  • 36% of tax professionals spend more than two months each year preparing workpapers. 53% said that updating information in workpapers is the most time consuming task they’re faced with.

Introduction

Rapid globalisation and ever increasing regulatory scrutiny are forcing companies to deal with more complexity than ever before.  New regulations are constantly being introduced by governments around the world.  The challenge for companies expanding globally is to remain compliant.  Consequently, tax and accounting professionals worldwide are experiencing increased pressure to do more – but often with simultaneous internal pressures to cut costs.

Traditional approaches to manually collecting and manipulating information are no longer sufficient.  This is driving a shift towards specialized software solutions that serve to increase efficiency, automate data collection, and reduce risk.

What are the challenges and the risks?

One of the major challenges companies face is a lack of control in and around workpaper documents.  Workpapers are typically spreadsheets put together in a relatively ad-hoc fashion.  Mistakes in these spreadsheets effectively cause the workpaper to “break” and produce incorrect results or conclusions.

Workpapers are often distributed to dozens of subsidiary business units across the globe, frequently in an effort to collect and consolidate information.  If the company has not put controls in place to ensure the structure of those workpapers is preserved, then the risk of errors and inconsistencies is even greater. Poorly constructed workpapers often result in tax and audit departments conducting redundant work, which wastes time.

Different departments often have different document repositories and filing standards that create further collaborative barriers. This can be a particularly disruptive to the audit process especially for public companies as they are audited annually.

As workpapers become more complex to maintain, tax and accounting professionals are finding that their current practices, usually spreadsheets stored on a shared hard drive, do not offer the efficiency and control that they need.

What’s the solution?

To reduce risk and gain control, tax and accounting professionals need a solution that offers the ability to use their existing spreadsheets, but offers a level of protection from incorrect use or changes.  Preventing users from inserting unwanted rows or columns, changing calculation formulas, or breaking links to other worksheets can significantly reduce the chances of workpapers “breaking”.

Implementing a system to more easily create, maintain and share workpapers allows tax and accounting departments to find a balance between flexibility and structured control.  Flexibility, in that they need to be able to gather information from a variety of sources, aggregate it and perform ad-hoc calculations on it.  Control, in that they need these things to be done consistently and with less concern that the structure of the workpapers has been changed.

One technique that can simplify the use of spreadsheets as workpapers is to break down large workbooks into a set of modular worksheets, ideally based on standard templates.  Grouping related information together in a consistent fashion can reduce the chances of error and can facilitate scalability for the future.

Workpapers almost never live in isolation – they are typically woven into a complex tapestry of documents that build up to provide a solid auditable defence for a tax return or other type of external declaration.  Workpapers need to be connected with traditional tax software systems in such a way that users can easily trace information back to it source – this helps improve transparency and assists with audit defence.

Workpapers usually have to be “rolled over” from month to month, quarter to quarter and year to year.  This process can be time consuming, tedious and error prone.  Software systems can help to automate these rollovers, ensuring they’re done quickly and consistently.

Implementing a single, consistent document repository across the tax and audit departments is another technique that can improve the critical to maximum workpaper efficiency. Cloud-based solutions are growing in popularity and can create efficiencies by ensuring consistent indexing of documents and flexible searching and retrieval.

Tax professionals can now print a document directly into a document management system in the cloud, as well as onto paper.  While the printer may produce a crisp paper copy of the document, it won’t index the document, back it up or make it available to a broader audience.

This is particularly beneficial where tax departments are geographically dispersed; an increasingly common phenomena as companies expand their global operations.

Summary

Workpaper management systems are helping manage the risk around complex, interwoven spreadsheet based systems.  While not necessarily replacing spreadsheets, they aim to control the use of spreadsheets and offer connectivity with traditional document management systems and tax software.

Integrated tax software suites are growing in popularity as users demand a more seamless experience between spreadsheet based workpapers, document management systems and tax provision and tax return software.