Bank Reconciliations - How can we find information from previous months reconciliations?

We are fairly new to Sage 100. We upgraded to Sage 100 in March 2023 due to corrupted data in Sage 50.  When we reconciled our bank accounts for March and April, unfortunately we didnt print out the reconciliation and the staff member that completed the reconciliation is no longer with the company.  We are now being told by Sage 100 support that there is absolutely no possible way for us to look back at, nor print a bank reconciliation that was already completed so we can see what it included. How is this even possible?  What if there were errors based upon the software being brand new and a staff member not fully understanding the new software? We dont have ending balances to start with.   Even basic software like Sage 50 and Quickbooks allows you to go back and reference bank reconciliations from a prior month and even make adjustments if needed.   Does anyone have any suggestions, work arounds or ideas for us?  There are so many things we are discovering that Sage 100 does not do that even Sage 50 did.   

  • 0

    I'm sorry you found out the hard way.  If you were using Paperless Office, you can have that paperwork saved when it's printed.  If your reseller cannot give you training on your new system, you can check out SageU.com - they have training on pretty much every aspect of Sage 100 (I see a Bank Rec course if $59, currently).

  • 0

    I would recommend you setup all journals and registers to go to paperless office to help prevent this issue in the future and make sure you do NOT allow updating journals from preview.

  • 0

    We have all our registers use Paperless office so they are saved as PDFs. Even the bank reconciliation, which we attach to the GL account as a memo each month, so it's easy to find. (We do the same with the A/R and A/P reconciliations.)

  • 0 in reply to Sage100User

    So if you can not go back and print old bank reconciliations (or how do you know if 'Paperless Office' was/is turned on?) - how do you know the last time one was completed? Sorry, brand new to Sage for a company very behind on their books. When you open the 'Reconcile Bank' module and select the account you want to reconcile, it comes up with a number in the ending statement balance box, which can be changed, is the number defaulted/shown, is that the ending statement balance from the last time the account was reconciled. Any guidance/help is much appreciated, this system doesn't seem to be real intuitive/user friendly but hopefully it get's better. Any beginner pointers/courses suggested to get up to speed would also be appreciated. Thanks!

  • 0 in reply to JCharles

    Once the bank rec is completed, if you purged cleared transactions and did not save that report, then it is gone forever.

  • 0

    Write a Crystal report based on the AP_CheckHistoryHeader and include the ClearBank and ClearedDate fields to find out which checks were cleared on what date.  You can also edit the AP Check History Work table to add these fields to the works table and then add the fields to the report.