Please can someone help me. We have a problem where Quickbooks doesn't automatically update 5 of our bank accounts as they conflict (no fix for 7 months already). We have to update the bank accounts manually, easy to do on a Windows based computer however we have now moved to Mac (Apple) and each time we try to update the CSV it shows an invalid file format. 

Our version of Excel (Office 365 - V16.30) does not offer a "Windows CSV" in the speciality drop down on saving. The Macintosh-CSV option also gives an invalid format error.

If we use the OFX document from our bank it doesn't allow us to select the transactions to import, it auto adds everything which means we then need to delete each duplicate transaction.

We have 11 accounts in total of which 5 we have to manually upload each week. This is extremely frustrating and I am not getting any help with this issue. We urgently require assistance and a fix.

Does anyone else have this problem? Or can anyone help?

Thanks in advance!