Real Estate Bookkeeping: How Houston Property Investors Keep Their Numbers Straight

An investor walked into our office with eight rental properties spread across Montrose, the Heights, and Katy. He’d been tracking everything in one giant spreadsheet — rental income, repairs, mortgage payments, property taxes, insurance — all of it lumped together. When I asked him which property was actually making money and which was bleeding cash, he couldn’t tell me. He just knew the total bank balance was going up, so things felt okay.

Real estate bookkeeping is a different animal from standard small business accounting. Every property is its own profit center with its own income, expenses, depreciation schedule, and tax implications. Mix them together and you lose the information that drives every important decision: which properties to keep, which to sell, when to refinance, and whether that next acquisition makes financial sense.

Here’s how we set up the books for Houston real estate investors so every property tells its own story.

Property-by-Property Tracking: The Foundation

The first rule of real estate bookkeeping is that every property gets its own set of accounts. In QuickBooks, this means using class tracking or location tracking so every transaction — every rent payment received, every repair invoice, every property tax payment — is tagged to a specific property.

This is how you build a property-by-property P&L. When a Heights duplex shows $2,400/month in rental income but $2,100/month in expenses (mortgage, insurance, taxes, maintenance), you can see the $300/month cash flow without it being hidden behind the stronger performance of your Katy single-family rental.

Some investors use separate bank accounts for each property. Others use one operating account with class tracking. Either works. What doesn’t work is running all eight properties through a personal checking account with no categorization. I see this constantly, and it always ends the same way: a tax season scramble where we’re reverse-engineering 12 months of mixed transactions.

Income Tracking: More Than Just Rent

Rental income seems straightforward — tenant pays rent, you record it. But real estate income has several components that need separate tracking:

Base rent. The monthly lease amount.

Late fees. Taxable income. Record separately from rent because it helps you spot collection problems. If you’re booking $500/month in late fees across your portfolio, that’s a management issue, not a revenue stream.

Security deposits. These are NOT income when received. Security deposits are a liability — you’re holding someone else’s money. They become income only if you keep a portion for damages when the tenant moves out. Recording security deposits as income when received is one of the most common real estate bookkeeping errors, and it inflates your taxable income in the year you collect them.

Laundry and parking income. If your Montrose fourplex has coin laundry or rented parking spots, that’s separate income to track.

Reimbursements. If tenants pay utilities and reimburse you, the reimbursement offsets the utility expense, not adds to rental income. The distinction matters for tax reporting.

Expense Categories That Actually Help

A generic “Repairs & Maintenance” category tells you nothing useful. Here’s what works for real estate:

Repairs and maintenance. Routine fixes — plumbing, electrical, appliance repair, pest control. These are fully deductible in the year incurred.

Capital improvements. New roof, HVAC replacement, kitchen renovation, adding a room. These are NOT immediately deductible. They get added to the property’s cost basis and depreciated over time. The distinction between a “repair” and an “improvement” is one of the most audited areas for rental property owners. In general: if it restores the property to its existing condition, it’s a repair. If it improves, adapts, or extends the property’s useful life, it’s an improvement.

Property management fees. If you use a management company (common for investors who own properties in multiple neighborhoods), their fees are deductible. Usually 8-12% of collected rent.

Insurance. Landlord policies, umbrella coverage, flood insurance (a real consideration for Houston properties, especially in the Heights and Meyerland).

Property taxes. Harris County, Fort Bend County, and Brazoria County all have different rates. Track by property and by jurisdiction.

HOA fees. Common for condos and some townhome rentals in areas like Midtown and the Galleria.

Travel. Driving to properties for inspections, meeting contractors, showing units. Track mileage by property. The IRS allows $0.70 per mile in 2026 for business use.

Professional services. Legal fees (evictions, lease review), accounting fees, real estate attorney consultations.

Depreciation: The Tax Benefit That Confuses Everyone

Depreciation is the single biggest tax advantage of owning rental property. The IRS lets you deduct the cost of the building (not the land) over its useful life: 27.5 years for residential rental property, 39 years for commercial.

Buy a rental property for $300,000. The land is worth $60,000 (based on the county appraisal or an allocation at purchase). The building is worth $240,000. Divide $240,000 by 27.5 years and you get $8,727 per year in depreciation deductions — a paper expense that reduces your taxable income without costing you a dime in cash.

That means a property generating $3,600/year in cash flow after all expenses could show a tax loss of over $5,000 ($3,600 minus $8,727 in depreciation). That loss can offset other rental income or, depending on your income level and participation, even offset W-2 income.

Cost segregation studies. For higher-value properties, a cost segregation study breaks the building into components (appliances, flooring, landscaping, parking lots) and assigns shorter depreciation periods (5, 7, or 15 years instead of 27.5). This front-loads your depreciation deductions. A cost segregation study on a $500,000 commercial property in the Energy Corridor might shift $80,000-$120,000 of the building cost into shorter-lived categories, dramatically increasing your deductions in the early years of ownership.

