5 Common QuickBooks Errors (And How to Fix Them)

QuickBooks Online is a powerful bookkeeping tool, but even experienced users can make mistakes that throw off financial reports. 

Some errors go unnoticed until tax time, while others create confusion when reconciling accounts.

In this guide, we’ll cover the most common QuickBooks errors, how to fix them, and tips to prevent them in the future. 

1. Not Deducting Fees from Deposits

When customers pay via Stripe, PayPal, or Square, the payment processor takes a fee before depositing the money into your account. 

However, QuickBooks does not automatically know that a transaction includes income and a fee.

You need to record both the full payment and the deducted fee. Otherwise, your income reports will be incorrect.

How This Mistake Happens:

The business owner records the deposit as the amount received instead of tracking the full invoice payment and the associated fee.

How to Fix It:

Use a Bank Deposit to track both the payment and the fees:

  1. Go to + New → Bank Deposit.
  2. Select the payment received.
  3. Add a second line for the processing fee:
    1. Category: Whatever you use to record fees.
    2. Amount: Enter the fee as a negative number (e.g., -$15.00).
      Bank deposit recording merchant fees in QBO
  4. Adjust the income line to the full payment amount.
  5. Make sure the total matches the actual deposit amount.
  6. Click Save.

📹 Watch my video on How to Record Deposits with Fees in QuickBooks Online (Stripe, Square, etc.).

Or, split the transaction in Bank Transactions:

  1. Click Transactions → Bank Transactions in the left-side menu.
  2. Select the appropriate bank account tile.
  3. Find and click on the transaction.
  4. Click the Split button.
  5. Adjust the income line to the full payment amount.
  6. Add the processing fee
    1. Category: Whatever you use to record fees.
    2. Amount: Enter the fee as a negative number (e.g., -$15.00).
      Splitting a transaction with a merchant fee in QBO
  7. Make sure the difference is $0.00.
  8. Click Split and add.

📹 Watch my video on How to Record Payment Processor Fees in QuickBooks Online – Stripe Example

2. Not Reconciling Correctly (or at All!)

Reconciling your bank accounts ensures QuickBooks matches your actual bank transactions.

But many business owners either skip reconciliation entirely or don’t check for uncleared transactions.

How This Mistake Happens:

Old or duplicate transactions stay in the register, causing incorrect balances on reports.

How to Fix It:

Reconcile your accounts every month to catch discrepancies:

  1. Click Transactions → Reconcile in the left side menu.
  2. Select the bank account you’re reconciling.
  3. Enter the ending balance and date from your bank statement.
  4. Check off transactions that appear on the bank statement.
  5. Investigate and fix uncleared transactions:
    • If a check hasn’t cleared, verify whether it’s still valid.
    • If the transaction is a duplicate, delete it.

💡 Tip: If your QuickBooks bank balance never matches your actual bank, there’s likely an error in reconciliation.

Additional Resources:

3. Messy Chart of Accounts

A well-organized Chart of Accounts is important for accurate financial reporting. However, many business owners create unnecessary accounts or misclassify expenses as assets.

How This Mistake Happens:

A business owner adds expenses to asset accounts, like listing software subscriptions under Fixed Assets instead of as Operating Expenses.

How to Fix It:

Review your Chart of Accounts:

  1. Click Transactions → Chart of Accounts in the left side menu.
  2. Sort by account type to find misclassified expenses.
  3. Reclassify incorrect accounts:
    1. Click the drop-down on the right and select Edit.
    2. Select an appropriate Account type.
    3. Click Save.
  4. Merge duplicate accounts to simplify reporting.
    1. Copy the Account name & Detail type of the account you want to keep.
    2. Click the drop-down on the right and select Edit on the account you want to merge.
    3. Change the Account name & Detail type to match the account you’re keeping. 
    4. Click Yes, merge accounts.
    5. Click Save.

💡 Tip: If your Balance Sheet includes expenses, something is likely misclassified.

📹 Watch my video on How to Edit the Chart of Accounts in QuickBooks Online.

4. Loan Payments Aren’t Categorized Correctly

Loan payments aren’t just expenses—they reduce your loan liability. However, many users record the entire loan payment as an expense, which skews financial reports.

How This Mistake Happens:

The full loan payment is categorized under Loan Payment Expense, instead of separating the principal and interest.

How to Fix It:

Break down loan payments correctly:

  1. Click + New → Check or Expense.
  2. Select the lender as the payee.
  3. Split the payment into two categories:
    • Principal → Assigned to the loan liability account.
    • Interest → Assigned to Interest Expense.
      Splitting a loan payment between principal and interest in QBO
  4. Click Save.

