5 Common Problems and Their Fixes for Landlord Chart of Accounts

Updated: Nov 7
If you own rental property, you already know how to spot a good deal. You know how to screen tenants, negotiate with contractors, and keep units filled. But can you look at your books right now and say which of your properties made money last year?
Most landlords can't. And it's usually not because they're bad with money. It's because their chart of accounts was never built for a rental business.
Your chart of accounts is the list of categories every dollar in your books flows through. Get it right, and your reports tell you exactly how your portfolio is performing. Get it wrong, and you're stuck with messy books, a stressful tax season, and decisions made on gut feeling.
At Okie Accounting Group, we review a lot of rental property books. The same five mistakes show up again and again. The good news? Every one of them can be fixed. And if you'd rather have a professional fix them with you, we're here to help.
Here are the five most common problems we see in landlord bookkeeping, and how to fix each one.
Problem 1: Personal and Rental Transactions Are Mixed Together
Why It Matters
Most landlords start small. One rental house. Maybe the home you kept when you moved. The rent goes into your personal checking account. The plumber gets paid with your personal credit card. It feels simple.
Then you buy a second property. Then a third.
Suddenly, your personal bank statements are a mix of groceries, family trips, rent payments, property tax bills, and a new water heater. Sorting that out at year-end takes hours. It's easy to miss deductions you're entitled to. It's just as easy to claim ones you aren't.
There's a legal risk too. If your rentals are held in an LLC, mixing personal and business funds can weaken the liability protection the LLC is supposed to give you. Courts look at whether you actually treated the business as separate. A shared bank account suggests you didn't.
The Fix
Here's how to separate the two for good:
Open a dedicated bank account. Every rent payment goes into it. Every rental expense comes out of it. If you own properties through more than one entity, give each entity its own account.
Get a dedicated credit card. Use it only for rental expenses, so you're never sorting card charges at tax time.
Add equity accounts. Set up Owner Contributions and Owner Draws in your chart of accounts. When you move personal money into the rental account to cover a big repair, that's an Owner Contribution. When you pay yourself from rental profits, that's an Owner Draw. Neither one is income or an expense. They simply track money moving between you and your business.
One caution. If your rentals are held in an S corporation or a multi-member partnership, the equity side works differently. Distributions and partner capital accounts take the place of simple draws, and those are worth setting up with a professional.
Once your money is separated, your QuickBooks bank feeds become far more useful. Everything coming through belongs to the business. That's the first real step toward clean real estate investor bookkeeping.
Problem 2: No Way to Track Profitability by Property
Why It Matters
Plenty of rental books have one "Rental Income" account and one "Repairs" account. Every property's rent lands in the first. Every property's repair bill lands in the second.
The totals look fine. But they can't answer the question every investor should be asking: which of my properties is actually making money?
That's a problem for two reasons. First, you can't make smart decisions about raising rents, refinancing, or selling an underperformer. Second, the IRS requires you to report income and expenses for each rental property separately on Schedule E. If your books lump everything together, someone has to go back and split the whole year by hand. That someone is usually paid by the hour.
The Fix
The answer is tracking expenses by property. QuickBooks for rental properties gives you a few ways to do it:
Classes or Locations. QuickBooks Online Plus and Advanced let you turn on class tracking, location tracking, or both. A common setup is one Class per property. You tag every transaction with its property, then run a Profit and Loss by Class report to see each property's results side by side. If you own properties across several entities, Locations can represent the entity while Classes represent the individual properties. Keep in mind that Simple Start and Essentials don't include class or location tracking, which is one reason many landlords need Plus.
Property-level sub-accounts. If you own just two or three properties, sub-accounts like "Rental Income: 123 Main St" and "Rental Income: 456 Oak Ave" can work. But this gets messy fast. Once you're past a few doors, Classes are the better choice.
There's a second half to this fix, and it's just as important. Build your expense accounts to mirror the Schedule E expense categories. Schedule E lists specific expense lines: advertising, auto and travel, cleaning and maintenance, commissions, insurance, legal and other professional fees, management fees, mortgage interest paid to banks, other interest, repairs, supplies, taxes, utilities, depreciation, and other expenses.
When your chart of accounts uses those same categories, your year-end Profit and Loss by Class report lines up directly with each property's column on Schedule E. Your tax preparer gets a clean report instead of a shoebox. You pay less for tax prep.
And you don't have to wait until April to benefit. Good rental income tracking lets you catch problems mid-year. A property whose utility bill suddenly doubled. A unit that's been vacant longer than you realized. You see it while you can still do something about it.
Problem 3: Security Deposits Are Recorded as Income
Why It Matters
A new tenant signs the lease and hands you first month's rent plus a security deposit. You deposit it all and record it as rental income. Simple, right?
Not quite. A refundable security deposit isn't your money. You're holding it for the tenant, and you'll most likely owe it back when they move out.
Recording deposits as income overstates your revenue. That can mean paying tax on money that was never yours. It also hides a real debt. Ten tenants with $1,500 deposits each means you owe $15,000 back to tenants. Your books should show that.
The Fix
Proper tenant security deposit accounting comes down to a few steps:
Create a liability account. Name it something like Tenant Security Deposits Held. When you collect a deposit, record it here, not in income. When you refund it, the payment reduces the liability.
Reclassify only what you keep. The IRS addresses this in Publication 527. You don't include a security deposit in income when you receive it if you plan to return it at the end of the lease. If you keep part or all of it because the tenant didn't meet the lease terms, such as damage beyond normal wear and tear or unpaid rent, you include the amount you keep in income for that year. That's when you move the retained amount from the liability account into income.
Watch for "deposits" that are really rent. If a deposit is meant to be used as the tenant's final month's rent, the IRS treats it as advance rent. Advance rent is income in the year you receive it, no matter what period it covers. How your lease describes the payment matters.
Check your state's rules. Some states require landlords to hold security deposits in a separate account. Some require you to pay interest to the tenant. Oklahoma, for example, requires security deposits to be held in an escrow account at a federally insured financial institution located in the state. Rules vary widely, so confirm your state's requirements with a qualified attorney. If your state requires a separate account, add that bank account to your books so the cash and the liability always match.
Problem 4: Capital Improvements Are Expensed as Repairs
Why It Matters
A new roof. A new HVAC system. A full kitchen remodel. These bills are big, and it's tempting to drop them into "Repairs & Maintenance" and take the whole deduction this year.
But the tax rules don't allow that for capital improvements. Expensing them anyway overstates your expenses in one year, understates your profit, and leaves out depreciation you're required to take. It can also raise questions if your return is ever examined.
Knowing the difference between capital improvements vs repairs is one of the most important skills in rental property accounting.
The Fix
Start with the right fixed asset accounts:
Land. Record land separately, because land is never depreciated. When you buy a rental, the purchase price has to be split between land and building. Your county's property tax assessment is one common way to support that split.
Buildings. This holds the cost of the structure itself. Residential rental buildings are generally depreciated over 27.5 years using the straight-line method under the General Depreciation System.
Improvements. This holds capital improvements made after you buy the property. Improvements to a residential rental building are generally depreciated over the same 27.5 years, though some items, like appliances and carpeting used in the rental, have shorter recovery periods.
Accumulated Depreciation. This contra-asset account tracks the depreciation you've taken to date. Each year, you record Depreciation Expense, which maps to the Schedule E depreciation line, and offset it to Accumulated Depreciation.
Next, use the IRS tangible property rules to decide what to expense and what to capitalize. In general, you must capitalize costs that result in a betterment (making the property better than it was), a restoration (returning it to working order after major deterioration, or replacing a major component), or an adaptation (changing it to a new use). A new roof or full HVAC replacement usually falls here.
Several safe harbors can help you deduct smaller costs right away:
De minimis safe harbor. If you don't have an applicable financial statement (most landlords don't), you can deduct items costing up to $2,500 per invoice or per item. The limit is $5,000 if you do have one. You have to elect this safe harbor each year by attaching a statement to a timely filed return.
Routine maintenance safe harbor. You can deduct recurring work you reasonably expect to do more than once during a ten-year period for a building, such as servicing equipment or replacing worn parts, as long as it keeps the property in ordinary operating condition.
Safe harbor for small taxpayers. If your building's unadjusted basis is $1 million or less and your average annual gross receipts are $10 million or less, you may be able to deduct repairs and improvements, as long as the year's total doesn't exceed the lesser of $10,000 or 2% of the building's unadjusted basis.
These rules have real nuance. Review big projects with your tax professional before you book them. When rental property depreciation is set up correctly, your books show the true value of your assets and the true profit of your business.
Problem 5: Mortgage Payments Are Recorded as a Single Expense
Why It Matters
Your mortgage payment leaves your account as one amount each month. So it's natural to record the whole thing as an expense.
But that one payment is usually three different things: principal, interest, and escrow for property taxes and insurance. Only some of those are expenses.
Expense the full payment, and your expenses are overstated while your profit looks lower than it really is. Meanwhile, your balance sheet still shows the original loan amount, even after years of payments. Lenders, partners, and buyers will want accurate loan balances. Your tax return depends on reporting interest correctly.
The Fix
Good mortgage principal and interest bookkeeping starts with a Mortgage Payable liability account for each property's loan. Name each one clearly, like "Mortgage Payable: 123 Main St," so every property's debt stands on its own.
Then split every payment into its parts:
Principal. This reduces the Mortgage Payable liability. It isn't an expense. You're paying back money you borrowed.
Interest. This goes to Mortgage Interest Expense, which maps to the Schedule E mortgage interest line. Your lender's annual Form 1098 shows the interest you paid, which makes it a handy check against your books.
Escrow. The cleanest method is to record escrow deposits to an Escrow asset account, then move amounts to Property Tax Expense and Insurance Expense when the lender actually pays those bills. Here's why that matters: property taxes and insurance paid through escrow are deductible when the lender pays them, not when you deposit money into escrow. Your lender's annual escrow statement shows what was paid and when. Some landlords with steady escrow amounts book the escrow portion straight to the expense accounts each month and adjust at year-end. That works, but the Escrow asset method gives you a more accurate picture.
To keep this manageable in QuickBooks, use your lender's amortization schedule to set up a recurring journal entry or bank rule for each loan. Check it against your mortgage statements now and then. Escrow amounts change when taxes or premiums change.
What a Clean Chart of Accounts Gets You
Fix these five problems, and your rental property chart of accounts starts working for you instead of against you.
Separate money. Your rental activity runs through its own accounts, with equity accounts tracking what you put in and take out.
Property-level clarity. Every transaction is tagged by property, and your expense accounts line up with Schedule E.
Honest liabilities. Security deposits sit in a liability account, and every mortgage shows its true balance.
Accurate assets. Land, buildings, and improvements are recorded as fixed assets, with depreciation tracked correctly.
The result is property management accounting you can actually use. You can see which properties are pulling their weight. You can plan for big repairs. You can walk into a lender's office with confidence. And you can hand your tax preparer clean reports at year-end.
One honest note: tax rules change, and every investor's situation is different. This article is general education, not tax or legal advice. For decisions about depreciation, entity structure, or your state's deposit laws, work with a qualified professional who knows your full picture.
The Next Step
Knowing what's wrong with your books is a good start. Fixing it is what actually pays off.
You built your portfolio to grow your wealth, not to spend your evenings untangling transactions. If your books have any of the problems above, or you're not sure whether they do, that's exactly where we come in.
At Okie Accounting Group, we specialize in bookkeeping for real estate investors. As QuickBooks ProAdvisors, we'll review your current setup, rebuild your chart of accounts the right way, clean up past records, and keep your books accurate going forward. That way, you always know how each property is performing.
Let's talk about where your books are today and where you want them to be.



Comments