How to track rental income and expenses for each property

If you own more than one rental, track rental income and expenses for each property separately. Otherwise you can't tell which unit pays for itself and which one costs you money every year. You also notice a late payment on the 20th instead of the 2nd, and you spend a weekend in March rebuilding last year from bank statements.

Why the numbers stop adding up

Rent arrives in your bank account with a reference like "TRANSFER 0391", and you have to remember which tenant that was. You pay the plumber by card, the gardener in cash and the property tax online. The receipts end up in your email, in WhatsApp chats and in the glove box. If a manager runs one of the properties, their statement comes as a PDF with its own categories.

Each payment takes a minute when it happens. Adding them up by property months later, with half the receipts missing, is where the weekend goes.

Keep one ledger for all your properties

Use a single list where every movement of money gets one row. One list for all properties is easier to keep up than a file per property, and a filter or a pivot table gives you any property's numbers in seconds.

Use these columns:

The amounts are only examples. A few rules keep the list useful:

• One row per movement. If a tenant pays in two parts, write two rows.
• Name properties the same way every time. "Apt 4B" in one row and "4B Maple" in another will split your totals.
• Write it down the day it happens, or at least the same week.

Use the same categories every month

Pick a short list and stick to it. Changing categories halfway through the year makes comparisons useless.

Income:

• Rent
• Late fees
• Other income (parking, laundry, a pet fee)

Expenses:

• Repairs and maintenance
• Cleaning and turnover between tenants
• Utilities you pay
• Building or HOA fees
• Property tax
• Insurance
• Mortgage interest
• Management fees
• Supplies and small purchases

If you file taxes on this income, ask your accountant which categories your country uses and copy them. In the US, rental income and expenses usually go on Schedule E; other countries have their own forms and rules on what you can deduct.

Keep security deposits out of your income

A deposit belongs to the tenant until the lease ends and you settle it. Record it in a separate list with the date, the amount and where you hold it. Some places require a separate account or interest on deposits, so check the rules where your property is.

Check rent on a fixed day each month

Late rent is easy to miss when it's mixed with everything else in your bank account. Keep a small rent roll next to the ledger, one row per unit:

• unit and tenant;
• monthly rent and due date;
• date paid and amount paid;
• status: paid, partial, late.

Pick a check day, such as two days after rent is due, and go through the list with your bank app open. If a payment is missing, send a short, neutral message the same day: "Hi, I haven't seen March rent for Apt 4B yet. Could you let me know when it's coming?" There's often a simple reason, like a new bank account or a payday that moved, and you find out in one message.

Record partial payments as they arrive, with the balance still due, so nobody has to argue about it later.

Keep every receipt with its entry

A number in a spreadsheet without a receipt won't help you at tax time or in a dispute with a tenant. Make it a habit:

1. Take a photo of the receipt or save the PDF the same day.
2. Name it with the date, property and amount: 2026-03-06 Apt4B 100 faucet.pdf.
3. Save it in one folder per property and per year.
4. Paste the link in the ledger's "Receipt" column.

Repair receipts matter twice: for your taxes, and as part of the property's repair history. Our guide on handling tenant maintenance requests covers how to keep that history together.

Review each property once a month

At the start of each month, filter the ledger by property and look at three numbers: rent received, total expenses and what's left. Compare them with the month before. A water bill that doubled or a third repair in the same bathroom is easier to act on in April than in December.

At the end of the year, the same filter gives you a summary per property and per category. Send it to your accountant with the receipts folder, and the tax appointment goes much faster.

How RentalThread will make it easier

RentalThread will show rent and expenses for each property at a glance, so you see which payments are late and what each unit costs without building the totals yourself. Repairs will carry their cost from the estimate to the payment, so the money side of every job is already recorded with its photos and invoice. AI will read invoices and leases to pull out amounts and dates, and you'll review what it found before anything is saved.

If you own a few rentals and track them by hand today, see what's planned for owners.