💡 Tip: Regularly reconcile your loan account to ensure all payments are recorded properly.

📹 Watch my video on How to Record A Payment To A Loan In QuickBooks Online.

5. Payroll Errors That Affect Financial Reports

Payroll mistakes can cause incorrect tax filings, unbalanced financials, and compliance issues.

Many bookkeepers struggle with tracking payroll liabilities, categorizing wages, and dealing with payroll issues.

How This Mistake Happens:

Payroll liabilities (such as taxes withheld from employees) are recorded as expenses instead of liabilities.

How to Fix It:

Ensure payroll is recorded correctly:

  1. Payroll expenses (wages, employer taxes) should go under Payroll Expenses.
  2. Employee tax withholdings should be categorized under Payroll Liabilities until paid.

Example payroll journal entry

💡 Tip: If QuickBooks Payroll is giving you incorrect payroll tax calculations, check out Payroll Restoration for troubleshooting support.

Want to avoid payroll mistakes? Learn how to handle payroll correctly in our payroll course: Gentle Frog Payroll with QuickBooks Online.

Final Thoughts: Avoiding QuickBooks Errors

Mistakes in QuickBooks can lead to incorrect reports, tax issues, and hours of cleanup work.

You can keep your books accurate and avoid financial headaches by catching and fixing errors early.

Key Takeaways:

  • Split bank deposits or downloaded transactions to track full payments and processor fees.
  • Reconcile accounts monthly to find missing or duplicate transactions.
  • Review your Chart of Accounts for misclassified accounts and duplicates.
  • Record loan payments correctly—split principal and interest.
  • Ensure payroll liabilities are tracked properly to avoid compliance issues.

Spot mistakes before they get out of control with our FREE Review Your QuickBooks Mini-Course.

Need some one-on-one QuickBooks assistance?
Share Now

This content is for information purposes only and should not be considered legal, accounting, or tax advice, or a substitute for obtaining such advice specific to your business. Additional information and exceptions may apply. Applicable laws may vary by state or locality. No assurance is given that the information is comprehensive in its coverage or that it is suitable in dealing with a customer’s particular situation. Gentle Frog, LLC does not have any responsibility for updating or revising any information presented herein. Accordingly, the information provided should not be relied upon as a substitute for independent research. Gentle Frog, LLC does not warrant that the material contained herein will continue to be accurate, nor that it is completely free of errors when published. Readers and viewers should verify statements before relying on them.

Leave a Reply

Your email address will not be published. Required fields are marked *

Read similar articles

5 Common QuickBooks Errors (And How to Fix Them)

Learn how to handle 5 common errors in QuickBooks Online.

Finding the Right Mentor and Coaching for Your Bookkeeping Journey

Learn how mentor and coaching can transform your bookkeeping business and help you achieve your professional goals.

QuickBooks Test Drive: How to Access and Use the Sample Company

Learn how to access QuickBooks Test Drive to practice transactions and explore features without affecting real data.

Have a QuickBooks / Bookkeeping Question?

Let me know what you’d like to see in future videos, blog posts, and courses.

Review Your QuickBooks

Are you a small business owner struggling to make sense of your QuickBooks data?

  • Discover how to spot costly mistakes in your bookkeeping and fix them quickly and easily.

  • Save time and money by streamlining your bookkeeping process and reducing errors.

  • Learn how to identify trends in your financial data so you can make smarter business decisions.

  • Get organized and stay on top of your finances by tracking expenses, managing receipts, and closing your books effectively.

Sign up now for this free mini-course and start mastering the essential bookkeeping skills that every small business owner needs to succeed!

FREE Mini Course

Sign up now and enjoy the peace of mind that comes with knowing your bookkeeping is accurate, up-to-date, and free from costly errors.

We won’t send spam. Unsubscribe at any time.

Review Your QuickBooks

Are you a small business owner struggling to make sense of your QuickBooks data?

  • Discover how to spot costly mistakes in your bookkeeping and fix them quickly and easily.

  • Save time and money by streamlining your bookkeeping process and reducing errors.

  • Learn how to identify trends in your financial data so you can make smarter business decisions.

  • Get organized and stay on top of your finances by tracking expenses, managing receipts, and closing your books effectively.

Sign up now for this free mini-course and start mastering the essential bookkeeping skills that every small business owner needs to succeed!

FREE Mini Course

Sign up now and enjoy the peace of mind that comes with knowing your bookkeeping is accurate, up-to-date, and free from costly errors.

We won’t send spam. Unsubscribe at any time.