Published 2026-10-05

Landlord spreadsheets by property type and lease situation

A rented house, a fourplex and a room rental all need a rent roll, a ledger and an expense log, but they split costs and show gaps differently. Pick your situation for a worked month and where each number goes.

General information only, not tax, legal or accounting advice. Late-fee, deposit and notice rules vary by state, city and lease; check your own. Names and numbers in the example are invented.

Pick the page that matches your situation

Basement apartment and ADU rental income and expense spreadsheet: two very different units: Track a main house plus a basement apartment or ADU as two units on one address: bills split equally by unit, and how to charge a bill to one unit only.
Condo rental income and expense spreadsheet: one unit, HOA dues and assessment: Track one rented condo in Excel: HOA dues as a repeating Expenses row, a one-off special assessment, small repairs and a worked month of rent.
Fourplex rental income and expense spreadsheet: four units, partial payment: Track four units in one building in Excel: four rent rows, two split common-area bills, one partial payer and the Balance column that shows what is owed.
House-hack rental income and expense spreadsheet: live in one unit, rent the others: Track a house-hack in Excel: only the rented units go on the rent roll, shared bills are typed as the rental share, and splits divide by the units listed.
Month-to-month tenants rent tracker spreadsheet: leave Lease end empty, watch the ledger: Track four month-to-month tenants in Excel with Lease end left empty: ledger Status shows who has paid, paid late or paid part, plus a rent increase preview.
Partial rent payments tracker: monitor balances when tenants pay part of monthly rent: Partial rent payments on a rent ledger: Partial status, Balance, Running balance per unit and a late fee shown as charged, with two of four tenants short.
Rent increase at lease renewal: plan and preview increases as leases end: Track lease end dates, the 90-day and 60-day Lease flag and an Increase % that feeds a new-rent preview. You change Monthly rent once it is agreed in writing.
Room rental income and expense spreadsheet: four rooms, three tenants, one empty room: Track a house rented by the room in Excel: four rooms as four units, three tenants, one vacant room at its asking rent, shared utilities split equally.
Single-family rental income and expense spreadsheet: one house, one tenant: Track one rented house in Excel: one rent roll row, a ledger line per month, bills and the deposit, with a worked month and the formulas behind it.
Small apartment building rent roll spreadsheet: six units, one vacant: Track a six-unit building in Excel: five rent rows, one vacant unit at its asking rent, split bills and the vacancy log, with potential rent when full.
Tenant turnover and vacancy tracker: monitor move-outs, move-ins, and prorated rent: Record a turnover in a four-unit building: a vacancy log row on Units & Leases, move-in and move-out dates that prorate the ledger, a Deposits row per tenant.
Triplex rental income and expense spreadsheet: three units, shared water: Track three units in one building in Excel: a lease end date per unit, a shared water bill split three ways, one partial payer and net operating income by unit.

More landlord guides

Already built

The Landlord Rent & Expense Tracker has the rent roll, rent ledger, expenses, deposits and P&L tabs wired together, with example data on every tab. One Excel file, $29.

See what is inside