Rental Property Income and Expense Spreadsheet

What this is for

Every April, a certain kind of landlord sits at the kitchen table with a shoebox, a year of card statements and a growing suspicion that the water heater was bought in a different tax year. This spreadsheet exists so that doesn’t happen. You log each dollar in and out as it happens, in the category it will end up in on the tax form, and at year end the totals are already sitting there.

Rental income and expenses are reported on IRS Schedule E, and the tracker is built around its expense lines: advertising, auto and travel, cleaning and maintenance, commissions, insurance, legal and other professional fees, management fees, mortgage interest, other interest, repairs, supplies, taxes, utilities, depreciation, and other. Those categories are the dropdown on the Expenses tab. The Income tab has its own list: rent, late fees, kept security deposit, pet rent or fees, parking or laundry, and other income. Two summary tabs total each category by month and for the year, and the Expense summary ends with a net figure, income minus expenses.

It is a record-keeping sheet, not tax advice. It will not work out depreciation, and it cannot tell you whether a new roof is a repair or an improvement. What it does is keep every number labeled, dated and tied to a receipt, so the conversation with your tax preparer is short and specific. The Receipt kept column flags any expense with no receipt in amber, while you still have a chance of finding it.

How to fill it in

1. Start on the Settings tab and type the tax year. Every total in the workbook counts only entries dated in that year, so one file per year works best.
2. On the Properties tab, list each property or unit you want to track separately, with its address: "Maple St", "Oak Ave duplex". These names become the Property dropdown on both the Income and Expenses tabs.
3. Delete the EXAMPLE rows on the Expenses and Income tabs.
4. For every expense, add a row on Expenses: Date, Property, Schedule E category, Paid to, Amount, Paid by, Receipt kept (Y or N) and Notes. Write in Notes what the money was actually for, like "kitchen sink leak, Unit A", because the category alone won’t jog anyone’s memory in eleven months.
5. Pick the category with care. Fixing a leak or patching drywall is usually a repair. Replacing the whole roof or adding a bathroom is usually an improvement, which the IRS says must be capitalized and depreciated rather than deducted. If you are not sure, enter it, choose the closest category, and write "repair or improvement?" in Notes to ask your preparer.
6. For every payment received, add a row on Income: Date, Property, Category, Received from, Amount and Notes. If you already keep a rent ledger, you can enter rent here as one monthly total per property instead of each payment.
7. When you keep part of a security deposit, record it on Income under "Kept security deposit" on the day you keep it. A deposit you plan to return stays off this sheet entirely.
8. Once a month, filter the Expenses tab for Receipt kept = N. Each amber row is a receipt to find, request again from the vendor, or replace with a bank statement and a note.
9. At year end, the Expense summary and Income summary tabs show each category by month with a Year total, and the net line at the bottom of the Expense summary. Print both, or send the file to your tax preparer.

A filled-in example

Common mistakes

• Mixing personal and rental spending on the same card, then sorting it out in March. Use a separate account for the property if you can, and log each expense on the tracker the week it happens.
• Filing a big replacement under Repairs because it felt like a repair. A new furnace, roof or kitchen is often an improvement, which is treated differently. Flag anything large in Notes and let a tax professional decide.
• Forgetting that a kept deposit is income. The IRS says a deposit you intend to return is not income when you receive it, but the part you keep is income in the year you keep it. Record it on the Income tab the day you decide.
• Ignoring the amber rows. A missing receipt is easy to replace in the first month and close to impossible in the second year. Deal with the flags every month.
• Typing an expense category by hand. The summary tabs match exact category names, so a hand-typed "Repair" instead of "Repairs" disappears from the totals. Always pick from the dropdown.