You can search for mandates in bulk using the POST SearchMandates API, which returns the list of payments based on the parameters given as input.