A Landlord Rent Tracking Example You Can Copy

A landlord rent tracking example can be more useful than a stack of receipts or a bank statement full of deposits. When you own one or a few rental properties, the goal is simple: know who has paid, who still owes money, and what the property is costing you each month.

You do not need to build a complicated accounting system to get there. A clear rent log, updated consistently, gives you a reliable picture of your rental income and helps you spot problems before they become harder to sort out.

What a rent tracker should show

A useful rent tracker records more than a tenant’s name and a payment amount. It should show the rent due, the date it was due, the date it was paid, the payment method, and any amount still outstanding. If you charge late fees, security deposits, parking fees, or pet rent, keep those items separate from the regular monthly rent.

That separation matters. For example, a $1,650 payment may look like full rent at first glance. But if it includes $1,500 in monthly rent and $150 for a late fee, you will want your records to show both amounts correctly. Clear records make it easier to answer questions later without relying on memory.

For a landlord with one duplex or a few small units, a simple spreadsheet or bookkeeping system is often enough. The best method is the one you will actually update every time money comes in or goes out.

Landlord rent tracking example for one month

Here is a simple example for a landlord who owns a four-unit building. The monthly rent is due on the first of each month.

| Unit | Tenant | Rent Due | Due Date | Paid Date | Amount Paid | Balance Due | Payment Method | Notes | |—|—|—:|—|—|—:|—:|—|—| | 1A | Jordan Lee | $1,450 | May 1 | May 1 | $1,450 | $0 | ACH transfer | Paid in full | | 1B | Casey Morgan | $1,500 | May 1 | May 4 | $1,500 | $0 | Check | Paid after reminder | | 2A | Taylor Reed | $1,550 | May 1 | May 1 | $1,550 | $0 | Online payment | Paid in full | | 2B | Sam Patel | $1,600 | May 1 | – | $0 | $1,600 | – | Reminder sent May 3 |

At a glance, this landlord can see that $6,100 was due for May, $4,500 has been received, and $1,600 remains unpaid. That is the value of tracking: the answer is already there when you need it.

If Sam pays $800 on May 6, do not replace the original row or simply mark the rent as paid. Update the amount received to $800, change the balance due to $800, and add a note such as “Partial payment received May 6.” When the remaining amount arrives, update the same record again.

Keep rent income separate from other tenant money

Not every payment from a tenant is rent. This is one of the most common areas where landlord records become confusing.

A security deposit should generally be tracked separately from rent because it is money you may need to return, depending on the lease and local rules. A reimbursement for a utility bill is also different from monthly rent. The same goes for a one-time key replacement charge or a pet fee.

You might use a second simple table for deposits and other tenant charges:

| Unit | Tenant | Item | Date Received | Amount | Notes | |—|—|—|—|—:|—| | 1A | Jordan Lee | Security deposit | April 15 | $1,450 | Held separately | | 2A | Taylor Reed | Utility reimbursement | May 10 | $62 | April water bill | | 1B | Casey Morgan | Late fee | May 4 | $75 | Rent paid after grace period |

This approach keeps your monthly rent total clean. It also helps you avoid accidentally treating every tenant payment as regular rental income in your records.

Rules for deposits, late fees, and reporting can vary by state and local area. If you are unsure how an item should be handled for tax or legal purposes, ask a qualified accountant or local professional.

Track the property expenses beside the rent

Rent tracking tells you what came in. Expense tracking tells you what it cost to operate the property. You need both to understand whether a rental is bringing in enough money after repairs, insurance, utilities, and other regular costs.

For the same month, the landlord’s expense log could look like this:

These expenses should not be mixed into the rent tracker itself. Keeping income and expenses in separate sections makes both easier to review. At the end of the month, you can total the rent received and compare it with the expenses paid.

In this example, the landlord received $4,500 in rent during May and paid $754 in listed expenses. That does not mean the monthly profit is exactly $3,746, since there may be other costs such as mortgage payments, property taxes, owner contributions, or unpaid bills. Still, it gives the owner a clear starting point.

A simple monthly routine that prevents catch-up work

Rent tracking works best as a short routine, not a year-end rescue project. On the first few days of the month, review each unit and enter payments as they arrive. If a payment is missing, note it right away and follow your normal lease and communication process.

Once a week, compare your tracker with your bank account. Look for deposits that have not been recorded and payments that may have been entered twice. This is especially helpful if tenants use different payment methods, such as checks, payment apps, or bank transfers.

At month-end, total the rent due, rent received, unpaid balance, and property expenses. Save digital copies of receipts, invoices, and repair records in an organized folder by property and month. A handyman invoice labeled “May 2026 – Unit 1B plumbing” is much easier to find than a photo named “IMG_4829.”

When a spreadsheet is enough and when software helps

A spreadsheet can work well if you have a small number of units, consistent rent payments, and the discipline to update it regularly. It is flexible and familiar for many landlords.

The trade-off is that spreadsheets depend on manual entry. It is easy to forget an expense, overwrite a formula, or lose track of which payments have cleared the bank. If you manage multiple properties, receive frequent transactions, or also run another small business, bookkeeping software can make the routine less stressful.

A simple tool such as Pro Ledger Online can help you record rental income, track expenses, and review what is owed without asking you to learn complicated accounting terms. The key is still the same: enter transactions consistently and give each payment a clear description.

Common rent tracking mistakes to avoid

The biggest mistake is waiting until tax time to organize the records. By then, a missed payment, repair charge, or security deposit may be difficult to explain. A second common mistake is recording the rent due as income before it has actually been paid, then forgetting to track the unpaid balance.

It also helps to avoid mixing personal spending with rental activity. If possible, use a separate bank account or card for rental-related transactions. That creates a cleaner paper trail and saves time when reviewing your records.

Finally, do not rely only on your bank balance. A bank balance does not tell you which tenant paid, whether a payment was partial, or whether you are holding deposit money that should be tracked separately.

A good rent tracker is not about creating perfect paperwork. It is about giving yourself a calm, clear answer when you need to know what happened to the money. Start with one month, update it as payments arrive, and let the habit do the hard work for you.