Catch-Up Bookkeeping for Property Managers

Catch-Up Bookkeeping for Property Managers: How to Clean Up Months of Behind Books

Catch-up bookkeeping means entering every transaction that never reached your books, in date order, until your records match your bank statements again. For a property manager, it also means rebuilding every tenant and owner ledger, because other people’s money sits in those books.

Perhaps your bookkeeper left in the spring. The person who kept the entries may have moved into operations while the books slid. Either way, you now have months of bank activity that never reached the ledger, owners asking when their statements will arrive, and a feeling that the trust account is off by something you can’t name.

This guide covers the order we’d follow, the numbers worth settling before you post a single entry, and the moment to stop doing it yourself. It runs long on purpose. Catch-up work fails in the details, and the details are where a property manager’s books differ from everyone else’s.

Catch-Up Versus Cleanup: Which Job Is Yours?

People mix these two terms up, and the difference decides where you start.

Catch-up bookkeeping is entry work. The transactions happened; they never reached the books, and somebody has to enter them.

Cleanup is repair work. The transactions reached the books wrongly, and somebody has to fix them. A late quarter might need only the first. Rushed months, where someone coded fast to get owner statements out the door, often need both.

Property books often land in that second group. Falling behind doesn’t happen on one clean date. The easy items get posted, the hard ones wait, and a few get guessed.

So bookkeeping cleanup and fresh entry end up tangled inside the same months, and you can’t finish cleanup bookkeeping on a month until you know what’s missing from it.

What To Compare Catch-Up Work Cleanup Work
What it fixes Transactions that never reached the books Transactions that reached the books wrongly
What you start with Bank statements and a gap in the ledger A full ledger with errors inside it
What it looks like Months with no activity, or activity that shows only in the bank Deposits booked as income, receipts on the wrong tenant, duplicate bills
Risk if you skip it Owner statements that leave out real money Owner statements that show wrong numbers with full confidence
Property-specific twist Every missing entry has a tenant or an owner attached A fix in one ledger often shifts another

Read your own books against that table before you plan anything. If you can point to a month with nothing in it, you have catch-up work. A month that looks complete but feels wrong means cleanup work. Real jobs often mix both, so plan for both.

Why Property Books Can’t Just Be Brought Current

In a typical service business, late books cost you time. You catch up, find a small difference, move it to a miscellaneous account, and carry on. Property books don’t work that way, because the money in them isn’t all yours.

Think about what sits in the ledger.

  • Rent you collected for owners.
  • Deposits you hold for tenants.
  • Repair bills you paid on an owner’s behalf.

Your management fee, and any other fee your management agreement lets you keep, is the only slice that belongs to your company. Everything else belongs to a named tenant or a named owner, and each of them has a ledger that has to be right.
Catch-Up Bookkeeping to Clean Up Months of Behind Books

That’s why a $40 difference (a made-up figure) isn’t small. It belongs to a specific person, and until you find out whose, you can’t plug it, park it in suspense, or round it away. That also explains a trap that catches careful people.

An owner draw posted to the wrong owner leaves one ledger too high and another too low, while the bank balance still looks perfect. The trust account can match the bank and still be wrong.

Settle the Starting Balances First

A catch-up bookkeeping job often goes wrong on day one, and the cause is a question nobody asks: which balances are we starting from?

You usually have two candidates. One is the balance sheet your outside accountant closed at the last year-end. The other is what the old system shows for that same date when you run it today. They often differ.

What To Compare Accountant’s Year-End Balance Sheet Old System, Same Date
What it reflects The books as the accountant closed them, adjustments included Every entry made so far, late and wrong ones included
Where it can drift Adjustments posted outside the property software Entries added after the books closed, and errors nobody reversed
Strength Someone outside your team looked at it It matches the ledgers tenants and owners see
Weakness It may not match tenant and owner ledgers line by line It can carry forward the very errors you’re fixing
Pick it when Owners and your accountant already work from these figures There’s no closed year to point to

