How to do bookkeeping for a small property management company?
By the Propfina team · Last updated
Keep two books: a trust ledger for owner and tenant money, and a company file for management fees and operating costs. Record rent deposits, security deposits, fees and owner draws as they happen, then close the month with a three-way trust rec and owner statements.
This is the monthly cycle for a small property-management office of about 50 to 300 doors on AppFolio, Rentvine or Buildium, often with a few short-term listings.
Two books, not one
Trust accounting holds other people’s money. Company bookkeeping tracks what the firm earned. One bank account and one QuickBooks file for both is how a rec stays open.
| Book | What you record | Whose money |
|---|---|---|
| Trust / property books | Rent deposits, security deposits, owner funds, owner draws, vendor bills paid from trust | Owners and tenants |
| Company books | Management fees, leasing fees, payroll, software, office rent | The firm |
AppFolio, Rentvine and Buildium win the trust books. They keep owner and tenant ledgers in the same system as the bank rec. On their own books, that rec works. QuickBooks Online wins the company file most CPAs already open.
A NARPM conference presentation (Mumford, hosted on narpm.org) writes the trust job as bank statement = check register = client ledgers, with no negative ledgers.
Chart of accounts that can close
You need two charts. The property-management software holds the property general ledger. QuickBooks holds the firm’s.
Buildium (August 3, 2026) numbers parent categories in blocks of a thousand: assets 1000–1999, liabilities 2000–2999, equity 3000–3999, revenue 4000–4999, expenses 5000–5999. Keep security-deposit cash as an asset and deposits held as a liability. Rent collected is owner funds, not sales.
| Account | Trust / property books | Company books |
|---|---|---|
| Operating checking | No | Yes |
| Trust checking | Yes | Only a matching bank account if the CPA wants it in QuickBooks |
| Security-deposit cash | Own bank account if the state requires it | No |
| Security deposits held | Liability | No |
| Owner funds held | Liability | No |
| Management fee | Transfer out of trust | Income |
| Rent collected | Owner funds, not sales | Never income for the firm |
Booking the deposit batch as sales is the usual way QuickBooks looks profitable while the trust rec is short.
Record the money during the month
Do this as cash moves, not on the 5th.
| Transaction | Where the cash goes | What the ledger does |
|---|---|---|
| Rent deposit | Trust bank | Raises that owner’s balance. The batch has to equal the bank lump |
| NSF / reversed ACH | Trust bank, reversed | Reverses the owner ledger. Late fees follow your policy, not a plug |
| Security deposit | Trust or a separate deposit account | Liability. Not income |
| Airbnb or Vrbo payout | Trust or operating, per the management agreement | Split rent, cleaning, host fee and tax. How to reconcile Airbnb payouts in QuickBooks Online is that split |
| Vendor bill for a door | Trust bank, from that owner’s funds | Lowers that owner’s ledger. Attach the invoice |
| Management fee | Trust to operating | The firm’s income. Take it before the owner draw |
| Owner draw | Trust bank to the owner | Only from that owner’s available balance |
Same-day posting keeps tenant ledgers current. Cash sitting in undeposited or unapplied is the usual hole in the three-way rec.
IRS Topic 414 (read 2026-10-08) says not to include a security deposit in income if you may have to return it. If you keep part at move-out, that amount is income in that year. A deposit used as last month’s rent is advance rent, counted in income when received. State holding rules still apply. This is not tax advice. Check your CPA.
Do not send an owner draw while that owner’s ledger is negative. Cash in the trust account can still belong to other owners and tenants. Buildium’s January 2026 checklist says a negative owner ledger before a draw means you are using other owners’ funds.
Close the month in this order
Pick the bank-statement date first. Run every report to that date. The usual miss is a statement through the 30th and an owner-ledger export on the 2nd.
- Tie every rent batch and every short-term payout to the bank.
- Post leftover bills and the management-fee transfer if they are still sitting in trust.
- Run the three-way rec: adjusted bank, trust ledger, sum of owner and tenant ledgers. How to do a three-way trust account reconciliation is that packet. How to reconcile a property management trust account in QuickBooks Online is the click path if the CPA’s trust bank lives there.
- Refuse owner draws until the difference is $0.00 and no owner ledger is negative.
- Build owner statements from those same ledgers.
- In QuickBooks, Match the management-fee deposit to operating. Rec the operating account. Do not Categorize a trust rent batch as income.
AppFolio (June 16, 2026) calls the trust job a Triple Tie Out of owners, banks, and the general ledger, and says to rec it monthly, 100 percent of the time. Rentvine (read 2026-10-08) describes a 3-way tie of bank statement, trust ledger, and property ledgers.
Owner statements go out after the rec, not instead of it. On r/PptyMgmtSoftware in February 2026, an office of about 45 doors wrote that custom owner reports took a full weekend, 12-plus hours. The canned statement from the PM software matches the ledgers. Extra Excel tabs are a second set of numbers.
For 2026 vendor payments, the IRS 1099-NEC threshold (read 2026-10-08) is $2,000, up from $600 for payments made before 2026. Track W-9s during the year. Filing is still on you or your CPA.
When the lists still disagree
Work bank-to-ledger first, then ledger-to-owners.
| Symptom | Likely cause | What to do |
|---|---|---|
| Trust bank higher than the ledgers | Unapplied receipt, or a fee never allocated | Find cash sitting in undeposited or unapplied |
| Ledgers higher than the bank | Owner credit without cash, or a cutoff mismatch | Re-export ledgers to the statement date |
| QuickBooks income is far higher than the management fee | Rent posted as sales | Reverse it. Rent is a liability until it is the owner’s |
| One owner is negative, cash is still in trust | Bills paid before rent posted, or rent applied to the wrong door | Hold that owner’s draw; fix the allocation |
| Bank rec closes, owner statements still wrong | Two-way rec only | Sum the owner and tenant ledgers |
On r/PropertyManagement in September 2025, one office heading into a real-estate-commission audit wrote that the trust account had never reconciled to the bank, and several properties showed negative balances they could not verify. Totals that look close are not a rec.
What the software already does
AppFolio, Rentvine and Buildium win owner ledgers, the three-way rec and owner statements. QuickBooks Online wins the two-way rec and the corporate file.
| Job | AppFolio, Rentvine or Buildium | QuickBooks Online | Spreadsheet |
|---|---|---|---|
| Owner and tenant ledgers | Yes, that is the product | No floor on a class | Only if you built them |
| Three-way trust rec | Yes, in the PM software | No. Bank vs register only | By hand |
| Owner statements from the same numbers | Yes | No. Export and rebuild | If you rebuild them |
| Blocks a negative owner draw | Visible on the owner balance report | No | Only if you look |
| Company P&L the CPA already opens | Extra, or a summary journal | Yes, that is the product | Fragile |
Someone still has to pick the cutoff, refuse a negative draw, and keep rent off the company’s income line.
Rules vary by state. Colorado expects monthly three-way recs for property-management trust accounts (audit process, read 2026-10-08). California Commissioner’s Regulation 2831.2 requires a monthly reconciliation of beneficiary records to the control record in months with activity. Texas requires a monthly accounting of trust money when the account had activity. This is not legal advice. Check your own state’s commission and your CPA.
How to tell this month is closed
Adjusted bank, trust ledger, and the sum of owner and tenant ledgers agree to the cent. No owner ledger is negative. Management fees left trust and landed in operating. Rent did not land in company income. Owner statements were built from those ledgers.
Open last month’s trust-account bank statement, the deposit and payout reports, and the owner and tenant ledger exports. Run the rec on those files first. They are already on your desk.
Frequently asked questions
Should a small property management company book rent as company income?
No. Rent in a trust account is money you hold for an owner. It raises the owner ledger and the trust bank. The firm's income is the management fee after you move it to operating. Booking the deposit as sales makes QuickBooks look profitable and leaves the trust rec short.
Do I still need QuickBooks if AppFolio or Rentvine already keeps the books?
For the doors, no. AppFolio, Rentvine and Buildium already hold owner ledgers, the trust rec and owner statements. QuickBooks Online is the company file most CPAs already open: payroll, operating expenses and tax. Keep property detail in the PM software. Post the management-fee transfer into QuickBooks, not every rent receipt.
Is a two-way bank rec enough to close a property-management month?
No. A two-way rec matches the trust bank to the trust ledger. The third number is the sum of every owner ledger and every tenant security-deposit ledger on that same date. If owner statements can still be wrong after the bank rec closes, you skipped the third leg.
Are tenant security deposits rental income?
No, if you plan to return them. The IRS says not to include a security deposit in income when you receive it if you plan to return it at the end of the lease. Keep it as a liability. If you keep part at move-out, that kept amount is income in that year. Check your state's holding rules and your CPA.
When can I send an owner draw?
After rent for that owner is posted, their bills are paid, the management fee is taken, that owner's ledger is not negative, and last month's three-way rec is closed. A negative owner ledger with cash still in the trust account means that owner's bills were paid with someone else's rent. Hold the draw.