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

If your sole-proprietor clients keep their books in Xero and you prepare their Form 1040 in Thomson Reuters UltraTax CS, the trial balance does not move between the two on its own. UltraTax CS imports tax data directly only from Thomson Reuters' own products — Accounting CS, Trial Balance CS, Workpapers CS. Xero isn't on that list, so the proprietor's profit-and-loss has to come in as outside data that you map by hand.

A Schedule C makes that mapping its own particular kind of careful. There is no separate business return to file and no balance sheet to reconcile against — the proprietorship's numbers land on the individual 1040 — so several of the safety nets you'd lean on for a 1120-S or 1065 simply aren't there. This guide walks the real workflow for a Xero-to-Schedule-C import, the tax codes that route balances to the right lines, the two accounts that quietly wreck a sole-prop import, and the version that takes about a minute.

Why there's no native Xero-to-UltraTax import

This isn't a setting you can switch on. UltraTax CS is built to pull tax data from the rest of the Thomson Reuters CS Professional Suite. When the source ledger lives in Accounting CS or Trial Balance CS, balances flow in by tax code automatically. Xero is a different company's product with no such hook, so UltraTax treats a Xero trial balance the way it treats any outside data: a spreadsheet you import and map by hand.

It's the same structural gap that sits between QuickBooks Online and UltraTax CS — two ecosystems that were never designed to talk to each other. The general manual path, and the gotchas that apply to every Xero import, are covered in the Xero-to-UltraTax overview. This page is about what changes when the return is a Schedule C.

The Schedule C is part of the 1040 — not its own entity

The first thing to get right is conceptual, and it trips up firms that mostly do entity returns. In UltraTax CS there is no "Schedule C entity." The client is a 1040, and the proprietorship's trial balance imports into Screen C (the Business folder) inside that individual return. When you confirm the entity type for the import, you're setting up a 1040, and the entity type has to match between your source data and the UltraTax client — exactly as it does for any other return.

Two consequences follow:

One taxpayer, multiple businesses, multiple units. If a client runs two Schedule C activities, each business gets its own unit number in UltraTax. The unit is one of the columns UltraTax reads on import (alongside account number, description, tax code, and amount), and it's what keeps a landscaping P&L from bleeding into a consulting P&L on the same 1040.
No Schedule L, no balance-sheet reconciliation. A Schedule C has no balance sheet. Nothing forces assets to equal liabilities plus equity, and there is no Schedule M-1 to catch a book-to-tax difference. The arithmetic check that would expose a misclassified account on an 1120-S isn't there, so the mapping has to be right going in.

The two accounts that wreck a sole-prop import

On an S corporation you worry about getting officer compensation onto the right line. On a Schedule C the danger runs the opposite direction: the owner is not an employee, and the two accounts that represent the owner are the ones most likely to be mismapped.

Owner's pay / owner's salary. A sole proprietor cannot pay themselves a deductible wage. A Xero account named "Owner's Pay," "Salary — Owner," or "Member Draw" must not map to wages (Schedule C line 26 — that line is for employees only). It belongs to none of the expense lines. Map it to wages and you've manufactured a deduction the IRS doesn't allow and understated the proprietor's taxable profit.
Owner's drawings / capital. Draws and contributions are equity movements, not income or expense. They have to be excluded from the import entirely — either left untagged or assigned an exclusion tax code (UltraTax uses dedicated exclusion codes such as 88888 / 99999 to keep an account out of the transfer). Because there's no balance sheet on a Schedule C, a draws account accidentally mapped to an expense line doesn't bounce — it just inflates expenses, and nothing in the return contradicts it.

These two are the whole reason a Schedule C import deserves its own checklist. Everything else is line assignment.

Assigning tax codes: the Schedule C mapping

UltraTax doesn't care what an account is called in Xero — it cares which line of the form the balance belongs on. You assign each account a tax code from the Tax Code Listing for a 1040 / Schedule C, and UltraTax summarizes the balances, applies whole-dollar rounding, and transfers each amount to Screen C by tax code.

The destinations follow the current Schedule C itself. A representative mapping for the accounts you'll see in most sole-prop Xero files:

| Typical Xero account | Schedule C destination | | --- | --- | | Sales / Services revenue | Part I — Gross receipts (line 1) | | Inventory purchases, direct materials, direct labor | Part III — Cost of goods sold (lines 36–42, flows to line 4) | | Advertising & marketing | Line 8 — Advertising | | Vehicle / mileage expense | Line 9 — Car and truck expenses | | Contractor / 1099 labor | Line 11 — Contract labor | | Depreciation, Section 179 assets | Line 13 — Depreciation and §179 | | Business insurance (liability, property) | Line 15 — Insurance (other than health) | | Bank/loan interest | Line 16b — Interest (other) | | Accounting, legal, professional fees | Line 17 — Legal and professional services | | Software, postage, general office | Line 18 — Office expense | | Rent — premises / equipment | Line 20a/20b — Rent or lease | | Repairs & maintenance | Line 21 — Repairs and maintenance | | Supplies | Line 22 — Supplies | | Business taxes, licenses, permits | Line 23 — Taxes and licenses | | Travel | Line 24a — Travel | | Meals | Line 24b — Meals (UltraTax applies the 50% limit) | | Utilities, phone, internet | Line 25 — Utilities | | Employee wages | Line 26 — Wages (employees only) | | Bank fees, dues, other | Line 27a — Other expenses (Part V) |

