Blog

Real Estate Bookkeeping Cleanup: Untangling 18 Months of Mixed Accounts in One Week

A property owner came to us with a problem that’s more common in real estate management than most people admit: the books hadn’t been touched in 18 months, and expenses had been paid out of five different bank accounts — including a savings account that was never supposed to be part of the operating picture.

Here’s what that actually looked like, how we fixed it, and what we found once we started asking questions.

The Starting Point

Eighteen months of transactions sat completely uncategorized. That alone isn’t unusual for a busy property owner — bookkeeping is easy to postpone when the business itself is running fine day to day. What made this case harder was where the money had actually moved:

Before we could categorize a single transaction, we had to reconstruct which account paid for which expense, then decide how to treat the savings account activity so it didn’t distort the real operating picture.

The Process

We asked the owner for full statement access across all five accounts for the full 18-month window. That request itself took the longest — five days passed before we had everything in hand, which is typical. Owners are running their business, not sitting on standby for document requests.

Once we had everything, the actual cleanup took two days. Total elapsed time: one week. Actual hands-on-books time: two days.

The work itself was methodical:

  1. Pulled and organized all statements by account and by month
  2. Matched every transaction to its source account and built a categorization structure specific to real estate — rent income, maintenance, property management fees, utilities, and separated out anything that wasn’t a true business expense
  3. Reconciled the savings account activity separately, then folded the legitimate business transactions back into the correct operating picture
  4. Flagged anything ambiguous for a direct conversation with the owner, rather than guessing

That last step is where the real value showed up.

The Surprises

Three things came up that no amount of statement-reading alone would have caught — they only surfaced by asking the owner directly:

Personal expenses mixed into the business accounts. Not deliberate, just the byproduct of using one account for convenience. Left uncorrected, this quietly distorts the true cost of running the properties and creates real tax exposure.

Security deposits recorded as income. This is a classic real estate bookkeeping trap — a deposit hits the bank account and looks like revenue, but it’s a liability that belongs to the tenant until it’s earned or returned. Booking it as income overstates profitability and creates a mess down the line when the deposit has to be refunded.

Unrecorded owner draws. Money had moved out of the business for personal use without ever being logged as a draw. Left alone, this understates what the owner actually took out of the business and makes the real profit picture inaccurate.

None of these were caught by staring harder at a spreadsheet. They came out of direct conversation — “why did this transaction happen” — which is exactly why a cleanup like this isn’t just data entry. It’s investigation.

The Outcome

By the end of the week, the owner had accurate books across all five accounts, a clean separation between business and personal activity, deposits correctly classified as liabilities, and a clear record of actual owner draws. For the first time in 18 months, the numbers reflected what was actually happening in the business — not just what the bank balances suggested.

If This Sounds Familiar

If your books have gone untouched for months, or expenses are scattered across more accounts than you’d like to admit, you’re not alone — this is one of the most common situations we see in property and real estate management specifically. The good news: once we have full document access, this kind of cleanup usually moves fast. The bottleneck is almost never the bookkeeping itself; it’s getting everything in hand.

If that’s where you’re at, get in touch and let’s talk through what a cleanup would look like for your books.

Share
Previous How to Clean Up a Bookkeeping Backlog: The Complete Step-by-Step Guide Next Business Closure Checklist: The Financial and Bookkeeping Steps You Can’t Skip
Keep reading

More from the blog

Get Started

Like what you read? Let’s talk.

A 30-minute call to map your workflow and decide whether we’re the right partner.