Connect with us

Accounting

Modernizing your tax workpapers process

Published

on

For decades, the tax process has centered around compliance. And for good reason — it’s an important and highly scrutinized output of the tax function. But if compliance is the endgame, what about all the work that comes before the forms?

Like having to “show your work” in math class, workpapers are essential not only for compliance, but also to support the tax accounting and reporting process, providing critical proof needed during an audit. They are also where some of the most complicated, time-consuming, and painful tax work is done.

However, Excel workpapers are tedious, prone to human error, devoid of controls and repeatability, and often rely on macro- or complex formula-based automation — which makes them hard to maintain, subject to key person dependencies, and outdated in comparison to today’s technological innovations.

For too long, tax departments have longed to improve their workpapers process but they lack the time, resources or expertise to do so. In a 2023 survey conducted by Bloomberg Tax & Accounting and Arizent, 89% of corporate tax professionals said their current workpapers process is difficult, while 92% said it’s overly time-consuming.

A better way to work

It is clear that tax departments are in need of a modern approach to simplify the workpaper creation and maintenance process — a solution that is easy to use, yet robust enough to handle the complexities inherent in the overall tax lifecycle.

The benefits are there for the taking. Relying on a solution that’s purpose-built to improve specific steps within the overall workpapers process can not only reduce risk and build confidence, but save tax departments valuable time that can be better spent on strategic, value-creating activities for their organization.

These are six key steps in the tax workpapers process that tax departments can evaluate for opportunities to save time, reduce risks, and increase flexibility through automation. 

1. Roll forward your prior period workpapers. Automating the roll forward process minimizes manual intervention and the associated risk of errors. It also significantly reduces the manual updates needed to create a workpaper in the new period and the associated time and effort involved. A robust roll forward automation will find and update the formulas and links within the workpaper to the desired new period — providing the preparer a head start in constructing the new workpaper.

2, Gather and transform current period data from source systems. One of the most common challenges in the workpapers process is gathering and transforming source data for use in tax calculations. It’s no secret that the tax department doesn’t own the source systems where most of their data comes from. So it’s also no surprise that one of the greatest opportunities for automation is to connect directly to data sources and transform them into usable formats. Look for a solution that allows you to pull data from enterprise resource planning and general ledger systems directly to your workpapers.

You should also seek a solution to automate those tedious data cleanup steps repeated each year — or any time new data, such as a new trial balance, becomes available. This cuts down on a significant amount of manual, repetitive work you must do every year before even getting to the tax calculation step.

3. Prepare your workpaper calculations. Because preparing tax workpapers is not always a linear process — data inevitably goes through updates and revisions — the calculations and data transformation steps that come before should be tightly integrated. Technology built for tax processes can make pulling data into your workpapers much faster and smoother — not simply for “same as last year” information, but also anything that has changed.

In addition, a solution with tax calculation templates, kept up to date with the latest law changes, can help with new or complex calculations applicable to your company. Think calculations like the new corporate AMT or the always-challenging GILTI.

4. Justify tax positions. Traditionally, justifying tax positions requires research from preparers in solutions wholly separate from where the workpapers are prepared or updated. Rates and regulations change constantly, and businesses may enter new jurisdictions, forcing you to look up new rates, dates, calculation methods, and other pertinent tax information.

A solution providing integrated tax guidance helps to ensure you are using the latest rates and tax law updates to inform your calculations.

p18m2p9i4rm811k011qmb1aak1p7n6.jpg

5. Review your workpaper. Change tracking and sign-offs are often important evidence that must be provided during a financial statement audit to prove the effective operation of internal controls. A solution that allows you to see who made changes and who signed off on a workpaper can be much more effective than the manual alternative. Further, it can significantly reduce the risk of unintended changes to the workpaper calculations. Look for a solution that offers controls that stand up to the rigors of a SOX audit.

6. Send final calcs to other relevant workpapers or systems. Although workpapers are the critical centerpiece to many tax processes, they are typically not the end of the process. Calculations done in workpapers often precede or are dependent on yet another calculation and, eventually, must be input to tax software solutions supporting compliance and provision. Tax tools that talk to each other and share data through key integrations create confidence that everything from data gathering to calculations to reporting will be consistent and efficient.

Look for a solution that works well not only with existing tools (like Excel, for parts of the process that will inevitably remain there), but also offers flexibility for importing final calculations into various tax preparation solutions and other business systems.

Going beyond a focus on compliance

To truly reap the benefits of modern technology, tax teams must look beyond compliance deliverable systems to solutions that focus on workpaper calculations. This shift in thinking will result in a more integrated, efficient, and intelligent tax workflow.

Continue Reading

Accounting

Continuous Auditing Transforms Corporate ERPs

Published

on

continuous auditing transforms corporate erps

As corporate accounting departments cross the threshold into late July 2026, the adoption of continuous, automated auditing systems has reached a definitive turning point. Driven by advances in artificial intelligence and deep integration with modern Enterprise Resource Planning (ERP) platforms, leading finance organizations are moving away from traditional, periodic post-hoc audits in favor of real-time, 100% transactional verification. This technological transition is redefining internal control environments, reducing compliance costs, and eliminating the structural delays inherent in legacy quarterly closing processes.

Unlike traditional auditing frameworks that rely on statistical sampling—a process that inevitably leaves operational blind spots—continuous auditing software monitors operational data feeds continuously. Every purchase order, electronic invoice, payroll disbursement, and cross-border wire transfer is automatically cross-referenced against established corporate governance parameters, regulatory tax schedules, and anti-fraud algorithms in real time. Anomalies or unauthorized ledger entries are flagged instantly, allowing internal audit teams to investigate and remediate compliance gaps immediately rather than months after the close of a financial period.

