The Skill Mill

The property looked great on paper. Rent came in, mortgage went out, and for a few months it felt like the spreadsheet was basically running itself. Then the water heater filed for early retirement, the insurance renewal landed, and the tenant asked why the garbage disposal sounded like a blender full of rocks.

Welcome to landlord bookkeeping for beginners — the part nobody covers in the “build wealth with real estate” content you were watching at midnight.

This post is a practical beginner guide to rental property income and expense tracking: what categories matter, why you need them before tax time, and how a simple landlord spreadsheet keeps you from guessing whether the property is actually working.

Why Tracking Rent Collected Is Not the Same as Tracking Cash Flow

New landlords often watch one number: rent collected. If the deposit hits the account, the month feels like a win. But rent collected is just the top of a much longer column.

Your real question is: after every expense leaves the building, what’s left? That’s cash flow — and it’s a very different figure from gross rent.

Between rent collected and cash flow, you have to account for:

• Mortgage (PITI): Principal, interest, property taxes, and insurance. If you’re escrow-impounding taxes and insurance, your actual monthly payment already bundles these. If not, you need to track them separately or you’ll forget they exist until January.
• Vacancy reserve: Most landlords model vacancy at somewhere between 5% and 10% of gross rent. An occupied unit doesn’t mean you skip this line — it means you’re building a buffer for the month it sits empty between tenants.
• Repair reserve: Different from CapEx. Repairs are the garbage disposal. CapEx — capital expenditures — is the roof, the HVAC, the water heater. Both need a line. Neither is optional just because nothing broke this month.
• Property management fees: If you self-manage, this is your time. If you hire out, it’s a real dollar figure that belongs on the ledger.
• Utilities: Relevant if you pay water, trash, or heat for a multi-unit building or include any utilities in rent.

Run those numbers honestly and your net operating income (NOI) — income minus operating expenses, before debt service — tells you whether the deal actually works. Subtract your mortgage payment from NOI and you have cash flow. That’s the number that pays or doesn’t pay you.

Landlord Accounting Basics: Organize by Schedule E from Day One

Here’s a tax-prep shortcut that saves hours every April: organize your expenses now using the IRS Schedule E categories. Schedule E is the form you’ll file to report rental income and losses, and it has specific line items. If your records already match those categories, preparing your return — or handing records to a CPA — is straightforward instead of painful.

The Schedule E expense categories for rental property include:

• Advertising
• Auto and travel
• Cleaning and maintenance
• Commissions
• Insurance
• Legal and professional fees
• Management fees
• Mortgage interest
• Repairs
• Supplies
• Taxes (property tax)
• Utilities
• Depreciation

Notice what’s on that list: repairs, supplies, management fees, insurance. These are all deductible. Notice what’s not on the list: the portion of your mortgage payment that goes to principal. Principal paydown builds equity but it isn’t deductible as an expense. Mortgage interest is. This distinction matters when you’re building your landlord spreadsheet.

Depreciation deserves its own sentence: it’s a non-cash deduction that reduces your taxable income even though no money leaves your account. It’s also recaptured when you sell, which is a tax conversation for another day — but it absolutely belongs in your records. Talk to a tax professional about how depreciation applies to your specific situation. For general reference, the IRS publishes guidance on rental income and expenses at irs.gov.

What to Actually Put in Your Rental Property Record Keeping System

You don’t need enterprise software to do this right. A well-structured spreadsheet handles everything a single-family or small multi-unit landlord needs. Here’s what your rental property record keeping spreadsheet should capture:

Income side:

• Rent collected by unit and by month
• Late fees collected (tracked separately — they’re income but not rent)
• Other income: laundry, parking, pet fees
• Security deposits received (these are liabilities, not income, until applied — track them separately)

Expense side, by Schedule E category:

• Date of expense
• Vendor or payee
• Amount
• Category (match it to Schedule E)
• Property (if you have more than one unit, tag every entry)
• Receipt or invoice reference

Summary metrics you want at a glance:

• Gross rent collected vs. scheduled rent (this shows real vacancy)
• Total expenses by category, by month and year-to-date
• NOI
• Cash flow after debt service
• Cash-on-cash return (CoC): annual cash flow divided by total cash invested. This is the number that tells you whether your down payment is working harder than a savings account.

If you want to evaluate a deal before you buy it, you’ll also want a cap rate calculation: NOI divided by purchase price. Cap rate doesn’t account for your financing — it measures the property’s income-producing ability independent of how you paid for it. That’s why investors use it to compare properties across different markets and price points.

