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 payroll records do I need to keep?
Federal law requires keeping payroll records for at least four years. This includes employee information, timekeeping, wage payments, and tax filings. California adds stricter requirements for itemized wage statements.
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 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 accounting method should restaurants use?
Most small restaurants should use cash basis accounting. It's simpler, legal for operations under the IRS gross receipts threshold, and gives a clear picture of actual cash on hand. Accrual makes more sense for larger operations or those seeking outside investment.
Read answerWhat qualifications should a bookkeeper have?
Formal certification isn't required for bookkeepers, but software proficiency, attention to detail, and industry experience matter most. The right qualifications depend on your business needs and how well the bookkeeper understands your specific situation.
Read answerHow do I track projects in QuickBooks Online?
Enable Projects in your QBO settings, create a project for each customer engagement, then assign every expense, invoice, and time entry to the correct project. Run Project Profitability reports to see your margins.
Read answer