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
How do I track income and expenses by property?
Use class or location tracking in QuickBooks to tag every transaction to a specific property. This lets you run profit and loss reports by property so you can see exactly how each one is performing.
Read answerWhat bookkeeping software works best for property managers?
QuickBooks Online is the standard for property managers and integrates with most property management platforms. But the software matters less than setting it up to track income and expenses by property.
Read answerCan a bookkeeper fix years of neglected books?
Yes. Bookkeepers regularly handle catch-up work for businesses with years of neglected records. As long as bank statements and basic documentation exist, the books can almost always be reconstructed and brought current.
Read answerCan QuickBooks integrate with my POS system?
Yes, QuickBooks Online integrates with most major POS systems including Square, Toast, Clover, and Shopify. The key is setting up the integration correctly so sales data flows into the right accounts.
Read answerWhat is TOT and how do I track it?
TOT stands for Transient Occupancy Tax. It's a local tax on short-term lodging that you collect from guests and remit to the city. In San Diego, the rate is 10.5% and you need to track it separately from your rental income.
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 answer
