Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowI recently started working for a person who is the owner of a small business. Our checking account has never been reconciled (the account opened in 2015.)
The bank account is using bank feeds through QuickBooks Online so the beginning balance on the most recent statement matches the balance in QB. The ending balance is off by almost $800k.
There are categories set up and those all seem to be correct and matched. There are about 4500 "pending" transactions. I started posting them and have gone back about 3 years. Do I need to post all of them?
I've been reconciling accounts for a long time but am at a loss as to where to begin with this one.
Solved! Go to Solution.
Who filed his 2024 taxes? The accountant? If so, I would let the accountant make an adjustment to reconcile through 12-31-24 and then start with January 2025. Good luck!
Thank you for bringing this matter to the Community forum, @erin_interav. As a best practice, QuickBooks Online recommends performing bank reconciliations on a monthly basis to ensure that your financial records accurately reflect your bank statements and to help catch any discrepancies or errors early on.
Since the account has remained unreconciled for nearly 10 years, the reconciliation process will understandably be more complex and time-consuming. Rather than attempting to reconcile the entire period all at once, the most effective approach is to start with the most recent bank statements and transactions, then gradually work your way backward. This method allows you to focus on the most current data first, ensuring that your records for recent months are accurate, while progressively addressing and cleaning up older periods. Additionally, I recommend working with an accountant or financial professional during this process to provide guidance, help resolve discrepancies, and ensure that everything is handled correctly.
Please also take note that when reconciling, it is crucial to have all bank statements covering the entire 10-year period. Having these statements on hand will allow you to accurately match and verify every transaction, ensuring nothing is missed or incorrectly recorded throughout the reconciliation process.
To answer your question about whether you need to post all transactions, it depends entirely on the bank statements you have. You only need to post and reconcile the transactions that appear on your bank statements.
To reconcile this, you can follow these steps:
You can also check this article for more detailed information: Reconcile an account in QuickBooks Online.
Thank you again for reaching out and sharing the details of your situation. We understand that reconciling an account with a long history of unreconciled transactions can be a challenging task, but by taking it step-by-step and focusing on the most recent transactions first, you can gradually restore accuracy to your records. Remember, patience and thoroughness will be your best allies throughout this process. Take care!
Thank you for responding.
I'm going to be honest and say that there is no way I'm going to reconcile 10 years worth of statements. It's just not a realistic option, at least not for me.
Is there a way to have our accountant make a general ledger adjustment or any other work-around?
We understand that reconciling 10 years of statements may not be feasible, @erin_interav. You’re correct, your accountant can make general ledger adjustments by creating journal entries to bring your accounts up to date. This can be a workable solution.
Before proceeding, let’s confirm if the 4,500 pending transactions include dates going back to 2015. If they do, we recommend posting these transactions and performing quarterly or yearly reconciliations starting from 2015 up to your most recent statement. Use the quarter’s end date (first, second, third, or fourth quarter of 2015) and ensure that each quarter or year aligns with your corresponding bank statement balance. If there’s only a small amount leftover, adjusting journal entries can be created to address the difference.
If the transactions only go back three years, your accountant will need to determine the latest statement’s beginning balance, which is the ending bank balance prior to your most recent statement’s balance. This discrepancy, amounting to nearly $800k, could explain why the ending balance is off and hasn’t been added yet. Using journal entries, your accountant can debit or credit the appropriate categories. Be sure the journal entry dates do not overlap with your most recent pending bank transactions. Once these entries are reconciled, your accountant can proceed with the most recent statement to ensure accuracy. This process will also help offset the $800k difference.
For a quick summary, the steps are as follows:
If you have any further questions, we’re here to help.
When you select all of the uncategorized (pending) bank transactions, how far off is the bank balance from the bank statement as of 8-31-25? I assume $800K is before taking into account the pending transactions, yes? Are the transactions clean- i.e., they're all legitimate business transactions? How far back do you have access to bank statements?
Depending on how you answer the above questions, you can likely reconcile through 12-31-24 in one fell swoop with an adjusting entry and then do monthly recs for 2025.
Yes, the 800K was before I posted the pending transactions. I have posted everything going back to 2020. At that point I started getting error messages say I need to choose a bank account for this transaction? I think maybe he either changed banks at some point or maybe changed accounts. The company was just a one man operation at that point so I don't think he was great about keeping records.
After posting about 5 years of transactions the closing balance discrepancy as of today is up to over 2 million dollars.
As of 1/02/2025 the discrepancy in QBO was $1,451,398.33.
Should I make an adjustment myself or let the accountant handle it?
And what should I do with the pending transactions that can't be posted? There are over 4000 of them, mostly from 2015-2020
And yes, I think they are all legitimate. It looks to me like at some point the owner connected his bank feed to QBO so they were categorizing many of the transactions but he didn't post them. I'm really not sure to be honest. I have access to statements going back to 2018.
Who filed his 2024 taxes? The accountant? If so, I would let the accountant make an adjustment to reconcile through 12-31-24 and then start with January 2025. Good luck!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here