Its ANZ bank. I have no idea why it would read the opposite way when importing over automatically...seems strange to me.

I will have to do this manually as you suggest later on when I have some time. Hopefully it's not too painful! :)