Here’s a made-up example. Run to that same year-end date, the old system shows $18,400 in tenant deposits, while the accountant’s balance sheet shows $17,900. That $500 gap matters, because it decides which number you rebuild from. If the owner will rely on the accountant’s figure, you want to know that before you spend a long stretch matching the system to numbers nobody was ever going to use.

So settle it first, and settle it with the person who will rely on the answer. Pick a cutoff date, ideally the month’s end, where you hold a statement for every account. Agree the source of the opening balances. Write one page that names the source, the date, and who agreed. If a difference remains between the source and the system, record it as a listed difference with a name on it. Never bury it as a plug. That single page saves a lot of arguments three months later.

Size the Job Before You Touch It

Before you post anything, take stock. Count the months behind. List the accounts, including the ones you forgot. Tally the statements you hold and the ones you don’t. Note which owners are waiting on statements. Then find the last month the trust account tied, if it ever did.

Those five answers tell you how big the job is. They also tell you whether you can finish it yourself, which matters later. A job with two months, three accounts and every statement in hand looks nothing like a job with nine months, eleven accounts and a gap in the trust records.

The Order of the Rebuild

The order matters more than the speed. Each step feeds the next, and a shortcut in step three shows up as a surprise in step six. Here’s the whole sequence at a glance, then each step in turn.

Step What You Do What It Proves
Before step 1 Agree the source of the opening balances Everyone rebuilds toward the same numbers
1. Confirm basis Pick cash or accrual and hold it Every month follows the same rules
2. List accounts and statements Build a grid of accounts by month You know what’s missing before you start
3. Reconcile oldest first Match each account to its statement Each month starts where the last one ended
4. Rebuild ledgers Tenants, then owners, then deposits Every dollar has a name on it
5. Bring payables current Fix unpaid, unentered and duplicate bills Costs sit on the right property
6. Tie out the trust account Compare the three balances The money you hold matches what you owe
7. Close forward Lock finished months and set a routine The books stay current

Confirm Cash or Accrual

Look at the last owner statements that went out. They show which basis the business used, and your management agreements tell you which one owners expect. Pick one and hold it for the whole rebuild. Switching halfway leaves months that tie to nothing.

List Every Account and Every Missing Statement

Build a simple grid. Down the side, list every operating account, trust account, deposit account, reserve account, credit card, and loan. Across the top, list the months. In each cell, mark whether you hold the statement, you’re missing it, or you’ve requested it. Here’s a made-up example.
Account and Every Missing Statement

Get missing statements from the bank itself. A feed shows what it captured, which isn’t always what happened. You’ll also find accounts you forgot, such as an old card still paying a vendor or a payment processor account that sweeps into the bank a few days late. Every empty cell is a month you can’t reconcile yet, so chase those first.

Reconcile Month By Month, Oldest First

Enter the month’s transactions, then reconcile. The first reconciliation must start from the agreed opening balance. If it doesn’t, stop there and go back to the starting-balance page. Each month’s ending balance becomes the next month’s opening balance, so a difference you carry forward doesn’t shrink. It grows.

A few practical points save time here. Bank deposits often bundle several tenants’ payments, so match deposit totals to the batch in your ledger, not to individual payments, or you’ll chase differences that don’t exist. Checks written late in one month and cleared early in the next sit on the outstanding list, so read the dates before you call something an error. And a tenant payment that bounced needs a reversal in the ledger, plus any fee, or the tenant’s balance will look paid when it isn’t.

Rebuild Tenant Ledgers, Then Owner Ledgers, Then Deposits

Start with tenants. Enter each charge and each receipt in date order, and apply every receipt to the charge it covers. Check that recurring charges posted every month of the gap, since a missed month of rent or a missed late fee shows up only when you compare the ledger to the lease. Rent paid ahead sits as a liability until its month arrives. It isn’t income yet.

