Please note that, in Xero, the opening bank balances need to be the STATEMENT balance not the "books" balance. You achieve this by posting the difference (unreconciled items) to a suspense account in the Conversion Balances list. As the items for the previous period come through you can then code them to the suspense account.
__________________
Adrian Pearson Blog: www.adrianpearson.com | Mobile: 07944 970997 | Email: adrianpearson@outlook.com Xero data conversion specialist. Founder of Movemybooks and Ledgerscope.