Water on the passenger's side floor driving me nuts

[CT_X5_Joe]

Your sunroof seals are worn, and the water is coming inside via the sunroof. Depending on how you park (as in the angle of the car) will determine if/when water comes in.

In my 2006 4.4i with pano roof, I only get water leaking in when the front is parked down hill and we get a heavy rain. Most of the time the water drips from the overhead lighting area onto my shifter and cup holders.