Reconcile the Security Deposit Ledger Before Reporting a Balance

A source-first routine for checking rental security deposit receipts, adjustments, and unresolved ledger differences.

By PortfolioRental Editorial Team · · Updated 2026-09-08

Reconcile the Security Deposit Ledger Before Reporting a Balance

A security deposit balance can look settled while the receipt, bank record, lease schedule, and property ledger still disagree. A compact reconciliation keeps an administrative mismatch from becoming an unsupported statement to an owner or resident.

Quick Overview

Start with the lease identifier and approved deposit schedule. Match each recorded receipt to its source transaction, preserve payment references, and separate cleared funds from pending or reversed items. Log every difference with an owner and review time. Do not change a resident balance merely to make totals agree.

This is an evidence routine, not legal or accounting advice. Deposit handling, permitted deductions, notices, timing, and account requirements vary. Authorized staff and qualified advisers retain those decisions.

Use a three-way match

Compare the lease schedule, payment processor or bank evidence, and property ledger. Record amount, effective date, transaction reference, status, and the system treated as authoritative. The move-in funds reconciliation helps separate deposit funds from other receipts. The final utility bill tracker keeps later charges in their own decision path.

If a payment is visible in one source only, label it unresolved. Preserve the original entry and add a correction trail after review rather than silently editing history.

Common Mistakes

Avoid treating a processor authorization as cleared cash, combining rent and deposits without allocation evidence, copying bank details into a broad task, or assuming a ledger adjustment is an approved deduction.

Common Questions Answered

When dates differ, retain both the submitted and settled timestamps. When a reversal appears, route it to the authorized accounting owner. When the lease schedule conflicts with the ledger, do not interpret the agreement in the coordination record.

Ready to use this routine

Sample recent deposits and test whether every displayed balance can be traced through all three sources. Assign recurring differences to the system owner instead of repeatedly patching individual rows.

Review HUD tenant rights resources for general federal context and obtain jurisdiction-specific guidance.

Published September 8, 2026.