How to Import a QuickBooks Online Trial Balance into UltraTax CS for a C Corporation (Form 1120)

If your client's books live in QuickBooks Online and you file its Form 1120 in Thomson Reuters UltraTax CS, you already know there's no import button between the two. The gap is structural, and it isn't getting closed by either vendor. So the trial balance comes out of QBO, gets reshaped into the columns UltraTax expects, and every account gets a tax code by hand before it imports.

The mechanics of that import are the same for any entity. What changes — and what decides whether the return is right — is which tax code each account gets when the return is a C corporation. A C corp is the one entity that pays tax at the entity level, takes a dividends-received deduction, and carries its federal tax through Schedule M-1. None of that exists on an 1120-S or a 1065, and mapping a C corp as if it were a pass-through is how a clean-looking import produces a wrong return.

Why the entity changes the mapping

UltraTax CS routes a balance by tax code, not by what the account is named in QuickBooks. QBO organizes accounts by type and detail type — what the money is. UltraTax organizes by tax line — where the number goes. The translation between them depends on the entity, and a C corp's translation is the one most likely to trip a preparer who's used to S-corps and partnerships.

Three things are genuinely different on a 1120:

  • The corporation pays its own federal income tax, so that tax is both a book figure and a Schedule M-1 adjustment.
  • Dividends the corporation receives get a dividends-received deduction, which depends on ownership percentage.
  • Equity is real C-corp equity — capital stock, paid-in surplus, and retained earnings split into appropriated and unappropriated. There is no Accumulated Adjustments Account; that's an S-corp construct.

If you maintain mapping templates across clients, this is the one place copying an S-corp template onto a C corp quietly breaks: the AAA and OAA codes you used last engagement don't exist here, and the federal-tax handling is the opposite.

The Form 1120 tax codes that matter

