New Year's Eve advice (Madrid)

I am celebrating my first New Years Eve in Madrid and having a few friends visit from the States. Can anyone recommend a place to go out at night to celebrate? I was thinking Sol, then to a bar/club. I'm looking for somewhere fun with good music, some dancing and reasonable access to the bar to get some drinks.... it doesn't need to be super posh/exclusive. I know that cover charges can be a bit high and also that it may be good to book in advance... Protected content advice is appreciated.
Thanks!!!