A rent ledger shows one balance. A notice for non-payment of rent needs a narrower number, and the two are rarely the same. The gap between them is where arrears applications fall apart.
Your ledger mixes money that can go on a notice with money that cannot
Most systems post everything a resident owes into one account: rent, an NSF fee, a utility recharge, a key replacement, a late charge. The balance adds them up and shows you a total. Ontario's Landlord and Tenant Board does not read it that way.
The LTB's Interpretation Guideline 11 is blunt about the consequences. NSF charges cannot be claimed in an N4, and including them will likely invalidate the notice. Where a tenant pays utilities directly to the utility company, unpaid utility costs are not rent arrears, and putting them on an N4 will likely invalidate it as well. Claiming an unpaid rent deposit on the notice invalidates it too. Non-refundable key deposits and most administrative charges are not permitted at all, even where the tenancy agreement says otherwise.
So the figure on your screen is a sum of amounts that belong on a notice and amounts that destroy one. Reading it off and typing it into a form is the mistake.
Payment application order is a decision your software makes for you
The second half of the problem is quieter. When a resident pays part of what they owe, something has to decide which charge that money cleared. Your ledger has a rule for it. Most people have never looked at the rule.
The Board has one, and it is fixed. Guideline 11 puts it plainly: the determination of arrears is usually based on the principle that payments are applied to the earliest rent owing. The example it gives is the one to hold on to. If a tenant misses May and then pays in June, the June payment is applied to May, and June is the month left outstanding.
Ledgers often behave differently. Some clear the oldest open line of any type, so a twenty dollar NSF fee takes the first twenty dollars of a rent payment. Some clear the newest charge. Some let whoever is posting choose, which means the rule is whichever person was in the system that day. Each of these produces a rent arrears figure that a hearing would not reproduce, and nothing in the software flags it, because nothing errored.
Make the ledger able to show its work
Four changes, none of which need new software.
- Give non-rent charges their own charge type and their own account. Rent has to be countable on its own.
- Set payment application to oldest rent first, and take that setting out of individual users' hands.
- Build the arrears figure month by month from the rent column, not from the account balance.
- Leave the rent deposit out of the calculation. Under the guideline it applies to the last month of the tenancy, and you should not net it against arrears before you apply.
Then test it. On a dummy resident, post two months of rent, add an NSF fee, then post a partial payment, and read back what the system decided. Ten minutes of that tells you more than the configuration screen does.
The specifics above are Ontario's. The structure is not. Any tribunal or court that hears an arrears claim will ask the same two questions: which of these charges is rent, and which month did that payment clear. Timing is the other half of the file, and we have covered how the notice calendar is changing. This is the arithmetic sitting underneath it.
A balance is a summary. An arrears number is a claim you have to defend month by month, in front of someone who applies payments in a fixed order. Those are different jobs, and one ledger column cannot do both.