Jim Merritt - October 19, 2026

QuickBooks® Online is a powerful accounting tool, but here's something I've learned after more than 25 years of helping businesses use QuickBooks® software:

Just because QuickBooks® allows you to enter a transaction doesn't necessarily mean you've entered it correctly.

Many of the accounting problems we see at QuickTrainer aren't caused by complicated transactions. They're caused by simple mistakes that happen repeatedly—sometimes for months or even years.

The frustrating part? Business owners often don't realize there's a problem until they try to reconcile a bank account, review their financial statements, or prepare information for their accountant.

The good news is that many of these problems can be avoided once you understand what causes them.

Let's look at seven common QuickBooks® Online mistakes, why they happen, and what you can do to correct them.

1. Categorizing Bank Transactions Instead of Matching Them

This is one of the most common mistakes I encounter when reviewing QuickBooks® Online files.

QuickBooks® Online downloads transactions from your connected bank and credit card accounts. When you review these transactions, you generally have two important choices:

• Match: Connect the downloaded transaction to something already recorded in QuickBooks®.

• Categorize: Create a new transaction using the downloaded banking information.

The mistake happens when someone categorizes a transaction that should have been matched.

Here's an example:

You create an invoice for $1,500. Your customer pays the invoice, and you record the payment in QuickBooks®.

A few days later, the $1,500 deposit appears in Bank Transactions.

Instead of matching the deposit to the payment already recorded, you categorize it as Sales Income.

Now you may have recorded the same income twice, or you may have an incorrectly recorded customer payment and an unexplained balance in Undeposited Funds.

How to Fix It

Review downloaded transactions carefully before posting them.

If the transaction already exists in QuickBooks®, look for the appropriate match rather than creating another transaction.

If you've already categorized the transaction incorrectly, review the original payment, deposit, and bank-feed entry. You may be able to undo the bank-feed categorization and match it properly.

Be careful: If the transaction has already been reconciled, investigate the impact before making changes.

The goal is simple: One actual transaction should not become two accounting transactions.

If you find yourself struggling with Bank Transactions, matching, or rules, QuickTrainer's One-on-One Training for QuickBooks Users can help you understand the correct workflow.

2. Recording Customer Payments and Bank Deposits Incorrectly

Customer payments can create some surprisingly confusing accounting problems.

In QuickBooks® Online, there is an important difference between creating an invoice, receiving a payment, and recording the money deposited into your bank account.

When these steps aren't handled correctly, you may encounter:

• Duplicate income

• Invoices that incorrectly remain unpaid

• Unexpected balances in Undeposited Funds

• Deposits that don't match your bank statement

• Incorrect Accounts Receivable balances

Here's an example:

A business receives three customer checks for $500 each.

The checks are recorded as customer payments and deposited together at the bank for $1,500.

However, when the $1,500 deposit appears in Bank Transactions, the user categorizes it directly to an income account rather than matching it to the deposit containing the three customer payments.

The result can be duplicate income and customer payments that remain in Undeposited Funds.

How to Fix It

Establish a consistent process for receiving payments.

1. Create an invoice when appropriate.

2. Use Receive Payment to record the customer's payment against the invoice.

3. Use Undeposited Funds when payments will be grouped into a later bank deposit.

4. Create a Bank Deposit that includes the applicable payments.

5. Match the downloaded bank deposit to the deposit recorded in QuickBooks®.

For merchant processing services that deduct fees or group payments, additional steps may be required to account for processing fees and settlement amounts correctly.

If your Undeposited Funds account contains old transactions, don't start deleting them.

Determine why those transactions are there and whether the related payments were already deposited.

A QuickBooks® Data Review can help identify these problems before corrections are made.

3. Not Reconciling Bank and Credit Card Accounts Every Month

I've encountered businesses that haven't reconciled their bank accounts in months—and sometimes much longer.

Unfortunately, they often assume that because their bank transactions are downloading automatically, everything must be correct.

That's not how accounting works.

A bank connection downloads information. It does not guarantee that your accounting records are accurate.

Reconciliation is the process of comparing your QuickBooks® records to your actual bank or credit card statement.

When you reconcile, you're confirming that the appropriate transactions have been recorded and that the account balances agree.

Without regular reconciliations, problems can go unnoticed.

These may include:

• Duplicate transactions

• Missing expenses

• Incorrect deposits

• Transactions posted to the wrong account

• Payments that never cleared the bank

• Incorrect beginning balances

How to Fix It

Reconcile each bank and credit card account monthly.

Before beginning, make sure you've reviewed the transactions downloaded through Bank Transactions.

Next, compare the statement's ending balance and date to the information entered in QuickBooks®.

If the reconciliation difference isn't zero, investigate the discrepancy rather than forcing the reconciliation to balance.

Here's an important tip:

Don't create a reconciliation adjustment simply because you can't locate a difference.

Doing so may make the reconciliation appear complete without resolving the underlying accounting problem.

