Rent Tracking Should Show What Is Owed, Not Just What Hit the Bank

A bank deposit can tell you money arrived. It cannot always tell you what the money settled.

Suppose rent is $1,400, due on the first, with a $75 late fee after the fifth. The tenant pays $900 on May 3. You approve a $100 repair credit because they bought a replacement lock with your permission. Then they pay $400 on May 12.

From the bank’s point of view, there were two deposits: $900 and $400. A saved bank rule might classify both as rental income. A spreadsheet import might place them neatly in the May rent column. A pivot summary might show $1,300 received from that tenant.

But the ledger view is more specific. May rent was charged at $1,400. The $900 payment reduced the balance. The $100 approved credit reduced it again. The second $400 payment brought the rent balance to zero. The late fee is a separate question: was it charged, waived, prohibited, unnecessary, or handled some other way under the lease and local rules?

Money movement is not the same as rent status

That is the difference between tracking money movement and tracking rent. A landlord does not only need to know whether cash hit the bank. A landlord needs to know what was owed, what was paid, what was credited, what was waived, what reversed, and what remains open.

Bank data is useful evidence. It confirms that money moved, failed, or reversed. It becomes weak only when it is treated as the rent record itself. A tenant ledger has to answer a different question: after the lease charges, payments, credits, deposits, waivers, reversals, and adjustments, what is actually owed now?

A rent ledger starts with the obligation

Good rent tracking starts before a payment arrives. The lease creates the expected charge. Payments, credits, waivers, and reversals then change that charge. If a tenant pays only part of the rent, the month is not simply paid or unpaid. The balance stays open until the ledger shows how the obligation was satisfied.

This matters most in ordinary conversations. If a tenant asks what they owe, you should not have to answer from memory or from a bank memo. You should be able to explain the charge, each payment, each credit, and the remaining balance.

The practical standard

The standard is not software instead of spreadsheets. The standard is an obligation ledger. Your system should distinguish rent from deposits, utilities, fees, and owner adjustments. It should reconcile to the bank without letting the bank decide what the tenant owed.

A clear ledger supports better decisions, but it does not make those decisions for you. Partial payments, late fees, notices, grace periods, and payment application rules vary by lease and jurisdiction. A rent ledger shows what happened and what remains open; it is not legal advice.