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 QuickBooks reports should I run monthly?
At minimum, run your Profit & Loss and Balance Sheet every month. Add Accounts Receivable and Accounts Payable aging reports to catch collection issues and upcoming bills before they become problems.
Read answerHow do I know if my bookkeeper is doing a good job?
Good bookkeeping shows up in reconciled accounts, timely reports you can actually understand, and smooth tax preparation. The clearest sign is whether you can use the numbers to make decisions.
Read answerShould I use QuickBooks Online or Desktop?
For most small businesses starting fresh, QuickBooks Online makes more sense due to cloud access and easier collaboration. Desktop still works better for complex job costing or advanced inventory needs, but Intuit is clearly investing in Online as the future.
Read answerHow do I track inventory for an art gallery?
Track each piece individually with artist, title, medium, acquisition cost or consignment terms, and asking price. Keep consigned work separate from owned inventory since the accounting treatment differs significantly.
Read answerHow do I handle progress billing for construction projects?
Set up billing milestones tied to project phases or completion percentages in your contract. Invoice as each milestone is reached, track retainage separately, and record everything in your accounting system so you know exactly where each project stands financially.
Read answerWhat is the difference between job costing and process costing?
Job costing tracks expenses by individual project or customer. Process costing tracks expenses by department or production phase for companies making identical products in continuous batches. Most small businesses need job costing.
Read answer



