How to Catch Up on Bookkeeping: Cleanup vs. Catch-Up for Real Estate Investors

If your rental property books are months — or years — behind, here is the short version. Catch-up bookkeeping records the transactions that were never entered. Cleanup bookkeeping fixes the transactions that were entered wrong: uncategorized items, duplicates, personal spending, unreconciled accounts, and balance sheet numbers that don't match reality. Most real estate investors who are behind need some of both, and cleanup always comes first — there is no point recording six new months on top of a broken foundation. The process below takes you from a shoebox of statements to reconciled, property-level, CPA-ready books in six steps.

Who this guide is for

• Best for: Real estate investors — landlords, short-term rental operators, flippers, and BRRRR investors — who are 3 months to 3+ years behind, often across multiple LLCs and bank accounts, with a tax deadline approaching.
• Not intended for: Businesses outside real estate, or investors whose books are current and reconciled (see the real estate bookkeeping blog hub for monthly-process guides instead).
• Complexity level: Moderate to high — multiple accounts, loans, and entities are assumed.
• Software assumed: QuickBooks Online (or moving to it). You'll need online access to bank, credit card, and loan statements.
• When professional help becomes worthwhile: More than 6–12 months behind, more than one entity, unexplained balance sheet numbers, or a CPA deadline inside 60 days.

Cleanup vs. catch-up: which one do you actually need?

The two terms get used interchangeably, but they are different jobs with different scopes.

Catch-up bookkeeping is data entry plus reconciliation for periods that were never recorded. The chart of accounts is sound, the last reconciled month was accurate — the books just stopped. The work is bringing them forward.

Cleanup bookkeeping is diagnosis and repair of records that exist but are wrong. Typical findings in investor books: hundreds of transactions sitting in Uncategorized Expense or "Ask My Accountant," bank feed duplicates from a re-connected feed, personal groceries mixed into an LLC's operating account, mortgage payments booked entirely to expense, security deposits recorded as rental income, and transfers between LLCs showing up as revenue in one company and expense in the other.

Here is the recommendation by situation:

Your situation	What you need	Why
Books were accurate and reconciled, then simply stopped 3–12 months ago	Catch-up	The foundation is sound; you're adding missing months onto a clean base.
Books are current but full of uncategorized, duplicate, or personal transactions	Cleanup	Nothing is missing — it's miscoded. Reclassify, remove duplicates, re-reconcile.
Books are behind and the last recorded months don't reconcile	Cleanup first, then catch-up	You can't reconcile January 2026 if December 2025's ending balance is wrong. Fix the base, then move forward.
Loan balances, escrow, or security deposit liabilities in QuickBooks don't match statements	Cleanup (balance sheet focus)	The P&L may look fine while the balance sheet is fiction. Balance sheet repair is cleanup work even if every month is "entered."
No books at all — everything lives in bank portals and a spreadsheet	Catch-up (full build)	Technically a from-scratch build: set up the file and a real estate chart of accounts, then import and reconcile history.

Warning signs your books are inaccurate — not just behind

Being behind is visible. Being wrong is not, which is why inaccurate books are more dangerous. Red flags that indicate cleanup work, in rough order of severity:

• Accounts have never been reconciled, or reconciliations show forced adjustments. If the reconciliation history is empty, nothing in the file is verified.
• Loan balances in QuickBooks don't match mortgage statements. Usually caused by booking the full mortgage payment to an expense account instead of splitting principal, interest, and escrow.
• Security deposits appear in income. A refundable deposit is money you owe back — a liability. Recording it as rent overstates income and hides an obligation.
• Negative balances that make no sense — a negative bank balance, negative loan, or negative equity line nobody can explain.
• Transfers between entities or accounts booked as income and expense. Moving $10,000 from LLC A to LLC B is not $10,000 of revenue — but miscoded intercompany transfers inflate both sides of a multi-entity P&L.
• Uncategorized Expense or "Ask My Accountant" holds more than a handful of transactions.
• Duplicate transactions from a bank feed that was disconnected and re-imported, or from entering bills manually and accepting the feed transaction too.
• No property-level detail. One lump P&L across six properties means no property is actually being tracked — and your tax preparer will have to rebuild per-property detail anyway, since Schedule E reporting is by property.

Self-diagnostic scorecard: DIY catch-up, professional catch-up, or full cleanup?

Answer yes or no to each question honestly, then use the scoring bands below. This scorecard is designed for rental and STR portfolios on QuickBooks Online, but the logic applies to any real estate operation.

