How do I set up bookkeeping for rental properties?
Start with a dedicated bank account for your rental activity. Mixing rental income and expenses with personal transactions creates confusion at tax time and makes it nearly impossible to see how individual properties are actually performing. If you have multiple properties, you can use one account for all of them as long as your bookkeeping tracks each property separately.
Set up per-property tracking in your accounting software. In QuickBooks, this means using classes or locations to tag every transaction to a specific property. When you receive rent from 123 Main Street, it gets coded to that property. When you pay for repairs at 456 Oak Avenue, that expense goes to that property. At year end, you can pull a profit and loss statement for each property individually, which is exactly what you need for Schedule E.
Your chart of accounts should mirror Schedule E categories since that’s where rental income and expenses land on your tax return. Create income accounts for rent, late fees, and other income. Create expense accounts for advertising, auto and travel, cleaning and maintenance, insurance, legal and professional fees, management fees, mortgage interest, repairs, supplies, taxes, and utilities. This structure means your financial reports translate directly to your tax form.
Handle security deposits correctly. A security deposit is not income when you receive it. It’s a liability because you owe that money back to the tenant unless they damage the property. Record deposits received as a credit to a Security Deposits liability account. When a tenant moves out and you return the deposit, debit that liability account. If you keep part of the deposit for damages, that portion becomes income at that point.
Track the difference between repairs and improvements. Repairs maintain the property in its current condition and are fully deductible in the year paid. A new water heater to replace a broken one is a repair. Improvements add value or extend the property’s life and must be depreciated over time. A kitchen renovation is an improvement. Getting this wrong means either overstating deductions or missing deductions you’re entitled to.
Create a monthly routine for your rental bookkeeping. Reconcile your bank account, categorize all transactions, and review your rent roll against deposits received. Tenants who pay late or skip payments show up quickly when you’re checking monthly. A bookkeeper for real estate investors can handle this routine for you and catch issues before they become problems.
If you’re managing rental properties in New Mexico, remember that rental income may be subject to Gross Receipts Tax depending on your situation. Most residential long-term rentals qualify for deductions, but commercial rentals and short-term vacation rentals have different rules. Make sure your bookkeeping captures the information you need for GRT reporting alongside your federal tax requirements.
QuickBooks works well for rental property bookkeeping once it’s configured properly. The key is setting up classes for each property and building a chart of accounts that matches your tax reporting needs. Property management software like Buildium or AppFolio includes bookkeeping features, but those tools work better when you have many units. For a few properties, QuickBooks handles the job and keeps everything in one system.
Santa Fe's Small Business Bookkeeper
The Next Step:
A Quick Conversation
Tell us about your business and what you're dealing with. We'll listen, ask a few questions, and give you a straightforward quote.
More Questions
Should I hire a bookkeeper for my vacation rental business?
If you manage multiple properties or find yourself spending hours each month sorting through platform payouts, a bookkeeper is worth considering. The complexity of tracking revenue by property, reconciling different platforms, and handling New Mexico's Gross Receipts Tax usually exceeds what most owners want to manage themselves.
Read answerHow do I track material costs by job in QuickBooks?
Enable project tracking in QuickBooks and assign every material purchase to the correct job when you enter it. The setup takes minutes. The discipline of coding every purchase consistently is what actually makes it work.
Read answerWhat reports should a construction company run monthly?
Construction companies need job cost reports, work in progress reports, AR aging, and profit and loss by job. These reports show profitability by project instead of just overall revenue.
Read answerDo I need to track mileage for rental property visits?
Yes, if you want to claim the deduction. Rental property mileage is deductible for trips like collecting rent, maintenance visits, and tenant showings. The IRS requires a log of each trip with date, purpose, and miles.
Read answerHow do I categorize rental property expenses for taxes?
Rental property expenses fall into specific categories on Schedule E. The main ones are mortgage interest, property taxes, insurance, repairs, and professional services. Getting the repair versus improvement distinction right matters most.
Read answerShould I use QuickBooks or property management software?
Property management software handles operations like tenant tracking and rent collection. QuickBooks handles actual accounting and financial reporting. Many property managers use both, with PM software syncing to QuickBooks for clean books.
Read answer



