Bookkeeping for Commercial Real Estate: 5 Tips Every Investor Should Know

You have a rent roll to review, a tenant asking about their CAM bill, a lender waiting on year-end financials, and a business of your own to run. Somewhere in that pile is the bookkeeping. If you are like a lot of commercial real estate investors, it is the task that keeps sliding to the bottom of the list.

Here is the problem with that. In commercial real estate, your books are not just a tax-time chore. They are how you know whether a property is actually making money, whether you can refinance, and whether that next acquisition makes sense.

Commercial property bookkeeping is also different from bookkeeping for a typical small business. You are often juggling several LLCs, leases with escalation clauses and expense reimbursements, big capital projects, and loans that come with reporting requirements. One sloppy habit, like paying for a roof repair at Property B out of Property A's account, can ripple into inaccurate financials, missed deductions, and uncomfortable conversations with your lender or CPA.

The good news is that a handful of solid habits go a long way. Below are five real estate bookkeeping tips every commercial investor should know, whether you handle the books yourself or work with an outsourced bookkeeper.

Want an expert to look over your books before you dive in? Book a Discovery Call Today

Tip 1: Keep Each Commercial Property and Entity Separate

Many investors hold each commercial property in its own LLC to limit liability. That is a smart move, but the protection works best when each entity actually operates like a separate business. That means separate bank accounts, separate books, and no commingling.

Commingling happens when money from one property, one entity, or your personal accounts gets mixed with another. It is easy to do when you are busy. A tenant's rent payment lands in the wrong account, or you cover a property tax bill from your operating business because it was convenient that day. But commingled funds make it hard to see how each property is really performing, and they can weaken the very liability protection you formed the LLC to get.

Set up your books the right way from day one

• Open a dedicated bank account, and a credit card if you use one, for each entity.

• Keep a separate set of books for each entity. In QuickBooks Online, each company file covers one business, so several LLCs generally means several company files.

• When one entity owns more than one property, use class or location tracking to see results property by property. These features are available in QuickBooks Online Plus and Advanced.

• Record money that moves between entities, or between you and an entity, as what it really is: a loan, a capital contribution, or a distribution. Do not record it as rent or an expense.

Build a chart of accounts made for commercial real estate

A generic chart of accounts will not give you the detail you need. Set up separate income accounts for base rent, CAM recoveries, tax and insurance reimbursements, and late fees. Then set up expense accounts that match the way you want to analyze each property. Getting this right in QuickBooks Online accounting from the start makes every report you run afterward more useful.

Tip 2: Track Leases, Rent Rolls, and CAM Reconciliations

Commercial leases are more complex than residential ones. You might have a triple net (NNN) lease where the tenant pays a share of property taxes, insurance, and maintenance. You might have a modified gross lease where those costs are split, or a retail lease with percentage rent tied to the tenant's sales. Add rent escalations, free-rent periods, and renewal options, and there is a lot to keep straight.

Keep your rent roll and your books in sync

Your rent roll should list every tenant, their space, lease start and end dates, current rent, scheduled increases, and security deposit. Each month, compare it to the rent income in your books. If the rent roll says you should have collected $42,000 and your books show $39,500, you want to find out why now, not in December.

Treat security deposits as liabilities

A refundable security deposit is not income when you receive it, because you may have to give it back. Record it as a liability on the balance sheet. If you later keep part of the deposit to cover unpaid rent or damage, that portion becomes income at that point.

Stay ahead of CAM reconciliations

Under many commercial leases, tenants pay estimated common area maintenance (CAM) charges throughout the year. After year-end, the landlord compares those estimates to actual costs, and the tenant either owes the difference or receives a credit.

Accurate CAM reconciliations depend on clean books. Track recoverable expenses in their own accounts and keep invoices organized by property. Review your lease language, too, since leases often spell out which costs are recoverable, how they are shared among tenants, and whether any caps apply. When a tenant questions their bill, you will have the backup ready instead of scrambling for it.

One more note: If you need GAAP-basis financial statements for a lender or investors, rent from leases with scheduled increases or free-rent periods is generally recognized on a straight-line basis over the lease term. That means the rent income on your financial statements may not match the cash you collect each month. Your CPA can tell you whether this applies to your situation.

Tip 3: Classify Repairs vs. Capital Improvements Correctly

Fixing a leaky faucet and replacing a building's entire HVAC system both feel like maintenance, but they do not land in the same place in your books. Repairs are generally deducted as expenses in the year you pay for them. Capital improvements are generally capitalized and depreciated over time. Nonresidential real property, which includes most commercial buildings, is depreciated over 39 years, and land is not depreciable at all.

How the IRS draws the line

