SMALL BUSINESS BOOKKEEPING GUIDE

How to clean up months of overdue bookkeeping in QuickBooks Online

Behind on your books? Learn how to identify the backlog, gather missing documents, review transactions and reconcile accounts without rushing into unsupported corrections.

By Bryan Dietz · Dietz Bookkeeping · Tampa-based, serving small businesses nationwide

The short answer

Start with the oldest incomplete month, collect every statement, compare downloaded and manually entered transactions, match or categorize transactions based on the actual records, investigate duplicates and missing activity, then reconcile each account in chronological order. Keep a written list of unresolved items and review financial reports before moving into ongoing monthly bookkeeping.

This guide is general bookkeeping education, not tax or accounting advice for a specific file. Menu names may change as QuickBooks Online is updated.

Catch-up bookkeeping versus cleanup bookkeeping

Catch-up bookkeeping

Entering, matching and reconciling transactions for months that have not yet been completed. The records may be mostly correct but unfinished.

Cleanup bookkeeping

Investigating and correcting supported errors such as duplicates, improper matching, unexplained balances or historical reconciliation differences. Both types of work may be needed.

Gather the records before editing the books

  • Bank and credit card statements for every affected month and account
  • Loan statements, if loans or credit lines appear in the books
  • Customer invoices, deposits, payment processor reports and vendor bills
  • Payroll summaries and relevant supporting records, shared securely when needed
  • The last completed reconciliation reports and any known unresolved questions

Do not send passwords, bank login credentials, payroll identifiers or sensitive customer documents through a public website form. Discuss secure access and document sharing before an engagement.

Seven steps to review overdue QuickBooks Online bookkeeping

A safe cleanup order matters. Review what already exists before adding, excluding or changing historical transactions. QuickBooks menus and tabs vary by account and subscription; use the app’s search when the navigation differs.

  1. 1

    Identify the starting point

    List every bank, credit card and loan account used by the business. Check the last month that was actually reconciled and identify the oldest incomplete period. A bank connection alone is not proof that bookkeeping is finished.

  2. 2

    Preserve records and review existing work

    Gather statements and save existing reconciliation reports before making historical changes. Look at the chart of accounts, opening balances and previously reconciled months. If a past reconciled entry looks wrong, investigate first rather than immediately editing or undoing it.

  3. 3

    Review downloaded and manually entered transactions

    In QuickBooks Online, review transactions under All apps → Accounting → Bank transactions (labels can vary). Match downloaded activity to existing invoices, payments or bills when appropriate; categorize only transactions not already entered. Review suggestions rather than accepting every category automatically.

  4. 4

    Investigate duplicates, transfers and exceptions

    Compare suspicious entries against the official bank or card statement. Common issues include an invoice payment counted again as new income, overlapping manual imports, transfers entered as income, and missing bank fees. Confirm the underlying facts before changing entries.

  5. 5

    Reconcile each account month by month

    Start with the oldest statement period needing reconciliation and work forward, checking beginning and ending balances. Resolve differences against actual records before finishing. If the beginning balance is wrong because of a historical change, review Intuit’s discrepancy guidance or consult an accountant.

  6. 6

    Review reports and record open questions

    After reconciliation, review the profit-and-loss report and balance sheet for unusual balances or missing activity. Also examine outstanding invoices, vendor bills and loan balances when relevant. Document uncertain classifications and questions for the owner or tax professional.

  7. 7

    Move into an ongoing monthly routine

    Once the historical periods are supported by records and unresolved items are documented, set a repeatable routine for collecting statements, reviewing transactions, reconciling accounts and checking reports each month.

Related: reconciling each statement period

If you need a walkthrough of the monthly bank reconciliation screen, see our separate guide.

How to reconcile bank accounts in QuickBooks Online

Example: a small business with three months behind

Imagine a cleaning business that last reconciled June. July, August and September contain activity from a business bank account and credit card. The owner notices a duplicate deposit, an unrecorded card fee and a missing August statement.

FIRST

Find the missing source

Request the August statement and compare it with the other months before deciding anything is missing.

NEXT

Investigate entries

Verify whether the deposit appears twice in QuickBooks and whether the statement supports the card fee.

THEN

Reconcile forward

Work through July, August and September by account and record any outstanding questions.

Illustrative training example only, not a real client result or promise of a fixed cleanup time.

Four issues to investigate carefully

Payments recorded twice

A bank-feed deposit may have been added as new income even though an invoice payment already exists. Verify the source and use matching where appropriate; never delete an entry solely because the amounts look similar.

Missing bank statements

Ask the bank or card issuer for complete statement periods. A current online balance is not a substitute for the historical month-end statement.

Personal and business purchases mixed together

Flag the items and ask the owner to identify their purpose. Avoid guessing tax deductibility or changing owner transactions without supporting information.

Older reconciliations were modified

Review prior reconciliation and discrepancy reports. Undoing a full reconciliation can affect later periods and permanently delete its report and attachments, so involve the appropriate accountant before proceeding.

Protect previously reconciled periods

Never undo old reconciliations or post unsupported adjustments merely to make a report match. Intuit warns that undoing a reconciliation can also undo later reconciliations and permanently remove related reports and attachments. Review with the appropriate accountant first.

Overdue bookkeeping cleanup FAQs

How far back should I go when cleaning up QuickBooks?

Begin by locating the last reliable, completed period and identifying the earliest month that needs attention. How far back the review must go depends on the missing records, the bookkeeping file and any advice from your tax professional.

Can I just categorize every transaction in the bank feed?

No. An item may already be recorded as an invoice payment, bill payment or transfer. Matching an existing record is different from creating a new transaction. Review source documents and duplicates before posting.

Should I undo old reconciliations to start over?

Not automatically. Undoing reconciliations can affect multiple later periods and delete reconciliation reports and attachments. First investigate the actual error, preserve reports, and consult your accountant when historical corrections are necessary.

Does a cleanup project include filing old tax returns?

No. Bookkeeping cleanup focuses on the accounting records, transactions and reconciliations in the agreed scope. Tax return preparation, amended returns and tax advice are handled separately by your qualified tax professional.

How much does QuickBooks cleanup cost?

Pricing varies with the number of months, bank and card accounts, transaction volume, missing statements, complexity and condition of the file. Dietz Bookkeeping reviews those factors before preparing a scope-based estimate.

Can Dietz Bookkeeping help my business outside Tampa?

Yes. We are based in Tampa and discuss remote QuickBooks Online cleanup and ongoing bookkeeping services with small businesses across the United States.

Official QuickBooks references

These topics were checked against Intuit’s QuickBooks Online documentation. Follow the instructions appropriate for your version and business records.

Prepared by Dietz Bookkeeping. QuickBooks is a trademark of Intuit Inc. Dietz Bookkeeping is an independent business and does not claim Intuit endorsement through this article.

Behind on your bookkeeping? Start with a review.

Dietz Bookkeeping discusses QuickBooks Online catch-up and cleanup projects for small businesses nationwide. Share the months affected, accounts involved and general condition of the books—without submitting sensitive financial documents in a public form.

Work directly with Bryan Dietz · Based in Tampa, serving U.S. small businesses remotely