Trust Accounting in QuickBooks: What It Can and Cannot Do

California lets a broker keep up to $200 of their own money in a trust account to cover bank charges. That small amount says a lot about trust accounting, meaning, when you’re holding someone else’s money, every dollar has to be accounted for. If you manage 20+ properties, this is a common audit finding, the more owner ledgers you're running, the easier it is for one of them to drift out of sync with the bank.

Quickbooks was built to keep your books in order, but trust accounting asks “whose money is it?” That’s where many property managers run into complications. Your CPA may already work in QuickBooks, but your owners need statements, and your state examiner expects the owner ledgers to tie to the bank every month. 

Whether you run a property management group, a brokerage with a management arm, or a growing rental portfolio that just took on its first third-party owner, you want to keep the accounting system you know and still meet additional trust requirements.

This article shares what QuickBooks handles well, what it leaves to you, and how managers pair it with a property management platform like Hemlane so the pairing does the whole job.

What trust accounting actually requires

Trust accounting means being responsible for the money that you hold for someone else in a separate bank account, tracking what belongs to each owner, proving every month that the bank, your books, and the sum of the owner ledgers all agree. The rules vary by state, but the pattern is consistent, and they are stricter than ordinary bookkeeping.

Texas is a useful example because the rule is short. Under 22 Tex. Admin. Code § 535.146, trust money includes rent, security deposits, and "any money held on behalf of another person." A broker has to deposit it by the close of the second working day, cannot commingle it with personal or business money, must give each beneficiary an accounting at least monthly when there is activity, and must keep the records for four years [1].

California goes further on the mechanics. The Department of Real Estate's trust fund guide requires two reconciliations every month: the bank account record against the bank statement, and the bank account record against the separate record kept for each beneficiary. Both have to be documented. The same guide allows up to $200 of broker funds in the account to cover bank charges, and lets earned management fees sit in trust for no more than 25 days before they are swept out [2].

Oregon spells out the three components of the monthly tie-out (adjusted bank balance, the receipts and disbursements record, and the sum of all positive owner ledgers) and requires the principal broker to review and approve each one [3].

Keep in mind that your state will have its own version. The three examples above are not a substitute for reading it. They shape the general idea for the job: separate account, per-owner ledger, monthly three-way proof, and a paper trail. General property management accounting covers income and expenses; trust accounting adds a fiduciary layer on top.

What QuickBooks can do for trust accounting

QuickBooks can hold the trust bank account, carry a liability for the funds you owe owners, split that liability by owner, reconcile the bank statement, and hand your CPA books they already know how to read. That is most of the job, and it is why so many managers keep QuickBooks at the center of their accounting.

• A dedicated trust bank account. Add the trust account as its own bank account in QuickBooks and keep it completely separate from your operating account. Each account can then be reconciled against its own bank statement, helping you maintain the separation trust accounting requires.
• A trust liability structure. Rent that comes in is not your income, so it lands in a liability account in your chart of accounts, such as "Funds held for owners." Disbursements and vendor payments made on an owner's behalf reduce that liability, and nothing touches your profit and loss except your management fee.
• Class tracking by owner. On QuickBooks Online Plus, you can tag every trust transaction with a class and run a balance sheet by class, which gives you a per-owner balance. Plus includes 40 combined classes and locations; Advanced removes the cap, and Simple Start and Essentials do not include classes [5].
• Bank feeds and rules. When each deposit and withdrawal arrives with a consistent memo, bank rules can post it to the right liability sub-account and class automatically, which is what makes month-end quick.
• CPA familiarity. In Hemlane's 2024 landlord and manager survey, 54.3% of respondents said they use QuickBooks for their property management accounting. Your accountant has probably never asked you to switch, and there is no reason to.

The bank-feed point is where a property management platform earns its keep. Hemlane's QuickBooks connection sends every deposit with a unique descriptor naming the property and the transaction type, so a bank rule can map it by property and general ledger account without anyone retyping it. The mechanics are in the write-up of Hemlane's QuickBooks integration.

What QuickBooks leaves to you, and what Hemlane picks up

