How to Import a QuickBooks Online Trial Balance into UltraTax CS for a Schedule C (Sole Proprietor)

If your client runs a sole proprietorship, keeps the books in QuickBooks Online, and you file their Schedule C in Thomson Reuters UltraTax CS, the trial balance import has a quirk the entity returns don't: most of the accounts in QuickBooks have nowhere to go.

There's no native QuickBooks-to-UltraTax connection to lean on — that's the same structural gap that sits between QuickBooks Online and UltraTax CS for every entity type. UltraTax imports tax data directly only from Thomson Reuters' own products like Accounting CS and Trial Balance CS. A QuickBooks trial balance comes in as outside data you export, reshape, and map by hand. This guide is the Schedule C version of that job: the accounts that map, the larger set that don't, and the sole-proprietor traps that pass through a clean-looking import and land on the return wrong.

Why a Schedule C import is different from an entity return

A partnership, an S corporation, or a C corporation files a balance sheet — Schedule L — and UltraTax has a tax code for every line of it: cash, receivables, fixed assets, payables, equity. When you import a 1065 or 1120-S trial balance, nearly every account in the books has a home on the return.

Schedule C has no balance sheet. A sole proprietorship is not a separate taxpayer; its profit flows straight onto the owner's Form 1040. The return is a single page of income and expenses (Part I and Part II), an optional cost-of-goods section (Part III), and vehicle and other-expense detail. There is no place to report cash, accounts receivable, accounts payable, loans, or owner's equity.

So the defining move on a Schedule C import isn't mapping — it's deciding what to leave out. Roughly half a typical QuickBooks chart of accounts has no Schedule C destination, and an account with no tax code is simply excluded from the import. That's usually correct here. The danger is the handful of balance-sheet-flavored accounts that look like deductions and get mapped anyway.

The Schedule C tax-code groupings that matter

UltraTax routes each balance to a Schedule C line by tax code. The codes below are from the Thomson Reuters Tax Code Listing for Chart of Accounts setup (the 1040 section), and they're what you assign to each QuickBooks income and expense account.

Income (Schedule C, Part I)

  • 801 — Gross receipts, non-1099-K (Line 1)
  • 850 — Gross receipts, 1099-K (Line 1)
  • 802 — Returns and allowances (Line 2)
  • 806 — Other income (Line 6)

The split between codes 801 and 850 is the first thing unique to a 1040 business. QuickBooks usually lumps all sales into one or two income accounts, but the IRS Schedule C instructions and Form 1099-K guidance treat card and third-party-network receipts (the amounts reported to the client on a 1099-K) as part of the same Line 1 total. If the client takes Stripe, Square, or PayPal, decide up front whether you're tracking the 1099-K portion separately — and if you are, that's a chart-of-accounts split in QuickBooks before you ever touch the import.

Cost of goods sold (Schedule C, Part III) — only if the business carries inventory

  • 834 — Purchases (Line 36)
  • 835 — Cost of labor (Line 37)
  • 836 — Materials and supplies (Line 38)
  • 837 — Other costs (Line 39)
  • 839 — Ending inventory (Line 41)

Most service sole proprietors have no COGS at all. If your client doesn't hold inventory, skip Part III entirely — don't force "Supplies" into COGS when it belongs in expenses (code 822).

Expenses (Schedule C, Part II)

  • 808 — Advertising (Line 8)
  • 810 — Car and truck expenses (Line 9)
  • 811 — Commissions and fees (Line 10)
  • 828 — Contract labor (Line 11)
  • 813 — Depreciation (Line 13)
  • 814 — Employee benefit programs (Line 14)
  • 815 — Insurance, other than health (Line 15)
  • 816 — Interest, mortgage (Line 16a) and 886 — Interest, other (Line 16b)
  • 817 — Legal and professional fees (Line 17)
  • 818 — Office expenses (Line 18)
  • 819 — Pension and profit-sharing (Line 19)
  • 820 — Rent, vehicles and equipment (Line 20a) and 880 — Rent, other business property (Line 20b)
  • 821 — Repairs and maintenance (Line 21)
  • 822 — Supplies (Line 22)
  • 823 — Taxes and licenses (Line 23)
  • 824 — Travel (Line 24a) and 884 — Meals, 50% limit (Line 24b)
  • 825 — Utilities (Line 25)
  • 826 — Wages (Line 26)
  • 809 — Bad debts and 827 — Other expenses (Line 27a, from Part V)

A note on meals: with the temporary 100%-deductible restaurant provision expired, code 884 (50% limit) is the normal destination again. UltraTax also carries codes for fully deductible and DOT meals, but reach for those only when the facts support them.

The sole-proprietor traps that pass through a clean import

