If you manage rental properties, chances are you run at least part of your business in AppFolio. It’s a powerful platform for rent collection, owner statements, and property operations. But here’s what trips up a lot of property managers: AppFolio bookkeeping is not the same as accounting for your business — and the gap between the two is where clean books go to die.
This guide covers how AppFolio fits into your books, the reconciliation standard most property managers have never been shown, and the two errors that make a management company’s financials unusable to a lender.
What AppFolio does well — and where it stops
AppFolio is excellent at the property management side: collecting rent and tracking tenant ledgers, paying owners and generating owner statements, tracking work orders and property-level income and expenses, and handling trust accounting for owner funds.
What it’s not designed to be is your company’s full general ledger. Your management company has its own income (management fees, leasing fees), its own expenses (payroll, software, marketing), and its own tax picture — separate from the properties you manage. Many property managers try to run everything through AppFolio, or through QuickBooks, or through both without reconciling them. That’s the root of the mess.
The dividing line that works: AppFolio is the system of record for anything that happens at a property or in trust. QuickBooks is the system of record for your management company as a business. Money crossing between them is a transfer, not income — and the crossings are where the errors live.
The two errors that make your financials unusable
Before the reconciliation mechanics, the two mistakes we see most often, because they distort the picture rather than merely making it untidy.
1. Gross rent is not your revenue. A management company with 400 doors collecting $600,000 a month is not a $7.2M business. That money belongs to owners; it passes through trust and out again. Your revenue is the management fee, the leasing fee, the maintenance markup, the late-fee share — whatever your agreement actually entitles you to. Book the gross and your P&L shows enormous revenue against enormous expenses and a margin that means nothing.
This matters most at the moment you need the numbers to be right. Apply for a line of credit, sell the book of business, or bring in a partner, and the first thing anyone competent does is strip out the trust flow. If you have not done it yourself, they will do it for you, conservatively, and the valuation follows their arithmetic rather than yours.
2. Security deposits are liabilities, not income. A deposit is the tenant’s money that you are holding, and it stays a liability on the balance sheet until it is returned or applied. Booking deposits as income overstates profit in the year you receive them and creates a tax bill on money you may have to hand back. It also breaks the third leg of the reconciliation below, because the cash is in the bank and nothing on your books says who it belongs to.
The reconciliation standard: three-way, monthly
This is the part most guides to AppFolio bookkeeping skip entirely, and it is the part your state’s real estate commission cares about.
A normal bank reconciliation has two sides: the bank statement and your books. Trust accounting has three. Every month, these must agree exactly:
One — the adjusted bank balance. The trust account statement, adjusted for deposits in transit and outstanding checks.
Two — the trust ledger balance. What your books say is sitting in trust in total.
Three — the sum of every individual owner and tenant ledger. Add up what each owner is owed and each deposit you are holding. That total has to equal the other two.
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, or a deposit was applied to the wrong lease. Two-way reconciliation cannot see any of that. The totals are fine. The composition is wrong.
What to do when it does not tie: find the difference, do not plug it. A trust account that balances because someone posted an adjusting entry is not balanced, it is disguised — and the entry is exactly what an auditor looks for. Chase the composition: compare the owner ledger detail to the trust ledger detail and find the transaction sitting under the wrong name.
Requirements vary by state, and in most states this reconciliation is expected monthly with a worksheet signed and retained. Reconciliation deficiencies are among the most commonly cited findings in state audits. Check your own commission’s rules rather than ours — but if nobody has ever handed you a three-way worksheet, that is worth knowing before an auditor tells you.
How to actually reconcile AppFolio to QuickBooks
The practical method, which is not obvious and which we learned the slow way.
Reconcile from AppFolio’s General Ledger report, not by searching amounts. The instinct is to take a figure from the bank and search AppFolio for it. This fails often enough to waste whole days: amounts repeat across properties, a single bank deposit is a batch of many receipts, and a management fee sweep is one line covering dozens of properties. Pull the General Ledger for the period, sort by date, and walk it against the statement. You are matching a sequence of events, not hunting for numbers.
Expect batching, and reconcile to the batch. One line on the bank statement is routinely twenty receipts in AppFolio. Do not try to make individual receipts match individual bank lines — match AppFolio’s deposit batch to the bank’s deposit total, then verify the batch’s contents once.
Track inter-entity movement with Due-To / Due-From accounts. When money moves between your management company and the properties, record it as a Due-To/Due-From, not as income or expense. Every one of those accounts should be readable: if you cannot say what the balance in Due From Properties consists of, it has become a dumping ground.
Get the management fee across properly. The fee is trust money leaving trust and becoming your revenue. That is a real transaction in both systems: out of trust in AppFolio, in as management fee income in QuickBooks. Skipped, the fee silently accumulates in trust and your actual revenue is understated all year.
If you manage property for other owners rather than only your own, the trust accounting and owner-statement side is its own discipline — we cover it on property management bookkeeping.
Why this matters at tax time (and every month)
When your AppFolio and QuickBooks records agree, your management company’s real profit is visible rather than tangled up in property cash flow. Owner statements are accurate and defensible, which matters the first time an owner questions one. Your CPA gets clean numbers instead of a reconciliation project billed at their rate. And you can decide whether to hire, raise fees, or take on doors using real data.
When they don’t agree, every one of those breaks down at once — and usually at the worst moment, because the moment you need the numbers is the moment someone else is reading them.
If it has already drifted and you want to know what putting it right looks like before you speak to anyone, what a property management cleanup actually involves sets out the sequence and how it should be quoted.
Running on a different platform? The same accounting discipline applies, and we cover the platform-specific parts in Buildium bookkeeping: what it handles, what it does not.
When to bring in help
If you are searching for AppFolio bookkeeping services rather than a how-to, the distinction that matters is the one above: you want the accounting underneath the platform handled, not the platform reconfigured.
DIY AppFolio bookkeeping works until the door count grows, the entities multiply, or a reconciliation gets away from you. Three specific signals: you are spending nights matching AppFolio to your bank, you cannot say what your management company earned last month without doing arithmetic first, or your trust account has a difference nobody has explained and everyone has stopped mentioning.
That last one does not improve with time. It compounds, because every month of new activity sits on top of the unexplained difference and makes finding it harder.
Do you need a bookkeeper, or an AppFolio consultant?
Worth separating, because people search for both and they are not the same job. An AppFolio consultant, or an AppFolio consulting engagement, is usually about the platform itself: implementation, configuration, getting workflows set up the way your company actually runs. That is systems work.
What we do is the accounting underneath it, reconciling what AppFolio reports against the bank and against QuickBooks and fixing it when those three disagree. If your platform is configured fine but the numbers coming out of it will not tie, that is a bookkeeping problem wearing a software costume. The same applies if you run Buildium or DoorLoop instead: the platform changes, the reconciliation discipline does not.
And if what you need is an AppFolio accounting cleanup, months or years where the platform and the books drifted apart, that is catch-up work with a trust-accounting layer on top. Say so on the call and we will scope it that way rather than as a monthly engagement.
Not sure whether any of this applies to your file? There is a self-check version of it: seven signs your AppFolio books will not reconcile, each one runnable in a minute or two without an accountant.
Common questions
Do I need QuickBooks if I have AppFolio? If you manage only your own properties, often no. If you manage for other owners, effectively yes — AppFolio runs the properties and the trust, and your management company still needs its own books, its own P&L and its own tax return.
What is three-way reconciliation? Matching three figures monthly rather than two: the adjusted trust bank balance, your trust ledger total, and the sum of all individual owner and tenant ledgers. All three must agree. The third is what proves the money is allocated to the right people and not merely present.
Can I just import AppFolio into QuickBooks? You can push summary entries across, and for many managers that is the right setup. What you should not do is import property-level detail into your company books — you end up with two copies of the same detail, disagreeing, and no clear answer about which one is right.
Are security deposits income? No. They are a liability until returned or applied against what a tenant owes. If deposits are sitting in your income accounts, that is worth fixing before your next return rather than after.
We speak AppFolio
At Profit Partners, reconciling AppFolio to clean, tax-ready books is core to what we do for property managers. Multi-property, multi-entity, trust accounting, three-way reconciliation, Due-To/Due-From — we handle the complexity generic bookkeepers stumble on, remotely and nationwide. We also take on the version where it has already gone wrong and needs unwinding without breaking the owner statements you have already issued.
Get a free bookkeeping review — we’ll look at how your AppFolio and books line up today and show you exactly where you stand.
Related reading: Track Multiple Properties in QuickBooks Online · Bookkeeping for Atlanta Real Estate Investors · Bookkeeping for Real Estate Investors · Catch-Up Bookkeeping · Free guide: 7 Real Estate Bookkeeping Mistakes
Weighing AppFolio against the alternatives? Here is our three-way comparison from the books side: AppFolio vs Buildium vs DoorLoop – what each means for your books.
Curious what actually separates one AppFolio bookkeeping firm from another? See why real estate investors choose Profit Partners specifically.
Tracking properties by class in QuickBooks? Check your headroom with our free class limit calculator.
Managing properties in the Atlanta metro? See our property management accounting services in Atlanta.
Trust account will not tie? See AppFolio trust account reconciliation.
Investing in the Atlanta metro with 5 to 50 doors? See AppFolio bookkeeping for real estate investors in Atlanta.
Want a checklist? See what should match between AppFolio and QuickBooks every month.
Recent Comments