How badly does it affect credit when a credit card closes your account

This is my situation.  I changed banks and accidentally paid on my walmart credit card with the wrong account. My bad so i got a returned payment.  Sadly i entered my new bank information incorrect and got a second returned payment. GE/Syn bank closed my walmart card.  I am a little peeved. granted it was my fault i made a typo but why cant these companies investigate what happened first like call me. i even called them prior and tried to see if they can stop the “bad” payement before it went threw.  I have like 8 years of perfect payement with them and this was the first issue I had. My account also shows I clearly “re-paid” those paments via my online banking and they cleared. I was not trying to commit fraud or float checks… etc. I actully recieved a debt consolidation loan and paid that account in full. I have many credit cards with this bank and did not have this problem. I think what caused me to make a typo is I was multitasking and also was in a bad automobile accident which made me hard to concentrate (stress)  how badly will this affect my fisco score? I was planning to never re-charge again but i was told keeping the older accounts open helps your credit score.

How to set up an apple ID without a credit card or computer