For stock SIPs, your funds are deducted from your Zerodha account. Your SIP order will fail if you do not have sufficient funds available on the specified date. You can use the eMandate facility to ensure your Zerodha account has the necessary funds.