Biofiltration processes help to remove trace organic chemicals (TOrCs) both in wastewater and drinking water treatment systems. However, the detailed TOrCs biotransformation mechanisms as well as the underlying drivers behind the variability of site specific transformation processes remain elusive. In this study, we used laboratory batch incubations to investigate the biotransformation of 51 TOrCs in eight bioactive filter materials of different origins treating a range of waters, from wastewater effluents to drinking water. Microscopy, 16S rRNA amplicon and whole metagenome sequencing for assessing associations between the biotransformation rate constants, microbial composition and genetic potential complemented chemical analysis. We observed strong differences in the mean global removal of TOrCs between the individual sand filters (-1.4% to 58%), which were mirrored in overall biomass, microbial community composition, and enzyme encoding genes. From the six investigated biomass markers, ATP turned out to be a major predictor of the mean global biotransformation rate, while compound specific biotransformations were correlated with the microbial community composition. High biomass ecosystems were indicated in our systems by a dominance of Nitrospirae, but individual TOrC biotransformation was statistically connected to rare taxa (< 2%) such as Hydrogenophaga, or indiviudal enzymes such as the enoyl-CoA hydratase/3-hydroxyacyl-CoA dehydrogenase gene. In general, this study provides new insights into so far rarely addressed variability of TOrCs biotransformation. We propose novel biological indicators for the removal performance of TOrCs in biofiltration systems, highlighting the role of ATP in predicting and normalizing the global transformation, and the role of the microbial community for the individual transformation of TOrCs in engineered and natural systems.