I understand how you feel, especially since you've been dealing with this issue for a while, idealappliancere. Also, appreciate the extensive efforts you've made to resolve the problem.

Since the issue persists, I suggest contacting the Green Dot support team. They have the tools to review your account and check on their end why your checking account and debit card are being declined and not working.

I also got you this article on managing your QuickBooks Checking account: Learn more about QuickBooks Checking.

Also, you can check this article for additional guidance on moving money from one account to another to correct the balance in QuickBooks: Transfer funds between accounts.  

Keep me posted if you need some help with working in QBO. I'd be glad to lend a helping hand. Wishing you the best. Have a great day!