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
What is the difference between GRT and sales tax?
Sales tax is imposed on the buyer and collected by the business. Gross Receipts Tax is imposed on the business itself for the privilege of doing business in New Mexico. This distinction affects how you price, invoice, and report.
Read answerHow do I handle payroll taxes in New Mexico?
Register with the IRS for an EIN and with New Mexico agencies for withholding and unemployment. You'll withhold federal and state income taxes plus FICA, then file and deposit on schedule.
Read answerWhat is the best bookkeeping software for truckers?
The best software depends on your operation size and tracking needs. QuickBooks works well for core bookkeeping, though you may need trucking-specific apps for IFTA tracking and load profitability. What matters most is picking something you'll actually use consistently.
Read answerHow do I calculate cost per mile for my trucking business?
Add up every expense tied to running your truck and divide by total miles driven. The challenge is capturing all costs, not just the obvious ones like fuel and maintenance.
Read answerWhat records do truck drivers need to keep for taxes?
Owner-operators need to track fuel purchases with state-by-state details, mileage logs, maintenance receipts, meals and lodging, tolls, equipment purchases, and all licensing costs. Company drivers have far less to track since most employee deductions disappeared in 2017.
Read answerHow do I track subcontractor costs in QuickBooks?
Set up subcontractors as vendors, use projects or classes to assign every bill to a specific job, and enter bills when you receive invoices rather than when you pay. This gives you accurate job costing and simplifies 1099 prep at year end.
Read answer



