bank fat fingered check number, how to reconcile?

Summary:

We have issues with our bank entering check numbers incorrectly, which then leads to the checks not reconciling in ERP. Need to do these in bulk, as the bank seems to do 200-300/month, so manually not an option. If we can do it in a spreadsheet that would be ideal, but I've poked around and haven't found any options that seem to work.

Content (please ensure you mask any confidential information):

Does anyone have any ideas as to how best to reconcile these? The bank so far has not been helpful.

Version (include the version you are using, if applicable):