When a tenant pays rent late or in parts, record each payment against the month it covers, keep a running arrears figure and log every reminder you send. The arrears for a tenant are the total rent due so far minus the total received so far, which stays correct even when payments do not line up with months.
Which month does a part-payment belong to?
The usual habit is to apply a payment to the oldest unpaid month first, unless you and the tenant agreed otherwise in writing. Whatever you choose, write it down and use it consistently. A message such as "this is for February" from the tenant is worth saving.
What does a worked example look like?
Hypothetical rent of ₹15,000 a month, January to March:
| Month | Due in ₹ | Received towards the month in ₹ | Month balance in ₹ |
|---|---|---|---|
| Jan | 15,000 | 15,000 (5 Jan) | 0 |
| Feb | 15,000 | 9,000 (12 Feb) + 6,000 (20 Mar) = 15,000 | 0 |
| Mar | 15,000 | 9,000 (20 Mar) | 6,000 |
On 20 March the tenant sent ₹15,000. ₹6,000 cleared February and the remaining ₹9,000 went to March. Total due by end of March is 3 × 15,000 = ₹45,000. Total received is 15,000 + 9,000 + 15,000 = ₹39,000. Arrears are 45,000 − 39,000 = ₹6,000, which matches March balance.
How do I calculate arrears in a sheet?
- Running arrears per tenant, with rent due in column C, received in D and tenant label in B: =SUMIFS($C$2:$C$500, $B$2:$B$500, "Flat 2A") - SUMIFS($D$2:$D$500, $B$2:$B$500, "Flat 2A")
- Number of months with a positive balance: =COUNTIFS($G$2:$G$500, ">0")
Both formulas work in Excel and Google Sheets. If you receive rent in two instalments, add a row for each credit, so the date of each is visible.
How do I log reminders?
Add a small second table: Date, Tenant, How sent (message, call, email), What was said and Reply. Keep the tone polite and factual, and send reminders in writing wherever possible so that you have a record. Save the messages themselves, not just a note about them.
- Send a first reminder soon after the due date, stating the month and the balance.
- Note the tenant's reply and any new date they promise.
- If they promise a date, put a follow-up reminder in your calendar.
- Save a screenshot of every message exchange about money.
What about late fees or notices?
Whether you may charge a late fee, and how a notice should be served, depends on your rental agreement and local law. I am not able to tell you what is allowed in your case. If arrears keep building, speak to a lawyer or someone who knows rental law in your state before sending a formal notice.
Where does the bank statement help?
Every rent credit is on your bank statement. When you use SpendixAI, you pick the account, upload the statement and review the rows before saving, then tick each credit off in your ledger. The ledger decides which month a payment belongs to, and the statement supplies the date and amount.
How do I keep the conversation calm?
Money talk with a tenant goes better with numbers on paper. Send a short message that says the month, the amount due, the amount received so far and the balance, and ask when you can expect the rest. Avoid blame in the wording. If the tenant has a real difficulty, you may agree a dated plan, but put the plan in writing and update the ledger whenever a promised date passes.
What to do this month
- Add a Balance column if you do not have one
- Apply each payment to a month and write the rule down
- Start a reminder log
- Review arrears at month end
Useful ideas start with a clearer picture of your own spending.
Explore your reports


