Free download
QuickBooks cleanup checklist for rental property books
A working checklist for cleaning up messy QuickBooks books, built for rental properties: 26 checks in six phases, in the order that actually works, with the landlord-specific traps the generic checklists skip. Status dropdowns and a progress counter, in a plain XLSX. No email, no signup.
- Six phases in cleanup order: scope, reconcile, chart of accounts, categorize, rental traps, close
- Every check carries the QBO path and why it matters
- Status dropdown per row, live progress counter up top
Educational template, not tax or accounting advice. Written for QuickBooks Online; the same checks apply in Desktop with different menu paths.
Order is the whole trick
Most failed cleanups fail on sequence, not effort. Categorizing before you reconcile means recategorizing the duplicates you have not found yet. Trusting a P&L before Undeposited Funds is empty means chasing income that was never real. The checklist runs the phases in dependency order: scope and back up first, reconcile every account oldest month first, fix the chart of accounts (our free rental chart of accounts is the target state, importable in one upload), then categorize, then the rental-specific work, and only then the reports you will actually hand to a CPA. Work it top to bottom and each phase makes the next one shorter. The narrative version of this process, with the judgment calls written out, is our rental books cleanup guide.
What a rental cleanup has that a generic one does not
Phase 5 is the reason this checklist exists. Generic cleanup lists stop at "categorize everything and reconcile", which leaves rental books wrong in ways that change the tax return:
| The trap | What it does to the books |
|---|---|
| Mortgage payment booked as one lump expense | Overstates deductions by the principal; the interest line the IRS matches against Form 1098 is missing |
| Security deposits booked as rent | Inflates income the year received, then double-counts at move-out. Deposits are a liability until kept |
| A new roof sitting in Repairs | A capital improvement depreciates over 27.5 years; only real repairs deduct this year |
| No class or location per property | One combined P&L cannot fill a per-property Schedule E, and a preparer bills hours splitting it |
| Custom expense categories | Every category needs re-translating to a Schedule E line at tax time; our categorizer maps any expense to its line |
Reconcile oldest-first, always
Every month reconciles against the month before it, so an error left in March quietly re-appears in every month after. That is why phase 2 insists on oldest-first and to-the-penny, and why the checklist has you record the starting mess in phase 1: scope measured up front is the difference between a weekend cleanup and a quarter of dabbling. If reconciliation itself is the unfamiliar part, the reconcile-without-a-bookkeeper guide walks it step by step, and the bookkeeping-from-scratch guide covers the habits that keep a cleaned file clean.
What clean looks like when you are done
Phase 6 is the proof: a P&L by property that matches what you know about each building, a balance sheet where the loan balances equal the lender statements, zero uncategorized anything, and a closing date with a password so nothing back-dated can quietly move it. That set of reports is exactly what a preparer needs, which is why a clean file also cuts the cost of tax season help: cleanup work is billed by the hour, and this checklist is the hours.
Keeping it clean is the actual product
A cleanup is a one-time payment on a recurring debt: the file starts drifting again the day you finish. Our bookkeeping product does the phase 2 through 5 work continuously on rental books, so the mortgage splits, deposit liabilities, improvement-vs-repair calls, and per-property tagging happen as transactions land, not in a year-end rescue. This checklist is the same standard, run by hand.
Frequently asked questions
What is a QuickBooks cleanup?
A pass through the whole file that makes the books match reality: every account reconciled to its statement, every transaction categorized to a real account, duplicates and stale balances removed, and the reports proven before anything is filed from them. For rental books it has a second half most definitions skip: mortgage payments split into principal and interest, security deposits held as liabilities, improvements separated from repairs, and every transaction tagged to its property.
How do I clean up messy books in QuickBooks?
In dependency order, not by whatever looks worst. Back up and measure the mess first, reconcile every bank and card account oldest month first, fix the chart of accounts, then categorize to zero, then work the rental-specific corrections, and finish by proving the reports and locking a closing date. Categorizing before reconciling is the classic false start: you end up categorizing duplicates you have not found yet. The checklist runs the six phases in that order.
How long does a QuickBooks cleanup take?
Scope decides it, which is why the checklist has you count the mess before touching it. A single property with one bank account and a few uncategorized months is a focused weekend. Several properties, mixed personal spending, and a year of unreconciled statements is 20 to 40 working hours. The multiplier is almost always reconciliation depth: months compound, so a year behind is not twelve times one month, it is worse.
How much does a QuickBooks cleanup cost to have done?
Bookkeepers commonly price cleanup at $50 to $100 an hour or quote a flat project fee in the $500 to $2,500 range per year of mess, with rental books toward the high side because of the property-level work. The checklist is the same task list a hired cleanup runs, so doing even the first two phases yourself (reconcile and categorize) shrinks a quote meaningfully. Our own AI bookkeeper does the recurring version of this on rental books as transactions land.
How should QuickBooks be set up for rental properties?
One class or location per property so every report can split by building, expense accounts that mirror the Schedule E lines instead of custom names, the mortgage as a liability account with payments split principal-interest-escrow, a liability account for security deposits, and a fixed-asset account per property for improvements on the depreciation schedule. That setup is what phase 3 of the checklist checks, and it is what makes tax season a copy job instead of a translation project.
How do I record security deposits and mortgage payments in QuickBooks?
A security deposit in is a liability (Tenant Security Deposits), not income; it becomes income only for the portion you keep at move-out, and the returned portion just clears the liability. A mortgage payment is three lines: principal reduces the loan liability, interest goes to mortgage interest expense, and the escrow portion sits in an escrow account until the lender actually pays the tax or insurance bill. Booked as lump expenses, both quietly misstate income.