QUICKBOOKS CLEANUP
How to clean up a messy QuickBooks Online account
QUICK ANSWER
Start with the last period you trust. Review the setup, clear the backlog, reconcile the statements, and check the reports.
Jump to a section
Start with the last period you trust. Then work forward: review the setup, match or categorize transactions, reconcile each statement period, and check the reports. A bank feed full of transactions is only part of the job. The balances and the records behind them need to agree too.
If you have already filed a tax return using these books, discuss changes to that period with your tax professional before making them. Keep a record of what you change and why.
Establish the scope before changing transactions
Gather the bank and credit card statements for the cleanup period, your existing financial reports, and any reconciliation reports. Include loan statements, payroll summaries, and sales-platform reports where relevant.
Review these areas:
- Which months and accounts have been reconciled?
- How many downloaded transactions still need review?
- Are accounts missing, duplicated, or connected twice?
- Do old invoices and bills represent amounts still owed?
- Does Undeposited Funds contain old payments that should already be in the bank?
- Have opening balances or previously reconciled transactions changed?
Choose a starting period and make an exceptions list. Record missing statements and questions for the owner rather than guessing. There is no reliable cleanup timeline based only on the number of months: transaction volume, missing records, and prior errors all matter.
Review the chart of accounts
A useful chart of accounts separates income, direct costs, operating expenses, assets, liabilities, and equity. Remove unnecessary complexity, but preserve information needed for reporting and tax preparation.
Start by identifying duplicate accounts and vague categories. Do not merge accounts simply because their names look similar. Intuit requires matching account names, account types, and detail types, with additional conditions for subaccounts. Merging is permanent, and the merged account loses its reconciliation history. Save the relevant reports first. Accounts connected to online banking and certain system accounts need special handling.
Making an unused account inactive and deleting a transaction are different actions. Review the account balance and history before either. If the structure affects a filed year or an important balance-sheet account, involve your accountant.
Review downloaded transactions before adding them
Work in statement-period batches, starting with the oldest month in scope. For each downloaded transaction, first check whether an invoice payment, expense, bill payment, or transfer already exists. Match an existing record when appropriate; adding the bank-feed line again creates a duplicate.
Use consistent categories for recurring expenses. Bank rules can help, but review their conditions and keep automatic posting limited to predictable transactions. A vendor name alone may not identify the right category for every purchase.
Transfers between your own accounts are not sales or operating expenses. Record both sides consistently. Separate personal spending from business expenses using treatment appropriate to the business entity; ask your accountant when that treatment is unclear.
Keep uncertain items on a questions list and resolve them before finalizing the reports. Do not leave a large temporary category unexplained at the end of the cleanup.
Resolve payments waiting in Undeposited Funds
Undeposited Funds holds payments waiting to be grouped into a bank deposit. A current balance can be legitimate. Old items need investigation.
Suppose a customer payment of $4,200 was recorded against an invoice, but the downloaded bank deposit was separately added as income. The file may now contain duplicate income and a payment still waiting to be deposited.
Creating another deposit alone does not remove that existing duplicate. Identify how both entries were recorded. The correction may involve undoing the incorrectly added bank-feed entry, creating or correcting the deposit linked to the original payment, and matching the downloaded transaction to that deposit. Preserve the invoice-payment connection and recheck the affected reports. Seek help if the period is already reconciled or filed.
Reconcile each account and review outstanding items
Match the books to each bank and credit card statement. Confirm the beginning balance, statement date, and ending balance. Investigate missing entries, duplicates, incorrect amounts, and unexpected changes to reconciled history.
Outstanding checks and deposits in transit can be legitimate. Leave items absent from the statement unchecked, while making sure the reconciliation difference reaches zero. Our bank reconciliation guide explains the distinction between an outstanding item and an unexplained difference.
Do not post an unexplained adjustment just to finish. If a small residual difference remains after investigation, discuss any proposed adjustment with your accountant and document the reason.
Check the reports and agree on a monthly routine
Review the profit and loss statement, balance sheet, receivables aging, and payables aging. Check whether unpaid invoices and bills are real, loans agree with lender records, and payroll liabilities agree with provider reports. A reconciled bank account does not prove every expense is categorized correctly.
After review, set the agreed closing date and controls. Closing-date protection reduces accidental edits; authorized users may still make changes, so keep the audit trail and review exceptions.
Use a bookkeeping checklist to keep the file current. The monthly routine should include questions, supporting documents, reconciliations, and report review.
When to bring in a bookkeeper
Get help when the starting balances cannot be explained, multiple accounts are affected, records are missing, or payroll, inventory, and filed periods are involved. A useful cleanup ends with reviewed balances, documented unresolved items, and a routine you can maintain.
Explore catch-up and cleanup support, or book a free consultation to discuss the scope before work begins.
Three things to remember
- Review the starting balances before working through the backlog.
- Match existing records before adding transactions from the bank feed.
- Finish with reconciled statements, reviewed reports, and a monthly routine.