Batch update not updating contribution account

Hello! Cloud user!

We have been forced into a new mandatory health care insurance. The change was quite fast and as a result a few months of payroll were posted to the incorrect liability account.

I created a new contribution item and I copied that account key.

When I go to batch update and replace the account key, it still shows up with the old key.
If I delete the key, it properly updates with no account, but if I change the key, it still shows as the old. I’m not sure what I’m doing wrong.

Old contribution item key:

New key:

When I copy and paste the updated data into manager.io it doesn’t show any change.

I thought it was related perhaps to the column not being recognized, but if I simply delete the key it updates.

I thought perhaps it was related to formatting so I tried changing to “text”, but same result.
Then perhaps I have the wrong key? But I checked that several times.

image

I have never had a similar problem. I’m doing something wrong, but not sure what. Any assistance would be greatly appreciated.