Troubleshooting
A transit account with a permanent balance is not a timing difference. It is cash your books cannot locate.
Updated 2026-08-02 · TrustRecon research team
Undeposited funds is a holding account with one job: to represent money you have received but have not yet taken to the bank. A tenant hands over a check on the 28th; you record the receipt immediately so the tenant's ledger is current, but the check does not reach the bank until the 2nd. Between those dates the money exists in your books and not in your bank statement, and undeposited funds is where it sits.
The defining property of a transit account is that it empties. Every dollar that enters must leave within days, when the deposit posts. If your undeposited funds balance at month-end is not either zero or a small figure you can point at a specific deposit slip to explain, the account has stopped being a transit account and become a place where errors accumulate quietly.
This matters for reconciliation because undeposited funds sits on the trust asset side while the corresponding tenant credit sits on the liability side. When cash is stuck in transit permanently, your trust ledger and your bank balance disagree by exactly that amount, every month, forever.
In AppFolio specifically, four patterns produce a stuck undeposited funds balance, and they are worth distinguishing because the fixes differ.
Receipts recorded but never batched into a deposit. A payment is entered against a tenant, which credits their ledger and debits undeposited funds. The deposit is then made at the bank without creating the corresponding deposit record in the software, or the record is created for a different set of receipts. The bank shows the cash; undeposited funds still shows it as in transit. Every subsequent month carries the difference.
Deposit amounts that do not match the receipt batch. Someone builds a deposit from a set of receipts, then the physical deposit differs — a check was held back, a cash amount was miscounted, one payment was voided after the batch was assembled. The deposit record clears against the bank while the leftover receipt sits in undeposited funds indefinitely.
Voided receipts that were already deposited. A receipt is voided after it was included in a deposit that cleared the bank. The void reverses the tenant credit and the undeposited funds entry, but the bank keeps the cash. This produces a negative contribution and is one of the harder patterns to spot, because the balance may look small while being the net of two large opposing errors.
Migration-era balances. An opening undeposited funds balance carried in from a previous system, representing receipts whose deposits happened before the migration and were never matched. This one is common and stubborn: nobody who works there now can identify the underlying transactions, so the balance is treated as background noise.
Before treating a balance as an error, establish whether it is legitimate. A genuine timing difference has three properties: you can name the specific receipts that compose it, those receipts are dated within the last several business days of the period, and the corresponding deposit appears on the bank statement early in the following period.
Run the undeposited funds detail report and check each item against those three tests. Anything older than about a week is not in transit — it is stuck. Anything you cannot tie to a specific expected deposit is stuck. In our audit work, the age distribution is usually the giveaway: a handful of items from the last few days, plus a residue of items months or years old that nobody has looked at.
The aged residue is the real balance. It is also usually the amount by which your reconciliation has been off for as long as anyone remembers.
The instinct is to write the residue off with a journal entry so the account returns to zero and the reconciliation balances. Resist it. Undeposited funds sits inside your trust asset structure, and a write-off there does not remove an obligation — it removes your record of an obligation. The tenant credit on the liability side remains. You have made the reconciliation agree by deleting evidence rather than by finding cash.
The correct sequence is to resolve each aged item to one of three determinations.
The deposit did happen and was never recorded. Find it on the bank statement, create the deposit record matching the original receipts, and let it clear. This is the most common outcome and it costs nothing but search time.
The receipt was recorded in error and no money was ever received. Void the receipt properly, which reverses both the tenant credit and the undeposited funds entry. Do not journal around it — the tenant's ledger needs the reversal too, or you have credited a payment that never arrived.
Money was received but is genuinely missing. This is a shortage. It requires investigation and, depending on your state and the amount, notification. It is rare, but it is exactly the scenario the account structure exists to surface, and it is not resolved by an adjusting entry.
Only after every item has a determination should the account return to zero. If a residue remains that resists all three determinations, that residue is the finding — document it and escalate rather than burying it.
Property managers usually notice this problem indirectly. The reconciliation screen shows an adjusted cash balance that will not match the bank, the difference is constant month over month, and the search starts in the bank register. Undeposited funds is one of the three or four structural causes behind a constant offset — the others being cross-period voids, bank-side transfers with no register entry, and stranded security deposit clearing accounts.
We walk through the diagnostic order for a stuck adjusted cash balance in this guide. If the offset equals your aged undeposited funds balance, you have found it in one step. The structural background — why transit and clearing accounts must return to zero, and where they belong in a trust-safe account structure — is covered in our chart of accounts guide.
Two habits eliminate almost all of this category. First, make the undeposited funds detail report part of month-end close, not an annual cleanup: any item older than a week gets resolved before the period closes, while the people who created it still remember it. Second, treat the deposit record as the thing that must match the bank, not the receipts — build deposits from actual deposit slips rather than assembling receipts and hoping the physical deposit matched.
If you want an independent check on whether transit and clearing accounts are actually returning to zero, our free audit includes that test among its 75 checks, with each finding tied to the specific record IDs. And if you simply want to know whether your three legs currently agree, the free checker answers that in a second, in your browser, with nothing uploaded.
Upload three exports. Within 48 hours you get a discrepancy report with every finding tied to a record ID. Built from the same failure patterns state auditors look for.
For property management companies on Buildium or AppFolio. No call required.