Is it necessary to have a sufficient amount in my bank account in order to create a mandate?

Yes, your mandate amount cannot exceed the balance in your bank account. For example if you are creating a mandate of rupees 5000 then the link bank account that you are using should have a minimum balance of rupees 5000.