The Role of Microsoft Excel™ in Modern Tax Models

For many tax departments, spreadsheets are the primary tool for most calculations and analysis, despite growing data volumes and complexity. Spreadsheets often also are used for tasks they were not designed to handle, which results in teams spending more time managing spreadsheets than analyzing results and creates bottlenecks and headaches during critical reporting periods.

While Microsoft Excel™ will continue to play an important role in tax departments, it can work better when paired with platforms and processes built to manage large, complex datasets. A modern tax data model separates data storage and processing from where professionals review and analyze the results. This approach allows teams to keep the familiarity of Excel while using scalable tools to manage growing complex tax data.

Defining the phrase “tax data model”

A tax data model organizes the flow of information through systems and processes within the tax function, separating key activities that often get combined inside spreadsheets.

These activities typically include:

• Data collection: From source systems, such as enterprise resource platforms and subledgers
• Data transformation: Where information is standardized and structured
• Data storage: Where the structured dataset is housed
• Calculation logic: Where tax rules and formulas are applied
• Review and analysis: Where professionals examine results and perform adjustments

Crowe observation

In many spreadsheet-driven processes, these activities occur inside a collection of workbooks. As data grows, that structure becomes difficult to maintain.

In a modern tax function, source data is collected and standardized in a platform designed for data processing, calculation logic is applied in a structured workflow, and Excel then provides the user a familiar interface to review results and perform analysis. This process makes the underlying work more stable, while the user experience remains familiar.

The problem: Spreadsheet-driven processes can be difficult to scale

Excel still is one of the most flexible tools available for analysis, scenario planning, and presentation. Tax professionals understand it well, and it allows quick exploration of results. The challenge arises when spreadsheets become the central platform for storing and processing large amounts of data as information often comes from multiple systems across the organization. When all that data is pulled into spreadsheets, files grow large and complicated. As a result, dependencies between workbooks increase and the processes become unstable and harder to maintain.

Some of the familiar symptoms of unstable spreadsheet-driven processes include:

• Multiple versions of files
• Broken links between workbooks
• Slow performance of files
• Long recalculation times during reporting cycles
• Key-person dependency

The solution: Separating data processing from review

Modern tax operations increasingly separate the heavy data work from the analytical interface. Analytics platforms are designed to process large data volumes efficiently. They automate data ingestion and transformation so updates can be processed quickly.

Crowe observation

Teams that don’t yet have an analytics platform can still make improvements to calculation speed by using Excel’s Power Query to reduce the calculations embedded in the workbook. When source data changes, workflows can be refreshed without rebuilding large spreadsheets.

Processes that are structured and repeatable reduce friction during reporting periods and allow teams to focus on reviewing results. The results of data processing in an analytics platform can be delivered to Excel, which provides the interface for tax professionals to review and analyze the results. The goal of using an analytics platform is not to replace spreadsheets but to use them where they provide the most value. When data storage, transformation, and calculations occur within a structured model using an analytics platform, Excel becomes a simpler and more effective tool for analysis.

Segregating operations performed in an analytics platform from those performed in Excel addresses some of the issues with a spreadsheet-driven approach and provides the following benefits:

• Consistent data transformations each reporting cycle
• Automatic application of validation rules
• Centralization of calculation changes
• More complete and accurate process documentation
• Simplified spreadsheets for review
• Teams better prepared for leadership and audit support

Looking ahead

For many organizations, transitioning to a modern tax data model is not just a technology decision, but the establishment of a new working environment. It is an opportunity to improve efficiency, strengthen governance, and reduce operational strain during reporting cycles. A phased approach often works best – first creating a governed tax data strategy that sets the foundation and then mapping process to help tax teams create a project plan based on various drivers like urgency, impact, financial cost, and opportunities unlocked.

Ultimately, the modern tax data model enables tax teams to spend less time managing data and more time delivering insights that support better business decisions. Organizations should consult a tax technology adviser to evaluate their current approach for calculations and analysis and consider whether improvements can be made to optimize their tax data model.

Microsoft and Excel are trademarks of the Microsoft group of companies.