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
How do I set up job costing for my construction business?
Job costing tracks every cost against the specific project that incurred it so you know which jobs make money. Setup requires defining cost categories, configuring your accounting software for project tracking, and establishing consistent processes for capturing labor and expenses.
Read answerWhat expenses can artists deduct on their taxes?
Artists can deduct materials, studio space, equipment, marketing costs, show fees, travel, and professional development. The key is running your art practice as a business and tracking expenses as they happen.
Read answerHow do I handle occupancy taxes for vacation rentals?
New Mexico vacation rentals face state lodgers' tax at 5% plus local taxes that vary by city. You need to register with state and local authorities, track taxes collected as a liability in your books, and verify what platforms like Airbnb actually remit on your behalf.
Read answerHow do HVAC contractors track service calls and installations?
Service calls get tracked by category and department metrics, while installations need project-level job costing. The two types of work have different financial characteristics and require different tracking approaches to understand profitability.
Read answerWhat happens if I file my GRT return late?
New Mexico charges a 2% penalty per month on unpaid GRT, capped at 20% of the tax due. Interest also accrues on the balance. The sooner you file, the less you'll pay in penalties.
Read answerHow do I separate gallery sales from secondary market purchases?
Set up separate income and cost of goods sold accounts for each revenue stream. Consignment sales and secondary market purchases have different accounting treatment because of how you acquire the work and what you owe when it sells.
Read answer
