I appreciate you for coming back to the thread and adding extra clarification about your concern, JAK-TSDB. Also, this isn't the kind of sentiment that I wish you to have when downloading transactions. With this, I'll ensure you'll be routed to the right person to assist you with further troubleshooting steps so you can get back on track.
Verifying and rebuilding your data in QuickBooks Desktop for Mac usually find the most common data issues in a company file and fixes them. Since you're unable or getting an unexpected error message in the rebuilding process, I recommend contacting our QBDT for Mac phone support. They have the tools to check your account in a safe environment which we're unable to do it here in the Community. That way, they'll be able to investigate the cause of the problem.
Lastly, you may refer to this article to see steps on how to fix invalid formatting in case you receive the error OL-222: Fix error OL-222 in QuickBooks for Mac.
Please know that you're always welcome to post any questions about importing or managing bank transactions you have in this space,
JAK-TSD. Have a great day ahead.
