1. Go to Control > Query
2. Click New and select Payments Query
3. Expand Payments > Payment Information
4. Click Payment Source Type and click Add
5. Choose Equals and Recurring Gift
6. Click OK
7. Click Payment Status and click Add
8. Choose Equals Failed
9. Click OK
10. Click Next
11. Choose the information you want to output in the query results
12. Click Finish