Bedford Borough Council admitted a spreadsheet error caused drivers to be charged for parking unfairly amid the Cost of Living crisis.