Bookkeeping

10 common QuickBooks Online mistakes and how to avoid them

Most QuickBooks Online errors stay invisible until tax time, when the profit on the report doesn't match the bank and expenses turn out to be overstated or missing. Here are ten common QuickBooks Online mistakes that keep showing up in small business books: how they happen, what they cost and how to fix them before they end up on a tax return.

Updated 7 min readNova Tax · reviewed by an Enrolled Agent
Need help?
QuickBooks & Zoho setup

We set up QuickBooks Online or Zoho Books with a chart of accounts built around your tax return and connect your bank and cards. The software subscription is paid separately.

Send a request — it’s free More about this service Call: +1 (929) 340-2427 Consultation from $120
Alena Tishchenko, Enrolled Agent
Alena TishchenkoEnrolled Agent, founder of Nova Tax

QuickBooks Online shows exactly what goes into it. If transactions are recorded wrong, the software will neatly produce the wrong profit and loss report, and your tax return will be prepared from it. The IRS doesn't require any particular software, but under Publication 583 your records must clearly show income and expenses, with a document behind every number. Below are the common QuickBooks Online mistakes that come up most often and how to spot them.

Why bookkeeping mistakes get expensive

An error in the books becomes an error in your tax. Overstated revenue means paying tax you don't owe; understated revenue means an underpayment with interest and penalties. Missed expenses mean lost deductions. And the longer a mistake sits there, the more it costs to fix: someone has to pull old statements and re-reconcile periods that were already closed.

10 common QuickBooks Online mistakes

1. Duplicates from the bank feed

The bank downloads a transaction that you already entered by hand: an invoice you marked as paid, or a check you recorded. According to Intuit's help article, you should match that transaction, not add it: adding creates a new record, and the income or expense is doubled. If a duplicate is already in the books, delete the extra record or exclude it from the feed.

2. Transfers between your own accounts booked as income

Moving money from checking to savings, or from one bank to another, is neither income nor an expense. If a transfer is recorded as revenue, profit goes up without a single sale. Record it as a transfer between the two accounts.

3. Credit card payments booked as expenses

Purchases on the business card are already in the books from the card's feed. When you pay the card off from your bank account, that is a transfer, not a new expense. Book the payment as an expense and the same spending is counted twice.

4. Personal spending and owner draws in expenses

Personal, living and family expenses aren't deductible, as Publication 334 states plainly. Money the owner transfers to themselves (an owner's draw) isn't a business expense either: it goes to an equity account. Leave it in expenses and your profit is understated, and those deductions will be thrown out in an audit. Our article on self-employment taxes explains how that profit is taxed.

5. Loan proceeds booked as income

Under Publication 334, money borrowed through a bona fide loan isn't income, so booking it as revenue overstates both profit and tax. Set the loan up as a liability, and split every payment in two: the interest is an expense, and the principal reduces the liability. Book the whole payment as an expense and the deduction is overstated.

6. Sales tax collected counted as revenue

Sales tax you collect from customers and pay over to the state isn't your income, per the same Publication 334. Include it in sales and revenue is inflated, and then the payment to the state shows up as an expense. The better way is to turn on sales tax in QuickBooks: it creates a liability account for the agency (Sales Tax Payable) and tracks the tax you collected there.

7. Balances stuck in Uncategorized and Payments to deposit

Intuit describes Uncategorized Income and Uncategorized Expense as accounts for money that still needs to be categorized. Payments to deposit (also called Undeposited Funds) holds payments you received until you record them as a deposit to the bank. A balance in these accounts at month-end almost always signals a problem: transactions nobody categorized, or payments counted twice, once through the customer invoice and again through the bank feed.

8. Not reconciling to the bank statement

Reconciliation means comparing the books with the bank statement for the month, line by line. Without it, duplicates, gaps and wrong amounts go unnoticed. Reconcile every bank account and every card, starting with the oldest statement; each reconciliation's beginning balance should equal the previous one's ending balance.

9. Leaving prior periods open

Once a tax return is filed, the books for that year should stay the way they were when the return was prepared. QuickBooks Online lets you close the books with a closing date and a password, and Intuit recommends reconciling every account up to that date first. Without it, one accidental change to last year and your report no longer matches the return you filed.

