How to Track Rental Income and Expenses (Schedule E Prep)
A practical landlord system for tracking rental income and expenses by property, reconciling monthly, and packaging Schedule E preparation summaries — not tax filing.
Track rental income and expenses in a dedicated account, categorize every transaction by property when it happens, reconcile monthly, and export Schedule E preparation summaries for your CPA. The goal is clean books — RentalNoodle organizes what you record; it does not file taxes.
Tax rules change and depend on your situation. RentalNoodle organizes income and expenses you record and can export Schedule E preparation summaries — it does not file taxes or give tax advice. Confirm treatment with a CPA or enrolled agent.
Separate the money first
Open a checking account used only for rentals (one account per property is ideal; one portfolio account with strict property tags can work for small portfolios). Every rent deposit and every property expense should hit that account. Mixed personal/rental cards force year-end reconstruction.
- Rent and other rental income deposited to the rental account
- Expenses paid from the rental account or a card paid in full from it
- Owner contributions labeled as transfers, not income
- Owner draws labeled as draws, not expenses
- Security deposits tracked as liabilities, not rent
If you already mixed accounts, start the clean system on the first of next month. Do not wait for January — partial-year clean books beat twelve months of fog.
What counts as rental income
IRS Publication 527 describes amounts you receive for the use of real property as rental income. For day-to-day tracking, record gross rent charged and paid by period, then add other rental receipts so nothing hides in “misc.”
| Income type | How to record | Common mistake |
|---|---|---|
| Monthly rent | By charge period + property | Posting to wrong month after late deposit |
| Late fees / NSF fees | Separate income line if material | Burying fees inside rent |
| Laundry / parking / storage | Other rental income by property | Leaving cash unlogged |
| Tenant reimbursement for repairs | Income or expense offset — ask CPA | Ignoring it because “they paid the plumber” |
| Prepaid rent | Liability until period earned | Booking entire prepay as income in month received |
| Security deposits held | Liability, not income | Depositing and calling it rent |
Forfeited deposits can become income under tax rules in some cases — flag them for your CPA rather than inventing treatment yourself. Pub 527 covers rental income topics; your job is a clear trail of what money moved and why.
Record expenses with Schedule E prep in mind
Every expense needs: date, amount, payee, property/unit, category, and a receipt or invoice for material amounts. Categories should roll up toward Schedule E preparation lines (advertising, insurance, repairs, taxes, utilities, and so on). See the expense categories guide for a practical map.
- Pay or charge the expense from the rental money path.
- Enter it the same day (or at least the same week) with the property tag.
- Attach the receipt PDF or photo to the transaction.
- If the purchase mixes personal and rental items, split the line immediately.
- If the work looks like an improvement (new roof, remodel, HVAC replacement), mark it capital/improvement — not “repairs.”
Home Depot run: $48 caulk/filters for Unit A (supplies/repairs) + $210 drill for your personal garage. Split at entry. Leaving it as one “Home Depot $258 repairs” line is how personal spend contaminates Schedule E prep.
Repairs vs improvements — track both, decide later with a CPA
Pub 527 distinguishes repairs that keep property in operating condition from improvements that add value or prolong life. You do not need to be a tax lawyer at the hardware store — you do need invoices that show what was done, where, and when. Tag ambiguous big-ticket work as “improvement candidate” so it is not silently swept into repairs at year-end.
- Repairs: fix leak, replace broken fixture, patch drywall after pipe burst
- Improvements (often capitalized): new roof, kitchen remodel, room addition, major system replacement
- Always keep: contractor invoice, address, date placed in service, payment proof
Property-level books, not one blob total
Schedule E preparation is property-oriented. Even if you own two duplexes under one LLC, keep income and expenses tagged per address (and ideally per unit when costs are unit-specific). Portfolio totals are for your cash dashboard; property totals are for tax prep and performance comparison.
Minimum tags on every transaction
- Property address (or property ID)
- Unit (when applicable)
- Category aligned to your chart of accounts
- Vendor / tenant name
- Period (for rent charges and rent payments)
- Attachment or receipt reference for amounts that matter
Monthly reconciliation rhythm
Weekly entry plus a month-end close beats a December binge. Reconciliation means your books explain the bank — not that every penny matches without a bridge.
- Download or sync the rental bank statement for the month.
- Match each deposit to rent periods or other income lines.
- Match each outflow to an expense (or transfer/draw).
- Explain uncleared items: pending ACH, outstanding checks, timing of late rent.
- Confirm security deposit activity updated the liability list, not income.
- Snapshot or export the month’s P&L by property into your tax folder.
Write a two-sentence bridge when bank deposits ≠ rent income (processor fees, partials, or rent held). That note is gold for your accountant in March.
What to keep so Schedule E prep is fast
IRS Publication 527 emphasizes keeping records that support income and expenses. Practically, store digital copies where you can find them by property and year:
- Lease and amendments (proves rent terms)
- Rent ledger by period
- Bank and credit-card statements for the rental account path
- Form 1098 mortgage interest statements
- Property tax bills and insurance premium proofs
- Repair and improvement invoices with addresses
- Mileage log if you deduct auto/travel for rental activity (confirm method with CPA)
- Prior-year Schedule E and depreciation schedule from your CPA
Year-end package without filing anything
Closing the year means totals by property, improvements listed separately, deposits excluded from income, and documents staged for the CPA. Use a Schedule E preparation checklist as the handoff map. RentalNoodle can export Schedule E preparation summaries from income and expenses you recorded — that export organizes numbers; it is not a filed return.
Year-end tracking close
- All rent periods for the calendar year posted
- All rental-account transactions categorized
- Improvements flagged with placed-in-service dates
- Owner transfers and draws not mislabeled
- Open security deposits listed as liabilities
- Reconciliation bridges written for odd months
- Exports generated per property
- CPA questions list attached (new purchase, refinance, personal use, claims)
Special situations to flag early
- Personal use of a dwelling you also rent (Pub 527 has special rules)
- Property placed in service or sold mid-year
- Insurance claim proceeds and related repairs
- Rent concessions or free months — document the reason
- Paying expenses from personal accounts — reimburse and record cleanly
- Tenant-paid repairs credited against rent — dual entry required
A simple weekly habit that replaces April panic
- Enter any rent payments received since last check.
- Enter any new expenses with receipts attached.
- Skim the rental account for unknowns.
- Close open maintenance tickets that have invoices waiting to be booked.
- Once a month, run the full reconciliation and export.
If you manage this weekly, Schedule E preparation becomes a packaging exercise — not archaeology. Confirm final tax treatment, depreciation, and filing with a CPA or enrolled agent.
Authoritative sources
Related guides
Keep these records in one place
RentalNoodle helps independent landlords organize properties, tenants, leases, rent, maintenance, inspections, and finances — without turning day-to-day management into busywork.
Start Managing FreeEducational content for independent landlords. RentalNoodle is property management software — not a law firm, CPA firm, or government agency. Rules vary by state and locality. Confirm legal and tax questions with qualified professionals.