7 Common QuickBooks Online Errors (And How to Fix Them)

When a new QuickBooks Online file lands on our desk, we do not start with the tax return. We start with the Balance Sheet and the Profit and Loss, because the same seven mistakes turn up in most owner-kept files, and every one of them moves the profit figure the return is built on. They rarely cancel out.

Here is how we find each one, why it matters and how to fix it, followed by a worked example in which all seven combined to overstate one company's profit by $36,150.

Errors that count the same money twice

1. Undeposited Funds keeps growing

Spot it: Balance Sheet. A healthy Undeposited Funds balance is a few days of receipts. Click into it and find customer payments from March still sitting there in September, and you have the error.

Why it matters: receiving an invoice payment parks the money in Undeposited Funds. When the real deposit arrives in the bank feed and someone clicks Add instead of Match, QuickBooks records a second sale. Revenue is doubled and the Balance Sheet shows an asset that does not exist. This is the largest source of overstated profit we see.

Fix and prevent: open + New, then Bank deposit, tick the payments that make up each real deposit and match the result to the bank-feed line. Where the feed deposit was already added as income, edit it to pull in the waiting payments and remove the extra income line. Going forward, a deposit from the feed is matched, never added.

2. Duplicate transactions from bank feeds plus manual entry

Spot it: sort the bank register by amount and scan for pairs. In Bank transactions, the Categorized tab shows whether each line was matched or added; a file where almost everything was "added" is full of duplicates.

Why it matters: the owner enters a bill by hand, then adds the payment again from the feed. Expenses are overstated, profit is understated and the account can never reconcile.

Fix and prevent: delete the manual duplicate, or if the feed line is still in For review, select it and choose Exclude. Intuit's guidance is that excluded transactions "move to the Excluded tab" and "won't be added to QuickBooks or downloaded again" (Intuit: exclude duplicate transactions). Never delete a reconciled transaction; fix the unreconciled twin. Limit auto-add rules to fixed-amount recurring vendors.

Errors that hide what a transaction really is

3. Uncategorized balances and an "Ask My Accountant" nobody asks

Spot it: Uncategorized Income, Uncategorized Expense or Ask My Accountant on the Profit and Loss, and Uncategorized Asset on the Balance Sheet. Parking a transaction for thirty days is fine; through year end is not.

Why it matters: the return maps each category to a line. A $24,000 lump of uncategorized spending usually mixes real deductible expenses with a credit-card payment already expensed through the card, an equipment purchase that belongs on the Balance Sheet and a personal charge. Uncategorized income is often an owner contribution or a loan, not income.

Fix and prevent: click each uncategorized total and work the detail line by line. Move equipment to Fixed Assets, card payments to the card liability and owner money to equity or a shareholder loan. Then empty the parking accounts before every month closes; our monthly bookkeeping checklist builds this in.

4. The owner's personal spending booked as business expense

Spot it: Expenses by Vendor Summary, read with a skeptical eye. Grocery stores, streaming services, a personal car lease, a July trip to Orlando coded to Travel.

Why it matters: the Code allows "the ordinary and necessary expenses paid or incurred during the taxable year in carrying on any trade or business" (26 U.S.C. §162(a)). Personal spending is not that. In an S corporation it is a distribution that also reduces stock basis, and in an audit, personal items in Meals and Travel are the first thing pulled.

Fix and prevent: reclassify each item to Owner Draw or Shareholder Distributions. Business use of a personal asset is reimbursed under an accountable plan, not run through the company. Separate cards, one rule: the business pays only for the business.

Errors that mix up the Balance Sheet and the Profit and Loss

5. Loan payments booked entirely to expense

Spot it: the truck or equipment loan on the Balance Sheet is missing or has not gone down all year, while an account called Loan Payment or Interest Expense equals twelve full monthly payments.

Why it matters: only the interest is an expense. Principal reduces a liability and is not deductible, so the whole-payment approach understates profit by the principal paid and overstates the loan by the same amount.

Fix and prevent: use the amortization schedule to split each payment between interest and the loan, or at minimum post one year-end entry that brings the QuickBooks balance to the lender's December 31 figure.

