Tidy Doors See the tracker

Tidy Doors guides

Landlord Bookkeeping for Small Landlords: A Simple System You'll Actually Keep Up With

When you own one rental, or five, bookkeeping can feel like something meant for bigger operations. It isn't. Bookkeeping for a small landlord is just a consistent way of answering three questions: What came in? What went out? Which property was it for?

Answer those three questions every time money moves, and you'll know whether each property is making money, you'll have what you need at tax time, and you'll have records to back up your numbers if anyone asks. This guide lays out a simple system you can set up in an afternoon and keep up with in a few minutes a week.

What bookkeeping means for a small landlord

For a small landlord, bookkeeping usually comes down to five jobs:

  1. Recording income: rent, fees and any deposits you keep.
  2. Recording expenses: everything you spend on the rental, labeled by property and category.
  3. Keeping proof: receipts, invoices, statements and tax forms.
  4. Reconciling: checking your records against your bank statements so nothing is missing.
  5. Reporting: monthly totals for yourself and a year-end summary for your taxes.

You don't need double-entry accounting, a chart of accounts with 80 lines or a degree in finance. You need a structure and a habit.

Step 1: Separate your rental money

This is the most valuable step, and it costs nothing. Open a checking account used only for your rentals. Rent goes in; rental expenses go out. If you can, use one credit card only for rental purchases too.

Why it matters:

  • Your bank statement becomes a near-complete record of your rental activity.
  • Monthly reconciliation takes minutes instead of an hour of sorting personal from rental charges.
  • If your records are ever questioned, clean separation is much easier to explain.

If you have several properties, one rental account is usually enough as long as every entry in your books is tagged with its property. Some landlords prefer an account per property; that's a personal choice, and it may also depend on how each property is owned.

Step 2: Choose your categories once

Pick categories at the start and stick to them. For US landlords who report rentals on Schedule E (Form 1040), the easiest list is the form's own expense lines: advertising, auto and travel, cleaning and maintenance, commissions, insurance, legal and professional fees, management fees, mortgage interest, other interest, repairs, supplies, taxes, utilities, depreciation and other.

Add two "tracking only" categories that are not regular deductible expenses:

  • Capital improvements, such as a new roof or HVAC system. These are generally depreciated over time rather than deducted in one year.
  • Refundable security deposits held, which generally aren't income while you hold them.

When every entry uses the same categories all year, the year-end summary builds itself. For a full table of the categories with examples, see Rental Property Expense Tracker Spreadsheet: What to Include.

Step 3: Pick a tool you'll actually use

There are three realistic options for small landlords. Here's an honest look at each.

Tool Good for Watch out for
Paper ledger or notebook One property, very few transactions Hard to total, easy to lose, no backup
Spreadsheet (Excel or Google Sheets) 1 to a few dozen units, landlords who like control and a one-time cost You enter data yourself; a homemade sheet needs careful formulas
Landlord or accounting software Larger portfolios, online rent collection, bank feeds Ongoing subscription; often more features than a small landlord uses

The right choice is the one you'll open every week. If you like seeing your numbers and don't need online rent collection, a structured spreadsheet is often enough. If you're spending hours each month on data entry or want tenant-facing features, software may earn its fee.

Step 4: Build a receipt system

Receipts are where most bookkeeping systems fall apart. Make it frictionless:

  • One folder per year, in Google Drive, Dropbox or on your computer, with subfolders for income, expenses and tax forms.
  • Photograph paper receipts immediately. Before you leave the hardware store, if possible.
  • Name files consistently: date_property_category_amount, for example 2026-05-02_OakSt_Supplies_42.pdf.
  • Forward email receipts to a dedicated folder or label.
  • Track receipt status in your books. A simple "Receipt saved? Yes/No" column turns "do I have everything?" into a 30-second filter.

The IRS says you generally need documentary evidence, such as receipts, canceled checks or bills, to support your expenses, so this step is worth getting right.

Step 5: Follow a weekly, monthly and yearly rhythm

Weekly (about 10 minutes)

  • Log any rent received and any expenses paid since last week.
  • Save the receipts.
  • Note anything unusual, like a late payment or a repair that may need follow-up.

Monthly (about 30 minutes)

  • Reconcile: compare your logs to the rental bank and card statements, line by line. Add anything missing.
  • Check rent: compare what you expected to collect from each property with what actually came in.
  • Review each property: income, expenses and net for the month, plus your expense ratio (expenses divided by income). A rising ratio is an early warning.
  • Total your mileage log if you drive for your rentals, and log it under auto and travel.

Year-end (an afternoon)

  • Collect Form 1098, property tax bills and insurance statements.
  • Fill any receipt gaps.
  • Add your depreciation figure for the year (often from your preparer or last year's Form 4562).
  • Record fair rental days and any personal-use days for each property.
  • Produce a year-end summary per property, organized by Schedule E line.
  • Archive the year's file and start a fresh one.

Step 6: Track each property separately

Even if all the money flows through one account, keep your books per property. It's required for reporting, since Schedule E lists properties side by side, and it's the only way to know which properties are pulling their weight.

When a cost covers more than one property, such as an umbrella insurance policy or a single invoice from a contractor who worked on two units, split it and record each property's share separately. Write down how you split it, so you can do it the same way next year.

Common bookkeeping mistakes small landlords make

  • Mixing personal and rental money. It makes every other step harder.
  • Recording the whole mortgage payment as an expense. Principal isn't an expense; interest (from Form 1098), and taxes and insurance paid through escrow, go on their own lines.
  • Counting refundable deposits as rent. It overstates income. Track them separately until you keep or return them.
  • Lumping improvements in with repairs. They're generally treated differently, so keep them apart.
  • Waiting until tax season. Twelve months of receipts in one weekend is how things get missed.
  • Inventing new categories mid-year. "Misc," "Stuff," "House things" all end up re-sorted in April.

When to bring in a professional

A good system makes a tax professional's job easier; it doesn't replace them. Consider getting help if you're buying or selling a property, have a short-term rental with significant personal use, are dealing with large improvements or a casualty loss, or simply aren't sure how something should be treated. A one-page summary per property, with receipts ready, can make that meeting shorter.

A shortcut if you want one

If you'd like a spreadsheet already set up this way, the Tidy Doors Rental Property Income & Expense Tracker is built for landlords with 1 to 25 properties who keep their own books. It has income and expense logs with dropdowns (including a "Receipt saved?" column), a properties tab with expected rent and rent collected this year, a monthly view with expense ratio, a dashboard, and a year-end summary in Schedule E line order. Deposits and capital improvements are tracked separately. It works in Excel and Google Sheets, has no macros, and costs $19 once.

See the tracker


Not tax advice. This article is general information for US landlords and is not tax, legal, accounting or financial advice. It refers to the 2025 Schedule E (Form 1040) instructions, IRS Publication 527 and IRS recordkeeping guidance. Tax rules change and depend on your situation; confirm with a qualified tax professional.

← All guides