How do I fix errors in QuickBooks?
The fix depends on what went wrong. QuickBooks errors usually fall into a few categories: duplicate transactions, wrong categories, incorrect amounts, or missing entries. Each has a different correction method.
Start by figuring out what’s actually wrong. Run a Profit and Loss and Balance Sheet report. Compare your bank statements to your QuickBooks registers. If numbers don’t match or something looks off, you’ve found where to dig deeper. The Transaction Detail by Account report shows exactly what transactions hit each account.
For duplicate transactions, the most common cause is entering something manually and also having it import through the bank feed. Delete the duplicate. QuickBooks will ask if you want to delete or void. For recent transactions in the current period, delete is usually fine. For transactions in closed periods, voiding preserves the audit trail.
Wrong categories are simple to fix. Find the transaction, click on it, and change the account. If you miscategorized a lot of transactions the same way, you can run a search, sort by vendor, and fix them in batches. This happens often when QuickBooks auto-categorizes based on previous entries and the original one was wrong.
Incorrect amounts need to be edited directly on the transaction. If the transaction already reconciled with the wrong amount, you’ll break the reconciliation when you change it. For reconciled transactions, consider whether the error is worth the complexity of undoing and redoing the reconciliation.
Missing transactions need to be added back. If you deleted something by accident, check the Audit Log under Settings to see what happened. If it was a bank feed transaction you rejected, you may need to manually recreate it.
For complex corrections affecting multiple accounts, a journal entry might be the right approach. Journal entries let you move amounts between accounts without touching original transactions. They’re clean for corrections but harder to understand later if you don’t add a clear memo explaining what you’re fixing and why.
Before making significant changes, back up your data. In QuickBooks Online, go to Settings, then Back Up Data. This gives you a restore point if your fix creates bigger problems.
Some errors aren’t isolated. If your books have months of miscategorized transactions, reconciliations that don’t match bank statements, or duplicates throughout, individual fixes won’t cut it. You need catch-up bookkeeping to clean everything up systematically. A San Diego bookkeeper who specializes in QuickBooks can untangle the mess faster than you can and without creating new problems.
The best fix is prevention. Set up rules so transactions categorize correctly. Review the bank feed weekly instead of letting it pile up. Reconcile monthly so errors get caught when they’re fresh and easy to remember.
San Diego's Small Business Bookkeeper
The Next Step:
A Short Conversation
A quick call to tell us about your business. We'll listen, answer your questions, and give you a clear price quote.
More Questions
What is three-way trust reconciliation?
Three-way trust reconciliation matches your bank statement balance against your general ledger balance and the sum of all individual client ledger balances. When all three match, you know client funds are properly accounted for.
Read answerWhat is COGS for a restaurant?
COGS (cost of goods sold) represents the direct cost of food and beverages you sell to customers. It includes everything that becomes a menu item but excludes labor, rent, and other operating expenses.
Read answerWhat is the difference between direct and indirect costs?
Direct costs can be traced to a specific job, product, or project. Indirect costs support the business overall but can't be assigned to one job. Understanding this distinction is essential for accurate pricing and knowing whether individual projects are actually profitable.
Read answerWhat records should I keep for my small business?
Keep financial records like bank statements, receipts, and invoices for at least seven years. You'll also need tax returns, business formation documents, contracts, and employee records if you have staff.
Read answerDo churches need bookkeeping?
Yes. Churches handle donated funds that come with expectations of accountability. Proper bookkeeping tracks designated gifts, produces donor statements, and demonstrates responsible stewardship to the congregation.
Read answerCan a bookkeeper help me with taxes?
Most bookkeepers don't file tax returns, but they help with taxes in ways that matter more than the actual filing. Clean books mean accurate deductions, faster tax prep, and records that survive an audit.
Read answer