Bank Rec out of balance after Year end purge

SOLVED

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
  • 0
    verified answer

    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.

  • 0 in reply to StephenC

    Hey Stephen yes thank you so much that worked perfectly. We also had an issue where all the AP vendors defaulted to the same expense account. I exported from the previous company file and imported to the new company file and seems to have straightened that out. The crew is here is now very weary something else is going to be out of place. =0

Reply
  • 0 in reply to StephenC

    Hey Stephen yes thank you so much that worked perfectly. We also had an issue where all the AP vendors defaulted to the same expense account. I exported from the previous company file and imported to the new company file and seems to have straightened that out. The crew is here is now very weary something else is going to be out of place. =0

Children
No Data