6. Sales tax collected booked as income

Spot it: compare revenue with the Sales Tax Liability report (Reports, Standard reports, search "Sales Tax Liability"). The tell is an invoice item called "Sales Tax" that posts to income.

Why it matters: sales tax you collect is the state's money and belongs in Sales Tax Payable. In Florida that is the 6% state rate plus county surtax, so a Hillsborough County business holds 7.5% of every taxable sale for the state. If December's tax is not paid until January, profit is overstated by the unremitted amount and the liability is missing.

Fix and prevent: turn on the built-in sales tax feature, reclassify collected tax to Sales Tax Payable and record remittances as sales tax payments, not expenses. Reconcile that account to the DR-15 monthly (our guide to Florida sales tax basics covers the filing side).

The error that hides all the others: forced reconciliations

Spot it: the Reconcile page shows a "last reconciled" date months ago, or every month was reconciled with an adjustment, and the Profit and Loss carries an account called Reconciliation Discrepancies.

Why it matters: a reconciliation that balances because of a plug proves nothing. Intuit's help text says the adjustment "creates an expense transaction if the difference is negative, or an income transaction if the difference is positive," and that "you must be absolutely sure the amount is small and an error" (Intuit: adjusting entries for a reconciliation).

Fix and prevent: remove the plugs, run the Reconciliation Discrepancy report, trace each item through the audit log and restore what was deleted. Then reconcile every account month by month from the last clean statement forward. House rule: nobody clicks Add adjustment.

Worked example: seven errors, $36,150 of phantom profit

Take a two-owner pool service and repair company in Pasco County, taxed as an S corporation, with $1.35 million of revenue. The owner-kept QuickBooks file showed net profit of $241,000. A review found this:

The return would have reported profit $36,150 too high. At a 24% federal marginal rate that is roughly $8,700 of tax on money the owners never made, before the QBI deduction softens it. Four of the seven errors pushed the other way and the gross errors total more than $124,000, which is why "the mistakes probably cancel out" is not a plan.

The Balance Sheet was wrong too: a $63,800 asset that did not exist, a truck loan overstated by $11,200, and a missing $2,700 sales tax liability and $12,000 shareholder loan. The corrected file also answered the question both owners kept asking: why profit did not match the cash in the bank.

What usually goes wrong, and what Intuit changed

The first do-it-yourself mistake is deleting instead of matching or excluding. The second is cleaning up a year that was already filed without telling the tax preparer. The third is clearing Undeposited Funds or old receivables with a journal entry, which fixes the total but leaves every customer balance wrong.

The fourth is trusting the software to decide. Intuit began rolling out its AI agents on July 1, 2025 and says the accounting agent "automates bookkeeping and transaction categorization, and assists in reconciliation." It learns from what is already in your file: if last year's personal spending was coded to Meals, it will keep coding it there, and a confidently wrong category is harder to catch than an uncategorized one.

When to get help

If you found one or two of these and the file is otherwise reconciled, fix them with the steps above and have your preparer review the year-end Balance Sheet before filing. If you found four or more, or the last reconciliation is more than three months old, the cheaper path is a proper cleanup: every account reconciled from the last clean statement and a corrected Balance Sheet your preparer can rely on. That is what our QuickBooks cleanup and catch-up service does; our guide to catching up on months of bookkeeping explains the sequence.

In our practice a cleanup is usually followed by monthly bookkeeping, because a file that drifted for a reason will drift again for the same reason. If you want a second set of eyes before year end, request a 20-minute fit call and bring the Balance Sheet and Profit and Loss; that is enough to tell which of the seven you have.

Jenny Gao, CPA, EA

Founder of Balance Partners. Florida-licensed CPA and IRS Enrolled Agent with more than a decade of accounting and tax experience. Jenny writes and reviews every guide on this site. About Jenny

This article is general educational information for U.S. business owners and is not accounting, tax, legal, payroll or financial advice for your situation. Rules change and vary by entity, state and facts. Balance Partners, LLC does not provide audit, review or other attest services. Last reviewed September 14, 2026.