Taxstra Logo
Free Initial Consultation Available

Real Estate Bookkeeping for Investor Portfolios

Per-property P&Ls, monthly reconciliations, and a depreciation schedule that never drifts from the books. Built for portfolios of roughly ten doors or more, multiple entities, or commercial assets, and run by the same CPA firm that plans the taxes on top.

A guide by Taxstra Tax & Accounting · CPA-led tax strategy for business owners

Written by Bryan Martin, CPA, Managing Partner and Founder of Taxstra. Last reviewed July 17, 2026.

Taxstra is a QuickBooks Online based CPA practice serving 1,000+ clients nationwide, led by a CPA and MBA who also holds a real estate broker license.

Real estate bookkeeping is portfolio accounting, not transaction sorting. Done right, it means a class-tracked P&L for every property, reconciled bank and loan balances, security deposits held as liabilities, and a fixed asset schedule that agrees with the tax return. Taxstra runs that as a monthly, CPA-led service for investors whose portfolios have outgrown a spreadsheet: roughly ten doors or more, multiple LLCs, syndication interests, short-term rental portfolios, or commercial assets. If that is you, the rest of this page explains exactly what we deliver and how the engagement works.

Key Insight
Our rental property bookkeeping service delivers per-property P&Ls in QuickBooks Online, monthly bank and PM statement reconciliations, security deposit and escrow tracking, fixed asset and depreciation schedule maintenance, and a year-end tax package, all from the same firm that prepares the returns and plans strategies like cost segregation on top of the books. It is built for portfolios of roughly ten doors or more; smaller landlords get a self-serve path below.

Who This Service Is For (and Who It Is Not)

Qualification first, so nobody wastes a call

This engagement is built for investors where the books are genuinely a multi-entity problem:

  • Portfolios of roughly ten doors or more, where per-property reporting, lender packages, and the year-end close stop being a weekend project.
  • Multi-entity structures: several LLCs, a management entity, or a holding company, with inter-entity transfers that need due-to and due-from accounts instead of guesswork.
  • Syndication GPs and LPs who need entity-level books that investors and K-1 preparation can rely on.
  • Short-term rental portfolios where platform payouts, cleaning and supply spend, and the records behind a material participation position all need to hold together.
  • Multi-state and commercial portfolios, where escrow, CAM, and loan structures add balance sheet complexity a generic bookkeeper will not touch.

Who it is not for: if you self-manage a few rentals, a monthly CPA-led engagement is usually more service than the portfolio can support, and we would rather tell you that here than on a call. The self-serve path works well at that size: set up your own file with our QuickBooks for landlords guide and learn the underlying method in our real estate accounting guide. If you are a real estate agent rather than an investor, commission income is a different bookkeeping problem; see bookkeeping for real estate agents. And if your main business is not real estate at all, start with outsourced bookkeeping for small business.

What We Deliver Every Month

The monthly close, itemized

Every month closes on a set schedule, and every close produces the same deliverables. No mystery, no "we will catch it at year-end."

Monthly deliverablePer-property P&L
What it coversClass-tracked QuickBooks Online income statement for every door in every entity
Why it matters in AprilRental schedules tie out by property instead of getting rebuilt in March
Monthly deliverableBank, loan, and escrow reconciliations
What it coversEvery operating account, mortgage, and escrow balance agreed to statements monthly
Why it matters in AprilInterest, principal, and escrow splits are already right when the return is prepared
Monthly deliverableSecurity deposit and escrow tracking
What it coversDeposits carried as liabilities tied to the lease roll, never mixed into rent
Why it matters in AprilRefundable deposits do not get taxed as income by mistake
Monthly deliverableFixed asset and depreciation schedule maintenance
What it coversAcquisitions, improvements, and dispositions logged as they happen, coordinated with the tax team
Why it matters in AprilThe depreciation schedule and the books agree all year, not just at filing
Monthly deliverableCapital vs repair review
What it coversLarge invoices called as capitalize or expense when they post, using the safe harbor rules
Why it matters in AprilNo pile of unclassified CapEx sitting in a suspense account in April
Monthly deliverableYear-end tax package
What it coversTrial balance, fixed asset roll, loan summaries, and per-property statements per entity
Why it matters in AprilReturn prep starts from clean books instead of a records request

Two of those rows separate real estate bookkeeping services from generic ones. First, the fixed asset and depreciation schedule: residential rentals generally depreciate over 27.5 years and nonresidential property over 39 years, and every improvement, closing cost allocation, and disposition changes that schedule. We maintain it in step with the books all year, coordinated with the tax team, instead of letting the books and the depreciation schedule drift into two different versions of reality.

Second, the capital vs repair review. When a big invoice posts, someone has to decide whether it is a deductible repair or a capital improvement, and the safe harbor rules, including the de minimis safe harbor that lets most investors expense items up to $2,500 per invoice or item, only help if the decision is made when the invoice posts. We make that call monthly and document it, so Schedule E and the entity returns are built on classifications, not a suspense account.

