7 Signs Your QuickBooks File Needs a Cleanup

QuickBooks only gives you useful numbers when the data behind them is clean. When it isn’t, your profit and loss report can look fine while your bank balance tells a different story. Most small business files drift out of shape slowly, a few skipped reconciliations here and some guessed categories there, until nobody trusts the reports.

Here are seven signs it’s time for a cleanup, and what each one usually means.

1. Your bank and credit card accounts aren’t reconciled

Reconciling means matching every transaction in QuickBooks to your bank or card statement and confirming the ending balances agree. If the last completed reconciliation was months ago, or never, you can’t be sure your cash balance is right. Missing deposits, duplicate expenses and old uncleared checks all hide here.

Quick check: go to the reconcile screen for each bank and card account and look at the “last reconciled” date. Anything older than last month needs attention.

2. “Uncategorized” or “Ask My Accountant” keeps growing

Bank feeds make it easy to accept transactions without choosing a real category. Over time, amounts pile up in Uncategorized Income, Uncategorized Expense or Ask My Accountant. Those dollars are missing from the lines where they belong, so your expense reports and tax deductions are understated in some places and overstated in others.

Quick check: run a Profit and Loss report for the year and look for any uncategorized lines. A small balance you’re actively working through is normal. A large or growing one is not.

3. Customer payments are stuck waiting to be deposited

When you record a customer payment, QuickBooks Online holds it in an account now called Payments to Deposit (long known as Undeposited Funds) until you group it into a bank deposit. If deposits get recorded straight from the bank feed instead, those payments never leave the holding account. Your income can end up counted twice, or invoices stay open even though the customer paid.

Quick check: open the Payments to Deposit (or Undeposited Funds) account. If it shows payments older than a week or two, they probably need to be matched to real deposits.

4. Your receivables report is full of old invoices

An Accounts Receivable aging report that lists invoices from many months ago usually means one of three things: the customer really hasn’t paid, the payment was recorded incorrectly, or the invoice should have been voided. Each one needs a different fix, and leaving them alone makes your income and your collections picture unreliable.

The same goes for Accounts Payable. Old unpaid bills often turn out to be bills that were paid directly from the bank without being matched.

5. Opening Balance Equity has a balance

QuickBooks uses Opening Balance Equity as a temporary holding account when accounts are set up with starting balances. In a healthy file it is usually cleared to zero once setup is complete. A lingering balance often points to a setup step that was never finished or to adjustments made to force balances to match.

6. You see negative balances that shouldn’t be possible

A bank account showing a negative balance when the real account never went below zero, or an inventory item with negative quantity, are signs that transactions were recorded out of order, duplicated or put in the wrong account.

7. You don’t trust the reports enough to make decisions

This is the most important sign. If you look at your Profit and Loss or Balance Sheet and immediately think “that can’t be right”, the file isn’t doing its job. Clean books should make it easy to answer simple questions: Did we make money last quarter? How much cash can we safely spend? Who owes us?

What a cleanup involves

A typical cleanup works backward from the most recent clean point:

1. Reconcile every bank, credit card and loan account, month by month.
2. Recategorize uncategorized and misclassified transactions.
3. Match customer payments and vendor bills to real deposits and payments, and resolve old open items.
4. Fix setup leftovers such as Opening Balance Equity.
5. Review the chart of accounts so future transactions land in the right place.

The goal is not only to fix the past, but to set up a monthly routine so the file stays clean: reconcile every month, clear the bank feed weekly, and review reports before you need them.

When to get help

If you spotted three or more of these signs, or if tax season is close, it is usually faster to have a bookkeeper take on the cleanup than to work through it alone. A clean file saves time at tax time and gives you numbers you can actually use to run the business.