AppFolio Bank Reconciliation Not Balancing? How to Find the Difference

Last updated July 2026.

When an AppFolio bank reconciliation will not balance, the ending balance you typed from the statement, the cleared balance AppFolio calculates, and the adjusted cash balance do not all agree, and the software will not let you finalize until they do. That difference is always one of a few things: a bank fee or interest entry you never posted, a transposed digit in a keyed amount, a deposit recorded twice or recorded but never banked, or a stale uncleared check. The fastest way to find which is to put the bank statement and the AppFolio ledger side by side as two sortable lists and let a formula find the item on one side and not the other.

That last part is where most of the lost time goes. Half of the comparison is inside AppFolio and can be exported. The other half is the bank statement, which usually arrives as a PDF you cannot sort or filter. Below is the order to work in, and a table of what each kind of difference is telling you.

How does an AppFolio reconciliation work?

You open the reconciliation from Accounting, pick the bank account and the statement period, and enter the ending balance from the bank statement. Then you tick off each deposit and payment that appears on the statement so it is marked cleared, review anything left uncleared, and finalize once the three balances agree. AppFolio calls that agreement the triple tie out. The software does the arithmetic. The work is the matching, and the matching is a comparison between the ledger and the statement.

First, check the obvious three

Before hunting line by line, rule out the three differences that account for most failed reconciliations:

• A bank fee or interest entry. Service charges, returned item fees, and interest on a reserve account appear on the statement but are easy to forget in AppFolio. If your difference is a small odd amount, this is almost always it.
• The ending balance you typed. Confirm you entered the statement's ending balance for the right date, not the beginning balance and not an available balance that excludes uncleared items.
• A prior month that was edited. If someone changed a transaction in a period you already reconciled, that month silently stops tying out and drags the current one with it. Re-tie the earlier month first.

What does the size of the difference tell you?

The number itself is a clue. A few patterns come up again and again.

The rule of nine is worth remembering. If the difference divides evenly by nine, you almost certainly transposed two digits somewhere, which narrows a long search to comparing amounts rather than hunting for a missing line.

The side by side method

When the quick checks do not find it, compare the two lists directly. Export the AppFolio transaction list for the period, get the bank statement into the same columned form, and match them by date and amount. Anything on one side with no partner on the other is a reconciling item. This is far faster than reading a PDF against a screen, and it catches the duplicates and omissions that the eye slides past.

Sort both lists by amount rather than date. Duplicates line up next to each other, and a deposit that exists in AppFolio but never hit the bank sits alone. The reason this is worth the setup is that the bank statement is normally a PDF, so getting it into columns is the one manual step. An AppFolio bank statement converter turns the statement into dated rows with amounts and a running balance, which is exactly the second list the comparison needs. The running balance also lets you check the math down the page, so you can see the precise point where the statement and the ledger diverge.

Why trust accounts make this stricter

Property management runs client money, so close enough is not the standard. Most states require that funds held for owners and tenants reconcile exactly every month and that no individual property goes negative. That means reconciling each trust account on its own rather than in aggregate, and being able to prove the position for a single owner if a board or a regulator asks. A reconciliation that is off by a few cents is not a rounding nuisance in that context, it is a compliance gap, which is why finding the difference matters more here than in ordinary bookkeeping.

What about a takeover portfolio?

If the account never balanced because you inherited it mid stream, the fix is different. Onboarding a portfolio from another manager usually means a folder of PDFs, a spreadsheet of balances, and no ledger to inherit. Convert every statement for the period you are picking up, build the opening position from the running balance, and reconcile forward month by month until you reach the current period. It is slow the first time and then it is done, and a converted set of statements is also what an incoming owner or an auditor will want to see.

Does AppFolio import a bank statement file?

AppFolio pulls transactions through bank connections with partner institutions rather than by taking a statement file you upload, and it has partnered with banks including Alliance Association Bank, Pacific Premier Bank, First Citizens Bank, and SmartStreet powered by Banc of California. If your account is at a bank outside that group, or you are reconciling periods before the connection existed, the statement PDF is the source you work from. Converting it does not push anything into AppFolio. It gives you the second list in a form you can actually compare against the first, which is the whole job when a reconciliation will not tie out.