Why Bookkeeping Matters for Landlords
Good bookkeeping is the foundation of a profitable rental property business. Without organized financial records, you risk missing tax deductions, overpaying the IRS, failing an audit, and making poor investment decisions based on incomplete data. The average landlord leaves $2,000 to $5,000 per year in unclaimed deductions simply because they do not track expenses consistently.
Consider a landlord who owns a single-family rental generating $24,000 per year in rent. If they fail to track $3,000 in deductible repairs, $350 in mileage, and $400 in supplies, they lose $3,750 in deductions. At a 24% federal tax rate, that is $900 in unnecessary taxes paid every year. Over five years, that adds up to $4,500 in lost savings from a single property.
Beyond taxes, bookkeeping gives you visibility into your property's true performance. You can see your net operating income (NOI), cash-on-cash return, and expense trends month over month. This data helps you decide when to raise rent, which expenses to cut, and whether a property is worth keeping or selling. Without it, you are operating blind.
Setting Up Your Bookkeeping System
A proper landlord bookkeeping system has three core components: a dedicated bank account, an organized chart of accounts, and a consistent tracking method. Start with these basics and build from there.
Dedicated Bank Account
Open a separate checking account exclusively for your rental property activity. All rent deposits go into this account, and all property-related expenses are paid from it. This creates a clean paper trail and makes it easy to reconcile your books against your bank statement each month. Many landlords also keep a separate savings account for reserves (typically three to six months of operating expenses, or $5,000 to $15,000 per property).
If you own multiple properties, you can use a single account with sub-ledger tracking, or open one account per property. Either approach works as long as you can clearly attribute every transaction to a specific property. RentalReportLab lets you tag each transaction to a property, so a single bank account works fine even with multiple rentals.
Chart of Accounts for Rental Properties
Your chart of accounts is the list of categories you use to classify every financial transaction. For rental properties, the most effective approach is to align your categories directly with IRS Schedule E lines. This eliminates the need to reclassify expenses at tax time.
Recommended Chart of Accounts
Income Categories
- •Rent income
- •Late fees
- •Pet fees / pet rent
- •Application fees
- •Other income (parking, storage, laundry)
Expense Categories (Schedule E)
- •Advertising (Line 5)
- •Auto and travel (Line 6)
- •Cleaning and maintenance (Line 7)
- •Insurance (Line 9)
- •Legal and professional (Line 10)
- •Management fees (Line 11)
- •Mortgage interest (Line 12)
- •Repairs (Line 14)
- •Supplies (Line 15)
- •Taxes (Line 16)
- •Utilities (Line 17)
- •Depreciation (Line 18)
- •Other: HOA, pest control, software (Line 19)
Tracking Rental Income by Source
Rental income comes from multiple sources, and tracking each source separately gives you a clearer picture of your revenue. Here are the most common income sources and how to record them:
- •Monthly rent: Record each rent payment with the date received, amount, and tenant name. If a tenant pays $2,000 per month, you should see 12 entries totaling $24,000 for the year. Note any partial payments or missed months.
- •Platform income (Airbnb, Vrbo): Record the gross booking amount before platform fees. If Airbnb shows a payout of $290 after their 3% host fee, the gross income is $299.18. Record $299.18 as income and $9.18 as a platform fee expense (Line 19). Download your annual earnings summary from each platform for easy reconciliation.
- •Late fees: A $50 late fee is taxable income. Record it separately from rent so you can track how often tenants pay late.
- •Pet fees and pet rent: A one-time $300 pet fee or a recurring $50 per month pet rent is taxable income. Do not confuse pet deposits (refundable) with pet fees (non-refundable). Only non-refundable amounts are income.
- •Security deposits: A security deposit is not income when you receive it (assuming you hold it for the tenant). It becomes income only if you keep part or all of it for damages or unpaid rent at move-out.
The total of all income sources is what you report on Schedule E, Line 3. For our example property, this might be $24,000 in rent plus $600 in pet rent plus $100 in late fees, totaling $24,700 in gross rental income.
Tracking Expenses by Schedule E Category
Every expense should be categorized at the time you record it. Waiting until year-end to categorize hundreds of transactions is inefficient and error-prone. Here are the most common expense categories with examples and tips:
- •Repairs (Line 14): Only expenses that restore the property to its original condition qualify. Examples: fixing a leaky faucet ($150), replacing a broken dishwasher part ($85), patching drywall ($200), fixing a running toilet ($120). If an expense adds value or extends useful life, it is a capital improvement and goes on Line 18 as depreciation instead.
- •Cleaning and maintenance (Line 7): Turnover cleaning between tenants ($200 to $400), lawn mowing service ($150 per month), gutter cleaning ($150 twice per year), HVAC filter changes and tune-ups ($200 per year), snow removal ($100 per occurrence).
- •Mortgage interest (Line 12): Record the interest portion only (from your Form 1098). On a $240,000 loan at 7%, first-year interest is approximately $16,500. Do not include the principal portion, which is not deductible.
- •Insurance (Line 9): Annual landlord policy ($1,400), umbrella liability policy allocation ($200 per property), flood insurance ($800 if in a flood zone).
- •Property taxes (Line 16): Record the actual amount paid during the year, which may differ from the amount assessed. If you pay $3,600 per year in two installments, record each $1,800 payment when it is made.
- •Utilities (Line 17): Water ($80 per month), sewer ($40 per month), trash ($30 per month), internet for common areas ($60 per month). Only include utilities you pay as the landlord, not those paid by tenants.
- •Supplies (Line 15): Smoke detector batteries ($20), cleaning products ($100), paint for touch-ups ($75), replacement light fixtures ($60), new door locks at turnover ($150).
For the full list of deductions with dollar examples, see our 25 rental property tax deductions guide.
Try it yourself:
Exclude mortgage and depreciation
Spreadsheet vs. Software: Which Is Right for You?
Both spreadsheets and dedicated software can work for landlord bookkeeping. The right choice depends on your portfolio size, technical comfort, and how much time you want to spend on record keeping.
| Feature | Spreadsheet | RentalReportLab |
|---|---|---|
| Cost | Free | Free (1 property), $9/mo Pro |
| Schedule E mapping | Manual setup required | Built in automatically |
| Depreciation calculation | Manual formula needed | Auto-calculated (27.5 years) |
| Receipt storage | Separate folder needed | Photo upload per transaction |
| PDF reports | Manual formatting | One-click generation |
| CPA sharing | Email attachment | Secure share link |
| Multi-property tracking | Separate tabs/files | Built-in property selector |
| Error risk | Formula errors common | Automated calculations |
If you have one property and are comfortable with Excel or Google Sheets, a spreadsheet is a reasonable starting point. Once you add a second or third property, the time spent maintaining spreadsheets typically exceeds the cost of dedicated software. RentalReportLab is free for one property, so there is no risk in trying it before committing to a paid plan.
The Monthly Bookkeeping Routine
Consistency is the key to good bookkeeping. Set aside 30 to 60 minutes on the first of each month (or the last day of the previous month) to complete these tasks:
- •Record all income: Log every rent payment, late fee, and other income received during the month. Verify that the total matches your bank deposits.
- •Categorize all expenses: Review your bank and credit card statements for property-related charges. Categorize each one to the correct Schedule E line. Common items: mortgage payment (split interest to Line 12), insurance auto-pay (Line 9), utility bills (Line 17).
- •Upload receipts: Photograph or scan any paper receipts from the month and attach them to the corresponding transaction. Do this promptly; paper receipts fade within a year.
- •Reconcile with bank statement: Compare your recorded transactions to your bank statement. Every deposit and withdrawal should be accounted for. Flag any discrepancies for investigation.
- •Review your P&L: Look at your month-to-date and year-to-date profit and loss. Are expenses trending up? Did you miss a rent payment? Is your NOI on track? Catching issues early prevents surprises at tax time.
- •Update mileage log: If you drove to the property during the month, record each trip with the date, destination, purpose, and miles. The 2026 IRS rate is $0.70 per mile.
This monthly routine takes 30 minutes per property once you have a system in place. It saves hours of scrambling during tax season and ensures you never miss a deduction.
Year-End Checklist
Complete these tasks in January to prepare for tax filing:
- •Reconcile December: Complete your final monthly reconciliation for the year. Ensure every transaction from January through December is recorded and categorized.
- •Verify total income: Compare your tracked income total to your bank deposit total for the year. They should match. If they do not, investigate the difference.
- •Issue 1099 forms: If you paid any contractor (plumber, electrician, handyman, property manager) $600 or more during the year, you must issue them a Form 1099-NEC by January 31.
- •Collect tax documents: Gather Form 1098 (mortgage interest), property tax statements, insurance premium summaries, and 1099-K forms from rental platforms.
- •Calculate depreciation: Update your depreciation schedule for the current year, including any new capital improvements placed in service. RentalReportLab does this automatically.
- •Generate your annual report: Create a year-end P&L report for each property showing income, expenses by Schedule E category, and net income or loss. This is the report you hand to your CPA or use to fill out Schedule E yourself.
- •Review for missed deductions: Scan your credit card and bank statements one more time for any property-related charges you may have missed. Common overlooked items include software subscriptions, mileage, and small supply purchases.
Record Retention Rules
The IRS has specific requirements for how long you must retain financial records. Falling short can leave you unable to substantiate deductions during an audit. Here is a summary of retention periods:
- •Income and expense records: Keep for 3 years after filing the tax return for that year. If you file your 2026 return in April 2027, keep records until at least April 2030.
- •Employment tax records: Keep for 4 years after the tax becomes due or is paid, whichever is later.
- •Property purchase documents: Keep for the entire time you own the property plus 3 years after selling it. These documents establish your cost basis and are essential for calculating depreciation and capital gains.
- •Capital improvement records: Same as property purchase documents. Each improvement adds to your depreciable basis and affects your gain or loss at sale.
- •Prior-year tax returns: Keep indefinitely. They serve as a reference for depreciation schedules, carryforward losses, and basis calculations.
Digital records (scanned receipts, PDF statements, software exports) are accepted by the IRS and are far more practical than paper files. Store backups in cloud storage or on an external drive in case of hardware failure.
Receipt Tips and Best Practices
Receipts are your primary evidence for deductions. Without them, the IRS can disallow expenses during an audit. Follow these best practices to make receipt management effortless:
- •Photograph immediately: Take a photo of every receipt the moment you receive it. Use your phone camera or a scanning app. Paper receipts printed on thermal paper fade within 6 to 12 months.
- •Include key details: Make sure the receipt shows the vendor name, date, amount, and a description of what was purchased. If the receipt is vague (like a hardware store receipt for $47.82), write a note on it before photographing: "Replacement faucet cartridge for Unit 3B."
- •Attach to transactions: Link each receipt photo to its corresponding expense entry. RentalReportLab lets you upload a receipt image directly to each transaction, so everything stays connected.
- •Use email receipts: For online purchases (Amazon, Home Depot online orders, software subscriptions), save the confirmation email or download the invoice PDF. These are generally more reliable than paper receipts.
- •Back up everything: Store receipt images in at least two locations: your tracking software plus a cloud backup (Google Drive, iCloud, Dropbox). Do not rely on a single storage location.
When to Hire a CPA
Many landlords with one or two properties handle their own bookkeeping and tax filing. However, there are situations where hiring a CPA who specializes in rental property is well worth the $300 to $1,000 fee:
- •You own three or more rental properties
- •You sold a property during the year and need to calculate depreciation recapture and capital gains
- •You are considering a 1031 exchange
- •You have complex ownership structures (LLC, partnership, S corp)
- •You qualify or want to qualify as a real estate professional for tax purposes
- •You received an IRS notice or are being audited
Even if you hire a CPA, keeping clean books throughout the year reduces their billable hours and your overall cost. A CPA who receives a well-organized P&L report from RentalReportLab can complete your return faster, saving you money on preparation fees.
This guide is for informational purposes only and does not constitute tax, legal, or financial advice. Tax laws change frequently. Consult a qualified CPA or tax professional for guidance specific to your situation.