These studies cost $3,000-$10,000 depending on property complexity, so they’re typically worth it for properties valued above $500,000 or portfolios above $1 million.

1031 Exchanges: Deferring Taxes on a Sale

Section 1031 of the tax code allows you to defer capital gains tax when you sell a rental property and reinvest the proceeds into a “like-kind” replacement property. For Houston investors sitting on significant appreciation — especially in neighborhoods like Montrose and the Heights where values have doubled in a decade — this is a powerful tool.

The rules are strict:

45-day identification window. After selling, you have 45 days to identify potential replacement properties in writing. Not 46 days. Not “we’re still looking.” Forty-five days.

180-day closing deadline. The replacement property must close within 180 days of the sale.

Equal or greater value. To defer the full gain, the replacement property must be equal to or greater in value than the property sold. You must also reinvest all the net proceeds.

Qualified intermediary required. You never touch the sale proceeds. A qualified intermediary holds the funds between the sale and the purchase. If the money hits your bank account, even for a day, the exchange is disqualified.

The bookkeeping for a 1031 exchange is specialized. The cost basis of the replacement property carries over from the original property (adjusted for any boot or additional investment), depreciation schedules reset or carry over depending on the exchange structure, and the documentation requirements are extensive.

We work with 1031 exchange intermediaries regularly and can coordinate the accounting side. The key is involving your accountant before you list the property for sale, not after you’ve already closed.

Trust Accounts and Security Deposits

If you manage your own properties, keeping security deposits in a separate trust account isn’t required in Texas — but it’s a best practice that keeps your books clean and protects you if a tenant disputes their deposit.

Texas law requires returning security deposits within 30 days of move-out, with an itemized list of deductions. If your security deposits are mixed into your operating account and you’ve spent the money, that refund comes out of your operating cash flow. A separate trust account makes the liability visible and the accounting simple.

For property managers, Texas Property Code Section 92.103 requires an accounting of security deposit deductions. Clean bookkeeping makes compliance straightforward. Sloppy bookkeeping makes every move-out a potential dispute.

Bank Reconciliation for Real Estate

Reconciling bank accounts monthly is important for any business. For real estate, it’s critical because you’re dealing with multiple income sources, multiple expense payees, and timing differences that create confusion.

Rent from a Montrose tenant might be paid on the 1st but not deposited until the 3rd. A repair invoice from a Heights plumber might be dated the 28th but the check doesn’t clear until the 5th of the next month. Property tax payments go out semi-annually. Insurance might be paid monthly or annually.

Without monthly reconciliation, you lose track of which expenses have cleared, which rents have actually been collected versus just invoiced, and whether your cash balance reflects reality.

Cash vs. Accrual for Real Estate Investors

Most individual real estate investors use cash basis accounting. It’s simpler — you record income when it hits the bank and expenses when you pay them.

Accrual basis makes more sense for larger portfolios (10+ units) or property management companies. It records rent as income when it’s due (whether or not the tenant has paid) and expenses when incurred (whether or not the bill has been paid). This gives a more accurate picture of financial performance by period but adds complexity.

The IRS allows cash basis for most individual landlords. If you’re operating through an LLC or partnership with gross receipts under $29 million (which covers virtually all small-to-mid-size Houston investors), cash basis is fine.

The 1099 Reporting Obligation

Pay a contractor more than $600 in a year and you’re required to issue them a Form 1099-NEC by January 31 of the following year. For real estate investors who use independent contractors — handymen, electricians, plumbers, landscapers, cleaning crews — this adds up fast.

Keep a W-9 on file for every contractor before you pay them the first time. This is the form that gives you their legal name, address, and tax ID number. Chasing W-9s in January for contractors you paid in March is a miserable experience, and I say that from watching dozens of clients do it every year.

The penalties for failing to file 1099s range from $60 to $310 per form depending on how late you are. For an investor using 15-20 contractors across multiple properties, that’s real money.

When to Bring in a Professional

Self-managing the books works for 1-3 properties if you’re organized and disciplined about recording transactions as they happen. Once you cross 4-5 properties, the volume of transactions, the depreciation tracking, the 1099 obligations, and the multi-property analysis start consuming hours you’d rather spend on acquisitions or property management.

That investor with eight properties across Montrose, Heights, and Katy? It took us about 40 hours to untangle two years of single-spreadsheet accounting, set up proper property-by-property tracking, calculate correct depreciation schedules, and file amended returns for the deductions he’d been missing. His ongoing monthly bookkeeping takes us about 6 hours. The depreciation deductions alone that he’d been missing exceeded the annual cost of our services by a factor of three.

Real estate bookkeeping isn’t complicated when it’s set up right from the beginning. It’s only painful when it’s been done wrong for years and everything has to be reconstructed.