For a deeper look at evaluating deals before you close, see how to analyze a rental property deal and our walkthrough of cap rate vs. cash-on-cash return.

Tracking Rent Payments, Late Fees, and Tenant Ledgers

Every tenant should have a running ledger: what they owe, what they paid, when they paid it, and any outstanding balance. This isn’t bureaucracy — it’s documentation you’ll want if a payment dispute ever escalates, and it’s the foundation of an accurate rent roll.

A rent roll is a simple snapshot: each unit, the tenant, the monthly rent, lease dates, and payment status. It’s what a lender or potential buyer asks for if you ever refinance or sell. Building one as you go is much easier than reconstructing it later from bank statements.

Late fees are worth tracking separately from rent, for two reasons. One, they’re income and belong on Schedule E. Two, they tell you something about a tenant’s payment habits over time — useful information if you’re deciding whether to renew a lease.

If you house hack — owner-occupying one unit of a small multi-family while renting the others — you’ll want to track your property expenses across the whole building but allocate income and deductions correctly between personal and rental use. That allocation affects what you can deduct, so clean records matter even more than usual. See house hacking tax basics for a primer.

FAQ: Landlord Bookkeeping Basics

Q: Do I need accounting software, or will a spreadsheet work?
A: For most landlords with one to a handful of units, a well-built spreadsheet does the job. Dedicated software adds cost and complexity that often isn’t necessary until you’re managing a larger portfolio. The priority is having a consistent system — whatever format you’ll actually use.

Q: What’s the difference between a repair and a capital expenditure?
A: A repair restores something to working condition (replacing a broken faucet). A capital expenditure improves or extends the useful life of the property (replacing the entire plumbing system). Repairs are generally deductible in the year you pay them; CapEx is depreciated over time. The line isn’t always clean — when in doubt, ask your tax professional.

Q: How should I handle the security deposit in my records?
A: Security deposits are held in trust for the tenant — they’re not your income until you apply them to unpaid rent or damages. Track them as a liability. When you return all or part of a deposit, record the transaction. When you apply part of it to a legitimate charge, that’s when it becomes income or an offset to an expense.

Q: What records should I keep, and for how long?
A: Keep all income and expense records, lease agreements, receipts, and tenant correspondence. Tax records for rental property are generally worth keeping for several years minimum — depreciation recapture can reach back to when you first placed the property in service. A tax professional can advise on your specific situation. The IRS guidance page at irs.gov is a useful starting reference.

---

If you’ve read this far and your current system is a folder of receipts and a rough memory of what rent came in last month, that’s fixable — but the time to fix it is before tax season or a tenant dispute, not during one.

The Vault & Press Rental Property Cashflow Analyzer is a spreadsheet built around exactly the structure described here: Schedule E expense categories, a rent roll, cash flow summary, and CoC return — all on a layout that doesn’t require an accounting degree to use. It’s the kind of tool you build once and update monthly, rather than reconstructing your records from bank statements every March.

You can also find more practical landlord resources at The Skill Mill, including guides on rental property cash flow analysis that walk through real numbers without the hype.

The property is passive right up until it isn’t. Good records are what you fall back on when it stops being passive for a month.

What’s the one expense category you wish you’d tracked from the beginning — or the one that surprised you most in year one? Leave it in the comments.

{“@context”:”https://schema.org”,”@type”:”BlogPosting”,”headline”:”Landlord Bookkeeping for Beginners: What to Track and Why”,”description”:”New to landlord bookkeeping for beginners? Learn what to track, how to organize rental income and expenses, and why good habits save you at tax time.”,”keywords”:[“rental property income and expense tracking”,”landlord accounting basics for new investors”,”how to track rental property finances”,”beginner guide to rental property bookkeeping”,”what expenses can landlords write off”,”rental property record keeping spreadsheet”,”tracking rent payments and late fees”,”landlord tax preparation record keeping”,”property management accounting for small landlords”,”how to organize rental property financial records”],”datePublished”:”2026-07-08T21:13:12.340Z”,”dateModified”:”2026-07-08T21:13:12.340Z”,”author”:{“@type”:”Organization”,”name”:”The Skill Mill”},”mainEntityOfPage”:”https://blog.theskillmillbooks.com/landlord-bookkeeping-for-beginners-what-to-track-and-why/?utm_source=skillmillblog&utm_medium=blog&utm_campaign=rental-property-tracking&utm_content=landlord-bookkeeping-for-beginners-what-to-track-and-why”}

Tools that help: MineStock Pro.