Variable recurring invoices

Hello,

I work for a lender and where our funding for loans comes from institutions who link their rates to Bank of England and their rates are variable. Therefore, our borrowers are also on a variable rates with their recurring invoices having to be changed manually when Bank of England rates increase.

Now we have almost 100 recurring invoices to amend each time there is a rate change and so wanted to know if there is a way to reduce the manual work here somehow.

I look forward to hearing a response.

Many Thanks,