Bank Reconciliations

SOLVED

Recently I took over the accounting for a company and have found that she did not use the reconciliation feature in sage, and did a manual reconciliation through 

excel.  So the company has not had a reconciliation done since 2014, our auditor comes next week and I need to have our first month of the new year reconciled to go along with 

last year's files. Can someone direct me on how I can change the date of the reconciliation to April 1 this year, and change the bank account information to reflect the current 

amount, so that I can reconcile on sage moving forward. 

I really appreciate any suggestions I have attempted to but do not want to make more work if I change something to have it affect the prior year's records.