First, create a query to pull the failed transactions:
  1. Click Queries
  2. Click Manage Queries
  3. Select a category that you want to store this query in (Ex: Base)
  4. Click New Query under the Tasks menu
  5. Name the query
  6. Set the Starting Query to Base/All Constituents
  7. Under Results, set the Data Return Type to Journal Entries
  8. Under Criteria Options mark Match each criteria
  9. Under Browse Fields select Commonly Used Fields from the drop down menu and click on Journal Entry Date
  10. Fill in your date range
  11. Under Browse Fields select Journal from the drop down menu and click on Transaction Auto Process Status
  12. Select Failed
  13. Click Save And Preview 

Then, create a report to display the failed entries:
  1. Click Reports
  2. Click Manage Reports
  3. Select a category that you want to store this report in
  4. Click New Report under the Task Menu
  5. Name the report
  6. Under Group Results, select to Group Report By Account and Show Group Totals
  7. Under Browse Fields, select Commonly Used Fields in the drop down menu and click Account Name, Date, Fund, and Received
  8. Select Journal Fields under Browse Fields and click Failure Code and Failure Message
  9. Arrange the columns into order by clicking on the middle of the field column and dragging up or down.
  10. Click Save and Run under the Task Menu
  11. Under Query select your category in the top box and your query in the bottom box
  12. At the bottom of the page select a Delivery Option and then click Submit