Rental Property Income and Expenses Spreadsheet Template

A rental property income and expenses spreadsheet template needs three working parts: an income section, an expense section, and a net cash-flow line that subtracts one from the other. The full row-and-column structure, plus one filled-in example month, is right below, ready to copy straight into Google Sheets or Excel. Keep those three parts consistent from month to month and the same sheet doubles as a running profit-and-loss statement.

The template: columns, rows, and a filled-in example

Build the sheet in two stacked blocks: income rows on top, expense rows below, with a net cash flow line at the bottom. Give each row one column for the month’s dollar amount, then add a column per month (Jan through Dec) plus an Annual total once you want the full-year view. Here’s an example month filled in, with figures that are illustrative only and not PURE HomeRiver portfolio data:

Total Income and Total Expenses are each a =SUM(range) formula over their own rows, something like =SUM(B2:B8) for income and =SUM(B10:B19) for expenses in this layout. Net Cash Flow is just Total Income minus Total Expenses: =B9-B20. Both formulas behave identically in Google Sheets and Excel, so the sheet survives moving between the two.

Copy this structure into a new spreadsheet, then add one tab per property so every address keeps its own income, expenses, and net cash flow line instead of blending together.

Income categories every landlord should track

Six categories cover income for almost any rental:

• Rent and late fees: give late fees their own line instead of folding them into rent. It keeps the base rent roll clean and makes chronic late payers obvious at a glance.
• Application fees: renters pay these during screening, and unless you log them separately they vanish inside the first month’s rent total.
• Pet fees and pet rent: keep pet deposits and recurring pet rent apart from base rent. It makes deposit returns and audits far easier to reconstruct later.
• Parking and storage fees: any charge for a reserved spot or a storage unit gets its own row so it doesn’t get buried inside rent.
• Laundry and vending income: common in multi-unit buildings, and worth tracking separately so you can actually tell whether the machines are profitable.
• Other income: lease renewal fees, lease-violation fines, anything else that doesn’t fit a category above. One catch-all row keeps small income from disappearing.

Expense line items to include

Most rentals split expenses into ten line items:

• Mortgage (P&I): principal and interest together, usually the largest fixed cost on the sheet.
• Property taxes: often billed annually or quarterly, but logged monthly so the sheet reflects the real obligation.
• Insurance: landlord policy premiums plus any added riders.
• Maintenance & repairs: routine work and one-off repairs, kept in a single line separate from CapEx.
• Owner-paid utilities: whatever you cover instead of passing through to the resident.
• Management fee: what you pay a property manager, if you use one.
• Legal & accounting: attorney fees, eviction costs, and tax preparation.
• Vacancy & leasing costs: advertising, screening, and leasing commissions during turnover.
• HOA/condo dues: monthly or quarterly association fees.
• CapEx reserve: money set aside for a roof, HVAC system, or other major replacement.

For what belongs in each category and typical dollar ranges, see our
complete breakdown of rental property expenses
.

The CapEx line matters more than its size on the sheet suggests. Blend it into maintenance and repairs and the property looks more profitable than it is, right up until the roof needs replacing and there’s nothing set aside to pay for it. A separate reserve line keeps your appreciation and long-term planning numbers honest.

How to turn the sheet into a profit and loss statement

Subtract Total Expenses from Total Income and the result is the property’s profit or loss for that period. Run the subtraction on a single month’s column for a monthly view, or total a full year of columns first for the annual figure your tax preparer will actually want. Our
guide to building a profit and loss statement for a rental property
walks through both versions in more detail.

At tax time, this is the same income and expense breakdown that lands on
Schedule E (Form 1040), Supplemental Income and Loss
, the form the IRS uses for rental income and expenses. Which costs are deductible in the current year versus depreciated over time is a tax professional’s call, not a spreadsheet’s. Keep the sheet itself tax-agnostic: log every dollar accurately, and let a tax professional sort out the treatment.

Keep the numbers accurate: formulas and the errors to watch for

Automate the totals with formulas instead of adding rows by hand. A single =SUM() per section keeps Total Income and Total Expenses correct automatically as you add rows or update figures, which solves most of the accuracy problem before it starts.

The rest comes down to watching for a handful of real traps:

• Formula errors: #VALUE! usually means text landed in a cell your formula expects to be a number. #DIV/0! means something is dividing by an empty cell. Both surface quickly once you’re summing the wrong range.
• Inconsistent categories: “repairs” one month and “maintenance” the next scatters what should be a single line item across your reports. Keep a fixed master list of category names and don’t deviate from it.
• Missed monthly updates: set a recurring reminder to enter transactions as they happen. Three months of backlog is hard to reconstruct accurately, and errors compound the longer the gap stretches.
• Data validation: a dropdown restricted to your master category list stops a typo from quietly creating a new, uncategorized row that nobody notices until reconciliation.

When a spreadsheet stops keeping up

A spreadsheet works fine for one or two properties with a handful of transactions each month. It starts breaking down at a fairly predictable point: multiple units, holdings spread across more than one state, or transaction volume high enough that reconciling every row by hand becomes its own part-time job. Past that threshold, manual entry is where errors creep in, whether that’s a missed expense, a miscategorized payment, or a report that took three tries before a lender or a tax preparer could actually use it.

That’s usually the point where owners either tighten their own systems for how they
manage a rental property
, or hand day-to-day operations to a manager who already has the reporting built. It won’t guarantee a flawless ledger, but it does move reconciliation and monthly reporting off your desk and onto a system built to handle the volume.

FAQ

How do I calculate profit or loss on my rental property spreadsheet?

Subtract Total Expenses from Total Income for the period you’re reviewing. Do it monthly to catch problems early, and add up a full year of columns for the annual number your tax preparer needs.

What expense categories should I include?

At minimum: mortgage, property taxes, insurance, maintenance and repairs, owner-paid utilities, management fees, legal and accounting, vacancy and leasing costs, HOA dues, and a separate CapEx reserve. Add anything specific to your property, but fix the category names once you set them and stick to them.

Can I track multiple properties in one spreadsheet?

Yes. Give each property its own tab with the same income and expense structure, then build a summary tab that pulls Total Income, Total Expenses, and Net Cash Flow from every property tab into one view.

How do I log expenses in the template?

Enter each cost under its category the day it hits your bank account or you pay the invoice. Waiting until month’s end invites the missed-update problem covered above.

What should a good rental property spreadsheet include?

An income section, an expense section with CapEx separated from routine maintenance, a net cash flow formula, and category names that don’t change month to month. Extra columns, notes fields, and multiple property tabs build on that base once you need them.

This article is general information, not tax advice. Tax laws change, and every situation is different. For guidance on your specific rental property taxes, talk to a licensed tax professional.