How to reconcile statements up to date

SOLVED

We are a student organization and we have had sage for several years but never really used it at full capacity. We do not have access to our bank account online and the organization does not have a credit card. We used to do bank reconciliations in an old fashion way but due to illness I have been on and off of work and bank reconciliations have been neglected during my time away. Essentially, bank reconciliations have not been done for the last 4.5 years. I am lost and extremely desperate because I do not know how to reconcile all those previous years. Sage won't allow me to post any historical journal entries (as far back as I can go is May 2023) and obviously the banking accounts are way off.  How can I fix this? Thanks!

Parents
  • +1
    verified answer

    Hi Crystal:

    In order to do your bank reconciliations I would suggest to manually reconcile up to April 30 2023. Run your General ledger transaction report for the years not reconciled. Post your reconciled entries dated May 1st 2023. Remember any adjustments dealing with expenses or revenues must be posted to retained earnings,  surplus account, endowment account or funds for specific purposes and your bank. Any assets, liabilities or equity accounts would be posted to their respective accounts and bank account. Once the adjustments are made in Sage 50 you can open your reconciliation module and date the closing date as May 1, 2023. Check off all of your entries cleared through the bank and you should be able to reconcile. If not, you could turn your reconcile module off and back on again and start your reconciliation from May 1st 2023. You would have to add any outstanding deposits, cheques, and debit or credit memos initially to start your first reconciliation for May 2023. If you have further questions please  post them on this forum.

  • 0 in reply to Agate

    Hi Agate, I manually reconciled up to April #0, 2023. I checked all the entries cleared but it does not allow me to post it. It says that: "the statement end balance does not equal the sum of the opening balance , the transactions appearing on my FI statement and general ledger adjustments". It says I need to ensure opening and ending balance match and all transactions are properly recorded. I have a negative discrepancy and negative unresolved amount. Any help would be greatly appreciated. 

Reply
  • 0 in reply to Agate

    Hi Agate, I manually reconciled up to April #0, 2023. I checked all the entries cleared but it does not allow me to post it. It says that: "the statement end balance does not equal the sum of the opening balance , the transactions appearing on my FI statement and general ledger adjustments". It says I need to ensure opening and ending balance match and all transactions are properly recorded. I have a negative discrepancy and negative unresolved amount. Any help would be greatly appreciated. 

Children
No Data