A rental property bookkeeping spreadsheet is the starting point most landlords reach for before moving to full bookkeeping software or a bookkeeper — and a good one needs to do more than total up rent collected. It needs to separate income from expenses by property, capture the categories that actually matter at tax time, and flag the single distinction that trips up more investors than any other: repairs versus capital improvements.
The template below tracks each transaction by property, date, category, and amount, with a column to flag whether an expense is a repair (deductible the same year) or a capital improvement (depreciated over time). That one column is worth more than the rest of the sheet combined — the IRS treats a $4,500 roof repair and a $4,500 roof replacement very differently, and a spreadsheet that doesn't distinguish them quietly hands your CPA a reconstruction project every year-end.
A basic category set covers most single-property or small-portfolio situations: rental income, mortgage interest (interest only — never include principal, which isn't deductible the same way), property tax, insurance, repairs and maintenance, capital improvements, property management fees, HOA fees, utilities the owner pays, and legal or professional fees. The template includes a category key defining each one, so the same categorization logic holds up whether you're tracking one door or five.
A spreadsheet like this works well for one to a few properties tracked by a hands-on owner. It starts to break down around the same point most DIY systems do: multiple properties or entities, inter-company transfers, depreciation schedules that need to persist correctly year over year, or the volume where a monthly spreadsheet update turns into a part-time job. That's usually the point where moving to QuickBooks Online with property-level class tracking — or handing it to a bookkeeper who already knows real estate — pays for itself in time and in deductions the spreadsheet was quietly missing.
Download the template, adapt the categories to your situation, and use the repair-vs-improvement column from day one rather than trying to reconstruct the distinction at tax time. If your portfolio has already outgrown a spreadsheet, or you want a second opinion on whether it has, a discovery call is the fastest way to find out.