Taxstra CPA Tip
Ask any bookkeeper one question before you hire them: who maintains the fixed asset schedule? If the answer is "your tax preparer handles that," you have two firms each assuming the other one owns depreciation, and that gap is where basis errors live for years.

The Rental Portfolio Chart of Accounts

Twelve accounts that make portfolio books work

Every engagement starts from a chart of accounts built for rentals, not a generic small business template with the word "property" typed into it. These are the core accounts and why each one exists:

AccountRental income (class-tracked by property)
TypeIncome
Why it existsGross rents per door, so every property has its own P&L and the rental schedules tie out by property.
AccountTenant security deposits held
TypeLiability
Why it existsRefundable deposits are debt to tenants, not income, tied to the lease roll and released at move-out.
AccountEscrow accounts (taxes and insurance)
TypeAsset
Why it existsLender escrow balances reconciled monthly, so tax and insurance payments never double-count.
AccountMortgage loans payable (one per loan)
TypeLiability
Why it existsEach note carried separately so every payment splits cleanly into interest, principal, and escrow.
AccountRefinance and draw proceeds
TypeLiability
Why it existsBorrowed money lands on the balance sheet, never in income, no matter which entity the wire hit.
AccountDue to/from affiliated entities
TypeAsset/Liability
Why it existsInter-entity transfers get a home that is not revenue, keeping every LLC's P&L real.
AccountBuildings, improvements, and land
TypeFixed asset
Why it existsAcquisition basis split at closing, because land does not depreciate and the allocation drives decades of deductions.
AccountAccumulated depreciation
TypeContra-asset
Why it existsThe book-side mirror of the tax depreciation schedule, maintained in step with the tax team.
AccountRehab and CapEx in progress
TypeFixed asset (WIP)
Why it existsRenovation spend accumulates per project until placed in service, so basis is provable at sale.
AccountRepairs and maintenance
TypeExpense
Why it existsDeductible repairs kept apart from improvements, with the capitalize-or-expense call made monthly.
AccountProperty management fees
TypeExpense
Why it existsPM fees at gross, from reconciled statements, not netted out of a lump deposit.
AccountOwner contributions and distributions
TypeEquity
Why it existsMoney in and out of each entity by owner, visible, so the P&L never absorbs personal cash flow.

Each niche we serve extends this core: a short-term rental adds lodging tax liability accounts, a development project adds draw schedules and interest capitalization, an HOA replaces it with fund accounting entirely. The niche pages linked later on this page show those variations account by account.

Portfolio KPIs We Track

Six numbers, defined, delivered with every close

Clean books exist so decisions can be made from numbers instead of impressions. These come standard with the monthly package:

  • NOI per property: net operating income by door, before debt service, the number every valuation and refinance conversation starts from.
  • Debt service coverage (DSCR): NOI against debt payments, per property and portfolio-wide, tracked monthly so a lender's covenant question never comes as a surprise.
  • Economic vacancy: rent actually collected against gross potential rent, which catches concessions, delinquency, and turnover drag that physical occupancy hides.
  • Operating expense ratio: operating expenses over effective income, per property, the fastest way to spot the one building quietly eating the portfolio.
  • CapEx as a percent of income: capitalized spend tracked against income so reserves and refinance timing are planned, not improvised.
  • Delinquency and deposit coverage: rents past due and deposits held against the lease roll, the two balance-sheet health checks lenders and buyers always run.

Books That Feed the Tax Strategy

The difference between a bookkeeping shop and a CPA firm

A bookkeeping-only shop hands you clean books and stops. The strategies that actually move a real estate investor's tax bill, cost segregation, real estate professional status, the short-term rental rules, entity structuring, all get planned somewhere else, by someone who has never seen your general ledger. Every handoff between those two firms is a place where detail dies.

Taxstra runs both sides. The team that closes your books each month is the same firm that prepares the returns and plans on top of them. When a cost segregation study makes sense on an acquisition, the fixed asset schedule is already structured to receive it. When a REPS or short-term rental position depends on contemporaneous records, the books and logs are built to support it from January, not reconstructed in March. And when the tax side is the service you actually need, planning, returns, and entity coordination for landlords, that is our landlord CPA service; this page is the bookkeeping engine underneath it.

Scope, and therefore cost, is driven by the shape of the portfolio: number of doors and entities, whether a property manager is involved, transaction volume, and how far behind the books are. We quote it after a free initial consultation, once we have seen the actual portfolio rather than a guess about it. For a fast, anonymous read on what bookkeeping typically runs for an operation your size, try our bookkeeping cost calculator.

Running ten doors on a spreadsheet and a memory?

A free initial consultation scopes your portfolio, your entities, and what a clean monthly close would look like. No obligation.

Book a Free 30-Minute Consultation

How the Engagement Works

From records request to quarterly tax review

The engagement follows the same four steps for every portfolio. The only variable is step two: current books get set up, behind books get caught up first.

