I have recently switched over from desktop Sage 50 to Sage business Cloud. I am trying to relearn everything. Migration moved 2 years worth of transaction over plus all relevant records. Im trying to do bank reconciliation but the bank feeds balance isnt correct. I go to Settings - Opening Balances, and try to change the date to the day I migrated over, but it wont let me change it. Its stuck on 30/4/25. Its more than a year off. I read that the opening balance for bank rec should be the next date, as the old system was reconciled up to the day of the migration. I did this so I would have a smooth transition and not to have any issues. But I have issues. The help isnt helping, because the steps its saying to do, dont work or apply. If I put the last reconciled amount into the opening balance, the end balance is off by £60 odd thousand. But if everything was reconciled up to the day of migrating, why is it that I need to reconcile thousands of pounds worth of transactions to get to todays bank balance?

Ive hit a brick wall in terms of progressing with any reconciliation and bank feeds. I move over because Sage50 was way too expensive and I was told Sage Cloud was simpler.