Nobody sets out to make a mess of their books. It happens one reasonable shortcut at a time. You accept a bank feed match without looking because you're busy. You record a customer payment as a new deposit because the invoice is somewhere else. You promise yourself you'll categorize everything at the end of the month. Each one feels harmless… until your reports stop making sense and you can't remember which shortcut caused it.
Here are nine of the most common QuickBooks mistakes, why they matter, and how to fix them.
1. Mixing personal and business transactions
The problem: Personal purchases on the business card, or business expenses on a personal card, make your books harder to read and your tax records weaker.
The fix: Use separate business accounts going forward. For past transactions, categorize personal spending as an owner's draw (or the equivalent for your business type), and record business expenses paid personally as an owner contribution or reimbursement. Ask your accountant which approach fits your setup.
2. Recording customer payments as new income
The problem: You send an invoice, the customer pays, and the deposit shows up in the bank feed. If you categorize that deposit as "Sales" instead of matching it to the invoice, QuickBooks counts the income twice, once from the invoice and once from the deposit. The invoice also stays open, making it look like the customer still owes you.
The fix: Always use Receive Payment against the invoice, or match the bank deposit to the existing payment. If you've already double-counted, delete the duplicate deposit categorization and match it correctly.
3. Ignoring the "Payments to deposit" account
The problem: In QuickBooks Online, payments you receive can sit in a holding account (often called Payments to Deposit, formerly Undeposited Funds) until you record the bank deposit. If you never complete that step, that holding account balloons and your bank balance looks low.
The fix: Check this account regularly. Group received payments into bank deposits that match what actually hit your bank, then match those deposits in the bank feed.
4. Skipping reconciliation
The problem: Without monthly reconciliation, duplicates, missing transactions, and errors pile up quietly.
The fix: Reconcile every bank and credit card account monthly. If you're months behind, start with the oldest unreconciled month and work forward.
5. Overusing "Uncategorized" or "Ask My Accountant"
The problem: These accounts are meant for occasional uncertainty. When they hold hundreds of transactions, your Profit and Loss report can't tell you much.
The fix: Review them monthly. Most transactions can be categorized with a quick look at the receipt or vendor name. Keep a short list of true questions for your accountant.
6. Bank rules that are too broad
The problem: A rule that automatically categorizes everything from a big retailer as one expense will misfile anything that doesn't fit, sometimes for months.
The fix: Make rules specific. Use conditions on description and amount where possible. Consider setting rules to suggest a category instead of auto-adding, so you still glance at each one.
7. Recording transfers as income or expenses
The problem: Moving money from checking to savings, or paying your credit card from checking, isn't income or an expense. But if each side gets categorized separately, it can inflate both.
The fix: Record these as transfers between accounts. When paying a credit card, use the transfer or credit card payment option so both accounts are updated correctly.
8. Deleting transactions instead of fixing them
The problem: Deleting a transaction you don't understand can break a reconciled period or erase a real record.
The fix: Investigate first. Use the audit log to see who changed what and when. If something needs to be corrected, edit or void it with a clear memo, and avoid changing reconciled months unless you know why.
9. Setting up too many accounts
The problem: A chart of accounts with dozens of overlapping categories ("Office Supplies," "Supplies," "Office Stuff") leads to inconsistent categorizing and confusing reports.
The fix: Merge duplicates where QuickBooks allows it, or mark extras inactive. Keep accounts broad enough to be useful. Use the vendor list, memos, or tags for extra detail.
How to know if your file needs a cleanup
Watch for these warning signs:
- Your QuickBooks bank balance doesn't match your bank
- Customers appear to owe money they've already paid
- Income on your Profit and Loss seems much higher than reality
- Large balances sit in uncategorized or holding accounts
- Your accountant keeps sending lists of questions
If you see two or more, set aside time to work through the fixes above, oldest problems first.
Prevention beats cleanup
A simple weekly routine prevents most of these mistakes:
- Review and categorize the bank feed
- Match deposits to invoices and payments
- Check the payments holding account
- Glance at your bank rules if something looks off
And once a month, reconcile and run your Profit and Loss.
Learn to do it right the first time
Most QuickBooks mistakes come from not knowing how the pieces connect, not from carelessness. Our QuickBooks Mastery for Small Business course explains how invoices, payments, deposits, bank feeds, rules, and reconciliation fit together, so you can keep clean books without second-guessing every click.