You open QuickBooks Online, look at your dashboard, and realize you do not trust a single number on the screen. Maybe you are months behind on entering transactions, or a tax deadline is approaching and your balance sheet looks completely wrong. Instead of ignoring the problem, you can use this systematic QuickBooks cleanup checklist to get your records back on track and get numbers you can actually trust.
What is a QuickBooks cleanup?
A QuickBooks cleanup is going back through the file to reconcile every bank and credit-card account, correct miscategorized transactions, remove duplicates, and get the books to match reality — restoring the month-end standard: reconciled accounts, categorized transactions, and a P&L plus balance sheet you can trust.
How do you know your file needs cleanup?
It is easy for a software file to get messy over time. You likely need a bookkeeping cleanup if you notice any of these common symptoms in your file:
- The bank balance showing in your QuickBooks dashboard does not match your actual bank statement balance.
- You have months of unreconciled transactions sitting in your system.
- "Uncategorized Expense," "Uncategorized Income," or "Ask My Accountant" accounts are piling up with transactions you did not know what to do with.
- Duplicate transactions are appearing in your ledger, often caused by duplicate bank feed imports or faulty app syncs.
- Negative balances show up on your balance sheet in accounts that should only have positive numbers, like credit cards or liability accounts.
- You look at your Profit and Loss report and the numbers simply do not match your actual business reality.
The QuickBooks cleanup checklist
To fix these issues, you need to work through your file systematically. Open your QuickBooks Online file in one window, open this checklist in another, and follow these ten steps to get your books back in order.
1. Gather bank and credit-card statements for the cleanup period
Before you change any numbers in QuickBooks, collect every PDF bank and credit card statement for the entire period you need to clean up. Having these documents ready lets you verify the exact opening and closing balances for every single month. This preparation ensures you are not guessing when you start matching numbers, giving you a solid paper trail to verify your work.
2. Pick your starting point
Go to the Reconcile tool (located under the Gear icon or the Accounting tab) and look at your reconciliation history. Find the exact date where your balances last matched your bank statements perfectly. This is your baseline. You will work forward from this date, making sure you do not touch or alter any prior reconciled periods, as doing so will break your historical reports.
3. Clear the bank feed backlog
Navigate to the Transactions > Bank transactions screen. Here, you will see all the transactions waiting in your "For review" tab. Work through these one by one.
- Match transactions that already exist in your system, such as invoices you paid or sales receipts you entered.
- Add transactions that are missing, assigning them to the correct category.
- Avoid the temptation to click "Add" on everything without looking, as this is the fastest way to create duplicate entries.
4. Hunt duplicates
Sometimes transactions get imported twice, especially if you use external software. Intuit says QuickBooks Online connects to over 300 third-party apps. While this is great when configured correctly, it can turn into a duplicate machine when two different sources feed the same transactions into your system. Review your register for transactions with identical dates and amounts, and exclude any duplicates from your bank feed before they enter your ledger.
5. Reconcile every account, month by month
Open the Reconcile tool again. According to the Bureau of Labor Statistics, checking figures and postings for accuracy and reconciling or reporting differences are the core of a bookkeeper's defined job. This is the step that makes the rest of your file trustworthy. Input your statement ending balance and ending date, and check off transactions until your "Difference" reads exactly $0.00. Complete this process month by month for every bank account and credit card.
6. Fix categorization errors
Search your Chart of Accounts for "Uncategorized Expense," "Uncategorized Income," or "Undeposited Funds." Intuit notes that QBO's automation "learns how you categorize income and expenses and then automatically matches and records transactions from then on." This means early miscategorizations will compound over time until you manually reset the pattern. Go through these uncategorized accounts and reassign the transactions to their correct expense or income categories.
7. Tidy the chart of accounts
Look at your list of accounts under Transactions > Chart of accounts. If you have three different accounts for "Office Supplies" or multiple duplicate categories, merge them to keep your reports clean. You can merge accounts by renaming one to match the other exactly. Deactivate any accounts you no longer use so you can stop the same type of expense from landing in three different places in the future.
8. Clean up Undeposited Funds and old open invoices or bills
Run your A/R Aging and A/P Aging reports to see if you have unpaid invoices or bills from months or years ago. Often, these were actually paid, but the payment was deposited directly to the bank feed instead of being matched to the invoice. This leaves the invoice open and creates a mess in your Undeposited Funds account. Match those payments to the invoices to clear out these phantom balances.
9. Rerun your financial reports
Go to the Reports menu and run your Profit and Loss and Balance Sheet. Look at every line item to ensure the numbers make sense. Your balance sheet accounts must tie directly to your actual bank and credit card statements for the end of the cleanup period. If a balance looks unusually high or low, click into the number to see the underlying transactions and correct any remaining errors.
10. Set a month-end routine
The ultimate goal of a cleanup is to establish a solid routine so you never have to do this again. The standard for healthy books is monthly reconciliation, proper categorization, and a Profit and Loss plus Balance Sheet delivered on a consistent schedule. If you want to hand this off to a professional to ensure it stays accurate, you can explore monthly bookkeeping services to keep the file clean month after month.
Cleanup vs. catch-up bookkeeping — what's the difference?
While people often use these terms interchangeably, they refer to two different problems.
- Catch up bookkeeping means entering months or years of financial data that were never recorded in the first place. Your bank feeds are empty, your invoices are unentered, and you need to build the books from scratch.
- Bookkeeping cleanup means fixing a file where transactions were entered, but they were done incorrectly. You might have duplicate entries, miscategorized accounts, or reconciliation discrepancies.
Most real-world projects are a mix of both. You might need to perform some catch up bookkeeping for recent months while simultaneously cleaning up the errors made earlier in the year.
How long does a QuickBooks cleanup take?
The time it takes to clean up your books depends on how many months you are behind, the number of bank and credit card accounts you use, and your overall transaction volume. A file with one bank account and fifty transactions a month will take much less time than a complex file with multiple inventory apps, payroll, and hundreds of monthly transactions.
To give you a real example of how quickly this can be resolved with dedicated help, a client called Avenue Bookkeeping on April 1st with two years of backlogged books and a tax deadline breathing down his neck. I worked through Easter weekend and had his books clean within a week and a half. While that was just one real project and every file is scoped on its own, the point is that even a serious backlog is entirely fixable.
What does a QuickBooks cleanup cost?
Because every business file has different levels of complexity, there is no one-size-fits-all price for a cleanup. Avenue Bookkeeping assesses the scope of your file first and quotes the project before starting, whether your file needs a few months of attention or a few years of deep cleaning.
Pricing depends entirely on what the scope assessment finds, which is why I assess the file first. This approach ensures you know the scope and the quote before any work begins. If you want to know what it will take to get your file back in order, you can learn more about my bookkeeping cleanup services.
Should you do it yourself or hire it out?
The checklist above is completely DIY-able if you only have a few messy months on one or two accounts. If you have the time and comfort level with the software, you can work through the steps to get your files clean.
However, a professional cleanup pays for itself if you have a year or more of backlog, payroll in the mix, or a file that was set up wrong from day one. As of July 2026, Intuit's QBO plan lineup runs from Simple Start at $38/mo, Essentials at $75/mo, Plus at $115/mo, to Advanced at $275/mo. Many business owners self-set-up on a plan or settings that do not fit their operations, and the file shows it. A file that was wrong from the start might need professional QuickBooks setup attention rather than just a simple cleanup.
As a solo bookkeeper with credentials including QuickBooks® Online Certified — Level 1, QuickBooks® Online Certified — Level 2, and QuickBooks® Online Payroll Certified, I have the training to spot and fix these structural setup issues quickly.
The bottom line
Working through this checklist top to bottom rewards you with a file you can trust and tax-ready books for a year-end CPA handoff. Washington businesses also file state excise returns through the year — with monthly returns due the 25th of the following month, quarterly returns due the end of the month after the quarter, and annual returns due April 15 per the WA Dept. of Revenue — and those filings draw on the very same clean records.
If you would rather focus on running your business than untangling bank feeds, contact me for a Free Consultation. Avenue Bookkeeping serves Spokane, Spokane Valley, Coeur d'Alene, and the Inland Northwest, helping business owners turn messy data into clear, reliable numbers.