Each of these produces a return that imports without error and is wrong on review — the most expensive kind of mistake.

  • Owner's draw is not wages. A sole proprietor cannot deduct payments to themselves. The IRS Schedule C instructions are explicit that Line 26 wages are for employees and exclude amounts "paid to yourself." In QuickBooks, owner's draw and owner's equity look like ordinary accounts, and mapping a draw to Wages (826) or any deduction inflates expenses and understates the profit the client owes self-employment tax on. Owner's draw, owner's pay, and owner's equity get no tax code — they're excluded, like the rest of the balance sheet.
  • The whole balance sheet drops out. Cash, accounts receivable, accounts payable, credit cards, loans, fixed-asset cost, accumulated depreciation, retained earnings — none of it has a Schedule C line. Leave these untagged (or use the exclusion codes below). This is correct. It only feels wrong because on an entity return all of these would map.
  • Fixed assets versus depreciation expense. The asset accounts (cost and accumulated depreciation) are balance-sheet items with no Schedule C home. The current-year depreciation deduction goes to code 813 — but in practice it's computed from the asset module, not pulled from a book depreciation account. Don't map a book "Depreciation expense" account straight to 813 without confirming it equals the tax depreciation for the year.
  • Health insurance is not a Schedule C deduction. A self-employed owner's health premiums are an adjustment on Schedule 1 of the 1040, not a Line 14 or Line 15 business expense. If QuickBooks has "Owner health insurance" in expenses, it doesn't belong on Schedule C.

The UltraTax import mechanics that bite regardless of entity

Even with every account mapped correctly, the file has to fit UltraTax's import rules:

  • Account numbers cap at 12 characters. If two accounts exceed that and collapse to the same value under the same tax group, the duplicate accounts won't import — and you won't get a loud error, just a missing balance.
  • Accounts under one tax code are summed. Map five QuickBooks expense accounts to code 818 and they collapse into one Office-expenses figure. Usually what you want, but a mismapped account hides inside a correct-looking total, so spot-check the groupings before you file.
  • Exclusion codes 88888 and 99999. When you want an account explicitly excluded rather than untagged, UltraTax recognizes 88888 and 99999 — the difference is only whether the account prints on the Tax Code Groupings report. For a Schedule C, that's a clean way to mark the entire balance sheet and owner's-equity section as intentionally out.
  • Untagged accounts disappear silently. An account with no tax code isn't an error; it's excluded. On a Schedule C that's mostly the point — but it means a real expense you forgot to map just isn't there, and the profit is quietly overstated until review.
  • Entity type must match on both sides. Pull a Schedule C set of codes and you've committed to the 1040 business mapping. Decide later it's actually a single-member LLC the client wants taxed as an S corp, and the mapping is the wrong listing — you start over.

None of these throw an error. They produce a Schedule C that imports successfully and reconciles to nothing.

The faster path: connect QuickBooks Online directly

AccountantSync removes this detour. It's the universal trial balance bridge to UltraTax CS — QuickBooks Online, Xero, and spreadsheet uploads are all supported — and it's built around the part of the job that actually takes judgment: the mapping.

The workflow:

  1. Connect QuickBooks Online through a secure authorization.
  2. Pull the trial balance for the client and year, and set the entity type to sole proprietor (Schedule C) and the accounting method.
  3. Auto-map the accounts to Schedule C tax codes. AccountantSync pre-fills the income and expense mappings it's confident about, excludes the balance-sheet and owner's-equity accounts that don't belong on a Schedule C, and flags the handful that need your call — using the same mapping logic we apply across QBO.
  4. Generate a UltraTax-ready import file with signs, whole-dollar rounding, and grouping handled to spec.

The compounding part: your mappings persist year over year and copy between similar clients. Set up one QuickBooks-based sole proprietor, and the next one — and next season's version of the same one — is close to a one-click sync. Instead of re-keying trial balances every season, you map once and reuse. If you're weighing tools, our comparison of trial-balance automation options covers what to look for.

Frequently asked questions

Can you import a QuickBooks Online trial balance directly into UltraTax CS for a Schedule C?

Not natively. UltraTax CS imports tax data directly only from Thomson Reuters products like Accounting CS and Trial Balance CS. A QuickBooks Online trial balance has to be brought in as outside data — either exported and mapped by hand to Schedule C tax codes, or automatically with a tool like AccountantSync that connects to QuickBooks and generates the import file.

Which QuickBooks accounts do I map for a Schedule C?

Only the income and expense accounts. Schedule C has no balance sheet, so cash, accounts receivable, accounts payable, loans, fixed-asset cost, accumulated depreciation, and owner's equity have no tax-code destination and are excluded. Income maps to gross-receipts codes (801, or 850 for 1099-K amounts) and expenses map to the Part II codes (advertising 808, supplies 822, wages 826, and so on).

Where does owner's draw go on a Schedule C import?

Nowhere on the return. A sole proprietor can't deduct payments to themselves, and Schedule C Line 26 wages are for employees only. Owner's draw and owner's equity accounts get no tax code (or an exclusion code, 88888/99999). Mapping a draw to wages or any deduction overstates expenses and understates the self-employment income.

Does AccountantSync support QuickBooks Online and Schedule C clients?

Yes. QuickBooks Online is fully supported and generally available, alongside Xero and direct spreadsheet/CSV uploads. You set the entity type to sole proprietor, and AccountantSync maps the income and expense accounts to Schedule C tax codes while excluding the balance-sheet accounts that don't belong. Start free with your first two clients, no credit card required.