Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
How do I reconcile uncleared transactions from previous years?
My account is current and balanced. I think most of these uncleared transactions are from a previous bank account. The previous bank account - let's call it BankA, has a list of a few uncleared transactions from almost 6-7 years ago. That is when the church started in with a new bank, let's call it BankB. Interestingly, the transfer of funds from BankA to BankB is not correct either. The last balance from BankA was $10,101.00 (+/-) and the opening balance of BankB $15,000.00.
My goal is to clean up the outstanding uncleared transactions so when I reconcile, I don't have these transactions permanently uncleared for all eternity. How do I resolve a situation like this appropriately. My plan is to go back and try to find the old 2014 records and see if I can reconcile them, but that is probably not likely.
Any suggestions would be welcome! If you need more details just let me know.
Hello there, @SVOhio.
You can reconcile your past transactions one year at a time. This way, all adjustments, service fees, and interest you enter during the reconciliation process will apply to the year in which those transactions occurred. I can guide you on how to do it.
You can read through this article for more detailed steps: Reconcile an account for multiple months or years of transactions and financial statements.
Also, I'd recommend consulting with your accountant so you'd be advised the best method for you to reconcile statements and transactions for multiple years.
Keep me posted if you have other questions about reconciling your account. I'm always here to help.
Greetings, @SVOhio.
I just want to make you're able to reconcile your previous transactions. Have you tried the steps I've shared? Were you able to reconcile your outstanding uncleared transactions?
Keep us posted here if you have other questions or concerns. I'm always here to lend a hand.
I cannot try your suggestion until this weekend and I had to hunt down the old records to see if I could find the old statements to see if it will help. I will keep you posted.
I am having a similar issue and your solution is not working for me. I am unable to go back to the earlier reports.
The Community has you covered, @Allie6.
Let's run the report for the specific bank account and filter it to show those uncleared transactions. Follow along below to get this done right away:
For more details, please refer to this article: Customize reports in QuickBooks Desktop.
Once done, you may now follow the steps outlined by my colleague, IamjuViel to reconcile your uncleared transactions from previous years.
Also, if in case you need info from your past reconciliation to review or fix a current reconciliation, you may pull up a reconciliation report. For the detailed steps, please see this article: Get reports for previous reconciliations in QuickBooks Desktop.
Feel free to post here in the Community if you have any concerns about reconciling your accounts in QuickBooks. I want to make sure you're taken care of, and I'm here to help you anytime. Take care always.
I apologize for the late response to all of these great suggestions to help. Thanks Everyone for the comments and support. I couldn't really use any of them, not because they were not correct but there were so many unreconciled transactions and funds transfers for 6 years that some records just simply were not available any longer. I ended up hiring a QuickBooks certified professional accountant to get assistance.
Thanks again.
Hi @SVOhio
Hope you are doinf well...!
Delete Transactions
Void Transactions
Clear Old Transactions With the Condense Data Tool
For further assistance, Call Sagenext Customer support: +1-855-922-7243
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