A messy QuickBooks Online file usually has a combination of problems. Duplicate transactions from importing bank feeds and entering things manually. Expenses categorized incorrectly or not categorized at all. Bank and credit card accounts that haven’t been reconciled in months. Opening balances that were entered wrong when the file was first set up. Fixing these issues requires working through them in the right order.

Start with reconciliation because it reveals what’s actually wrong. Go to Banking, then Reconcile, and select your checking account. Compare your QuickBooks balance to your bank statement for a specific month. If the numbers don’t match, you have transactions that are missing, duplicated, or recorded with wrong amounts. Work through the oldest unreconciled month first. Trying to reconcile recent months when earlier months are off just compounds the confusion.

Duplicates are the most common problem. They happen when you connect a bank feed and also enter transactions manually without matching them. Look for two identical charges on the same date for the same amount. In the Banking tab, QuickBooks sometimes catches potential duplicates and flags them, but not always. You may need to run a Transaction Detail report filtered by vendor or amount to spot them. Delete the duplicate entry, not both, and make sure the remaining one is categorized correctly.

Miscategorized transactions require a review of your expense accounts. Run a Profit and Loss report and look at the category totals. If Legal and Professional Fees shows $47,000 but you only spent $3,000 on your accountant, something got coded wrong. Click into the category to see the transactions and fix them one by one. Common mistakes include coding owner draws as expenses, putting loan payments in the wrong account, and categorizing transfers as income or expenses when they should hit balance sheet accounts.

Opening balances cause problems that ripple through everything else. If your beginning balance was wrong when you set up QuickBooks or migrated from another system, every reconciliation will be off by that amount. Check your opening balance equity account on the Balance Sheet. If it has a large unexplained balance, something went wrong at setup. Correcting this sometimes requires adjusting journal entries that go back to day one.

Uncategorized transactions pile up when bank feed items get imported but never reviewed. Open the Banking tab and work through anything sitting in the For Review section. Each transaction needs to be categorized or matched to an existing entry. Letting these accumulate makes month-end reconciliation nearly impossible.

After fixing everything, run your Profit and Loss and Balance Sheet reports again. The Balance Sheet should balance. Retained Earnings plus current year net income should tie to what’s on your income statement. Your bank and credit card accounts should match your actual statements. If something still looks off, there’s more cleanup to do.

This process can take hours or days depending on how far behind things are. If you’re dealing with months or years of neglected books, catch-up bookkeeping might be more practical than trying to fix it yourself. Getting the file cleaned up properly means your financial reports actually reflect reality, which matters when tax time comes or you need to make business decisions.

The best way to avoid this situation going forward is consistent monthly reconciliation. When a small business bookkeeping service on Long Island handles your books every month, problems get caught and fixed when they’re small. Letting things go for six months turns a minor discrepancy into a major cleanup project.