ATP is used for initiation, elongation and termination of transcription: energy from ATP hydrolysis is required in 2 or 3 steps of initiation including opening of the promoter region and promoter binding, and converting RNA pol II from closed to open complex, also helicase activity and termination factors require energy from phosphodiester bonds.
All in all it appears to require 4 ATP per transcript on average (2 for initiation, 1 for elongation, and 1 for termination). Energy from GTP hydrolysis is also used in transcription.