How to Import a QuickBooks Online Trial Balance into UltraTax CS for a Partnership (Form 1065)
If you keep a partnership's books in QuickBooks Online and file its return in UltraTax CS, the hard part isn't the export — it's that a 1065 routes trial balance accounts to a different set of tax codes than an 1120-S or an 1120, and it has no concept of the two things QBO does carry: partner draws and owner pay. There's no "officer compensation" on a partnership return, and a partner's pay isn't a wage. It's a guaranteed payment, on its own line, with its own tax code.
This is the partnership companion to our QuickBooks-Online-to-UltraTax overview. It assumes you already know the general mechanic — export the trial balance, reshape it, assign a tax code to every account — and focuses on what changes when the entity is a partnership, because that is where a clean-looking QBO import quietly produces a wrong K-1.
Why the entity decides the tax code
UltraTax CS imports trial balances natively only from Thomson Reuters' own products. A QuickBooks Online trial balance comes in as outside data: a spreadsheet whose columns you map to UltraTax's fields — account number, description, unit, tax code, and amount. UltraTax then summarizes the balances, rounds to whole dollars, and transfers each amount to the input screen named by its tax code.
The tax code is the whole job, and it's entity-specific. QBO organizes the chart of accounts by type — income, expense, asset, liability, equity. UltraTax organizes input by tax form and schedule. The same QBO "Interest Income" account is a separately stated Schedule K item on a 1065, not a page-1 income line — and a partner's "Guaranteed Payment" account is a deductible page-1 line, not equity. Thomson Reuters publishes a Tax Code Listing organized by entity; the 1065 section is the one that governs this import.
The 1065 tax codes your QBO accounts map to
These are the UltraTax tax codes most QBO partnership trial balances touch, with the form and line each one drives. Codes and destinations are from the Thomson Reuters Tax Code Listing for tax year 2024.
Income (Form 1065, page 1)
100— Gross receipts or sales → 1065, L1a101— Returns and allowances → 1065, L1b103— Other income → 1065, L7
Separately stated items (Schedule K)
These flow to Schedule K and out to each partner's K-1 — they are not page-1 ordinary income.
110— Interest income → Sch K, L5111— Ordinary dividends → Sch K, L6a112— Other portfolio income → Sch K, L11155— Tax-exempt interest → Sch K, L18a
Cost of goods sold (Form 1125-A)
275— Purchases → 1125-A, L2276— Cost of labor → 1125-A, L3279— Ending inventory → 1125-A, L7
Deductions (Form 1065, page 1)
200— Salaries and wages (non-partner W-2 staff) → 1065, L9201— Guaranteed payments → 1065, L10202— Repairs and maintenance → 1065, L11203— Bad debts → 1065, L12204— Rent → 1065, L13205— Taxes and licenses → 1065, L14206— Interest expense → 1065, L15208— Depletion → 1065, L17209— Retirement plans, paid → 1065, L18210— Employee benefit programs → 1065, L19211— Other deductions → 1065, L21
Guaranteed-payment specials
267— Guaranteed payments, health insurance → 1065, L10268— Guaranteed payments, pensions and IRAs → 1065, L10
Balance sheet and partners' capital (Schedule L / M-2)
400— Cash → Sch L, L1401— Accounts receivable → Sch L, L2a403— Inventories → Sch L, L3407— Loans to partners → Sch L, L7a425— Buildings and other depreciable assets → Sch L, L9a426— Accumulated depreciation → Sch L, L9b440— Accounts payable → Sch L, L15444— Loans from partners → Sch L, L19a465— Partners' capital accounts → Sch L, L21485— Capital contributed: cash → Sch M-2, L2a487— Distributions: cash → Sch M-2, L6a488— Distributions: property → Sch M-2, L6b
The partnership traps that distort a return
A 1065 import can succeed and still be wrong. These are the failure modes specific to partnerships — and to QBO charts in particular.
1. Guaranteed payments are code 201, not wages
A partner's pay is never a W-2 wage. In QBO it usually sits in an expense account named "Guaranteed Payments," "Partner Draws," or sometimes just "Owner Pay" — and firms inconsistently treat it. Compensation to partners maps to tax code 201 (Guaranteed payments → line 10); only W-2 wages paid to non-partner employees go to tax code 200 (Salaries and wages → line 9). Health insurance and retirement paid on behalf of partners are their own guaranteed-payment codes (267 and 268). Map a partner's pay to wages and you understate line 10, overstate line 9, and the K-1 guaranteed-payment box comes out empty.
2. Draws are equity, not an expense
This is the most common QBO-to-1065 error. A partner draw is a distribution — an equity reduction on Schedule M-2 (code 487 / 488), not a deduction. QBO frequently has both a "Guaranteed Payments" expense account and an "Owner's Draw" equity account, and they mean completely different things on the return. The draw never touches page 1. Map it to an expense code and the return looks balanced and is materially wrong.
3. Separately stated items have to come out of ordinary income
Interest, dividends, capital gains, Section 179, and charitable contributions are not 1065 page-1 lines — they're Schedule K items (codes in the 110s, and 224–242). A QBO "Interest Income" account mapped to ordinary income inflates the ordinary K-1 box and omits the separately stated one. Two errors from one mismap.
4. Partners' capital is one Schedule L line fed by Schedule M-2
QBO may show several equity accounts — one per partner, plus contributions and draws. On the return they roll into partners' capital accounts (code 465, Schedule L line 21), with the year's activity reconciled on Schedule M-2 (contributions 485, distributions 487/488). Decide how your QBO equity accounts map before import, because Schedule L line 21 has to tie to the sum of the partners' K-1 capital accounts.
The QBO mechanical gotchas
On top of the partnership logic, the QBO export and the UltraTax import enforce some quiet rules:
- QBO sub-accounts blow the 12-character limit. UltraTax caps account numbers at 12 characters. QBO sub-accounts export with the parent prefix and a colon (
Utilities:Electric), which is both long and punctuated. If two accounts truncate to the same 12-character number under the same tax group, the duplicate isn't imported — silently. Flatten or renumber sub-accounts before mapping. - Run a Trial Balance, not a P&L. QBO's Profit & Loss omits the balance sheet, and a 1065 needs Schedule L (and the capital accounts behind it). Export Reports → Trial Balance for the fiscal year so assets, liabilities, and equity come along.
- Classes and locations don't carry tax meaning. QBO classes are a management-reporting dimension, not a tax mapping. Collapse them before export, or you'll be mapping the same account several times.
- Untagged accounts are excluded, not flagged. An account with no tax code simply isn't imported. To deliberately leave one out, assign an exclusion code (88888 / 99999) so the omission is intentional and documented, not a forgotten line.
- Accounts under one code are summed. Five QBO expense accounts mapped to 211 collapse into one "Other deductions" total — usually what you want, but a mismapped account hides inside a correct-looking subtotal.
None of these throws a loud error. They produce a 1065 that imports successfully and is subtly off — the most expensive kind of mistake to catch on review.
The faster path: connect QuickBooks Online directly
AccountantSync removes this detour. It's the universal trial balance bridge to UltraTax CS, and QuickBooks Online is fully supported alongside Xero and direct spreadsheet uploads.
- Connect QuickBooks Online through a secure authorization and pull the client's trial balance for the period.
- Set the entity to partnership. AccountantSync resolves the entity-dependent codes — guaranteed payments vs. wages, draws as Schedule M-2 distributions, separately stated K items, partners' capital — using the same mapping logic described for QBO accounts, pre-filling what it's confident about and flagging the rest for your judgment.
- Generate a UltraTax-ready import file. Signs, whole-dollar rounding, the 12-character and sub-account rules, and grouping sums are handled to spec, so the file imports without hand-formatting.
Your mappings persist year over year and copy between similar clients, so the second partnership you set up — and every one after — is close to a one-click sync instead of re-keying the trial balance every season. The same approach applies if these books lived in Xero instead; see the general Xero-to-UltraTax guide.
Start free with your first two clients — no credit card required.
Frequently asked questions
Which UltraTax tax code is a guaranteed payment on a 1065?
Guaranteed payments map to tax code 201, which lands on Form 1065, line 10 — separate from salaries and wages (code 200, line 9), which is only for W-2 employees who aren't partners. Health insurance and retirement contributions paid on a partner's behalf have their own guaranteed-payment codes, 267 and 268. A partner's pay is never a wage on a partnership return.
How do partner draws map when importing a QBO trial balance into UltraTax CS?
Draws are distributions, not deductions. Map the QBO equity account (often "Owner's Draw" or "Partner Distributions") to the Schedule M-2 distribution codes — 487 for cash, 488 for property — so they reduce partners' capital. They never appear on page 1. Mapping a draw to an expense code is the most common 1065 import error.
Should I export a Trial Balance or a Profit & Loss from QuickBooks Online?
Export the Trial Balance (Reports → Trial Balance) for the fiscal year. A 1065 needs Schedule L and the partners' capital accounts, and the P&L doesn't include the balance sheet or equity. Also delete the report's Total row before importing — UltraTax reads it as an account with no tax code.
Can I reuse my 1120-S tax-code mapping for a partnership?
No. The codes are entity-specific: a partnership has guaranteed payments (201/267/268) and partners' capital (465) with no S-corp equivalent, while an 1120-S has officer compensation and the accumulated adjustments account, which don't exist on a 1065. Set the UltraTax client to partnership and map against the 1065 column of the tax code listing.
Does AccountantSync support partnership returns from QuickBooks Online?
Yes. You connect QuickBooks Online, set the entity to partnership, and AccountantSync maps the trial balance to the correct 1065 tax codes — including guaranteed payments, draws as Schedule M-2 distributions, and partners' capital — then remembers the mapping for next year. QuickBooks Online, Xero, and spreadsheet uploads are all supported.