Connect with us

Accounting

Art of Accounting: SmartProof worksheet template available

Published

on

Complimentary Access Pill

Enjoy complimentary access to top ideas and insights — selected by our editors.

Two weeks ago, I made my updated Word file with 190 checklists available. I now have a SmartProof Excel worksheet template available. I will provide it for free if you email me at [email protected] and just put Template as the subject. If you did not get the worksheet file and want it, send a second email with Checklists as the subject. This method is part of a system that makes it easier to respond. Please no messages, just the subject. 

I posted a previous column describing this method and provided reasons for when, why and how to use the SmartProof worksheet. I want to now add another reason…and it’s personal.

When we prepare our personal tax returns, there is no one to review them. It is up to us to check it and recheck it and then give it a final look-see before we push the button to file it. In my case I also want my wife to be aware of our income and tax situation. In both of these situations the SmartProof worksheet is a life saver, and I use it as my self-proving method. I enter everything from my “final” return and compare it to my projection and the last three years’ actual amounts. Any obvious errors pop right up. I could not be certain my return is correct without this SmartProof worksheet. Further, I also prepare some relatives’ returns with one being pretty involved. Again, the SmartProof worksheet is my review method. Note: At some point the tax preparation software will generate these SmartProof worksheets, but not now, so the entries have to be entered manually into the SmartProof worksheet. That’s OK because it gives the preparer another look at what they did. 

While my tax return is not that involved, it is not a plain vanilla version. When I review the final return with my wife, I use the SmartProof worksheet. That takes about 10 minutes while using the return with its many pages and some in an illogical order, it would take at least 45 minutes (if I am lucky). Likewise, I have some clients with 1,000-page tax returns. I can review it with them over the phone or in a virtual session in under 15 minutes! Without the SmartProof worksheet, fuhgeddaboudit!

A secondary use is where I enter unusual items that occur during the year in a projection column for the current year. This serves as a mind-jogger and is quick and easy to do.

When staff use this SmartProof worksheet, they have a method to self-check and self-review their own work and fix any errors before it goes to the reviewer. Shouldn’t that be the goal?

For the first time in many years I prepared a template that should work for most returns, with minor changes based on clients’ situations. I also added at the end of the SmartProof worksheet some of the information I include for my own return, so it should be a very helpful tool for you. I also hope that by using it to review your own return, you will see the benefits of it and extend it to standard use by your staff. From what I can tell, a few thousand firms are using this SmartProof worksheet, and I periodically get unsolicited thank you messages from many of them.

When I send you the template, I’ll also include prior articles posted here and sample spreadsheets. It will be two files — an Excel and a PDF. Email me at [email protected]. It’s free with my compliments. You’ll also be able to put it to immediate use. Learning time should be less than three minutes!

This was adapted from, and further information on reviewing tax returns is in, my How to Review Tax Returns, 3rd Edition book published by CPA Trendlines.

Do not hesitate to contact me at [email protected] with your practice management questions or about engagements you might not be able to perform. 

Continue Reading

Accounting

FASB Standardizes Carbon Offsets Accounting Rules

Published

on

FASB Standardizes Carbon Offsets Accounting Rules

In a decisive move toward standardized environmental financial reporting, accounting standards boards issued updated implementation guidance during the week ending July 25, 2026, regarding the formal recognition and valuation of corporate carbon offsets and environmental credits. The revised frameworks establish precise rules for how enterprises must measure, record, and disclose carbon credits on balance sheets, eliminating years of inconsistent reporting practices across public capital markets.

Under the finalized accounting standard, purchased carbon offsets can no longer be categorized under vague administrative expenses or unstandardized intangible asset accounts. Instead, organizations must classify environmental credits based on underlying operational intent—distinguishing between credits held for immediate compliance compliance obligations, long-term offset obligations, or active market trading. Furthermore, companies are required to evaluate carbon holdings for fair value impairment at the end of each reporting period, ensuring that depreciated or low-quality environmental credits do not distort corporate asset values.

The standardized rules carry significant implications for corporate audit committees and chief accounting officers. External audit firms are implementing rigorous verification protocols to validate the physical legitimacy, legal ownership, and scientific permanence of carbon credits claimed on balance sheets. Inaccurate or overstated carbon accounting claims now carry substantial financial litigation risk, alongside potential regulatory enforcement for misleading ESG disclosures.

To remain fully compliant, corporate accounting departments must establish centralized carbon tracking systems integrated into primary standard ERP ledgers. Accounting teams that proactively adopt standardized environmental reporting protocols will build investor credibility, streamline annual audit processes, and insulate their organizations against evolving regulatory scrutiny.

Continue Reading

Accounting

Automated Tax Compliance Tools Reduce Risk

Published

on

Automated Tax Compliance Tools Reduce Risk

Corporate tax departments reached a critical juncture in automated operational management. With nations worldwide rapidly enacting digital service taxes, localized value-added tax (VAT) mandates, and real-time electronic invoicing requirements, manual tax calculations have become obsolete. Modern corporate tax divisions are aggressively deploying AI-driven tax engine software to automate complex cross-border indirect tax calculations in real time.

The imperative for automated tax compliance stems from the sheer complexity of current trade policies and multi-jurisdictional commerce. E-commerce platforms, software vendors, and global manufacturers face constantly changing regional tax rates, statutory exemption rules, and cross-border tariff structures. Automated tax engines embed directly into enterprise enterprise resource planning (ERP) architectures, automatically applying correct tax codes at the point of sale, calculating real-time withholding amounts, and generating compliant e-invoices.

Automated audit trail generation represents another key advantage of modern tax tech integration. Advanced compliance platforms log every transactional tax determination on immutable digital ledgers, providing tax authorities with transparent, self-verifying audit trails. This capability drastically reduces the operational duration and administrative cost of corporate tax audits, protecting enterprises against severe penalties resulting from calculation errors or missed reporting deadlines.

For chief financial officers and tax directors, investing in automated tax compliance is a vital operational risk mitigation strategy. Automating routine tax calculations frees high-level accounting professionals to focus on strategic tax planning, transfer pricing optimization, and risk management in an increasingly complex global economic environment.

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

Trending