Bank Rec out of balance after Year end purge

Good morning,

Last weekend we ran the purge wizard to archive 20 years of data.

It seems that we did not instruct the purge wizard to leave the unreconciled bank transactions.

Now the bank recs from the purge date forward are out of balance by those amounts.

We ran the purge on a copy of a back up file so the original file is still intact.

Does anyone have a solution for this? Is there a way to bring those transactions over without losing all the work completed since the purge?

Thanks,

Andrew

Parents
  • I've never tried this before, but I think you should be able to fix this by entering the purged unreconciled items as "Beginning Transactions".

    In the Account Reconciliation window there's a Beginning Transactions button in the bottom right corner, just below the unreconciled difference. If you don't see it there, click the double arrow button that is in the bottom left corner to expand that section.

    In the Beginning Transactions window you can enter outstanding checks and deposits in transit. These transactions don't affect the general ledger. Normally this screen is only used when you first set up your company in Sage 50 to enter the outstanding items dated prior to your conversion date. But it should work in this situation too.

  • Thank you - I appreciate the suggestion.  I will try it when I get back from a couple of days off.  Part of the current problem is an "attack" on transactions from 2018 and I am suspecting 2017.  We are currently in 2020, I can't get back into those periods to fix it.

    Do you understand my frustration and simmering anger at this situation?  It is nothing I have done, yet I feel as though it is my fault because as the accountant here these numbers are my responsibility.  I have used the chat line in the past and been "informed" I obviously did something wrong - Really? - or don't know what I am doing.  Both times by someone who literally answered my question by rearranging the words and saying it back to me.  I hung up.

    I have had about 4 people on chat line who actually seem to understand my problem and either worked through it with me or passed me on to someone who could help, generally in I.T.  I do not call to ask how to do my job - I call because there is a legitmate mess on the system.

Reply
  • Thank you - I appreciate the suggestion.  I will try it when I get back from a couple of days off.  Part of the current problem is an "attack" on transactions from 2018 and I am suspecting 2017.  We are currently in 2020, I can't get back into those periods to fix it.

    Do you understand my frustration and simmering anger at this situation?  It is nothing I have done, yet I feel as though it is my fault because as the accountant here these numbers are my responsibility.  I have used the chat line in the past and been "informed" I obviously did something wrong - Really? - or don't know what I am doing.  Both times by someone who literally answered my question by rearranging the words and saying it back to me.  I hung up.

    I have had about 4 people on chat line who actually seem to understand my problem and either worked through it with me or passed me on to someone who could help, generally in I.T.  I do not call to ask how to do my job - I call because there is a legitmate mess on the system.

Children
No Data