Tenants who moved out during the gap need their attention. Each one needs a final ledger, the deposit applied to what they owe, and any refund recorded. Leave one half done, and the deposit liability stays too high with nobody to explain it.

Move to owners next. An owner ledger should show rent collected, less fees, repairs, and draws, and it should never dip below zero. When one does go negative, look for a receipt that hasn’t been entered yet, a bill or draw posted to the wrong owner, or money paid out before the rent came in.

Recalculate your management fee for the gap months on the basis your agreement sets, because a fee booked wrong in month two ripples through every statement after it.

Finish with deposits. Each tenant’s deposit needs its own line as a liability, and the total has to agree to the deposit liability in the general ledger and to the bank account that holds the deposits. Our guide to security deposit accounting walks through those entries.

Bring Payables and Vendor Records Current

Now deal with the bills. Some bills sit unpaid. Others left the bank and never reached the ledger. A few appear twice. One or two land on the wrong property, which makes an owner statement show a repair cost the owner never had. Vendor 1099 work depends on this step too, because it needs a clean record of who you paid and for which property.

Match each vendor payment to a bill and each bill to a property. A payment with no bill behind it deserves a question. Every unpaid bill deserves a date.

Tie Out the Trust Account

This is the test that matters most. A three-way reconciliation compares three balances: the trust bank statement, the trust balance in the general ledger, and the sum of the individual tenant and owner ledgers. All three must agree to the dollar. Our page on three-way trust reconciliation shows what a clean one looks like.

When they don’t agree, work back one month at a time until you find the first month where they split. The break often sits in one month and a handful of items. Don’t close the gap with a journal entry. Find the item.

Close Forward

Bring the books up to the current month, then close each month the way you plan to close every month after. Lock the months you’ve finished so nobody edits them by accident. Then put a routine in place, such as a month-end close checklist. A catch-up job that ends without a routine starts over in a quarter.

Talk to Owners While You Rebuild

Owners notice silence faster than they notice errors. A short note, sent early, buys you the quiet you need to finish the work.

Tell them the books are behind, name the last month that’s final, and say which step you’ve reached. Give them a date you can keep, tied to that step and not to a guess. Then send statements only for months that tie. A statement that goes out wrong costs you more trust than a statement that goes out late, because a late one is an inconvenience and a wrong one is a correction you then have to explain.

What Usually Turns Up

Every rebuild produces its own surprises. Still, a handful of patterns come up often enough to check for on day one.

Pattern What It Looks Like First Place To Look
Unapplied receipts Money in the bank, but the tenant still shows a balance owing The unapplied list and the deposit batches
Prepaid rent sitting as income A strong month followed by a thin one Receipts dated before the month they cover
Deposits mixed with rent Revenue looks high and the deposit liability looks low Income entries that match a known deposit amount
Negative owner ledgers An owner balance below zero, such as -$320 (a made-up figure) Draws and bills paid before the rent arrived
Shared bank account, no clearing account No single property’s books balance Transfers between properties
A chart of accounts that grew by accident Catch-all and near-duplicate accounts The account list sorted by name

Unapplied receipts do the quickest damage. The tenant paid, the bank shows it, and the ledger still says they owe, so a late notice goes out for money you already hold. Prepaid rent sitting as income does quieter damage. January’s rent lands in December, December looks great, and January looks thin for no reason anyone can explain.

A shared bank account with no clearing account deserves a word of explanation. When one account holds money for several properties, a clearing account tracks transfers between them. Without it, no single property balances, and you can’t tell which one is short.

Months of rushed coding also leave a mess in the account list itself. A cleaner chart of accounts makes the rebuild faster and the reports easier to trust.

On books we take over, roughly 30% of trust accounts don’t tie on the first three-way reconciliation we run.

That figure is why the trust tie-out is a step of its own, not a formality at the end. A trust account isn’t right just because the bank balance looks reasonable.

What Done Looks Like

