Bank Rec out of balance after Year end purge

Question

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

StephenC · Accepted 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.

Sage 50 US

Bank Rec out of balance after Year end purge

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING