QuickBooks Online Cleanup Checklist: Fix Your Books Before Tax Season

I've worked on QuickBooks cleanup projects involving everything from duplicate transactions and unreconciled bank accounts to customer balances that didn't make sense. One thing I've learned is that cleanup is much easier when you know exactly what to review instead of jumping from one issue to another.

That's why I created this QuickBooks Online cleanup checklist. Use it to review every key area of your QuickBooks file, keep track of what you've already checked, and reduce the chances of overlooking issues before tax season.

What is a QuickBooks Online cleanup?

A QuickBooks Online cleanup involves reviewing the areas where bookkeeping mistakes tend to accumulate over time. Think of it like proofreading a document before submitting it. The document is already written, but you still want to catch spelling mistakes, duplicate sentences, and missing information before anyone reads it.

QuickBooks works the same way. A duplicate bank transaction here or an uncategorized expense there may not seem like a big deal. Over time, though, those small mistakes add up and make your books less reliable.

A cleanup typically focuses on reviewing key areas such as:

• Bank and credit card reconciliations
• Transaction categorization
• Accounts Receivable and Accounts Payable
• Payroll records
• Sales tax
• Inventory (if applicable)
• Fixed assets
• Financial reports

How do you know if your QuickBooks Online file needs cleanup?

Before you start fixing your books, it's worth confirming whether your QuickBooks Online file actually needs a cleanup. Here are some of the most common warning signs I've encountered during cleanup projects.

• Your bank or credit card accounts haven't been reconciled for months. If the balances in QuickBooks don't match your statements, it's difficult to know whether your books are accurate.
• You have a large balance in Uncategorized Income or Uncategorized Expense. This usually means transactions were imported but never properly reviewed, which can affect the accuracy of your financial reports.
• Your Accounts Receivable (A/R) doesn't reflect what customers actually owe. Old invoices, unapplied customer payments, or duplicate invoices can make it look like you're owed more or less than you really are.
• Your Accounts Payable (A/P) doesn't match what you owe vendors. Duplicate bills, unapplied vendor credits, or bills that should have been closed can overstate your outstanding liabilities.
• You're seeing duplicate transactions. This often happens when bank transactions are imported more than once or manually entered after already being downloaded from the bank feed.
• Your accountant asks for multiple corrections before preparing your tax return. If your accountant regularly has to fix reconciliations, reclassify transactions, or investigate unusual balances, it's usually a sign that your books need a more thorough review.
• Your financial reports don't make sense. If your Profit and Loss or Balance Sheet shows numbers that don't match how the business is actually performing, there's likely an underlying bookkeeping issue that needs attention.

The more of these warning signs you recognize, the more valuable a thorough cleanup becomes. The checklist in the next section will help you review each key area of your QuickBooks file so you can identify and correct issues before tax season.

What should a QuickBooks Online cleanup checklist include?

Cleaning up your books is easier when you review one area at a time instead of trying to fix everything at once. I usually start with the items that affect the accuracy of the financial statements, then work through the rest of the file. For each item in this checklist, I'll explain why it matters, how to review it in QuickBooks, and what issues to watch for based on the problems I commonly encounter during cleanup projects.

Reconcile every bank account

If I had to choose just one place to start a QuickBooks cleanup, it would be bank reconciliations. Almost every cleanup project I've worked on has uncovered issues that could have been identified much earlier through regular reconciliations. Until your bank accounts match your bank statements, it's difficult to know whether the rest of your books are accurate.

Things to look for

• Missing bank transactions
• Duplicate downloaded transactions
• Transactions with incorrect amounts or dates
• Transactions cleared in QuickBooks but not on the bank statement
• Reconciliation discrepancies from previously completed periods
• Old outstanding checks or deposits that may need investigation

How to check it

In QuickBooks Online, go to Transactions > Reconcile (or Settings ⚙️ > Reconcile, depending on your version). Review the reconciliation status for each bank account and compare the ending balance and ending date with your latest bank statement.

Reconcile every credit card account

The most common issues I see are duplicate downloaded charges, card payments recorded as expenses, and balances that do not match the statement. These errors can overstate expenses or leave the credit card liability incorrect.

Things to look for

• Duplicate charges imported from the bank feed
• Payments categorized as credit card expenses instead of transfers
• Missing annual fees, interest, refunds, or statement credits
• Personal purchases charged to the business card
• Charges entered under the wrong credit card account
• Old uncleared transactions that do not appear on recent statements
• Beginning balance discrepancies caused by changes to prior reconciled entries

How to check it

Open Reconcile in QuickBooks Online, select the credit card account, and enter the statement’s ending date and ending balance. Match each charge, payment, credit, fee, and interest entry to the statement.

For business cards with multiple employee cardholders, reconcile the main account using the consolidated statement rather than treating every card number as a separate liability unless the accounts were set up that way in QuickBooks.

Review uncategorized transactions

Start by checking the Uncategorized Income and Uncategorized Expense accounts on your Profit and Loss report. These balances usually mean transactions were imported into QuickBooks but never assigned to the correct account. Leaving them unresolved can make your financial reports and tax return inaccurate.

Things to look for

• Transactions posted to Uncategorized Income or Uncategorized Expense
• New vendors or customers that haven't been categorized before
• Personal expenses mixed with business expenses
• Duplicate bank feed transactions
• Transactions assigned to the wrong expense or income account
• Bank transfers incorrectly categorized as income or expenses

How to check it

Open your Profit and Loss report and look for Uncategorized Income or Uncategorized Expense. You can also search for transactions assigned to these accounts from the Chart of Accounts or by running a Transaction Detail by Account report. Review each transaction and assign it to the correct category based on its purpose.

Remove duplicate transactions

Duplicate transactions often happen when transactions are manually entered after already being downloaded from the bank feed or when bank accounts are reconnected, and the same transactions are imported again. If left unchecked, duplicates can overstate your income, expenses, or account balances.

Before deleting a transaction, confirm which one is correct. If one transaction was matched to the bank feed and the other was entered manually, keep the correctly matched transaction and remove the duplicate.

Things to look for

• Bank transactions imported more than once
• Manually entered transactions that were later downloaded from the bank
• Duplicate customer payments or deposits
• Duplicate bills, checks, or expenses
• Duplicate journal entries
• Transactions with the same date, amount, and payee

How to check it

Review your Bank Transactions (Bank Feed) and compare them with your Bank Register. Look for transactions with the same date, amount, and payee. You can also sort transactions by amount or run a Transaction Detail by Account report to identify possible duplicates.

Review Accounts Receivable

One report I always review during a cleanup is the Accounts Receivable (A/R) Aging Summary. It's common to find old unpaid invoices, unapplied customer payments, or duplicate invoices that make it look like customers owe more than they actually do. If these issues aren't corrected, your outstanding receivables and income can be overstated.

Things to look for

• Old unpaid invoices that should have been collected or written off
• Customer payments that were recorded but not applied to invoices
• Duplicate invoices
• Duplicate customer payments
• Credit memos that haven't been applied
• Negative customer balances
• Customer balances that don't match your records

How to check it

Run the Accounts Receivable Aging Summary or Accounts Receivable Aging Detail report in QuickBooks Online. Review outstanding invoices by customer and investigate balances that seem unusually old or don't match your records. Open the customer's transaction history to verify that invoices, payments, credit memos, and refunds have been applied correctly.

Review Accounts Payable

The Accounts Payable (A/P) Aging Summary can reveal bills that were already paid but still appear outstanding, duplicate vendor bills, and unapplied credits. These issues can make it look like the business owes more than it actually does and may also distort expenses.

Things to look for

• Old bills that were already paid
• Duplicate bills
• Bill payments recorded as regular expenses
• Unapplied vendor credits
• Negative vendor balances
• Missing bills or payments
• Vendor balances that do not match statements
• Personal purchases recorded under business vendors

How to check it

Run the Accounts Payable Aging Summary or Accounts Payable Aging Detail report in QuickBooks Online. Review balances by vendor, especially older items, negative balances, and amounts that do not match vendor statements. Open the vendor’s transaction history to confirm that bills, bill payments, vendor credits, and refunds were recorded and applied correctly.

Verify opening balances

Opening balance errors often appear after switching to QuickBooks, connecting a new account, or importing historical data. Even when current transactions are correct, an inaccurate starting balance can prevent reconciliation and leave the Balance Sheet wrong from the beginning.

Things to look for

• Opening balances that do not match prior records
• Incorrect start dates
• Duplicate opening balance entries
• Balances entered with the wrong sign
• Beginning balances posted directly to income or expense accounts
• A remaining balance in Opening Balance Equity
• Historical transactions imported in addition to an opening balance

How to check it

Compare each account’s opening balance and start date in QuickBooks with the source records used during setup, such as prior financial statements, bank statements, loan statements, or the previous accounting system.