You’re finished when six things hold at once. Each one has a way to prove it, so you don’t have to take your own word for it.

Check How You Prove It
Banks, cards and loans match their statements Each reconciliation ends at the statement balance with nothing unexplained
Suspense sits at zero The suspense account shows no balance
Opening balances match the agreed source The one-page note and the opening entries agree
No owner ledger is negative A report of owner balances shows none below zero
The trust account ties The three balances agree to the dollar
Finished months are locked Nobody can post into them without leaving a note

Hit all six and you have books you can send owner statements from without crossing your fingers.

When to Hand It to a Professional

Some of this work you can do yourself. The rest you shouldn’t. Three moments tell you which is which.

One is a trust account that still won’t tie after you’ve worked back through the months. Another is an owner balance gone negative that you can’t trace to a source. The last is statements that already went out and may be wrong. At those points, more effort from you stops helping, because each fix needs someone who has rebuilt these ledgers before.

The sizing you did at the start counts too. Nine months, eleven accounts and a gap in the trust records is a job to hand over before you start, not after you get stuck.

If statements already went out wrong, the fix is a corrected statement with a plain explanation, and the owner should hear it from you first.

That’s the work our property management accounting services cover. We start where this guide starts, with the statements and the starting balances, then rebuild forward in the order above.

Frequently Asked Questions

What is catch-up bookkeeping?

It’s the work of entering every transaction that never reached your books, month by month, until the records match your bank statements. For a property manager, it also covers rebuilding tenant and owner ledgers so every dollar of trust money has a name on it.

What’s the difference between catch-up and cleanup bookkeeping?

Catch-up enters work that was never done. Cleanup fixes work that someone did wrongly, such as deposits booked as income or payments applied to the wrong tenant. Property books often need both.

How do I catch up on bookkeeping quickly?

The fast route isn’t a shortcut through the entries. It’s settling the starting balances and collecting every missing statement first, because those two steps decide whether the rest holds. Skip them and the rebuild starts over.

What do I need before I start?

You need a statement for every account and every month, the list of tenants and owners with their current balances, and the opening balances your owners and accountant will accept. Add your management agreements, so you know the fee basis, and any open vendor bills. Missing statements come first, because nothing reconciles without them.

How long does catch-up take?

Nobody can give an honest answer before seeing the books. It depends on how many months are behind, how many accounts are involved, and how many statements and documents are missing. Anyone who quotes a date without looking is guessing.

How is catch-up work priced?

That depends on the same factors, so an article can’t give you a number. Pricing goes straight to a conversation about your months, your accounts, and your records, and you can start that conversation from the link at the end of this page.

Final Thoughts

Catch-up bookkeeping takes time because it’s careful work, not because it’s complicated. Settle the starting balances, collect the statements, reconcile oldest first, and tie out the trust money before you trust any report. If you’d rather not carry that alone, we keep the first step small: start-small pilot, no annual lock-in.

Book a call and we’ll talk through where your books stand.

About the Author

Sunil Khullar

Sunil Khullar - B.Com., FCA, DISA

Founder & Managing Director

Sunil Khullar founded Outsourced Bookkeeping in 2004. He brings over 20 years of experience as a financial professional to the property management industry. He was admitted as a member of the Institute of Chartered Accountants of India (ICAI) in 1995. He received his Certified Information Systems Auditor (CISA) certification in 2003. Sunil combines conventional accounting practices with modern technological advancements and has extensive knowledge across multiple software applications such as QuickBooks, Sage, Drake, UltraTax and ProConnect to assist clients in streamlining their accounting systems.

Let’s Take Our Conversation Ahead

Outsourced Bookkeeping is a trusted provider of bookkeeping, accounting, and tax preparation services. We deliver reliable, end-to-end solutions for CPAs, accounting firms, and small to mid-sized businesses across the US & Canada.

Schedule a Meeting
Need Help?

Schedule a callback to discuss your business needs.

Full Name