How the Engagement Runs

01

Records request

Bank and loan statements, closing disclosures, PM statements, leases, prior returns, and an entity org chart. One list, one secure upload.

02

QBO setup or cleanup

Chart of accounts built for rentals, a class per property, bank feeds connected. Behind books get a catch-up project first.

03

Monthly close cadence

Transactions categorized, PM statements reconciled, inter-entity balances cleared, per-property P&L delivered on a set schedule.

04

Quarterly review with the tax side

A CPA reviews the books against the tax plan: estimates, acquisition and disposition treatment, cost segregation timing, REPS and STR documentation.

If your books are more than a couple of months behind, the cleanup happens as a defined project before the monthly cadence starts, so the monthly service never inherits a mess. That project is our catch-up bookkeeping service, and for real estate clients it is rebuilt from bank statements, loan documents, closing disclosures, and PM statements rather than from memory.

Why Real Estate Books Break at Scale

The four failure modes we clean up most often

Almost every portfolio that comes to us with broken books broke in one of the same four places. None of them are visible at two doors. All of them are structural at fourteen.

  • Inter-entity transfers booked as income or expense. Money moved from LLC A to LLC B to cover a mortgage payment is a balance sheet event, not revenue. Booked wrong, both entities' P&Ls are fiction and the year-end untangling is expensive.
  • Refinance proceeds booked as income. A cash-out refi deposit is loan principal and belongs on the balance sheet as a liability; borrowed money is not taxable income. Booked as rent, it inflates the P&L and quietly misstates the return workpapers.
  • CapEx draws scattered across the ledger. Construction loan draws and rehab spend that never make it to the fixed asset schedule become depreciation that is simply never taken, or basis that cannot be substantiated at sale.
  • PM statements never reconciled to the books. AppFolio and Buildium statements report gross rents, management fees, and repairs, then deposit one net number. Books built off the bank feed alone record only that net deposit, understating both income and expenses and breaking the audit trail.
Watch Out
Refundable security deposits are not rental income when you receive them; they are a liability you may have to pay back. Portfolios that run deposits through the rent account overstate income in the year of move-in and then have no liability to release when the tenant leaves. Multiply that by forty leases and the balance sheet stops meaning anything.

What This Looks Like: 14 Doors Across 3 LLCs

An illustrative month, end to end

Worked example (hypothetical, illustrative)

Take a hypothetical investor with 14 doors across three LLCs: eight residential units under a property manager in LLC A, five self-managed units in LLC B, and a small commercial building in LLC C. Each LLC keeps its own QuickBooks Online books with a class per property.

The monthly close: LLC A's AppFolio statement is reconciled gross-to-net, so the books show full rents, management fees, and repairs instead of one net deposit. LLC B's bank and mortgage feeds are categorized and reconciled, with each loan payment split between interest, principal, and escrow. LLC C's CAM charges and commercial escrow are agreed to statements. A transfer LLC B made to cover LLC A's insurance premium is booked through due-to and due-from accounts, not as income. An $1,800 water heater is expensed under the de minimis safe harbor; a $28,000 roof replacement is capitalized to the fixed asset schedule and flagged to the tax team for the depreciation treatment conversation. Security deposit liabilities are tied to the current lease roll. Three per-property P&L packages go out on the same business day each month.

At tax time, there is no handoff to a stranger. Each LLC's year-end package, trial balance, fixed asset roll, and loan summaries, goes straight to the same firm's tax side. The depreciation schedules already match the books, the roof is already on the schedule, and the cost segregation conversation on the commercial building starts from numbers everyone already trusts. This example is illustrative and hypothetical; it describes workflow, not tax outcomes, and results depend on your facts.

Taxstra CPA Tip
If your property manager's statement shows a net deposit and your books call that net number "rent," your income and expenses are both understated by the same amount. The profit line survives, but every lender ratio, every per-property comparison, and the audit trail behind your deductions do not.

Specialized Real Estate Accounting, by Niche

The same discipline, tuned to how each asset class actually works

Portfolio bookkeeping is the anchor, but real estate is not one business. Each of these niches has its own chart of accounts, its own KPIs, and its own failure modes, and each has a dedicated page explaining exactly how we run it:

For the tax strategies that sit on top of all of it, cost segregation, REPS, the short-term rental rules, 1031 exchanges, start at the real estate tax hub.

Frequently Asked Questions

Real estate bookkeeping services, scoped honestly

Yes. Property management software is an operations tool, not an accounting system. We treat the monthly PM statement as a source document: gross rents, management fees, repairs paid from rent, and the net owner draw all get reconciled into QuickBooks Online so the books match what actually hit the bank, at the gross level, not the netted one.

Get Portfolio-Grade Books and the Tax Plan Under One Roof

Book a free initial consultation. We will scope your doors, entities, and cleanup needs, and show you what a clean monthly close and an integrated tax handoff look like for your portfolio.

Book a Free 30-Minute Consultation