QuickBooks can tell you what entered or left an account, but it isn’t a property management system. It doesn’t manage tenant ledgers, prevent an individual owner’s balance from going negative, complete the owner-ledger portion of a three-way reconciliation, or automatically turn those records into owner-ready statements. That doesn’t mean QuickBooks is doing anything wrong. It simply means some of the information you need has to be tracked somewhere else.

Intuit's own guidance draws the same line. Its property management setup article is written for QuickBooks Desktop and suggests two company files, one for the rental properties and one for the management company, with owners set up as vendors and properties tracked through the Customer: Job list [4]. Intuit staff in the QuickBooks Online community point managers toward classes or tags. Both approaches work; both assume something upstream is tracking tenants and owners.

The tenant rows are especially useful. QuickBooks records what already happened, so late fees, partial payments, and security deposits arrive from whatever system collected the money. Hemlane's online rent collection is that system, with no ACH fees, deposits in two to three business days, and automated late fees. QuickBooks is then asked to do only what it does best.

How property managers set up QuickBooks for trust funds

The common setup is a separate trust bank account from operating funds, record owner money as a liability, and the owner-ledger check to your monthly reconciliation. It's workable, and plenty of managers run it; the work scales with owner count, not unit count.

1. Open the trust account at the bank first, in the name your state requires, and add it to QuickBooks with no other activity in it.
2. Create the liability account in your chart of accounts for owner funds, with a sub-account or class per owner. If you hold security deposits, give those their own liability account; California and Texas both treat deposits as trust money.
3. Route every trust transaction through the liability, never through income or expense. Rent in raises the owner's balance, a plumber paid for that owner lowers it, and your fee moves to management income and out to the operating account.
4. Reconcile three ways every month. Reconcile the trust bank account to the statement, then confirm the sum of owner balances in your trust ledger (the class balance sheet) equals the reconciled bank balance, and flag any negative balance before it reaches your CPA. Keep the report; Oregon and California both require a record of each reconciliation [2][3].
5. Plan for the class count. On Plus, 40 combined classes and locations means roughly 40 owners before you move to Advanced or keep owner detail upstream in a property management platform [5].

Confirm each step with your state's commission rules and your CPA before you rely on it; these are the same records a state audit asks to see. This is how managers commonly build it, not a compliance opinion. On the operating side, Hemlane's accounting features sync your bank and card accounts through Plaid and record transactions automatically, so your management company's books stay current while the trust books run in parallel.

Which setup fits your portfolio

The right combination depends on whose money you hold and who you answer to. Owners managing their own units rarely need trust accounting, but managers of third-party doors need it from the first owner. Here is how the pairing usually lands.

The difference becomes more noticeable as the number of owners grows. A 60-unit portfolio spread across 25 owners doesn’t just mean accounting for 60 units. It also means maintaining and reconciling 25 individual owner balances.

That’s where keeping the property-level detail upstream can save time. Hemlane tracks the activity connected to the property, while QuickBooks receives cleaner, labeled transactions for the books. Hemlane’s guide to property management accounting software goes deeper into how those options compare.

Where Hemlane fits alongside QuickBooks

Hemlane runs the property side of the business and QuickBooks stays the general ledger your CPA already trusts. Neither one has to give up ground for the other to work.

In practice, the difference looks like rent, late fees, repair invoices, and leasing all happen on Hemlane. Each payment lands in your bank feed as its own labeled transaction, "Owner Distribution, 123 Main St, October Rent," instead of a lump sum you'd have to untangle by hand. Your CPA gets clean, pre-sorted activity instead of a spreadsheet full of guesswork. And because Hemlane charges no per-user fees, your bookkeeper gets their own login instead of working off yours, which matters more than it sounds like it should the first time two people are trying to close the books on the same account at once.

For a management group between 10 and 200 units, the 2026 platform fee is $28 per month plus a per-unit rate, from $2 on Basic to $58 on Complete, with the Essential tier adding 24/7 repair coordination and state-specific leases. Current tiers and add-ons are on the Hemlane pricing page.

