If the balance in QuickBooks does not match your bank statement, months of activity have never been reconciled, or previous reconciliations were completed incorrectly, the problem may require more than simply clicking “reconcile” again.
OneBooks helps New Jersey businesses identify and repair historical QuickBooks Online reconciliation problems, correct missing or duplicate transactions, rebuild inaccurate periods, and bring bank and credit-card accounts back into agreement with the underlying statements.
We are based in Wyckoff, New Jersey and work with businesses throughout the state using QuickBooks Online and secure electronic records.
Bank reconciliation cleanup is the repair of historical reconciliations that were never completed, were forced to balance with adjustments, or no longer agree with the bank statement because transactions were later changed, deleted, duplicated, or recorded incorrectly.
It differs from routine reconciliation, which compares one period of QuickBooks activity with one bank or credit-card statement.
A cleanup may require reviewing earlier periods, identifying where the discrepancy began, correcting the underlying transactions, and then re-reconciling the affected months in chronological order.
You may need reconciliation cleanup if:
These are symptoms. The next step is determining what caused them.
A transaction may appear on the bank statement but never have been entered into QuickBooks.
This can happen if a bank feed was disconnected, a transaction was excluded, or historical activity was never imported.
Transactions may be entered manually and then added again through the bank feed.
Duplicates can distort income, expenses, cash balances, and financial statements.
If someone deletes, changes, re-dates, or unreconciles a transaction after it was previously reconciled, the next reconciliation’s beginning balance can be affected.
Transfers between business accounts are sometimes mistakenly recorded as income in one account and an expense in another.
That can distort both the Profit & Loss and account balances.
If QuickBooks was set up using the wrong opening balance or opening date, reconciliation problems can continue from the first reconciliation forward.
Credit-card payments may be coded as expenses instead of transfers against the credit-card liability, causing both the bank and credit-card balances to be wrong.
Businesses using Stripe, Square, PayPal, or other payment processors may record sales at the gross amount while the bank receives a net deposit after fees.
Deposits can also remain incorrectly in Undeposited Funds instead of being grouped to match the actual bank deposit.
Both situations can cause QuickBooks deposits to differ from the bank statement and may need to be corrected before the account can be reconciled properly.
Bank service charges, returned payments, and stale outstanding checks can create similar differences when they are not recorded or cleared correctly.
Bank-feed activity can be duplicated, excluded, matched incorrectly, or categorized improperly.
The bank feed is not the accounting record itself.
It is a tool for bringing banking activity into QuickBooks. The actual reconciliation still needs to be performed against the bank or credit-card statement.
QuickBooks expects the beginning balance of a new reconciliation to equal the ending balance of the prior reconciliation.
If QuickBooks says:
“Your beginning balance is off by…”
it generally means something affecting a previously reconciled period has changed.
QuickBooks provides reconciliation-history and discrepancy tools that can help identify what changed.
The objective is to find and correct the underlying change rather than simply override the difference.
Possible causes include:
QuickBooks can create a Reconciliation Discrepancies account when reconciliation differences are recorded.
A balance in this account is a reason to review the historical reconciliations.
It may indicate that prior differences were adjusted rather than fully resolved.
An adjustment can make the reconciliation screen reach zero, but it does not necessarily explain what caused the difference.
Usually not.
If the difference is caused by a missing expense, duplicate deposit, deleted transaction, incorrect transfer, or another historical problem, an unexplained adjustment may hide the issue without correcting the bookkeeping.
OneBooks focuses on identifying the source of the difference and correcting the underlying records wherever practical.
Every OneBooks bookkeeper is required to earn QuickBooks Online ProAdvisor certification, and completed cleanup is reviewed by a Certified ProAdvisor before financial statements are delivered.
We begin by reviewing the affected bank and credit-card accounts in QuickBooks Online.
We may review:
This helps determine where the problem began and whether the issue affects one period or many.
We compare QuickBooks with the actual bank and credit-card statements for the affected periods.
Historical cleanup generally cannot be completed reliably from the QuickBooks bank feed alone.
The statements provide the independent source record needed to verify the transactions.
We compare QuickBooks with the source statements and determine whether the difference is caused by missing, duplicate, changed, deleted, misdated, or incorrectly recorded transactions.
The necessary corrections are made in QuickBooks.
Depending on the condition of the books, this may involve correcting individual transactions or reconstructing entire periods.
Once the underlying activity is corrected, the accounts are reconciled against the statements.
For historical projects, the work is generally completed from the oldest affected period forward.
That order matters because one month’s ending balance becomes the next month’s beginning balance. An unresolved error in an earlier month can therefore affect every reconciliation that follows.
After the reconciliation work is complete, we review the Profit & Loss and Balance Sheet for remaining issues caused by the historical errors.
The result is a more reliable QuickBooks file that can be used for management reporting and provided to your CPA or tax preparer.
Yes, but it should be done carefully.
A full-period undo requires an authorized role such as the Primary Admin, an In-house accountant, or an accountant user connected through QuickBooks Online Accountant.
OneBooks can work in the file with appropriate accountant access and, when needed, undo and redo prior reconciliations in the proper order.
In some cases, only individual transactions need to be unreconciled and corrected.
Before undoing a reconciliation, OneBooks preserves any available reconciliation reports and attachments that may be needed for the cleanup record.
This is important because undoing a reconciliation can remove reports and attachments associated with that reconciliation.
Usually back to the last reconciliation that agrees with the corresponding bank or credit-card statement.
If there is no reliable prior reconciliation, the review may need to go back to the opening balance or the earliest available source records.
The objective is to establish a reliable starting point and then work forward chronologically.
Yes, when sufficient source records are available.
OneBooks specializes in historical bookkeeping projects involving businesses that are months or multiple years behind.
If the reconciliation problem extends back several years, portions of the bookkeeping may need to be reconstructed before the accounts can be reconciled correctly.
Typical source records may include:
The farther back the problem goes, the more important it becomes to work through the periods systematically.
To evaluate and repair historical reconciliation problems, we typically need:
If you are not sure how far back the problem goes, that is fine.
Part of the assessment is determining where the reconciliation first stopped being reliable.
OneBooks reviewed a New Jersey contractor whose checking account had been unreconciled for more than a year.
The difference was traced to a combination of an incorrectly recorded credit-card payment and a deleted deposit from a previously reconciled period.
After correcting the underlying transactions, the affected months were re-reconciled chronologically and the Balance Sheet was reviewed before the books were returned to the CPA.
This example is anonymized and identifying details have been changed.
Then the project may require both cleanup bookkeeping and catch-up bookkeeping.
Entering transactions into QuickBooks does not necessarily mean the accounts were reconciled.
If months of activity were recorded without comparing QuickBooks to the bank and credit-card statements, we may need to review those periods from the beginning.
OneBooks can help.
Your CPA may identify reconciliation problems while reviewing the Balance Sheet, year-end account balances, or prior-period activity.
With your authorization, OneBooks can coordinate with your CPA or tax professional regarding the bookkeeping issues they identified.
OneBooks handles the bookkeeping cleanup and reconciliation. Your CPA or tax professional remains responsible for tax advice, tax positions, and tax-return preparation.
These services overlap, but they solve different problems.
Catch-up bookkeeping completes work that was never done.
Cleanup bookkeeping corrects work that was done incorrectly.
Reconciliation cleanup focuses specifically on bringing the transactions and balances recorded in QuickBooks into agreement with the supporting bank and credit-card statements.
A business may need one, two, or all three.
For example, if six months of transactions are missing and the prior year was never reconciled, the project may require catch-up work first and reconciliation cleanup second.
A broader QuickBooks cleanup may also include:
The cost depends on:
OneBooks reviews the condition of the books first and provides a fixed-price quote before work begins.
For broader historical cleanup pricing, see the OneBooks Catch-Up Bookkeeping Cost Guide.
Smaller reconciliation cleanup projects may take several weeks.
Projects involving multiple accounts or years of historical bookkeeping can take longer because the records often need to be corrected and reconciled chronologically.
The timeline depends on transaction volume, number of accounts, complexity, and how quickly source statements are available.
If your CPA has given you a filing deadline or your tax return is on extension, tell us during the assessment so the deadline can be considered when the project is scoped.
Yes.
Credit-card accounts should also be reconciled against their monthly statements.
Historical credit-card problems commonly include:
In many cleanup projects, the bank and credit-card accounts need to be repaired together.
Usually not.
Many reconciliation problems can be corrected within the existing QuickBooks Online file.
OneBooks first determines what can be preserved and what needs to be corrected.
Starting a completely new file is not automatically necessary simply because historical reconciliations contain errors.
Once the historical bank and credit-card accounts are properly reconciled, the next objective is keeping them that way.
OneBooks provides ongoing monthly bookkeeping for New Jersey businesses using QuickBooks Online.
Moving from historical cleanup into monthly bookkeeping can help prevent the same reconciliation backlog from developing again.
Monthly bookkeeping can include:
OneBooks is based in Wyckoff, Bergen County, New Jersey and serves businesses throughout the state using QuickBooks Online.
If your QuickBooks file no longer agrees with your bank and credit-card statements, you do not have to determine where the problem originated on your own.
OneBooks can review the historical activity, identify the issue, and develop a cleanup plan.
We help New Jersey businesses fix:
Speak directly with Robert Mitchell, founder of OneBooks, about the reconciliation problems in your QuickBooks file, how far back they extend, and what records are available.
Booking form not loading? Open the scheduling page or call 888-665-5085.
OneBooks LLC
681 Lawlins Rd Ste 10-4
Wyckoff, NJ 07481
Common causes include missing transactions, duplicate entries, changed or deleted reconciled transactions, incorrect transfers, opening-balance errors, payment-processor deposits, and bank-feed problems. Historical records may need to be reviewed to determine where the difference began.
It generally means activity affecting a previously reconciled period has changed. A reconciled transaction may have been deleted, edited, re-dated, unreconciled, or the opening balance may have been altered.
QuickBooks can create this account when reconciliation differences are recorded. A balance in the account is a reason to review whether prior reconciliations were forced through with adjustments instead of resolving the underlying difference.
Usually back to the last reconciliation that agrees with the corresponding statement. If no reliable reconciliation exists, the review may need to begin with the opening balance or the earliest available source records.
Typically, OneBooks needs accountant access to QuickBooks Online, bank and credit-card statements for the affected periods, and any relevant loan, payroll, merchant-processor, reconciliation, or CPA records.
Pricing depends on the number of accounts, number of historical periods, transaction volume, and complexity. OneBooks reviews the file and provides a fixed-price quote before work begins.
Yes. Once the historical accounts are reconciled and the books are current, OneBooks can provide ongoing monthly bookkeeping to help keep the accounts reconciled going forward.
Reviewed by Robert Mitchell, Founder/Managing Partner, OneBooks
Robert Mitchell has more than 40 years of financial and business management experience and leads OneBooks' approach to catch-up, cleanup, and monthly bookkeeping services.
Every OneBooks bookkeeper is required to earn QuickBooks Online ProAdvisor certification, and completed cleanup is reviewed by a Certified ProAdvisor before financial statements are delivered.
