QuickBooks Online to UltraTax CS — Why There's a Gap (And How to Bridge It)
If you prepare tax returns in Thomson Reuters UltraTax CS and your clients use QuickBooks Online for their books, you already know the drill. Every engagement starts the same way: pull up the client's trial balance in QBO, open UltraTax CS, and start typing numbers into input cells. One account at a time. One client at a time.
It feels like something that should have been solved years ago. QuickBooks Online is the most widely used small business accounting platform in the U.S. UltraTax CS is one of the most established professional tax preparation systems on the market. Surely there's a button somewhere that connects the two.
There isn't. And there's a reason for that.
Two Ecosystems That Were Never Designed to Talk
QuickBooks Online is an Intuit product. UltraTax CS is a Thomson Reuters product. These are two of the largest, most direct competitors in the accounting technology space. Intuit builds its own tax preparation software — ProConnect Tax Online and Lacerte — and has no incentive to make it easy for firms to move data into a competitor's platform. Thomson Reuters, for its part, has built deep integrations with its own ecosystem (CS Professional Suite, Practice CS, Accounting CS) but hasn't prioritized connections to Intuit's products.
This isn't an accident or an oversight. It's a strategic reality. Both companies want to keep firms inside their respective ecosystems. If you use QuickBooks Online, Intuit would prefer you also use ProConnect for tax prep. If you use UltraTax CS, Thomson Reuters would prefer you use their accounting tools too.
But that's not how most firms actually work. The reality on the ground is that thousands of accounting firms use QuickBooks Online for client bookkeeping — because their clients chose it, because it's dominant in the small business market — while preferring UltraTax CS for tax preparation because of its depth, flexibility, and the workflow their firm has built around it over years or decades.
These firms are caught in the middle. And they pay for it with their time.
The Real Cost of Manual Re-Keying
Without a native connection between QuickBooks Online and UltraTax CS, the standard workflow during tax season looks like this: export a trial balance or profit-and-loss report from QBO, open UltraTax CS, and manually enter each line item into the appropriate tax input cell. For a typical small business return, this process takes approximately one hour per client.
One hour doesn't sound catastrophic until you multiply it across your client base. A firm with 200 returns is looking at 200 hours of pure data entry — the equivalent of five full work weeks. That's time spent not on advisory work, not on complex tax planning, not on anything that actually requires professional judgment. It's clerical work, and it's the kind of work that drives experienced staff to frustration and burnout during the busiest months of the year.
And the cost isn't just time. Manual data entry introduces errors. A transposed digit, a missed account, a mapping mistake — any of these can cascade through a return. Catching errors means reviewing everything twice. Missing them means potential amendments, client dissatisfaction, or worse.
For most firms, this is simply accepted as the cost of doing business. It shouldn't be.
Why Existing Workarounds Fall Short
Some firms have tried to build their own bridges. The most common approach is exporting a CSV from QuickBooks Online and trying to massage it into a format that UltraTax CS can import. This works in theory but breaks down in practice for a few reasons.
First, QuickBooks Online's chart of accounts doesn't map cleanly to UltraTax CS's input structure. QBO organizes accounts by type (income, expense, asset, liability), while UltraTax CS organizes input by tax form and schedule. Translating between the two requires professional judgment — knowing that "Advertising Expense" in QBO maps to a specific line on Schedule C, for example. A raw CSV export doesn't carry that mapping.
Second, the mapping is different for every client. A sole proprietor's QBO accounts map to entirely different UltraTax CS inputs than an S-Corp's. There's no one-size-fits-all template.
Third, even when a firm builds a custom spreadsheet or macro to handle the translation, it's fragile. Any change to the client's chart of accounts — a new account added, an account renamed — means the mapping needs to be updated. Maintaining these custom solutions is its own time sink.
Bridging the Gap with AccountantSync
AccountantSync was built specifically to solve this problem. It connects directly to QuickBooks Online, pulls the client's trial balance data, and lets you map each account to the correct UltraTax CS input — visually, in a browser, with no software to install on your desktop.
The first time you set up a client, you walk through the mapping: this QBO account goes to this UltraTax CS input cell. AccountantSync remembers that mapping for next year. When tax season rolls around again, you pull the updated trial balance and the mapping is already done. Review it, confirm it, and generate the import file.
The result is a file that UltraTax CS can ingest directly — no manual re-keying, no CSV gymnastics, no transposed digits. What used to take an hour per client becomes a few minutes of review.
And the real payoff isn't even in year one. It's in year two and beyond, when the mappings are already set and the process becomes nearly automatic. The time savings compound with every client you onboard and every tax season you complete.
What AccountantSync Doesn't Do
It's worth being clear about scope. AccountantSync currently supports QuickBooks Online as the source and UltraTax CS as the destination. If your clients use QuickBooks Desktop or Xero, support for those platforms is coming soon but isn't live yet.
AccountantSync is a cloud-based trial balance solution designed specifically to take your trial balance from your accounting source — after you have made all your adjustments in your accounting system (QuickBooks Online, for example) — help you with mappings and groupings, and import those numbers directly into your tax software as the destination.
AccountantSync also doesn't pretend to handle every edge case without your input. The account mapping step is intentionally interactive because professional judgment matters — you know your client's situation better than any algorithm. What AccountantSync does is handle the predictable, repeatable parts of the workflow so you can focus your expertise where it actually counts.
Getting Started
AccountantSync offers a free tier that covers 2 clients — enough to see the full workflow in action with your own data. Setup takes about ten minutes, and there's nothing to install on your desktop. Connect your QBO account, map your first client's accounts, and generate the import file.
If you've been manually re-keying trial balance data from QuickBooks Online into UltraTax CS, you already know how much time it costs. The gap between these two platforms isn't going away — but you don't have to keep paying for it.