Rentals

A rental property chart of accounts that actually works

Most rental property charts of accounts come in two sizes. One has a dozen vague accounts and tells you nothing at tax time. The other has two hundred accounts nobody keeps up. I’ve kept books for thirty years, a good share of it for landlords and real estate investors, and this is the middle ground I set up in client files. It’s about sixteen accounts, and the expense categories line up with Schedule E.

The full chart

These are the accounts I create in QuickBooks Online for a straightforward rental operation. There’s no account per property. Properties get handled with classes, which I’ll get to below, so the chart stays this size whether you own one door or forty.

AccountTypeWhat goes in it
Rent IncomeIncomeMonthly rent, prorated rent, month-to-month premiums
Late FeesIncomeLate charges and NSF fees collected from tenants
Application FeesIncomeScreening and application fees from prospective tenants
Other Property IncomeIncomeLaundry, storage, pet rent, parking, anything small and miscellaneous
Repairs & MaintenanceExpenseFixes that keep the property in its current condition: leaky faucet, patched drywall, a new door lock
Capital ImprovementsFixed assetWork that adds value or extends the property’s life: new roof, HVAC replacement, an addition. This lives on the balance sheet, and your CPA depreciates it
UtilitiesExpenseWater, sewer, trash, electric, gas you pay as the owner
InsuranceExpenseLandlord policies and umbrella coverage on the properties
Property TaxesExpenseReal estate taxes on the rentals
Management FeesExpenseWhat you pay a property manager, including leasing fees
Landscaping & Snow RemovalExpenseMowing, trimming, plowing, seasonal grounds work
AdvertisingExpenseListing fees, signage, photos, anything spent to fill a vacancy
MileageExpenseVehicle costs for property trips, logged with dates and miles so your CPA can apply the right method
Professional FeesExpenseBookkeeping, legal, CPA, eviction filings
Security Deposits HeldOther current liabilityTenant deposits you’re holding. Money you might have to give back is a debt, so it sits here until you return it or lawfully keep it
Owner Contributions / Owner DrawsEquityMoney you put into the business and money you take out. Keeping these out of income and expense is what keeps the P&L right

Security deposits are not income

This is the mistake I correct most often in rental cleanups. A deposit check arrives, it gets categorized as rent, and the books overstate income all year while hiding a debt. A security deposit is money you’re holding that probably goes back to the tenant, so it belongs in the Security Deposits Held liability account the day it arrives.

When the tenant moves out, one of two things happens in the books. You return the deposit and the liability clears to zero. Or you lawfully keep part of it, and that part moves out of the liability, either to income or against the repair cost it covered. Every state sets its own deadline for returning deposits after move-out, along with rules about itemizing what you kept, and your attorney can confirm the specifics for your state and your situation. From the bookkeeping side, a clean liability account tells you at any moment whose money you’re holding and how much.

One property or twenty: classes and locations

The chart stays small because QuickBooks Online has classes, which beat cloning accounts for every address. In QBO Plus and above, I set up one class per property, then tag every transaction with its property as it comes in, income and expense alike. From there, one report, Profit and Loss by Class, puts each property in its own column, side by side, with a total column at the end.

That report tells you which property actually makes money, which one eats every dollar it brings in, and how the whole thing did. Some bookkeepers use locations instead of classes, which works fine too; the principle is the same. Pick one, tag everything, and don’t let a transaction into the file without a property on it. Anything you leave untagged, somebody has to go back and sort out later.

Want this set up in your file?

It’s part of every rental cleanup I do: the chart, the classes, the deposit liabilities, all built into your QuickBooks Online file with your history recategorized to match. You get the price in writing after a free review.

Set up my free call

Repairs or improvements?

The line between Repairs & Maintenance and Capital Improvements matters more than any other call in rental bookkeeping, because it decides whether a cost comes off this year’s taxable income or gets spread over years of depreciation. My working rule when I keep the books: fixing what broke and putting the property back the way it was is a repair. Replacing a major system, upgrading, or adding years to the property’s life goes on the balance sheet as an improvement. Anything in between, a new furnace, a partial re-roof, I flag for the CPA, because depreciation method and the tax rules around it are squarely their call. My job is making sure they can see every one of those costs instead of finding them buried in a catch-all account.

If you manage properties for other owners

All of that assumes you own the rentals. Managing property for somebody else, collecting their rent and holding their funds, is a different job. Owner money stays separate from your money, in the books and usually in the bank, and every owner gets a statement that reconciles to the penny. That’s more than one paragraph, so I wrote up how I handle it on my property management bookkeeping page. If that’s your world, start there. At year-end, my checklist for property managers covers the trust side.

Questions

Questions I hear a lot

Can I import this chart into QuickBooks Online?
Yes. Put the account names and types in a simple spreadsheet, then use Settings, Chart of Accounts, and the import option to bring them in at once. You can also add them one at a time in about fifteen minutes. Either way, do it before you start categorizing transactions, not after.
Do I need a separate bank account for every property?
You need at least one dedicated business account, separate from personal, full stop. Per-property bank accounts are optional; classes in QuickBooks Online usually do that job with less upkeep. The exception is money you hold for other people, like tenant deposits or owner funds, which belongs in its own account, always.
Does this chart map to Schedule E?
Yes. That’s the point of it. The expense categories line up with the lines your CPA fills in on Schedule E, so tax time is a handoff instead of a translation job. Your CPA still makes the calls on depreciation and anything borderline.
Reviews

From a Google review

5 out of 5 stars

Accurate, detailed and personable; three of many qualities that Diane brings to the table every single day. There is no one I would trust more than Diane with my bookkeeping.

Brady R · Google review
5 out of 5 stars

Diane is very competent and dependable. She has been working in the bookkeeping, finance, and records area for many years and does great work. Her services are recommended.

Nik J · Google review

Sound like your books?

Tell me what you’re seeing, and on a free 30-minute call I’ll tell you plainly what it’ll take to fix.

I call you myself. I’ll only use your number to call you back about this request. You don’t need to find anything first.

A rough guess is fine, even if it’s been years.

If it was your CPA, tell me who. I can send your finished file straight to them.

Please don’t include account numbers, Social Security numbers or passwords. I’ll ask for what I need on a secure call.

I’ll call you back within 15 to 20 minutes during the day. No obligation. Or call me now at (417) 323-2629. How I handle your details

I’ve worked in accounting and bookkeeping for 30+ years, and I’m a Certified QuickBooks ProAdvisor. You can read my Google reviews.

I’m a bookkeeper, not a tax preparer or attorney. For tax and legal questions, confirm the details with your CPA. I keep the books that make their job easier.

Wondering how this applies to your own books?

You can leave the free call with a price range if you send three to six months of bank and credit card statements ahead of time. If the range works for you, the fixed price comes next, in writing.

I call you myself. I’ll only use your number to call you back about this request. You don’t need to find anything first.

Please don’t include account numbers, Social Security numbers or passwords. I’ll ask for what I need on a secure call.

I’ll call you back within 15 to 20 minutes during the day. No obligation. Or call me now at (417) 323-2629. How I handle your details

I’ve worked in accounting and bookkeeping for 30+ years, and I’m a Certified QuickBooks ProAdvisor. You can read my Google reviews.

Want a second set of eyes on your books?

On a free 30-minute call, you’ll hear plainly what shape your books are in and what I’d recommend. You don’t sign or owe anything unless you decide to go ahead.

I’ll call you back within 15 to 20 minutes during the day.