I wanted to make sure it will work with Sonoma on M1 iMac that I was looking to purchase.

You can use the trial version to make sure. 

I was looking for a new accounting SW that I could export my QBdata into theirs, but have not been able to find anything. I tried with one and they couldn't covert my QB data CSV file into their system.

Which one do you mean? You may consider to purchase a 3rd party conversion service. I would recommend to start from scratch on the new SW to lower your conversion costs. You can use the trial version to access your historical data for good later.