If you've fallen several months behind, work through the reconciliations in chronological order.

If you're dealing with multiple reconciliation problems, our Cleanup Services for QuickBooks® Users can help identify and correct the underlying issues.

4. Changing or Deleting Previously Reconciled Transactions

This is one mistake that can turn a relatively clean accounting file into a real mess.

Once a transaction has been reconciled, it becomes part of the accounting records used to establish your bank reconciliation history.

Changing or deleting that transaction can affect subsequent reconciliations.

Here's an example:

You reconciled a bank account for August.

In October, you discover an expense that was categorized incorrectly.

Instead of investigating the transaction, someone deletes it and enters a new expense.

Now your reconciliation history may no longer agree with the transactions in your accounting records.

The next time you reconcile, QuickBooks® may report a beginning balance discrepancy.

How to Fix It

First, determine exactly what needs to be corrected.

If the problem is simply an incorrect expense category, you may be able to correct the category without changing the transaction amount, bank account, or reconciliation status.

However, corrections involving the transaction amount, date, account, or deletion require additional care.

Before making changes:

• Review the original transaction.

• Determine whether it was previously reconciled.

• Review the reconciliation history.

• Check whether the change affects a closed accounting period.

• Consult your accountant when the correction could affect previously reported financial information.

The important lesson: Don't delete previously reconciled transactions simply because something looks wrong.

Understand the accounting impact before making the correction.

QuickTrainer can help with these situations through our Data Review Services for QuickBooks® Users, particularly when you aren't sure which transactions caused the discrepancy.

5. Recording Payroll Transactions Incorrectly

Payroll accounting can be confusing, especially when a business uses a third-party payroll service.

Companies frequently use services that automatically withdraw payroll and payroll taxes from their bank accounts.

Some payroll services also send journal entries directly into QuickBooks® Online.

Problems arise when the payroll journal entries and actual bank withdrawals aren't recorded or matched correctly.

Here's an example:

Your payroll provider sends a journal entry into QuickBooks® recording:

• Gross wages

• Employee payroll withholdings

• Employer payroll taxes

• Payroll liabilities

• Net payroll

Later, the payroll provider withdraws money from your bank account.

If the downloaded bank withdrawal is categorized directly to Payroll Expense without considering the journal entry, payroll expenses may be overstated.

Meanwhile, the payroll liability or clearing accounts may still show balances that should have been reduced.

How to Fix It

Understand how your payroll system communicates with QuickBooks®.

Review the payroll provider's General Ledger mappings and determine how the following items are recorded:

• Gross wages

• Employer payroll taxes

• Employee withholding liabilities

• Net pay

• Payroll tax payments

• Payroll clearing accounts

Next, compare the payroll journal entries to the amounts actually withdrawn from the bank.

If a payroll clearing or liability account is being used, make sure transactions are posted consistently and that balances clear as expected.

Don't automatically categorize every payroll-related bank withdrawal as Payroll Expense.

Remember: Proper payroll accounting involves more than recording money leaving your bank account.

If your payroll integrations or existing QuickBooks® file were not configured correctly, our Setup Services for QuickBooks® Users can help review the accounting structure and General Ledger mappings. Payroll tax compliance and filing questions should be confirmed with your payroll provider or tax professional.

6. Ignoring Unusual Balances on the Balance Sheet

Many business owners spend most of their time reviewing the Profit and Loss report.

That's understandable. After all, everyone wants to know whether the business is making money.

But the Balance Sheet deserves just as much attention.

Your Balance Sheet reports assets, liabilities, and equity at a particular point in time.

It can also provide valuable clues about accounting problems.

Here are a few warning signs:

• Undeposited Funds contains payments from several years ago.

• Accounts Receivable shows amounts that customers have already paid.

• Accounts Payable includes vendor bills that were previously paid.

• A payroll liability account has an unexplained balance.

• A clearing account continues growing month after month.

• A bank account balance doesn't agree with the bank statement.

These situations don't automatically mean your accounting is incorrect, but they certainly deserve investigation.

How to Fix It

Make reviewing the Balance Sheet part of your monthly accounting routine.

Look for account balances that don't make sense.

For example, if Undeposited Funds contains $25,000, ask yourself:

Do we really have $25,000 in customer payments waiting to be deposited?

If the answer is no, something needs attention.

Likewise, if Accounts Payable shows $15,000 outstanding but you believe every vendor has been paid, you need to understand the difference.

The first step is to examine the transactions making up the balance.

Avoid creating journal entries simply to make an account balance disappear.

A journal entry may change the account balance without correcting the original customer, vendor, or payment transaction.

If your Balance Sheet contains questionable balances, consider a QuickBooks® Data Review before beginning cleanup.

7. Assuming That Because QuickBooks® Accepted a Transaction, It Must Be Correct

This may be the most important mistake of all.

QuickBooks® Online has become increasingly automated.

