What documents do I need for a QuickBooks cleanup?

Start with statements for every bank, credit card and loan account for each month being cleaned up, plus the month before. Add payroll reports and filed payroll returns, sales tax returns if you collect sales tax, loan paperwork, and the last financial statements someone outside relied on. A bookkeeper can only correct what these records support, so gaps usually mean slower or less complete work.

How long does a QuickBooks cleanup take?

It depends on how many months and accounts are involved, how many transactions each month holds, and how quickly statements and reports arrive. A dependable estimate usually comes only after someone has reviewed the file. Be cautious of a firm timeline offered before anyone has looked, and ask for the schedule to be written into the scope.

How do I know my QuickBooks cleanup is finished?

Every bank, card and loan account should be reconciled to its statement through the agreed end date, with a saved reconciliation report for each. Payroll and sales tax liabilities should agree with outside reports, and opening balances should tie to a trusted starting point. Agree on these checks in writing before the work starts, so finished means the same thing to both sides.

Will a QuickBooks cleanup change my tax returns?

A cleanup corrects the books. It does not file or amend tax returns. If corrected figures differ from what was reported on a return already filed, your CPA or enrolled agent advises on whether anything needs to be done. For payroll filings, your payroll provider or tax adviser handles any corrections. Ask the bookkeeper to list the differences clearly so your adviser can review them.

Should I clean up QuickBooks before switching to QuickBooks Online?

Usually, yes. Moving a file copies its problems along with its data, so unreconciled accounts and wrong balances arrive in the new file unchanged. Cleaning up first, or at least reconciling every account to a recent statement, gives the new file a starting point you can trust. A records review shows whether the cleanup or the move should come first.

Before You Hire a QuickBooks Cleanup

The short answer

Before anyone starts a cleanup or catch-up, gather statements for every bank, card and loan account for every month involved, list the problems you already know about, and pull payroll and sales tax reports for the same period. Then agree in writing what done means. A sensible finish line is every account reconciled to its statement, tax liabilities that agree with outside reports, and opening balances tied to a known good point.

Agree on the finish line first

Your QuickBooks file is behind, or wrong, or both, and you are about to pay someone to fix it. If you are not sure which kind of work you need, read cleanup vs catch-up bookkeeping first. This guide is about what happens before the work starts: what you hand over, and what you agree the result will be.

The most useful thing to settle is the finish line. Most bookkeepers would accept this one: every bank, credit card and loan account reconciled to its statement through an agreed end date. In QuickBooks Online, a reconciliation is finished when the difference between the statement and the cleared transactions is zero, and QuickBooks saves a reconciliation report you can open later under History by account.

Reconciled cash is the floor, not the whole job. A finished cleanup also has payroll and sales tax liabilities that agree with outside records, loan balances that match the lender, and an Opening Balance Equity account that is explained rather than used as a catch-all. Put the end date and these checks in the written scope.

What to gather before the first day

The bookkeeper can only correct what the records support. IRS Publication 583 describes supporting documents as sales slips, paid bills, invoices, receipts, deposit slips and canceled checks, and says your books must show your income, deductions and credits. For a cleanup, start with these:

Statements for every account and every month in the period: checking, savings, each credit card, each loan and line of credit. Include the month before the period starts, to confirm the opening balance.
Payroll reports from your payroll provider for the same months, plus copies of the payroll returns that were filed. The IRS says employment tax records should be kept for at least four years after the fourth-quarter return for the year is filed.
Sales tax returns filed for the period and the sales reports behind them, if you collect sales tax.
Loan paperwork, such as the note and any payment schedule, so principal and interest can be split correctly.
The last numbers someone outside relied on, such as a prior year-end balance sheet, a board report or the figures your CPA used for the last return.
Access to the file as a separate named user. See giving your bookkeeper access safely.

List the problems you already know about

A short list in your own words saves hours. Write down what you have noticed: an account that has not been reconciled since a certain month, a bank feed that stopped connecting, transfers that may have been recorded twice, personal charges on a business card, invoices you know were paid but still show as open. Note who kept the books before and whether that person can answer questions.

Also note the starting point you trust. A cleanup works forward from the last month where the books and the bank agreed. QuickBooks Online records an opening balance for each account as of a start date and offsets it in Opening Balance Equity, so an opening balance entered with the wrong date or amount carries into every later month. If no month can be trusted, the cleanup has to start earlier, and that adds work.

Check whether someone set a closing date in QuickBooks. A closing date protects finished periods from edits, and the bookkeeper will need to know it exists and who holds the password before changing anything in those months.

Cleanup readiness checklist

Item	Why it matters	If you do not have it
Statements for every account and month	Each reconciliation is checked against the statement, the one record from outside your file	Request copies from the bank, card issuer or lender before work starts
Payroll reports and filed payroll returns	Withholding and payroll tax balances should agree with what was withheld, paid and reported	Ask your payroll provider for reports for the same months
Sales tax returns and sales reports	Sales tax collected is owed to the taxing agency, not income, and the books should match what was filed	Ask whoever filed them, or the state tax agency, for copies
A trusted starting point	Every later month builds on the opening balances	The cleanup starts earlier, which adds months of work
Your list of known problems	It points the review at likely errors first	A records review will find them, but more slowly
A named user for the bookkeeper	Changes are recorded under their own name in the audit log	Set it up first; see access without sharing passwords

Liabilities need their own check

Bank reconciliation proves cash. It does not prove what you owe. Payroll taxes withheld, sales tax collected and loan balances all sit on the balance sheet as liabilities, and each one should agree with a record from outside your file: the payroll provider's liability report, the sales tax returns you filed, and the lender's statement.

When a liability does not agree, the bookkeeper's job is to find out why and show you the difference. Whether a past return needs to be corrected is a different question. That belongs with your CPA or enrolled agent, or your payroll provider for payroll filings. A cleanup corrects the books; it does not file or amend returns.

QuickBooks Online keeps an audit log of who changed what, including sign-ins and edits, and Intuit says those events are available for two years. If you suspect old entries were changed, raise it early so the review can use the log while the history is still there.

What you should receive at the end

Ask for the deliverables in the written scope, so both sides know when the project is finished:

A reconciliation report for every bank, card and loan account through the end date.
A balance sheet and a profit and loss for the period, by month if the period is long.
A short list of the significant corrections made, and why.
A list of open questions that need a decision from you or your CPA.
A closing date set in QuickBooks for the finished period, protected by a password, so it does not change by accident.
A plan for keeping the books current, whether you do it or someone else does. The monthly bookkeeping checklist shows the routine.

Churches, and where Danielson Bookkeeping fits

A church cleanup adds fund balances, giving records and payroll for ministers. Those steps are covered in cleaning up church books, along with why a cleanup is not an audit. If the file is moving from QuickBooks Desktop at the same time, read moving from QuickBooks Desktop to Online and decide the order before work begins.

Danielson Bookkeeping handles QuickBooks cleanup and catch-up as a defined project. Every project starts with a review of the file and a written scope, as described on QuickBooks services. Tax filing, amended returns and audits stay with your CPA. When your records are gathered, request a consultation.

General bookkeeping information, not tax, legal or investment advice. A CPA or enrolled agent handles tax questions for your situation. Danielson Bookkeeping & Consulting does not prepare tax returns or give tax, legal or investment advice; see what we do and don't provide.

Getting Ready for a QuickBooks Cleanup or Catch-Up