I think a lot of pain could have been prevented if QB had pushed out an email indicating that it would it would prevent operation of QB Mac Desktop 2023 if you upgraded the Mac OS to Sonoma. Honestly, I ought to have known better because the same thing happened when we migrated to Monterey (and a couple of earlier upgrades).  Apple didn't introduce Sonoma to the public as beta software, but it was introduced after three months of beta testing. 

I looked at the link provide, Understand QuickBooks Desktop Compatibility with Beta Operating Systems., and I did not see anything that indicated moving to Sonoma would be a bad thing. It still does not say, "Don't upgrade to Mac OS Sonoma." It does say, "An operating system of at least Mac OS X v12.0 (Monterey)." I think Sonoma is "at least" Mac OS X v12.0?

I know you'll get it sorted out, and I wish you the best of luck with that. It is just a royal pain for us out in customer land. Have a great day!