#	Question	Yes / No
1	Are all bank, credit card, and mortgage accounts reconciled through last month?
2	Is every transaction from the last 12 months categorized (nothing parked in Uncategorized or "Ask My Accountant")?
3	Have your books been updated within the last 60 days?
4	Can you run a profit & loss report for a single property (classes, locations, or tags are set up and used)?
5	Do the loan balances in your books match your most recent mortgage statements within a few dollars?
6	Are tenant security deposits recorded as a liability rather than as rental income?
7	Are transfers between your accounts and LLCs recorded as transfers — not as income in one place and expense in another?
8	Is personal spending kept out of the business accounts (or coded to owner draw/contribution when it happens)?
9	Are your books free of duplicate transactions from bank feed re-imports or double entry?
10	Could you send your CPA a P&L and balance sheet today without an apology attached?

Scoring:

• 9–10 yes: Your books are in maintenance mode. Stay on a monthly close and you won't need this article next year.
• 6–8 yes, and your "no" answers are on questions 1–3: DIY catch-up is realistic. Your structure is sound; you're just behind. Follow the six-step process below, oldest month first.
• 3–5 yes: Professional catch-up territory. The volume of unrecorded and miscoded work is large enough that DIY typically stalls — especially with multiple entities or a tax deadline inside 60 days.
• 0–2 yes, or any "no" on questions 5, 6, or 7: Full cleanup. A "no" on loan balances, security deposits, or intercompany transfers means the balance sheet itself is wrong, and every report built on it is unreliable. This needs diagnosis and repair before any new months are added.

Scored into cleanup territory with a deadline looming? That is exactly the situation QueueFortress's cleanup and catch-up work is built for — see how QueueFortress handles real estate bookkeeping cleanup and monthly service, or keep reading to understand what the work involves.

The step-by-step catch-up process

Whether you do this yourself or hire it out, the sequence is the same. Order matters: work from the oldest unreconciled month forward, because each month's ending balance is the next month's starting point.

Step 1 — Gather every statement before touching the software

Collect PDF statements for every account for every missing month: business checking and savings, credit cards, mortgages and HELOCs, private/hard-money loans, and platform accounts (Airbnb, VRBO, property manager statements). Banks often limit online statement history to 12–24 months, so download everything now — if you're two years behind, some statements may already require a written request to the bank. Also pull closing statements for any purchase, sale, or refinance in the gap period.

Step 2 — Rebuild or import the transaction history

Connect bank feeds where history is still available; import CSV/OFX files where it isn't. Before importing, check what's already in the register for overlapping dates — importing on top of existing entries is how duplicate transactions are born. If the file already contains partial, unreliable data, decide now whether to repair it or start a fresh QuickBooks file and rebuild from statements. For books more than 2–3 years wrong, a rebuild is often faster than a repair.

Step 3 — Categorize by property, not just by account

Categorize every transaction to the right account and the right property (class, location, or tag). This is the step generic catch-up guides skip, and it's the one that matters most for investors: a lump-sum catch-up that ignores property-level coding just creates a second cleanup project later. Real-estate-specific coding rules to apply as you go:

• Security deposits received go to a liability account, not income. (For bookkeeping purposes, track them separately so your tax preparer can determine treatment if any portion is kept — IRS Publication 527 addresses when kept deposits become income.)
• Mortgage payments get split three ways: principal to the loan liability, interest to interest expense, escrow to an escrow asset account. Property tax and insurance are recorded when the servicer disburses them from escrow.
• Intercompany transfers between LLCs are recorded as transfers or due to/from balances — never income or expense. (If you run several entities, the workflow in bookkeeping for multiple LLCs covers this in depth.)
• Owner money in and out goes to contribution and draw/distribution equity accounts, not to income or expense.
• Rehab and improvement costs get tracked separately from repairs, per property, so your CPA can decide capitalization — don't bury a $28,000 renovation in "Repairs & Maintenance."

Step 4 — Reconcile every account, every month

Reconcile each account against each monthly statement, oldest first, until the difference is $0.00 — that's the standard QuickBooks reconciliation workflow, and it is non-negotiable. Reconciliation is what converts "data entry" into "books you can trust." Do not skip months, do not reconcile out of order, and do not plug differences with an adjustment to force a zero. If a month won't reconcile, the cause is almost always in that month or the one before it: a duplicate, a missing transaction, or an edited historical entry. Find it before moving on.

Step 5 — Fix the balance sheet

Once cash and card accounts reconcile, verify the rest of the balance sheet against outside documents:

