Why property management books work differently
Most bookkeeping systems assume one business, one bank account, one owner. Property management breaks that assumption immediately. You're tracking rent for dozens of units, security deposits that legally aren't yours, and owner disbursements that have to hit the right account on the right schedule. Get the structure wrong and you're not just sloppy — in most states you're violating trust accounting rules that license your brokerage.
The core discipline is separation. Tenant funds and owner funds sit in a trust (or escrow) account. Your management fees and operating expenses sit in a separate operating account. The two never mix, and every dollar in the trust account has to be traceable to a specific property and a specific owner at any point in time.
That's the part that trips up new property managers coming from general bookkeeping. A trust account balance isn't "cash on hand" — it's a pool of money you're holding for other people, and your books need a sub-ledger showing exactly how much belongs to each property.
Tracking rent and expenses by property
Every transaction needs a property tag, not just a category. Rent from Unit 4B at the Elm Street fourplex is a different line than rent from a single-family home on Oak, even though both hit the same trust account on the same day.
The practical way to build this: export the trust account statement and code every deposit to its property before you touch categories. Then layer expenses the same way — a plumbing invoice paid out of the trust account gets tagged to the property that generated it, not lumped into a general "repairs" bucket.
This is where a lot of firms lose time. Bank feeds import transactions but don't know which property a given Zelle payment or ACH deposit belongs to — you're still matching tenant names to units by hand. If you're working from PDF statements instead of a feed (common when a bank changes formats or a client hands you six months of statements at once), converting them to a spreadsheet first makes the property-tagging pass much faster than transcribing line by line. Converting a PDF trust account statement to Excel gives you sortable rows you can tag and pivot by property in minutes instead of hours.
Set up the chart of accounts to match how owners think
Owners want to see their property's performance, not your firm's. Structure classes or locations by property (or by owner, if one owner has multiple doors) so you can pull a clean statement for each one without re-sorting transactions every month.
Security deposits are a liability, not income
This is the single most common error in property management books, and it's the one that gets flagged fastest in a trust account audit. A security deposit is not revenue. It's a liability sitting on your balance sheet until the tenant moves out and you either return it or apply it against damages or unpaid rent.
Booking a deposit as income overstates the property's earnings for that month and understates your trust liability — which means your trust account reconciliation will never actually tie out, because your books think there's less obligated cash than the bank statement shows.
Keep a running deposit ledger by unit: date received, amount, interest accrued if your state requires it, and disposition when the tenant leaves. That ledger's ending balance should equal the deposit portion of your trust account balance at any given moment. If it doesn't, you have a reconciliation problem before you have a books problem.
Owner draws and monthly disbursements
Most management agreements call for a monthly owner statement and disbursement: gross rent collected, minus your management fee, minus any repairs or vendor payments made on the owner's behalf, equals the net paid out. That math has to match two things simultaneously — the owner statement you send, and the actual transfer out of the trust account into the owner's personal or business account.
Build the disbursement calculation directly off the reconciled trust account activity for that property, not off an estimate. If a repair invoice cleared the bank on the 28th but you cut the owner statement on the 25th, the owner's report is wrong and you'll be issuing a correction next month. Wait for the statement to close, reconcile it, then run disbursements.
Reconciling trust and operating accounts
Reconcile both accounts every month, not just at year-end, and reconcile them separately. The trust account reconciliation has an extra step beyond a normal bank rec: the ending bank balance has to match the sum of every property's individual liability balance in your sub-ledger. That three-way tie-out — bank statement, book balance, sub-ledger total — is what a trust account audit actually checks.
The operating account is simpler: management fees in, payroll and overhead out, standard business reconciliation. Don't let vendor payments or tenant refunds leak between the two accounts without a documented transfer; that's the fastest way to break both reconciliations at once.
If your trust account reconciliation doesn't tie to the sum of your per-property ledgers within a few dollars, stop and find the break before you close the month. It compounds.
When you're catching up several months of trust activity at once — common after taking over a portfolio from another manager — converting the PDF statements into a working spreadsheet first lets you rebuild the property-by-property ledger against actual cleared transactions instead of guessing from owner reports.