When is the referral fee due? Is it due once we are connected to a financial institution and an account has been opened with them?

Yes. That is correct. Your referral fee is due when your account is approved.