Bank transactions download automatically. Rules suggest account categories. Third-party applications send accounting entries, and AI-powered features can help with various tasks.

These tools can save an enormous amount of time.

But automation does not replace an understanding of accounting.

Here's a simple example:

Suppose you purchase a piece of equipment for $12,000.

QuickBooks® allows you to categorize that purchase directly to Office Supplies Expense.

The transaction may post without an error message.

But depending on the nature of the purchase and your accounting policies, the equipment may need to be recorded as a fixed asset rather than immediately expensed.

QuickBooks® cannot always determine the correct accounting treatment simply from the information supplied by a bank transaction.

How to Fix It

Learn the accounting principles behind the transactions you're entering.

You don't need to become a CPA to manage your bookkeeping, but you should understand the basics.

That includes:

• The difference between an asset and an expense

• How Accounts Receivable and Accounts Payable work

• How customer payments affect financial statements

• Why some transactions belong on the Balance Sheet

• How bank and credit card reconciliations work

• Why financial reports should be reviewed regularly

And most importantly, understand that automation should help you perform your accounting—not make every accounting decision for you.

This is exactly why QuickTrainer offers One-on-One Training for QuickBooks Users.

We don't simply show you where to click. We help you understand why you're performing a particular accounting task and how it affects your financial records.

How Can You Tell If Your QuickBooks® File Already Contains These Mistakes?

Here's something to consider.

You don't have to wait until your accountant tells you there's a problem.

There are several warning signs that may indicate your QuickBooks® file needs attention.

For example:

• Your bank reconciliations no longer balance.

• Your Profit and Loss shows income that seems too high or too low.

• Your Undeposited Funds account contains old transactions.

• Your Accounts Receivable doesn't agree with what customers actually owe.

• Your payroll clearing accounts never return to their expected balances.

• Your Balance Sheet contains accounts you don't recognize.

• Your financial reports simply don't make sense.

If any of these situations sound familiar, the best approach is usually to investigate the problem before making changes.

At QuickTrainer, we believe in a straightforward process:

Review → Diagnose → Correct → Learn → Maintain

That means identifying the problem, understanding what caused it, making the appropriate correction, learning how to avoid repeating the mistake, and maintaining accurate records going forward.

Sometimes the solution is simple.

Other times, a file may need more extensive cleanup.

Either way, understanding what went wrong is an important part of fixing it properly.

How QuickTrainer Can Help You Avoid These Mistakes

QuickTrainer, Inc. has been helping businesses use QuickBooks® software more effectively since 2006.

Our approach is simple: provide practical, personalized assistance based on what your business actually needs.

Whether you're just getting started, trying to correct existing accounting problems, or looking for ongoing assistance, we can help.

One-on-One Training for QuickBooks Users

Learn how to handle the transactions and accounting tasks that matter most to your business. Our personalized training focuses on your experience level, your workflow, and the areas where you need help.

Data Review Services for QuickBooks® Users

Not sure whether your accounting records are correct? We can review your QuickBooks® file, identify potential problems, and recommend the appropriate next steps.

Cleanup Services for QuickBooks® Users

If your file already contains duplicate transactions, reconciliation discrepancies, incorrect balances, or other accounting problems, we can help get things back on track.

Setup Services for QuickBooks® Users

Starting a new business or setting up a new QuickBooks® file? We can help establish the proper accounting structure and workflows from the beginning.

Bookkeeping Services for QuickBooks® Users

Prefer to have someone help maintain your accounting records? Our bookkeeping services can assist with ongoing transaction processing, reconciliations, account reviews, and financial reporting.

The Bottom Line: Accurate Accounting Starts With Understanding What You're Doing

QuickBooks® Online can make accounting easier, but it doesn't eliminate the need to understand how transactions should be recorded.

The mistakes we've discussed are common—and many are preventable.

The key is knowing what to look for, reviewing your financial records regularly, and asking questions when something doesn't make sense.

And if your accounting file already contains problems, don't assume the only solution is to start over.

In many cases, the existing file can be reviewed, corrected, and improved.

That's where experienced guidance can make a real difference.

Need Help With Your QuickBooks® Online Accounting?

If you're dealing with duplicate transactions, incorrect account balances, reconciliation problems, or financial reports you don't understand, QuickTrainer can help.

You don't need to know exactly what's wrong before contacting us.

Tell us what you're experiencing, and we'll help determine the appropriate next step.

QuickTrainer is located in Wilmington, NC and works remotely with businesses throughout the United States.

📞 Call QuickTrainer at 910-338-0488
📧 Email: [email protected]
🌐 www.qti-wilmington.com

Let QuickTrainer give you back your time.

QuickTrainer, Inc. is an independent consulting, training, and bookkeeping company serving QuickBooks® users. QuickTrainer is not affiliated with or employed by Intuit Inc.

Intuit, QuickBooks®, and QuickBooks ProAdvisor® are trademarks or registered trademarks of Intuit Inc. used in accordance with applicable program agreements.