Pay close attention to accounts that have never reconciled correctly. Also review the Opening Balance Equity account. A remaining balance may indicate that one or more opening entries were incomplete, duplicated, or posted to the wrong account.

Review payroll entries

Payroll errors can affect several accounts at once, including wages, payroll taxes, benefits, and amounts still owed to employees or tax agencies. I usually compare QuickBooks with the payroll reports and tax filings because the bank withdrawals alone do not show whether payroll was recorded correctly.

Things to look for

• Payroll expenses recorded twice
• Net pay posted as the full payroll expense
• Missing employer payroll taxes
• Payroll tax payments applied to the wrong liability account
• Old payroll liabilities that should already be cleared
• Employee reimbursements recorded as wages
• Manual journal entries that do not match payroll reports
• Payroll transactions posted in the wrong period

How to check it

Review the payroll expense and payroll liability accounts in QuickBooks, then compare them with your payroll summaries, tax filings, and payment records. Confirm that payroll runs, tax payments, benefit deductions, reimbursements, and any manual adjustments were recorded correctly.

When payroll is processed outside QuickBooks, verify that each payroll entry includes the proper split between gross wages, employee deductions, employer taxes, and net pay.

Review inventory (if applicable)

Inventory problems often go unnoticed until product quantities or costs don't match what's actually on the shelf. During cleanup, I pay close attention to negative inventory, incorrect quantities, and unusually high or low inventory values because these issues can affect both the Balance Sheet and the Cost of Goods Sold.

Things to look for

• Negative inventory quantities
• Inventory items with unusually high or low quantities
• Products with incorrect costs
• Duplicate inventory adjustments
• Missing inventory purchases or sales
• Inventory items that no longer exist but remain active
• Differences between physical inventory counts and QuickBooks

How to check it

Run the Inventory Valuation Summary and compare the quantities and values in QuickBooks with your latest physical inventory count. Review recent inventory transactions to confirm purchases, sales, returns, and inventory adjustments were recorded correctly.

If you use another inventory management system, verify that the inventory data syncs correctly with QuickBooks and investigate any differences.

Verify sales tax 

Sales tax errors are often easy to miss because transactions can still be recorded even when the wrong tax rate or tax code is used. During cleanup, I review sales tax carefully because mistakes can lead to inaccurate tax filings and unexpected liabilities.

Things to look for

• Incorrect sales tax rates or tax codes
• Taxable sales recorded as non-taxable (or vice versa)
• Missing or duplicate sales tax payments
• Outstanding sales tax liabilities that should already be paid
• Transactions assigned to the wrong tax agency
• Adjustments made without supporting documentation
• Differences between QuickBooks and filed sales tax returns

How to check it

Open the Sales Tax Center in QuickBooks Online and review your tax agencies, filing history, and outstanding balances. Compare the sales tax collected in QuickBooks with your filed tax returns and payment records. If your business operates in multiple tax jurisdictions, confirm that the correct tax rates and tax codes were applied to each transaction.

Review fixed assets

Fixed asset errors are common when businesses purchase equipment, furniture, vehicles, or computers. I've seen these purchases recorded as regular expenses when they should have been capitalized, or assets left on the books long after they were sold or disposed of. Both situations can affect your financial statements and tax reporting.

Things to look for

• Equipment purchases recorded as operating expenses
• Fixed assets that were sold or disposed of but remain on the books
• Missing depreciation entries
• Duplicate fixed asset records
• Incorrect purchase amounts or acquisition dates
• Assets assigned to the wrong fixed asset account
• Improvements that should be capitalized instead of expensed

How to check it

Review the Fixed Asset accounts in your Chart of Accounts and compare them with your fixed asset register, purchase records, and depreciation schedule. Confirm that recent equipment purchases were recorded correctly and that any assets sold, traded in, or disposed of have been removed from the books.

Review owner's contributions and draws

It's common for business owners to pay personal expenses from the business account or deposit personal funds into the business, especially during the early stages. If these transactions aren't recorded correctly, they can distort business income, expenses, and equity.

Things to look for

• Personal expenses recorded as business expenses
• Personal deposits recorded as business income
• Business expenses paid personally but never reimbursed
• Owner withdrawals recorded as operating expenses
• Duplicate owner contributions or draws
• Transactions posted to the wrong equity account

How to check it

Review the Owner's Contribution, Owner's Draw, or equivalent equity accounts in your Chart of Accounts. Compare these transactions with bank records and supporting documents to confirm that personal deposits, withdrawals, and business expenses paid personally were recorded in the appropriate equity accounts instead of income or expense accounts.