The implications for executive financial management are far-reaching. By embedding continuous verification directly into daily transaction workflows, chief financial officers gain uninterrupted visibility into the organization’s true financial standing. Real-time balance sheet auditing eliminates the severe operational bottlenecks associated with month-end and quarter-end financial reconciliations, freeing accounting professionals to focus on strategic financial modeling, tax planning, and capital allocation rather than manual data entry and spreadsheet consolidation.

However, implementing continuous auditing requires accounting leadership to invest heavily in data governance and technical upskilling. Internal audit teams must evolve from manual ledger reviewers into system architects capable of auditing complex algorithms and validating automated data pipelines. Accounting firms and corporate controllers that master continuous auditing will establish a resilient compliance framework capable of meeting stringent international regulatory standards with total transparency.

Continue Reading

Accounting

U.S. Imposes New 50% Tariffs on Canadian Imports Under Rare Legal Provision

Published

on

U.S. Imposes New 50% Tariffs on Canadian Imports Under Rare Legal Provision

WASHINGTON — In a major escalation of cross-border trade friction, U.S. President Donald Trump has signed executive orders imposing new 50% tariffs on a wide selection of Canadian exports, citing discriminatory practices by Ottawa targeting American auto, dairy, and beverage industries.

The new duties, announced Monday, will take effect in 30 days. They target a broad spectrum of consumer and industrial goods—ranging from wine, liquor, and milk products to commercial cement, furniture, clothing, and hockey equipment.

Untested Legal Mechanism

To enact the sweeping measures, the administration invoked Section 338 of the Tariff Act of 1930—a rarely used legal provision allowing the executive branch to levy additional tariffs of up to 50% on foreign nations deemed to discriminate against U.S. commerce.

White House officials noted that Section 338 addresses trade discrimination rather than national security or economic emergencies. The move comes months after prior global emergency tariffs faced legal challenges in domestic courts, signaling Washington’s pivot toward alternate statutory authorities to maintain import duties.

Senior administration officials briefed reporters that the measure directly responds to Canadian provincial bans on U.S. alcohol, restrictions on American vehicle exports, and import quota disparities affecting U.S. dairy and cheese producers relative to third-party trading partners.

“While the administration continues to secure reciprocal trade agreements globally, Canada retaliated against efforts to protect domestic industry,” U.S. Trade Representative Jamieson Greer stated.

USMCA Impact and Carve-Outs

Significantly, the newly ordered 50% duties will apply to designated items even if they otherwise comply with the United States-Mexico-Canada Agreement (USMCA).

However, the administration confirmed key targeted exemptions:

  • Energy products (including oil and natural gas)
  • Potash and critical minerals
  • Fish and seafood
  • Goods already governed by sector-specific duties (such as existing steel and aluminum tariffs)

Administration representatives emphasized that the tariffs do not stem from recent disputes concerning drifting Canadian wildfire smoke, noting that policy options regarding environmental spillover remain under separate review.

Canadian Response and Market Reaction

Following the White House announcement, the Canadian dollar experienced a sharp decline against the U.S. dollar, falling approximately 0.4% during evening trading.

Canadian Prime Minister Mark Carney issued a statement emphasizing that Canada’s earlier counter-duties had merely matched previous U.S. trade actions. “Canada stands ready to engage intensively to address outstanding issues with the U.S. to the mutual benefit of our citizens,” Carney stated, pointing to detailed proposals Ottawa submitted to modernize the USMCA framework.

Ontario Premier Doug Ford took a firmer stance, urging a “dollar-for-dollar” reciprocal response if the measures go into effect on August 19.

With a 30-day implementation window before the duties officially lock in, industry associations and trade groups on both sides of the border are calling for urgent bilateral negotiations to avert further supply chain disruption across North America.

Continue Reading

Accounting

Automated Continuous Auditing: Transforming Compliance and Real-Time Financial Oversight

Published

on

Transforming Compliance and Real-Time Financial Oversight

The traditional accounting paradigm—defined by periodic monthly closures and post-hoc annual audits—is rapidly giving way to continuous, automated financial oversight. As of July 2026, forward-thinking accounting practices and multinational corporate finance departments are leveraging continuous auditing systems powered by advanced machine learning models. These systems monitor operational transactions in real time, shifting audit methodologies from sample-based post-analysis to absolute, 100% transaction-level verification.

The operational advantages of continuous auditing are transformative. Standard auditing procedures historically relied on statistical sampling, which, despite rigorous methodology, inherently left gaps where anomalies or fraudulent transactions could go undetected for months. Modern continuous auditing platforms integrate directly with enterprise resource planning (ERP) databases, instantly cross-referencing purchase orders, invoices, bank feeds, and tax records. Any deviation from established control parameters or unusual transaction behavior triggers immediate flags for internal audit teams, dramatically reducing detection lag from quarters to seconds.

Beyond fraud prevention, continuous auditing fundamentally alters internal reporting and decision-making. Executive leadership no longer has to wait weeks after the close of a quarter to evaluate precise financial standing; real-time verified ledger data provides an uninterrupted view of operating margins, tax liabilities, and cash flow dynamics. This real-time visibility enables corporate controllers to adjust capital allocation strategies dynamically, mitigating liquidity constraints and capitalizing on emerging commercial opportunities far more efficiently than competitors bound to legacy reporting cycles.

However, implementing continuous auditing requires accounting professionals to acquire new analytical capabilities. The role of the auditor is evolving from manual data reconciliation toward system validation, algorithmic model governance, and strategic risk interpretation. Accounting firms and corporate finance departments must invest in continuous technical education, ensuring that audit staff possess the data engineering skills necessary to design, maintain, and evaluate complex automated compliance systems.

Continue Reading

Trending