These are the actual UltraTax CS tax codes for the 1120 (from Thomson Reuters' Tax Code Listing for chart-of-accounts setup). Not every client touches all of them, but these are the accounts a C corp's QBO trial balance almost always has — and the ones most often miscoded.

Income and cost of goods sold

  • 100 Gross receipts → 1120, Line 1a
  • 101 Returns and allowances → 1120, Line 1b
  • 275 Purchases → Form 1125-A, Line 2
  • 280 Inventory at end of year → Form 1125-A, Line 7

Cost of goods sold lives on its own form, 1125-A, not on page 1 — so a QBO "Cost of Sales" group has to break into the 1125-A codes rather than collapse into a single deduction.

The dividends-received deduction

  • 107 Dividends, domestic, 50% deduction → Schedule C, Line 1
  • 108 Dividends, domestic, 65% deduction → Schedule C, Line 2
  • 112 Dividends, foreign, 50% deduction → Schedule C, Line 6

This is uniquely a C-corp problem. If the corporation holds stock in other companies, dividends it receives flow through the 1120's own Schedule C, where the deduction percentage depends on ownership: generally 50% under 20% ownership, 65% from 20% to 80%, 100% at 80%+. A QBO account simply called "Dividend Income" carries none of that — you have to know the ownership tier to pick the code. Code it as plain other income and you lose the deduction entirely.

Officer compensation

  • 200 Compensation of officers → Form 1125-E, Line 1
  • 201 Salaries and wages → 1120, Line 13

As on every corporate return, officer compensation is a separate code (200) that flows to Form 1125-E; the rest of payroll is code 201 on page 1. Most QBO charts lump them into one "Payroll" account, so the split is a judgment call you make before coding. (UltraTax only prints Form 1125-E once total receipts reach $500,000, but the figure has to be coded correctly regardless. Note that salaries land on Line 13 of the 1120 — a different line number than the same account would use on an 1120-S.)

The federal tax that doesn't exist on a pass-through

  • 480 Federal income tax → Schedule M-1, Line 2
  • 443 Federal income tax payable → Sch L, Line 18
  • 407 Prepaid federal income tax → Sch L, Line 6
  • 301 Estimated tax payments → Schedule J, Line 14

This is the cluster that has no equivalent on an 1120-S or 1065. A C corp's book income tax expense is added back on Schedule M-1 (code 480) to bridge book income to taxable income; the related payable and prepaid sit on the balance sheet; estimates paid during the year go to Schedule J. If your client's QBO file has an "Income Tax Expense" account and you code it like any other expense, Schedule M-1 won't reconcile and taxable income will be understated.

Schedule L equity and Schedule M-2

  • 465 Capital stock – preferred → Sch L, Line 22a
  • 466 Capital stock – common → Sch L, Line 22b
  • 467 Paid-in or capital surplus → Sch L, Line 23
  • 468 Retained earnings – appropriated → Sch L, Line 24
  • 469 Retained earnings – unappropriated → Sch L, Line 25
  • 492 Cash distributions → Schedule M-2, Line 5a
  • 493 Stock distributions → Schedule M-2, Line 5d
  • 494 Property distributions → Schedule M-2, Line 5c

C-corp retained earnings split into appropriated (468) and unappropriated (469) — a distinction QBO doesn't track, so you make it at mapping time. Distributions to shareholders are dividends on a C corp (codes 492–494 on Schedule M-2), taxable to the recipient — not the nondividend distributions you'd code on an S-corp. Shareholder loans (409 loans to stockholders, 445 loans from stockholders) round out the section.

The workflow, C-corp specifics only

The export-and-reshape mechanics are the same as any trial-balance import. Here's what's different once you know the client is a C corporation:

  1. Confirm the entity on both ends. The client must be set up as an 1120 in UltraTax before any code is meaningful. A balance imported under the wrong entity maps to nothing.
  2. Handle the federal tax accounts deliberately. Book income tax expense → 480 (M-1 add-back). Payable → 443. Estimates → 301. Don't let "Income Tax Expense" fall into ordinary deductions.
  3. Split officer pay out of Payroll into officer compensation (200) and other salaries (201) before assigning codes.
  4. Code dividend income by ownership tier, not as generic other income, so the dividends-received deduction survives.
  5. Map equity to real C-corp equity. Capital stock to 465/466, paid-in surplus to 467, retained earnings split into 468/469. Do not reach for AAA or OAA codes — they don't exist on a 1120.
  6. Exclude what doesn't belong on the return. Suspense, clearing, and rounding accounts get tax code 88888 or 99999, which tells UltraTax to skip them. Don't assign a unit to either.

Gotchas that bite on a QBO C corporation specifically

  • Income tax expense coded as an ordinary deduction. The single most common C-corp import error. It belongs on Schedule M-1 (480), not page 1, or the book-to-tax reconciliation breaks.
  • Dividends-received deduction lost at the source. "Dividend Income" in QBO doesn't carry the ownership percentage, so it's easy to drop into other income and forfeit the deduction.
  • An S-corp template copied onto a C corp. If your firm reuses mappings across clients, the AAA/OAA codes from an S-corp don't map on a 1120, and distributions reverse meaning. Start C corps from C-corp codes.
  • Officer comp buried in Payroll. As on any corporate return, officer compensation has to be separated (200) from the rest of wages (201).
  • The 12-character account-number limit and duplicate groupings. UltraTax truncates account numbers past 12 characters, and two groupings carrying the same name fail the import — keep one group per tax code even when several QBO accounts (multiple bank accounts to Cash 400) sum into it.
  • Contra accounts need a sign toggle. Accumulated depreciation (426) and the allowance for bad debts (402) come out of QBO with the opposite sign to what UltraTax expects on Schedule L; flag them so the balance sheet balances.

The faster path

Everything above is the manual version, and it's real work — the federal-tax handling, the dividends-received tiers, the officer split, the equity coding. The point of doing it carefully once is that the judgment is reusable.

AccountantSync connects to QuickBooks Online directly, pulls the C corporation's trial balance, and applies the Form 1120 tax codes automatically based on the entity you select — keeping officer compensation, the federal-tax add-back, and the contra-account signs straight, and generating a file built to UltraTax's exact import spec. The mappings persist year over year and copy from one C-corp client to the next, so the second 1120 you set up inherits the judgment from the first. It's free for your first two clients, no credit card.

If your firm runs a mix of C corps, S corps, and partnerships on QuickBooks Online, the entity-aware mapping is the whole point: you stop re-deciding where the federal tax and the dividends-received deduction go on every engagement.