Rates and Units Mapping up to 300+

We have a large client who have almost 300 rates. having multiple templates does not work as the rate names are very particular its hard to keep track of

Describe the Challenge

Payroll doesn't balance, rates are duplicated and missed