Under the IRS tangible property regulations, often called the repair regulations, a cost generally must be capitalized if it results in a betterment to the property, restores it, or adapts it to a new or different use. Replacing an entire roof will usually fall on the capital side. Patching a small section usually will not.

The regulations also offer helpful safe harbors. The de minimis safe harbor election lets a business deduct items that cost up to $2,500 per invoice or per item, or up to $5,000 for businesses with an applicable financial statement such as audited financials. The election is made each year with your tax return, and your books have to treat those items consistently. Other safe harbors cover routine maintenance and certain smaller taxpayers with buildings.

Why it matters beyond this year's taxes

How you classify a cost affects more than your current tax bill. Capital improvements increase your basis in the property, which affects your gain when you sell and the numbers in a 1031 exchange. Keep invoices, contracts, and photos for every significant project so your classifications are easy to support later.

Leasing costs have their own rules as well. For example, leasing commissions are generally capitalized and amortized over the term of the lease rather than deducted all at once. And if you are buying a larger property, ask your CPA whether a cost segregation study makes sense. These studies can identify building components that qualify for shorter depreciation periods than the building itself.

Because tax treatment depends on your specific situation, coordinate these decisions with your CPA. A good real estate bookkeeper keeps the records organized so your CPA can make those calls quickly and accurately.

Tip 4: Record Debt and Lender Reporting Accurately

Most commercial property is financed, and loan payments are one of the most common places books go wrong.

Split principal, interest, and escrow

A typical commercial mortgage payment can include principal, interest, and escrow for property taxes and insurance. Each piece belongs in a different place in your books:

• Principal reduces the loan balance, which is a liability. It is not an expense.

• Interest is an expense, and business interest is generally deductible.

• Escrow deposits go to an escrow asset account until the lender pays the tax or insurance bill.

Booking the full payment as an expense overstates your expenses, understates your profit, and leaves your loan balance wrong. Use the lender's monthly statement or amortization schedule to split each payment, and reconcile your loan balance to the lender's statement every month.

Know your covenants

Commercial loans often come with covenants and reporting requirements, such as annual financial statements, updated rent rolls, or a minimum debt service coverage ratio (DSCR). DSCR is calculated by dividing net operating income by annual debt service. A DSCR of 1.25 means the property produces $1.25 of NOI for every $1.00 of loan payments.

Many commercial lenders look for a DSCR of around 1.20 to 1.25 or higher, though requirements vary by lender, loan type, and property type. Your loan documents will spell out the exact terms. If your books are behind, you may not notice a property slipping toward its covenant limit until the lender points it out. Keep a calendar of every reporting deadline, and review your DSCR before the lender does.

Tip 5: Close the Books Monthly and Track Key KPIs

Catching up once a year at tax time means you are making decisions with numbers that are months old. A monthly close keeps your commercial real estate financials current, so you can spot problems early and act on opportunities with confidence.

What a monthly close looks like

• Reconcile every bank, credit card, and loan account.

• Tie rent income back to the rent roll and follow up on late payments.

• Record large costs that build over the year, like property taxes and insurance, so each month carries its share.

• Review the profit and loss report for each property and look into anything that seems off.

The KPIs worth watching

Net operating income (NOI): NOI is a property's income minus its operating expenses. It does not include debt service, depreciation, capital expenditures, or income taxes. NOI is also the foundation of valuation, since a property's cap rate is its NOI divided by its value. Every dollar of NOI you protect adds to what the property is worth.

Debt service coverage ratio (DSCR): As covered in Tip 4, this shows how comfortably a property's income covers its loan payments. Tracking it monthly means no surprises at loan review time.

Occupancy: Track how much of your leasable space is leased. It is also worth watching economic occupancy, which reflects the rent you actually collect after vacancies, concessions, and unpaid rent.

Budget vs. actual: Build an annual budget for each property, including reserves for capital projects, and compare actual results to it every month. Big variances are early warning signs, and they are much easier to fix in March than in November.

Clean Books Lead to Better Commercial Real Estate Decisions

Strong real estate accounting is not about paperwork for its own sake. When each property has its own clean books, your leases and CAM charges are tracked, your capital projects are classified correctly, your loans are recorded accurately, and you review your numbers every month, you can make decisions about buying, selling, and refinancing with real confidence.

You already have a business to run. You do not have to carry the books for your commercial portfolio on top of it. At Okie Accounting Group, we provide cloud-based real estate bookkeeping and advisory services for commercial investors across the country. Our team is led by a QuickBooks ProAdvisor, and we understand the entity structures, lease details, and lender requirements that come with commercial property.

Ready to get your commercial real estate books in order? Let's talk about what your portfolio needs. Book a Discovery Call Today