Check miscellaneous accounts

Miscellaneous accounts are often where uncategorized or uncertain transactions end up during day-to-day bookkeeping. During a cleanup, I pay close attention to accounts like Ask My Accountant, Miscellaneous Expense, or Suspense because they can hide transactions that should have been classified elsewhere.

Things to look for

• Transactions sitting in Ask My Accountant or Suspense accounts
• Expenses posted to Miscellaneous Expense that belong to a specific expense category
• Income recorded in miscellaneous accounts instead of the correct income account
• Duplicate or uncategorized transactions
• Old transactions that were never reviewed or reclassified
• Entries without supporting documentation

How to check it

Review the Chart of Accounts for accounts such as Ask My Accountant, Miscellaneous Expense, Suspense, or other similar accounts. Open the transaction details and determine whether each entry belongs in a more appropriate account. Use receipts, invoices, bank descriptions, or supporting documents to help classify transactions correctly.

Review retained earnings

The Retained Earnings account usually doesn't require frequent adjustments, but I always review it during a cleanup if the balance looks unusual or changes unexpectedly. In many cases, unexpected changes are caused by edits to prior-year transactions rather than problems with the retained earnings account itself.

Things to look for

• Unexpected changes in the retained earnings balance
• Transactions added, deleted, or edited in prior years
• Journal entries posted directly to the Retained Earnings account
• Corrections made after the books were closed
• Differences between the current Balance Sheet and prior-year financial statements

How to check it

Review the Balance Sheet and compare the current retained earnings balance with the prior year's financial statements. If you notice a significant change, run an Audit Log report or review transactions dated in closed accounting periods to identify what caused the difference.

If your accountant has already finalized a prior year, avoid making changes without consulting them first.

Review financial reports 

Once the individual accounts have been reviewed, I run the main financial reports to see whether the numbers make sense as a whole. This final review often reveals issues that are easy to miss when looking at transactions one at a time, such as unusual balances, unexpected swings, or accounts that were classified incorrectly.

Things to look for

• Unusually high or low income and expense balances
• Negative asset or liability balances that do not make sense
• Large changes from the prior month or year
• Accounts with balances that should be zero
• Duplicate, inactive, or unnecessary accounts
• Expenses recorded in the wrong category
• Loan, credit card, payroll, tax, or equity balances that do not match supporting records
• Cash flow results that do not align with changes in bank balances

How to check it

Run the Profit and Loss, Balance Sheet, and Statement of Cash Flows for the period you're reviewing. Compare them with prior periods, budgets, tax returns, or other supporting records when available.

What are the most common QuickBooks cleanup mistakes?

Cleaning up QuickBooks isn't just about correcting errors. It's also about avoiding changes that can create even bigger problems. Here are some of the mistakes I see most often and how you can avoid them.

Read also: Common QuickBooks Mistakes and How to Fix Them

Tips to keep your books clean all year

A major cleanup shouldn't be an annual event. In my experience, businesses that follow a simple bookkeeping routine throughout the year spend less time fixing errors before tax season and have more reliable financial reports year-round.

• Reconcile your bank and credit card accounts every month. This helps catch missing, duplicate, or incorrectly recorded transactions before they accumulate.
• Review bank feed transactions regularly. Don't let downloaded transactions pile up. Reviewing them weekly makes categorization much easier.
• Categorize transactions correctly the first time. Taking a few extra seconds to assign the right account reduces the need for corrections later.
• Keep receipts and supporting documents organized. Save digital copies of receipts, invoices, and bills so you can easily verify transactions when questions arise.
• Review your financial reports each month. Scan your Profit and Loss and Balance Sheet for unusual balances or unexpected changes while they're still easy to investigate.
• Apply customer and vendor payments promptly. Matching payments to invoices and bills keeps your Accounts Receivable and Accounts Payable reports accurate.
• Separate business and personal finances. Use dedicated business bank accounts and credit cards to avoid unnecessary cleanup work.
• Review automation periodically. Bank rules, recurring transactions, and recurring journal entries save time, but they should be checked occasionally to ensure they're still posting correctly.
• Close completed accounting periods. Once a month or year has been finalized, set a closing date to prevent accidental changes to completed books.
• Schedule a periodic review with your accountant or bookkeeper. A quarterly or year-end review can identify small issues before they become costly mistakes or tax filing problems.