Three line assignments are easy to get wrong because the natural account name points at the wrong place:

Self-employed health insurance is not a Schedule C expense. The owner's own health premiums are an above-the-line adjustment on Schedule 1 of the 1040, capped at the business's net profit — not line 15 (Insurance) and not line 14 (Employee benefit programs). UltraTax handles the self-employed health insurance deduction on the 1040 side, so a Xero "Health Insurance — Owner" account routed to a Schedule C line is a double-counting error waiting to happen.
The owner's retirement is not line 19. Line 19 (Pension and profit-sharing) is for employee plans. The proprietor's own SEP or SIMPLE contribution is a Schedule 1 adjustment, not a Schedule C deduction.
Meals and entertainment are not the same account. Map meals to line 24b and let UltraTax apply the 50% limitation; entertainment is non-deductible and should be excluded, not folded into meals.

The general import mechanics still apply

The constraints that govern every UltraTax trial-balance import don't relax for a Schedule C:

Account numbers are capped at 12 characters. Longer identifiers get truncated, and if two accounts truncate to the same value under the same tax grouping, the duplicate won't import — a balance silently goes missing.
Untagged accounts disappear. An account with no tax code isn't an error; it's simply excluded. On a Schedule C, with no balance sheet to fail, a forgotten account just quietly lowers the wrong number.
Accounts under one tax code are summed. Map five Xero expense accounts to line 27a and they collapse into one "Other expenses" total. Usually fine — but a mismapped account can hide inside a correct-looking subtotal.
The basis has to match the return. Xero will export cash or accrual. If the trial-balance basis doesn't match how the Schedule C is filed, the profit reconciles to nothing.

None of these throw a loud error. They produce a return that imports successfully and is subtly wrong — and on a Schedule C, that wrong net profit flows straight through to self-employment tax on Schedule SE and to the qualified business income deduction, so a single misclassified account moves more than one number.

The faster path: connect Xero directly

AccountantSync removes this entire detour. It's the universal trial balance bridge to UltraTax CS, and Xero is fully supported alongside QuickBooks Online and spreadsheet/CSV uploads.

The workflow:

Connect Xero through a secure OAuth connection — the same kind of authorization you'd use for any trusted Xero app.
Pull the trial balance for the client and period, and set the return type and accounting method (cash or accrual).
Auto-map the accounts to the right Schedule C destinations. AccountantSync pre-fills the mappings it's confident about, flags the handful that need your judgment, and keeps owner's pay and draws out of the deductions — drawing on the same mapping logic we use for QBO.
Generate a UltraTax-ready import file. Signs, whole-dollar rounding, the 12-character account limit, description truncation, and grouping sums are handled to UltraTax's spec, so the file imports without hand-formatting.

The part that compounds: your mappings persist year over year and copy between similar clients. The first sole-prop you set up takes a few minutes of review. Every engagement after that — and every similar client — is close to a one-click sync. Instead of re-keying trial balances every season, you map once and reuse.

Preparing entity returns from Xero too? The same approach applies to an S corporation (1120-S) and a partnership (Form 1065) — each with its own entity-specific mapping. If you're still deciding how to handle this across the practice, our comparison of trial-balance automation options lays out what to look for.

Frequently asked questions

Can you import a Xero 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 sole proprietor's Xero trial balance has to be exported and brought in as outside data — either mapped by hand through a spreadsheet import into Screen C of the 1040, or automatically with a tool like AccountantSync that connects to Xero and generates the import file for you.

Where does a Schedule C live in UltraTax CS?

A Schedule C isn't a separate entity in UltraTax CS — it's part of the individual 1040. The proprietorship's trial balance imports into Screen C in the Business folder. If a taxpayer has more than one sole-proprietor business, each one is a separate unit so the activities don't combine.

How do I handle owner's pay and owner's draws on a Schedule C import?

Neither is deductible. A sole proprietor can't pay themselves a wage, so an "Owner's Pay" account must not map to line 26 (wages are for employees only). Owner's draws and capital are equity, not income or expense, and must be excluded from the import entirely. Because a Schedule C has no balance sheet, a draws account mismapped to an expense line won't be caught by any reconciliation — it just overstates deductions.

What about the owner's health insurance and retirement contributions?

Those don't go on the Schedule C. The self-employed health insurance deduction and the proprietor's own SEP or SIMPLE contribution are above-the-line adjustments on Schedule 1 of the 1040. Line 14 (employee benefit programs) and line 19 (pension and profit-sharing) on Schedule C are for employee plans only.

Does AccountantSync support Xero for sole proprietors?

Yes — Xero is fully supported and generally available, alongside QuickBooks Online and direct spreadsheet/CSV uploads. You connect Xero once, pull the trial balance, map it to the Schedule C lines (with owner's pay and draws kept out of the deductions), and export a UltraTax-ready file. Start free with your first two clients, no credit card required.