QBO and Ultratax Addin for Excel

UltraTax Excel Add-in helps accounting and tax professionals transform financial statement data into organized, reviewable tax return workpapers directly within Microsoft Excel.

The add-in is designed for firms that spend significant time exporting financial statements from accounting systems, cleaning up general ledger account descriptions, grouping accounts, and manually determining where balances belong on a tax return. It provides a structured workflow for mapping profit and loss and balance sheet accounts to applicable UltraTax input fields.

Key capabilities include:

• Importing and organizing financial statement data within Excel

• Mapping general ledger accounts to standardized tax return categories and UltraTax fields

• Using AI-assisted recommendations to accelerate the initial account-mapping process

• Reviewing, approving, and modifying suggested mappings before finalizing results

• Saving reusable mapping rules for future clients and reporting periods

• Aggregating multiple financial statement lines into summarized tax workpaper amounts

• Maintaining a clear audit trail between source accounts, mapped categories, and final totals

• Reducing spreadsheet manipulation, repetitive data entry, and inconsistent mapping decisions

The product benefits CPA firms, tax preparers, controllers, outsourced accounting teams, and other professionals who prepare business tax returns using financial statements exported from QuickBooks or similar accounting platforms.

By keeping the mapping and review process inside Excel, the add-in allows tax professionals to work in a familiar environment while improving consistency, documentation, and preparation efficiency.

This product is an independent workflow and productivity solution and is not affiliated with, endorsed by, or sponsored by Thomson Reuters, UltraTax CS, or Intuit Quickbooks Online.

To sign up for an account, visit https://knd-randy.github.io/ultratax-excel-addin/