A single rental property is simple. Revenue, expenses, depreciation, done. But real estate investment firms do not own a single property. They own 10, 30, or 100 properties across multiple entities, each with its own bank account, its own investors, its own operating agreement, and its own tax return.
The bookkeeping requirements scale non-linearly. Going from 5 properties to 20 does not quadruple the work. It multiplies it by 8 or 10 because of the intercompany transactions, investor reporting, distribution calculations, and entity-level compliance that come with a growing portfolio.
We handle this exact scenario at Madras Accountancy, supporting CPA firms whose clients are real estate investment firms, syndicators, and family offices with multi-property portfolios. Our real estate bookkeeping outsourcing guide covers the fundamentals. This article goes deeper into the operational details.
In our experience, the tipping point where bookkeeping complexity overwhelms the existing process happens faster than most principals expect. A firm that managed 5 properties on spreadsheets and a single QuickBooks file adds 5 more properties, brings in outside investors for a couple of deals, and suddenly the bookkeeping demands have tripled. The principal is spending evenings reconciling bank accounts instead of sourcing the next deal. The CPA is getting incomplete records during tax season. And the investors are asking for reports that nobody has time to prepare.
Most real estate investors hold each property (or group of properties) in a separate LLC for liability protection. A 20-property portfolio might have 20 property-level LLCs, a management company LLC, a holding company LLC, and 3 to 5 syndication LLCs with outside investors. That is 25 or more entities, each requiring its own books, its own bank reconciliation, and its own tax return.
Keeping these entities straight in the accounting system is the first challenge. The second challenge is tracking the intercompany transactions between them. The management company charges management fees to the property LLCs. The holding company distributes cash to the management company. Investor capital calls flow from investors to the syndication LLCs to the property LLCs.
Every one of these intercompany transactions needs to be recorded in both entities and eliminated in any consolidated reporting. Miss one and your consolidated financials are wrong. Miss several and the K-1s are wrong, which means the investors' personal tax returns are wrong, which means you get angry phone calls in April.
At Madras, our offshore team maintains separate books for each entity using classes or separate QBO files, depending on the complexity. We reconcile intercompany balances monthly and flag discrepancies before they compound. The CPA firm reviews the consolidated picture and handles the judgment calls on entity structuring and tax elections.
The chart of accounts design matters significantly for multi-entity real estate bookkeeping. Each entity needs a consistent chart of accounts that captures the specific expense categories relevant to real estate (repairs and maintenance, property taxes, insurance, HOA fees, property management fees, utilities) while also supporting the reporting needs of investors and the CPA. We typically recommend a standardized chart of accounts across all entities, with property-specific tracking handled through classes or locations within the accounting software. This standardization makes consolidated reporting possible and simplifies the CPA's work during tax season.
The bank account management is another area that requires careful attention. Each entity typically has its own bank account (and sometimes multiple accounts: an operating account and a reserve account). For a 25-entity portfolio, that is 25 to 50 bank accounts that need to be reconciled monthly. Our team at Madras reconciles every account as part of the monthly close process, flagging unusual transactions, unresolved items, and low balances for the CPA firm and the principal to review.
Investors want to know how each property is performing individually. A property-level P&L needs to show rental income (broken out by unit if it is a multi-unit property), operating expenses by category (repairs and maintenance, property taxes, insurance, HOA fees, utilities, management fees), net operating income (NOI), debt service, and cash flow after debt service.
The key metric is cash-on-cash return: annual cash flow divided by total cash invested. An investor who put in $200,000 and receives $18,000 in annual distributions is earning a 9 percent cash-on-cash return. This number needs to be calculated per property and reported to investors quarterly or annually.
Our team builds property-level reporting templates during onboarding and produces these reports monthly as part of the standard close process. The data comes from property management software (AppFolio, Buildium, Yardi, Rent Manager) and bank statements. Reconciling property management software to the general ledger is a recurring task that requires attention to detail but follows a consistent process month to month.
The reconciliation between property management software and the accounting system is one of the most common sources of error in real estate bookkeeping. Property management software tracks rental income, maintenance expenses, and management fees from an operational perspective. The accounting system needs to reflect the same transactions from a financial reporting perspective, including accruals, depreciation, and debt service that the property management software does not track. Our team reconciles the two systems monthly, identifies discrepancies, and resolves them before the month-end close is finalized.
In our experience, the property-level P&L also needs to include a comparison to the original pro forma. When a property was acquired, the investor presentation included projected NOI, projected cash flow, and projected returns. The monthly or quarterly P&L should show actual performance against those projections so investors (and the principal) can see whether the property is performing as expected. Significant variances trigger investigation and action: if NOI is below pro forma because vacancy is higher than expected, the property management team needs to address the vacancy. If expenses are above pro forma because insurance costs increased, the principal may need to shop for better rates. This variance analysis turns the property-level P&L from a backward-looking report into a management tool.
Syndicated real estate deals have operating agreements that define how cash distributions flow to investors. These waterfall structures can be simple (pro-rata based on ownership percentage) or complex (preferred return hurdles, catch-up provisions, promote splits that change at different return tiers).
A typical waterfall might work like this. Investors receive an 8 percent preferred return on their invested capital first. After the preferred return is met, the sponsor receives a 20 percent catch-up until they have received 20 percent of total distributions. After catch-up, remaining distributions split 80/20 between investors and sponsor.
Calculating these distributions accurately requires tracking each investor's capital account, preferred return accrual, and prior distributions. One error in a quarterly distribution calculation means every subsequent calculation is wrong.
Our offshore team at Madras maintains investor capital account ledgers and calculates distributions according to the operating agreement terms. The CPA firm reviews the calculations before distributions are wired. For the quality control process on investor calculations, we use a dual-review system where two team members independently calculate the distribution and compare results.
The capital account tracking requires particular precision. Each investor's capital account starts with their initial contribution, increases with additional contributions and allocated income, and decreases with distributions and allocated losses. For deals with multiple contribution schedules (capital calls over time rather than a single investment), the preferred return calculation needs to account for the timing of each contribution. An investor who contributed $100,000 at closing and an additional $50,000 six months later has a different preferred return entitlement than an investor who contributed $150,000 at closing. Our team tracks these timing differences and calculates preferred returns on a daily or monthly basis, depending on what the operating agreement specifies.
The waterfall calculation also becomes more complex at disposition. When a property is sold, the disposition proceeds flow through the waterfall differently than operating distributions. Many operating agreements have separate waterfall structures for operating cash flow and capital events (sales, refinancing proceeds). The disposition waterfall typically requires full return of invested capital before any promote is paid, and the promote percentages may differ from the operating waterfall. Our team builds the disposition waterfall model during onboarding and updates it as capital account balances change.
Every partnership-taxed LLC issues Schedule K-1s to its members. For a real estate firm with 20 entities and 50 unique investors, that is potentially 200 or more K-1s prepared during tax season.
K-1 preparation requires accurate books at the entity level, correct allocation of income, losses, deductions, and credits based on the operating agreement, and proper handling of Section 704(b) book/tax differences.
The workflow we follow at Madras: close the entity-level books by January 31, prepare the draft partnership return and K-1s by February 28, CPA reviews and finalizes by March 15 filing deadline (or extension date). Our tax preparation outsourcing guide covers the broader process. For real estate partnerships specifically, the key items are depreciation calculations (including cost segregation adjustments), Section 199A qualified business income allocations, and passive activity classifications.
The depreciation calculations for real estate entities are among the most detail-intensive aspects of the bookkeeping. Each property has a building component (depreciated over 27.5 or 39 years depending on residential versus commercial), land (not depreciable), land improvements (15 years), and potentially components identified through a cost segregation study (5, 7, or 15 years). When a cost segregation study reclassifies $500,000 of building cost into shorter-lived components, the depreciation schedule for that property changes significantly, and the catch-up depreciation in the year of the study must be calculated correctly.
Our team maintains detailed depreciation schedules for every property, updates them for capital improvements and dispositions, and calculates the depreciation expense by component. This detail feeds directly into the K-1 preparation, ensuring that each investor receives the correct allocation of depreciation deductions.
Real estate investment firms typically carry significant debt, with each property financed separately. The bookkeeping needs to track the loan balance, interest expense, principal payments, escrow accounts, and amortization schedule for every loan. For a 20-property portfolio with 20 separate mortgages, this is a meaningful amount of recurring work.
Our team maintains a loan schedule for every property that tracks the original loan amount, current balance, interest rate, payment amount, maturity date, and any covenants or reserves required by the lender. The monthly bookkeeping includes recording the mortgage payment with the correct split between principal and interest, reconciling the escrow account, and updating the loan balance. The loan schedule is reviewed quarterly to identify upcoming maturities and covenant compliance requirements.
The debt tracking also supports the fractional CFO's work on refinancing and capital allocation decisions. When the CFO evaluates whether to refinance a property, they need accurate current loan balance, remaining term, prepayment penalty calculations, and current interest rate information. If the bookkeeping team maintains this data accurately, the CFO can model refinancing scenarios quickly. If the data is unreliable, the CFO spends hours verifying loan information before the analysis can begin.
For a CPA firm with real estate investment clients, the outsourcing decision typically triggers at one of these points.
The client crosses 10 properties and the bookkeeping hours are exceeding what your staff can handle alongside their other clients. At 10 properties with separate entities, expect 30 to 50 hours of bookkeeping per month, plus quarterly investor reporting.
The client adds outside investors (syndication) and the reporting and compliance requirements jump significantly. Investor correspondence, distribution calculations, K-1 preparation, and capital account tracking add substantial volume.
The client grows beyond what a single bookkeeper can handle and you need redundancy. A dedicated offshore team of 2 to 3 people provides coverage that a single in-house bookkeeper cannot.
At Madras, we support real estate portfolios ranging from 5 properties to 100+. If your CPA firm serves real estate investors and needs production capacity for the bookkeeping, reporting, and tax preparation, reach out at madrasaccountancy.com. We can discuss what the engagement would look like for your specific client base.
Yes. AppFolio, Buildium, Yardi, and Rent Manager are all cloud-based and accessible remotely. Our team reconciles property management reports to the general ledger monthly. The property management software handles tenant-facing operations (rent collection, maintenance requests, lease management). The accounting software handles the financial reporting and tax preparation.
Cost segregation studies reclassify building components into shorter depreciation lives. When a cost segregation report is completed, our team reclassifies the affected assets in the depreciation schedule, calculates the revised depreciation expense, and posts the catch-up adjustment. This is a one-time process per property when the study is completed, followed by ongoing adjusted depreciation calculations.
For a 20-property portfolio with separate entities, monthly outsourced bookkeeping typically runs $4,000 to $8,000 depending on transaction volume, investor reporting requirements, and the number of unique investors. That compares to $6,000 to $10,000 per month for an in-house bookkeeper dedicated to the portfolio (fully loaded cost). The outsourced model also provides redundancy and scalability that a single hire does not.
We request the organizational chart and operating agreements during onboarding. For a 20-entity structure, it takes 1 to 2 weeks for our team to map the relationships, set up the chart of accounts, and understand the intercompany transaction patterns. By the end of the first month-end close, the team is working independently on the recurring processes. The first 90 days follows the same framework as any new client, with additional focus on entity mapping and investor tracking.
Yes. Tax season (January through March for calendar-year entities) adds the K-1 preparation workload on top of the regular monthly bookkeeping. Our team handles this by closing the entity-level books early (by January 31), preparing draft tax returns and K-1s through February, and supporting the CPA's review and finalization through March. We plan for the seasonal workload increase and staff accordingly, so the regular monthly bookkeeping does not fall behind while tax preparation is happening. For firms with a large number of real estate entities, we typically assign a dedicated sub-team to tax season work so the monthly bookkeeping team can maintain their normal schedule.
Transitioning existing clients to an outsourced CAS team is operationally straightforward and emotionally tricky. Here is how to do it without losing clients.
Your first outsourced tax season will either be a relief or a disaster. The difference is whether you start preparing in October or panic-call a provider in February.
CPA firms are terrible at collecting their own invoices. Average days in AR is 65 days. Here is how outsourcing AR management cuts that to 40 and improves cash flow.