Ready to see how it runs on your portfolio? Sign up for Hemlane or book a demo to walk through the platform with a specialist.

Frequently Asked Questions

Is QuickBooks compliant for property management trust accounting?

QuickBooks does not position itself as a trust accounting system, but it can hold a separate trust bank account, carry a liability for owner funds, and reconcile the bank statement, which covers a large part of trust accounting compliance. The per-owner ledger, the three-way reconciliation record, and owner statements are added around it, usually by a property management platform. Confirm your setup against your state real estate commission's rules.

Should you connect the trust bank account to QuickBooks Online?

Many managers do, because the bank feed is the easiest way to record every trust deposit and disbursement with a consistent memo. The one habit to keep is treating the feed as one leg of reconciliation, not the whole thing. The feed proves the bank matches QuickBooks; the owner-ledger schedule proves the owners' balances match the bank. Reconcile both monthly.

Do you need QuickBooks Online Advanced for property management?

You need Advanced when the number of owners or properties you track by class exceeds 40, because Plus includes 40 combined classes and locations, and Simple Start and Essentials do not include classes. Below that threshold, Plus works well. Many managers stay on Plus by keeping owner and tenant details in a property management platform such as Hemlane and using QuickBooks as the general ledger.

What is three-way reconciliation in property management?

Three-way reconciliation compares three balances as of the same date: the trust bank statement adjusted for outstanding items, the trust account record in your books, and the sum of every owner's ledger. All three must match. Oregon requires it monthly with principal broker sign-off, and California requires both legs of it under Regulation 2831.2. QuickBooks handles the first comparison; a platform or a schedule supplies the owner-ledger leg.

Does Hemlane replace QuickBooks?

No. Hemlane handles rent collection, tenant ledgers, late fees, repairs, and leasing, and sends each transaction to your bank with a descriptor that QuickBooks rules can map by property and general ledger account. QuickBooks stays your general ledger and your CPA's working file. Managers who prefer a single system can also run property-level books inside Hemlane's accounting features.

What does a QuickBooks chart of accounts look like for trust accounting?

A trust accounting chart of accounts separates the trust bank account (an asset) from a liability account such as "Funds held for owners," with security deposits in their own liability account apart from general owner funds. Everything that isn't your management fee routes through the liability side, not income or expense, so your profit and loss shows only what you actually earned.

What is a trust ledger, and how is it different from an owner ledger?

The trust ledger is the master record of every transaction moving through the trust account as a whole; an owner ledger is the slice of that record belonging to one owner. Three-way reconciliation checks that the bank statement, the trust ledger, and the sum of every owner ledger agree. In QuickBooks, the balance sheet by class is how most managers produce the trust ledger view.

What counts as commingling in a property management trust account?

Commingling is mixing money you hold for someone else with your own operating funds: paying a company bill from the trust account, depositing rent into the operating account, or leaving your management fee in trust past your state's allowed window. Most state rules treat it as a serious violation regardless of intent, which is why the trust account should carry no activity except owner and tenant money.

References

1. Cornell Law School, Legal Information Institute. 22 Tex. Admin. Code § 535.146, Maintaining Trust Money. https://www.law.cornell.edu/regulations/texas/22-Tex-Admin-Code-SS-535-146
2. California Department of Real Estate. Trust Funds: A Guide for Real Estate Brokers and Salespersons, RE 13 (Rev. 1/2014). https://dre.ca.gov/files/pdf/re13.pdf
3. Oregon Real Estate Agency. Maintain Clients' Trust Accounts. https://www.oregon.gov/rea/brokerage/cta/pages/maintain-cta.aspx
4. Intuit. Record transactions for a property management company in QuickBooks Desktop. https://quickbooks.intuit.com/learn-support/en-us/help-article/service-items/record-transactions-property-management-company/L3ibLu83B_US_en_US
5. Intuit. Learn about usage limits in QuickBooks Online. https://quickbooks.intuit.com/learn-support/en-us/help-article/intuit-subscriptions/learn-usage-limits-quickbooks-online/L6THMltE4_US_en_US