From unreconciled to lender-ready

The client

Our client is a hands-on real estate investor in the Kansas City metro who owns a portfolio of long-term rentals through an LLC and regularly buys, renovates, and refinances properties. Like many investors, they'd grown the portfolio faster than the bookkeeping behind it. Each property had its own mortgage or line of credit, its own escrow account, its own insurance policy, and its own tenant, and more than a dozen bank, credit card, and loan accounts were spread across ten-plus lenders and servicers.

The books existed in QuickBooks Online, but they weren't telling the owner what was actually happening. They reached out in late 2024, ahead of tax season, wanting to know where they really stood.

The challenge

We started with a diagnostic review: a no-pressure look at the file to see what was working and what wasn't. It surfaced problems that touched every report the owner relied on:

• Nothing had been reconciled in almost a year. Both operating checking accounts and the main credit card hadn't been reconciled since the prior December. One checking account showed a negative balance, and a business card had carried a negative balance all year.
• Loans had never been reconciled. Mortgage and line-of-credit payments weren't split between principal and interest, so interest expense (the investor's single largest cost) was misstated, and loan balances didn't match lender statements.
• Every property was lumped together. Land, buildings, improvements, closing costs, and depreciation for all properties sat in shared accounts. When a property sold, there was no way to see at a glance what should come off the books.
• Escrow was invisible. Property taxes and insurance paid through mortgage escrow weren't broken out, and an old negative escrow balance had never been cleared.
• Rentals and flips were mixed. Repairs, contract labor, and professional fees weren't separated between rental upkeep and renovation projects, which changes how they're treated at tax time.
• The accounting basis was unclear. The file was set to accrual, but rent was recorded when cash arrived, so late and prepaid rent landed in the wrong months.
• A long list of loose ends. Transactions parked in “Ask My Accountant” and uncategorized expense, long-term loans classified as current liabilities, inconsistent class tracking, and no W-9 process for the contractors who'd need 1099s.

The owner was making real decisions about buying, refinancing, and selling without reliable numbers.

What we did

1. Cleaned up the full year. We went back to January 2024 and reconciled every bank, credit card, escrow, and loan account to its statements, cleared the “Ask My Accountant” backlog, recategorized misposted transactions, and moved long-term debt to the right side of the balance sheet. Year-end financials went to the owner and their CPA in mid-February.
2. Gave every property its own set of books inside the books. We rebuilt the chart of accounts so each property carries its own sub-accounts for land, building, improvements, equipment, loan closing costs, and accumulated depreciation, plus its own escrow account. Classes track income and expense by property. When a property is sold or refinanced, everything tied to it is visible in one place.
3. Made the debt tie out to the penny. For each mortgage, line of credit, and vehicle loan, we worked out how that lender actually calculates interest (day-count method, payment effective dates) and verified it against months of statement history, so principal and interest splits match the lender exactly. When the owner refinanced a property, we booked the closing properly: payoff of the old loans, the new note, and closing costs capitalized to that property.
4. Untangled owner financing. The owner had advanced funds to the business from a personal home equity line for several different purchases. We split that single line into separate amortization schedules, one per purpose, with interest accrued monthly, so each advance shows its true balance and cost on the books.
5. Set up tenant deposit tracking. We built a security deposit register by tenant and property, separating refundable deposits, non-refundable pet fees, and last month's rent, so the liability on the balance sheet matches what's actually owed back.
6. Delivered monthly management reports, not just statements. Every month the owner receives a Profit & Loss, Balance Sheet, cash flow statement, month-over-month comparison, and P&L by property. Each report ends with an Understanding the Financials section that walks through liquidity, leverage, interest coverage, and cash flow to debt in plain English, including what the numbers mean for the business.

The results

• Clean, CPA-ready books. A full year of cleanup delivered in time for tax season, with every account reconciled to its statement.
• Profit by property. The owner can see which properties carry their weight and which don't, instead of one blended number for the whole portfolio.
• Debt they can trust. Loan balances and interest match every lender statement, and interest expense, their biggest cost, is finally accurate.
• Lender-ready when it counts. When it was time to refinance, the property-level records and loan history were already organized and current.
• Straight talk, every month. The monthly ratios don't sugarcoat anything. They flag leverage and interest-coverage risk early, so the owner can plan paydowns, refinances, and sales with eyes open.

Nearly two years in, we still handle the books every month, and the client has moved from asking “where do we stand?” to asking “what should we do next?” That's what monthly bookkeeping with CFO-level reporting is supposed to feel like.