How to Import a Xero Trial Balance into UltraTax CS for a Partnership (Form 1065) Return
If your partnership clients keep their books in Xero and you file their returns in Thomson Reuters UltraTax CS, you already know the connection that should exist doesn't. There's no native Xero import. UltraTax CS reads trial balance data automatically only from Thomson Reuters' own ledgers — Accounting CS, Trial Balance CS, Workpapers CS. Everything else, Xero included, arrives the same way: a spreadsheet you map by hand.
We've covered the general Xero-to-UltraTax export-and-reshape workflow and why the gap exists at all elsewhere. This guide is narrower and goes deeper: the part that actually decides whether a Form 1065 partnership return imports clean or comes back wrong — assigning the right UltraTax tax code to every account on a partnership trial balance.
A 1065 is harder to map than a corporate return for one reason. A partnership pushes far more activity out of ordinary income and onto Schedule K, where it splits to the partners on their K-1s. Get the page-1 deductions right and you can still file a wrong return if the separately-stated items, guaranteed payments, and partner equity land in the wrong place.
The tax code is the whole job
UltraTax doesn't care what an account is named in Xero. It cares about the tax code you attach to it. Each code points the account's balance at a specific line of the return — page 1 of the 1065, Schedule A / Form 1125-A, Schedule K, Schedule L, or the M-1/M-2 reconciliations. UltraTax then summarizes by code, applies whole-dollar rounding, and transfers each total to the right input screen.
The codes below are the real UltraTax CS partnership codes from Thomson Reuters' Tax Code Listing for Chart of Accounts setup. Use them as the target when you build the tax-code column on your reshaped Xero export.
Ordinary business income — Form 1065, page 1
These are the accounts that net to ordinary business income (loss) on Line 22:
- 100 — Gross receipts or sales → 1065, Line 1a
- 101 — Returns and allowances → 1065, Line 1b
- 200 — Salaries and wages → 1065, Line 9 (W-2 employees only — not partners)
- 201 — Guaranteed payments → 1065, Line 10
- 202 — Repairs and maintenance → 1065, Line 11
- 203 — Bad debts → 1065, Line 12
- 204 — Rent → 1065, Line 13
- 205 — Taxes and licenses → 1065, Line 14
- 206 — Interest expense → 1065, Line 15
- 210 — Employee benefit programs → 1065, Line 19
- 211 — Other deductions → 1065, Line 21
Cost of goods sold — Form 1125-A
If the partnership carries inventory, COGS goes to Form 1125-A, not page 1:
- 275 — Purchases → 1125-A, Line 2
- 276 — Cost of labor → 1125-A, Line 3
- 277 — Additional Section 263A costs → 1125-A, Line 4
- 278 — Other costs → 1125-A, Line 5
- 279 — Ending inventory → 1125-A, Line 7
Separately-stated items — Schedule K
This is where partnership mapping diverges hardest from a Xero profit-and-loss. Xero lumps these into "Other income" or "Other expenses." On a 1065 they must break out to Schedule K so they flow to the K-1s at the correct character:
- 110 — Interest income → Sch K, Line 5
- 111 — Ordinary dividends → Sch K, Line 6a
- 112 — Other portfolio income → Sch K, Line 11
- 155 — Tax-exempt interest → Sch K, Line 18a
- 225 — Cash contributions (60%) → Sch K, Line 13a
- 224 — Contributions (100%) → Sch K, Line 13b
- 232 — Investment interest expense → Sch K, Line 13b
- 228 — Section 179 expense → Sch K (see the exclusion note below)
Balance sheet — Schedule L
- 400 — Cash → Sch L, Line 1
- 401 — Accounts receivable → Sch L, Line 2a
- 403 — Inventories → Sch L, Line 3
- 425 — Buildings and other depreciable assets → Sch L, Line 9a
- 426 — Accumulated depreciation → Sch L, Line 9b
- 429 — Land → Sch L, Line 11
- 440 — Accounts payable → Sch L, Line 15
- 465 — Partners' capital accounts → Sch L, Line 21
The four traps specific to a 1065
A corporate trial balance you can mostly map line-for-line. A partnership has four places where a reasonable-looking Xero account maps to the wrong code and produces a return that's wrong in a way the preparer often catches only at review.
1. Guaranteed payments are not salaries — and not draws
In Xero, payments to partners are frequently sitting in an account called "Owner compensation," "Members' wages," or worse, bundled into "Wages." Two different mistakes follow. Mapping them to 200 (salaries, Line 9) overstates the partnership's employee wages and understates Line 10. Treating them as partner draws drops a real deduction off the return entirely. Guaranteed payments are code 201, Line 10 — a deduction in computing ordinary income, and separately reported to each partner. Salaries (code 200) is reserved for W-2 employees who aren't partners.
2. Partner draws and distributions are equity, never expense
A partner's draw is not a deduction. In Xero it lives in equity, and that's exactly where it belongs on the return — the Schedule M-2 analysis of partners' capital (distributions: cash is code 487, distributions: property is 488), not the income statement. If a draw account slips into your deduction codes, ordinary income is understated and the M-2 won't tie. Map draws to the M-2 distribution codes, or exclude them from the income import and enter the capital activity directly.
3. Partners' capital and book equity get excluded from the income import
Thomson Reuters' own import guidance puts partners' capital (1065) in the excluded category — the same bucket as book depreciation, book gains on asset sales, and Section 179. UltraTax wants the capital roll-forward driven by the M-1/M-2 codes and the asset module, not pulled in as another mapped balance. Two codes do the excluding: 88888 keeps the account visible on the Tax Code Groupings Report; 99999 suppresses it entirely. Use them deliberately on equity, book depreciation, and any book-only figure so it doesn't double-count.
4. Depreciation and Section 179 come from the asset module, not the book
The depreciation expense on a Xero P&L is a book number. The deductible tax depreciation comes out of UltraTax's asset module. Map book depreciation to 207 (book depreciation, Schedule M-1) so the M-1 reconciles, and let the asset module produce the deduction. Section 179 (code 228) is handled the same way — entered on the assets, excluded from the trial balance import. Importing a book depreciation figure as if it were the tax deduction is the most common reason a first-pass 1065 import is off.
The mechanical gotchas that apply to every import
On top of the partnership-specific decisions, UltraTax enforces a handful of format rules that quietly break an otherwise clean file:
- Account numbers are capped at 12 characters. Longer Xero account codes get truncated or rejected.
- Balances are limited to 12 places. A consolidated client with very large numbers can overflow.
- Two accounts mapped to the same tax code group can collide — duplicate accounts under one grouping fail the import rather than summing silently.
- Entity types must match. The source has to be set up as a partnership and the UltraTax client has to be a 1065. A trial balance built for an 1120-S won't map cleanly onto a partnership, because the separately-stated items and capital structure differ.
That last point is the reason you can't reuse an S-corp mapping on a partnership: the same "Other income" account belongs to a different Schedule K line, and the equity section is built differently.
Doing this without the spreadsheet
The mapping logic above doesn't change from year to year, and it barely changes from one partnership client to the next. That's exactly the kind of work that shouldn't be rebuilt by hand every January.
AccountantSync pulls a partnership's trial balance straight from Xero, lets you assign each account its UltraTax tax code once, and generates an import file built to UltraTax's exact spec — 12-character account numbers, signed amounts, exclusion codes handled. The mappings persist year over year and copy across similar clients, so a partnership you set up this season imports in about a minute next season. It's free for your first two clients, no credit card.
The 1065 is where careful mapping pays off the most, because the cost of a wrong separately-stated item isn't just a re-import — it's a wrong K-1 in a partner's hands. Get the tax codes right once, and let the file build itself after that.
Sources: Thomson Reuters, Tax Code Listing for Chart of Accounts Setup (2024), Tax Codes – 1065, Partnerships; Thomson Reuters, Import account balances into UltraTax CS; IRS, Instructions for Form 1065. Tax codes reflect the 2024 listing and should be confirmed against the current year's UltraTax Tax Code Listing before filing.