• Every loan balance matches the lender's statement as of the same date.
• The security deposit liability equals the sum of deposits actually held for current tenants.
• The escrow asset roughly tracks the servicer's escrow analysis.
• Fixed asset accounts reflect purchases, improvements, and closing statements — with per-property detail.
• Due to/from entity balances mirror each other across your companies.
• No mystery negatives, no orphaned Opening Balance Equity that nobody can explain.

Step 6 — Produce the reports and lock the period

Run a property-level P&L, a balance sheet, and reconciliation reports for the caught-up period. Review them for reasonableness — does each property's numbers pass the smell test against what you know? Then close the books (set a closing date and password in QuickBooks Online) so historical months can't drift while you operate going forward. A clean QuickBooks Online setup for landlords with bank rules and a monthly close is what keeps you from ever being here again.

Worked example: what nine months of misbooked mortgage payments looks like

Illustrative example — not a client. An investor with a rental in an LLC pays $1,880/month on the mortgage: $412 principal, $983 interest, $485 escrow. For nine months, the full $1,880 was booked to "Mortgage Expense."

Line	As booked (wrong)	After cleanup (correct)
Interest expense (9 months)	$16,920 ("Mortgage Expense")	$8,847
Loan principal reduction	$0 recorded	$3,708 (liability reduced)
Escrow asset funded	$0 recorded	$4,365 (asset), expensed as taxes/insurance when disbursed
Effect on reported profit	Understated by $8,073	Accurate

The property looked like it was barely breaking even; it was actually cash-flowing. Multiply this by six properties and two years, and you see why cleanup changes refinance conversations, partner distributions, and tax prep — this single error pattern is one of the most common things found in investor books.

What affects cleanup scope and timeline