10. Contractors not tracked for 1099s

If you pay contractors, mark them as 1099 vendors in QuickBooks and collect a Form W-9 up front. For payments made in 2026, you issue Form 1099-NEC to a contractor you paid $2,000 or more, according to the IRS instructions, and the deadline is February 1, 2027, since January 31 falls on a Sunday. If vendors aren't tracked, you end up building the list from bank statements in January. For who counts as a contractor and who is an employee, see W-2 vs 1099.

A 15-minute check of your books

Open your reports and go down this list:

  1. Reconciliation. Every bank account and card is reconciled through the last closed month.
  2. Uncategorized Income and Uncategorized Expense are zero or close to it.
  3. Payments to deposit is empty or holds only the last few days' payments.
  4. Opening Balance Equity. QuickBooks uses this account for opening balances and adjustments. A balance sitting there means the opening balances were never fully sorted out.
  5. Loans. Each loan balance matches the lender's statement.
  6. Sales tax. Sales Tax Payable matches what you owe the state on your latest returns.
  7. Owner draws are booked to equity, not to expenses.

If three or more items don't check out, the QuickBooks mistakes are probably systemic, and it is better to go through the books as a whole than to fix transactions one by one.

How to keep QuickBooks mistakes from coming back

  • Review the bank feed weekly, not quarterly: the fresher a transaction, the easier it is to remember what it was and find the receipt.
  • Be careful with bank rules. A rule set to auto-confirm adds transactions to the books without review. If the rule is wrong, the mistake repeats on every matching transaction. Save auto-confirm for simple recurring payments such as rent.
  • Attach documents. QuickBooks Online lets you attach a file to a transaction, so the receipt or bill sits right next to the number it supports.
  • Reconcile every month and close the period once it is reconciled.
  • Give your bookkeeper access instead of emailing exports. You can invite an accountant as a separate user, so errors get caught where they happen.

Fix it yourself or call a bookkeeper?

If there are only a few errors and they are from the last month or two, you can usually fix them yourself using Intuit's help articles. If the books have been kept "however it worked out" for many months, they need to be cleaned up first, and then the software should be set up so the errors don't come back. Our Year-End Clean-Up starts at $300. If past periods were never recorded at all, that is catch-up bookkeeping.

We set up the software itself for $200, QuickBooks Online or Zoho Books, with a chart of accounts built around your tax return and your bank and cards connected; the details are on our QuickBooks setup page. The subscription is paid separately. If you'd rather hand off the bookkeeping entirely, see our bookkeeping service and what a bookkeeper costs.

Not sure how serious it is? Book a consultation and we'll talk through your books and where to start.

Frequently asked questions

Can I delete a duplicate in QuickBooks if the month is already reconciled?

It's better not to delete reconciled transactions: doing so changes your reconciled balances, and the next reconciliation won't tie out. If the duplicate came in through the bank feed and the original record is already reconciled, exclude the downloaded transaction so it doesn't land in the books twice.

What should I do with a balance in Uncategorized Expense at year-end?

Assign every transaction to the right category. Uncategorized spending won't land on the correct lines of your return, and to claim a deduction you need both the category and the supporting document: a receipt, a bill or a contract.

Do I need to reconcile if my bank is connected to QuickBooks?

Yes. A bank feed doesn't guarantee the books are complete and free of duplicates: transactions can come in twice, not come in at all or clash with entries made by hand. Reconciling to the statement every month is the only way to check.

Does QuickBooks Online or Zoho Books lead to fewer mistakes?

Mistakes depend more on setup and habits than on the software. We work in both and set up either one for $200. The choice comes down to what you already use, whether you need payroll and whether you track projects.

What if I find a mistake after the tax return is filed?

Fix the books and check whether profit changed. If the error changes the tax, you generally file an amended return: Form 1040-X for a single-member LLC owner, an amended 1120-S or an administrative adjustment request (AAR) for a 1065. If the tax doesn't change, correcting the books and closing the period is enough.

This article is for general information and does not replace advice on your specific situation.

Keep reading