How should an undeposited funds balance be reconciled?
An undeposited funds balance can be an ordinary timing item or a sign that receipts and bank deposits have come apart — which matters in property management because one receipt can touch a tenant ledger, a property’s income and a bank account. Confirm what the clearing account actually represents in the system in use before adjusting it, since the naming and workflow differ between platforms.
An undeposited funds balance can be a normal timing item, but it can also signal that receipts and bank deposits have become disconnected. In property management, that gap matters because a receipt may affect a tenant ledger, a property’s cash records, an owner statement and a bank reconciliation. Each view needs to tell a consistent story.
Software uses different names and workflows for receipt clearing accounts. Confirm what the account represents in your system before adjusting it. This guide covers a reconciliation approach, not a universal journal-entry rule or jurisdiction-specific trust-account requirement.
1. Confirm what the account represents in your system
Start with the account definition and the receipt workflow. Determine whether the balance includes receipts entered before deposit, payments awaiting settlement, grouped payment batches, card or ACH receipts, or another clearing process. Do not assume that an account called “undeposited funds” works identically across platforms.
- Confirm the general ledger account and balance at the cutoff date.
- Identify which receipt types flow through it.
- Determine whether receipts are recorded individually or in batches.
- Confirm how deposits, reversals and returned payments are posted.
2. Build a dated list of outstanding receipts
Export the detailed transactions making up the balance. Include the receipt date, amount, payer or tenant reference where appropriate, property, payment method, deposit batch and current status. The detail should add up to the general ledger balance, with any excluded or filtered transactions explained.
Sort the items by age and amount. Recent items may be legitimate deposits in transit; older items deserve closer attention. A balance without transaction-level support is not a sufficient reconciliation.
3. Match receipts to deposit batches and bank activity
Trace each receipt to the deposit batch and then to the bank statement or bank transaction feed. The total and composition of a batch should agree to the recorded deposit, allowing for documented processing fees or timing differences where applicable. Check that the deposit was posted to the correct bank account and accounting period.
- Match each receipt to a deposit record or identify why it remains outstanding.
- Compare the deposit total with the bank credit.
- Review settlement dates, weekends, holidays and processing delays.
- Identify deposits split across accounts or combined from several receipt batches.
- Record the bank date and clearing status for each item.
Use the property management bank reconciliation guide for the bank-side process. The undeposited funds schedule should tie into, not replace, that reconciliation.
4. Tie receipt detail to tenant and property records
For rent and other tenant receipts, confirm that the payment was applied to the correct tenant, lease, property and charge according to the receipt and allocation rules. A receipt can be deposited successfully yet still be posted to the wrong tenant or property. Conversely, a tenant ledger may show a payment while the corresponding deposit has not cleared.
Compare the relevant receipt listing with the tenant ledger and the appropriate control account. Investigate duplicate receipts, unapplied cash, reversed payments and receipts applied to the wrong period. The tenant ledger reconciliation guide provides additional checks for charges, receipts, credits and open balances.
5. Investigate common causes of old balances
- Receipt not included in a deposit: locate the original receipt and determine whether it was deposited, reversed or left pending.
- Deposit posted directly to bank: check whether the bank deposit bypassed the clearing workflow, leaving the original receipt open.
- Duplicate receipt: compare receipt IDs, payer, amount, date and source transaction.
- Returned or reversed payment: confirm that both the tenant record and cash/clearing entries reflect the reversal consistently.
- Wrong bank account or property: trace the transaction to the correct ledger and document the approved correction.
- Bank-feed matching error: confirm whether a transaction was matched to an existing deposit or entered again as a new transaction.
- Unidentified historical item: document the search performed, evidence available and escalation decision; do not manufacture a clearing explanation.
6. Separate legitimate timing items from unresolved exceptions
At month-end, some receipts may be in transit. For each item, document why it remains open, its expected clearing date and the later bank evidence when available. Use an aging threshold to flag older items for review, but do not treat the threshold as permission to write off a balance automatically.
If the item is unresolved, record the amount, property or payer reference, owner of the next action and the evidence needed to close it. Explain material items in the close file and follow the organization’s escalation policy.
7. Correct the cause, then confirm the account clears
Once the underlying cause is established, prepare the correction using the software’s supported workflow and the organization’s accounting policy. Check the effect on cash, tenant balances, property records and any owner or client-fund control accounts. Obtain review where required and retain a link between the original item, correction and supporting evidence.
After posting, rerun the detail and confirm that the remaining balance consists only of supported open items. Do not post a generic journal entry solely to force the account to zero.
8. Add the schedule to month-end close
Include the clearing account in the recurring close checklist, with a preparer, reviewer, cutoff date, aging view and exception log. Review changes from the prior month and confirm that old items are progressing toward resolution. The property management month-end close checklist can help place this work alongside bank, tenant, payable and owner-ledger reconciliations.
Where receipts affect money held on behalf of owners or tenants, follow the account-specific controls and applicable requirements. The trust-accounting reconciliation guide covers the additional bank-to-ledger and supporting-detail checks that may be needed.
Undeposited funds reconciliation checklist
- Account purpose and system workflow confirmed.
- Detailed outstanding receipt listing ties to the general ledger balance.
- Receipts matched to deposit batches and bank credits where available.
- Tenant, property and receipt allocations checked.
- Duplicate, reversed, returned and misapplied transactions investigated.
- Legitimate timing items documented with expected clearing dates.
- Corrections supported, reviewed and linked to the original records.
- Remaining balance aged, reviewed and included in month-end close.
The goal is not to make every clearing account zero by force. It is to explain every open item, trace receipts to deposits and bank activity, and ensure that the tenant and property records reflect the same underlying transaction.