Across the bookkeeping industry, cleanup and catch-up work is typically scoped after a diagnostic review of the file, and the drivers are consistent (these are market factors, not any firm's pricing):

• Months behind and transaction volume. Twelve months at 150 transactions/month is a different project than twelve months at 900.
• Number of accounts and entities. Every additional bank account, card, loan, and LLC multiplies the reconciliation work — and multi-entity files add intercompany matching.
• State of the existing file. Adding clean months is faster than untangling wrong ones; badly damaged files sometimes justify a full rebuild.
• Statement availability. Missing statements older than the bank's online history window can stall a project for weeks.
• Real estate events in the gap. Purchases, sales, refinances, and rehabs each require closing-statement entries and fixed-asset work beyond routine categorization.
• Property-level requirements. Building class/location structure into historical data takes longer than lump-sum coding — but it's the whole point for an investor.
• Deadline pressure. A filing deadline inside 30–60 days compresses timeline and usually the price, industry-wide.

Professionally, a 12-month catch-up for a small portfolio commonly runs a few weeks; multi-year, multi-entity cleanups run longer. DIY timelines vary too widely to generalize — the honest predictor is your scorecard result above. For what monthly service costs after the cleanup, see how much real estate bookkeeping costs.

How to prepare your records for your CPA

The end goal of catch-up work is usually a tax return. Here is what your CPA actually needs at year-end — sending this package, instead of a QuickBooks invite and an apology, is the difference between a smooth filing and a month of back-and-forth:

Item	Why the CPA needs it
Property-level P&L and year-end balance sheet	Rental activity is generally reported per property (Schedule E for many individual investors); a lump-sum P&L forces the preparer to rebuild detail.
December 31 statements + reconciliation reports for every bank and credit card account	Proves the books tie to the bank — the first thing a preparer checks.
Year-end mortgage statements and Forms 1098 for every loan	Verifies interest expense and year-end loan balances.
Closing statements for every purchase, sale, and refinance during the year	Needed to establish basis, record sale proceeds, and book new loans correctly.
Fixed asset / improvements list per property (with invoices for major work)	Your CPA — not your bookkeeper — decides repair vs. capital improvement treatment; they need the itemized support.
Security deposit ledger (held, received, kept, returned)	Deposits kept during the year may be reportable income; deposits held are not — the CPA needs the split.
Owner contributions and distributions summary, by owner	Required for capital accounts, especially in partnerships and multi-member LLCs.
1099s issued to contractors and any 1099s/K-1s received	Cross-checked against the books for completeness.
Prior-year tax return and depreciation schedule	Carries forward basis, depreciation, and any loss carryovers.
New entity documents (operating agreements, EIN letters) for entities formed during the year	Determines filing requirements before the deadline, not after.

Keep the underlying records after filing: the IRS generally expects supporting records for at least 3 years, and records relating to a property until the limitations period expires for the year you dispose of it — which for buy-and-hold investors means keeping purchase and improvement records essentially for the life of ownership.

Bookkeeping vs. tax vs. management: keep the lanes straight

• Bookkeeping: Capture every transaction, coded by property, with documentation, and reconcile it to source statements. This is what cleanup and catch-up restore.
• Tax: How items are ultimately treated — repair vs. improvement, deposit kept vs. held, depreciation — is determined by your CPA, EA, or tax attorney under current law and your specific facts. Clean books give them the raw material; they don't replace the judgment. Confirm tax treatment of any item in this article with your tax professional.
• Management: Property-level reports exist so you can act — raise a rent, refinance, sell an underperformer. Books that are merely "done for taxes" waste most of their value.

Common mistakes when catching up

• Starting with the newest month because it's freshest. Balances build forward; always start with the oldest unreconciled month.
• Skipping reconciliation once everything is "entered." Unreconciled catch-up is just organized guessing.
• Forcing reconciliations with plug adjustments to hit zero. The difference is a real error hiding somewhere — usually a duplicate or missing transaction.
• Ignoring the balance sheet. A tidy P&L on top of wrong loan, escrow, and deposit balances is still a cleanup project.
• Lump-coding without property detail to finish faster — which guarantees a second project when the CPA or a lender asks for per-property numbers.
• Categorizing "for taxes" — making deductibility calls that belong to the CPA instead of recording items separately and letting the tax pro decide.
• Catching up with no forward system. Without bank rules, a monthly close, and a set day to reconcile, you'll be back here in a year.

What to do next

1. Take the 10-question scorecard above and count your yes answers.
2. Scored 6–8 (behind, not broken): Block the time, pull every statement per Step 1, and work the six steps oldest-month-first. Then set up a monthly close so it sticks.
3. Scored 5 or below, or failed questions 5–7: Get a professional diagnostic before anyone touches the file. Repairing a balance sheet across entities is not a weekend project.
4. Either way, assemble the CPA package from the checklist above — it's the deliverable that actually ends the stress.

QueueFortress does exactly this work: cleanup and catch-up for real estate investors, built property-by-property in QuickBooks Online by a 100% US-based team, then kept current with monthly bookkeeping so the backlog never comes back. If your books are behind and a deadline is coming, see how QueueFortress cleanup, catch-up, and monthly real estate bookkeeping works and book a call to get a scoped plan for your file.

FAQ

How far back should I catch up my books?

At minimum, back to the last reconciled, accurate month — or to January 1 of the earliest unfiled tax year. If prior years were filed from inaccurate books, talk to your CPA before rebuilding those years; whether to amend is a tax decision, not a bookkeeping one.

Do I need cleanup or catch-up if I'm switching from a spreadsheet to QuickBooks Online?

That's a catch-up-style build: set up the file and chart of accounts, enter opening balances from statements and closing documents, then import and reconcile history. The spreadsheet helps as a reference, but statements — not the spreadsheet — are the source of truth.

What does bookkeeping cleanup usually include?

A diagnostic review, then: removing duplicates, categorizing everything (by property), correcting miscoded items like full mortgage payments and security deposits, recording missing transactions, reconciling every account for every month, correcting loan/escrow/deposit/equity balances, and delivering reconciled property-level reports.

Can I just hand my CPA the bank statements and let them sort it out?

You can, but tax preparers typically charge preparer rates for bookkeeping work, do it under deadline pressure, and build only what the return needs — usually without property-level management detail or a reconciled file you can keep using. Catching up first is almost always cheaper and leaves you with an asset, not just a filed return.

Will catching up fix my prior-year tax returns?

No — it produces accurate records for the periods rebuilt. Whether a prior return should be amended based on the corrected numbers is a decision for your CPA or EA.

Sources checked

• IRS Publication 527 (2025), Residential Rental Property — security deposit and rental income treatment. Checked 2026-07-20.
• Intuit — Reconcile an account in QuickBooks Online — reconciliation workflow and $0.00 difference standard. Checked 2026-07-20.
• IRS — How long should I keep records? — record retention periods, including property records. Checked 2026-07-20.
• IRS — About Schedule E (Form 1040) — per-property rental reporting context. Checked 2026-07-20.

This article explains bookkeeping workflows and recordkeeping. It is not tax, legal, or investment advice. Tax treatment of any item discussed depends on your facts and current law — confirm with your CPA, EA, or tax attorney.