What happens if I don't have sufficient funds in my bank account?

It will automatically cancel the scheduled purchase and you need to redo the recurring purchase set up. You will also get a notification in the app regarding insufficient funds.