You do not need an accountant to tell you whether your AppFolio books are in trouble. Most of the damage announces itself, if you know which number to look at.
Seven checks below. Each takes a minute or two, each is something you can run yourself today, and each one we have found on real property management files. If more than two come back badly, the problem is structural rather than a bad month.
1. The unassigned column is not zero
Run your profit and loss by property. Look at whatever your books call the unassigned bucket — in QuickBooks it is Not Specified.
It should be zero. Every dollar sitting there belongs to one of your properties and has not been attached to any of them, which means every per-property number on the report is wrong, and wrong in a direction you cannot see. One property looks profitable because its costs are parked in the unassigned column. Another looks fine because the repair that hit it was never tagged.
This is the fastest test there is and it takes about five seconds. A non-zero unassigned column means the per-property reporting you have been making decisions from is decoration.
2. Your owner ledgers do not add up to your trust bank balance
This is the one most managers have never been shown, and it is the one a state auditor asks about.
A normal bank reconciliation has two sides. Trust accounting has three, and all three must agree every month: the adjusted trust bank balance, your trust ledger total, and the sum of every individual owner and tenant ledger.
The third leg is the one that gets skipped, and it is the one that catches real problems. Bank and book can agree perfectly while an individual owner’s balance is wrong — because a disbursement went to the wrong owner, or a repair was charged to the wrong property. Two-way reconciliation cannot see any of that. The totals tie. The composition is wrong.
Add up what each owner is owed. Compare it to the trust account. If those two numbers are not identical, something underneath is misallocated.
3. Security deposits are sitting in an income account
Open your chart of accounts and find where deposits land. If the answer is anything in the income section, that is a real problem and not a filing preference.
A deposit is the tenant’s money that you are holding. It stays a liability until it is returned or applied against what they owe. Booking it as income overstates profit in the year you receive it, creates a tax bill on money you may have to hand back, and breaks check number 2 above — because the cash is in the bank and nothing on your books says whose it is.
4. Your management fee is still sitting in trust
The fee you earn is trust money that leaves trust and becomes your revenue. That is a real transaction in both systems: out of trust on the platform side, in as management fee income on the company side.
When that crossing is skipped — and it is skipped often, because nothing forces it — the fee quietly accumulates in the trust account and your actual revenue is understated all year. You find out when your accountant asks why a company with four hundred doors reports so little income.
Check: does your management fee income for the year look like roughly what your agreements should have produced? If it looks low, this is usually why.
5. You are trying to match individual receipts to individual bank lines
If reconciling takes you whole evenings, look at how you are doing it before assuming you are just busy.
One line on a bank statement is routinely twenty receipts on the platform. A management fee sweep is one line covering dozens of properties. Trying to match receipts one-to-one against bank rows is a fight you cannot win, and the usual outcome is a plug to make it close.
The method that works: reconcile from the platform’s General Ledger report, sorted by date, walked against the statement — matching a sequence of events rather than hunting for amounts. Match the deposit batch to the bank total, then verify the batch contents once. Searching by amount fails often enough to waste days, because amounts repeat across properties.
6. You could not defend an owner statement line by line
Pick one owner, pick last month, and try to explain every line on their statement from source documents.
If that is uncomfortable, the statement is being generated from data nobody has verified. It usually holds — until the first owner who questions one, and that conversation goes differently depending on whether the numbers behind it reconcile.
7. Last month’s report changes when you run it again
This is the quiet one, and it is the most serious.
Run a report for a closed prior period. Note the total. Run it again next week. If the number moved, someone is posting into periods you have already reported on — and every statement, every tax figure and every decision based on that period is now built on something that has since changed underneath it.
Books where history does not stay still are not books. They are a running total. The fix is a closing date with a password on it, and the diagnosis is this one report run twice.
What the results actually mean
None of these failing — your books are in better shape than most. Keep the monthly discipline.
One or two failing — normally a process gap rather than damage. The fee crossing and the deposit coding are the two most common, and both are quick to correct going forward.
Three or more, or check 7 failing at all — this is structural. It will not resolve by being tidier next month, because the problem is in what has already been recorded. That is a cleanup project, and it should be scoped and quoted as one rather than absorbed into a monthly service.
If several of these did come back badly, the next question is what fixing it actually involves. What a property management cleanup actually involves covers how the work is scoped, what really drives the price, and the one thing you should refuse to accept at the end of it.
If you have decided you need outside help, the next question is what kind. We compare the options honestly, including firms that are not us, in AppFolio bookkeeping help: comparing your options.
Common questions
Does this apply to Buildium and DoorLoop too? Yes, all seven. The platform changes, the reconciliation discipline does not. Trust accounting works the same way whichever system holds it.
Is a non-zero unassigned column always a problem? In a property file, effectively yes. Some of it may be genuine company overhead rather than property cost, but that should be coded to the company, not left unassigned. If you cannot say what is in that column, it is a problem.
How far back does a cleanup have to go? Usually to the last point where the books demonstrably reconciled — not to the beginning. Establishing where that point is comes first, before anyone quotes you, because it decides the size of the job.
Can this be fixed without disturbing owner statements I have already issued? Usually, yes, and it should be a stated requirement of the work. Statements already sent to owners are the constraint the cleanup has to work around.
If several of these came back badly
At Profit Partners we keep books for property managers and real estate investors, and untangling platform-versus-books drift is routine work here — including the version that has been building quietly for a couple of years.
Get a free bookkeeping review — we will run these checks against your actual file and tell you honestly which ones fail and what it would take to fix.
This is general information, not tax or legal advice, and trust accounting requirements vary by state. Confirm your obligations with your CPA and your state real estate commission.
Related reading: AppFolio Bookkeeping: keeping property management books clean · Property Management Bookkeeping · Catch-Up Bookkeeping · Track Multiple Properties in QuickBooks Online
Recent Comments