1. Run the Pledge Status Report on a specific date range

2. Set all appropriate parameters

3. On the Gift Types tab,mark the Calculate Gift Balance Based on Date Range, Campaign, Fund, or Appeal checkbox to see the pledge balance as of the end date on the report

4. Run the report

5. Export the report to Excel

6. Sort the Excel file by Pledge Balance

7. Remove all pledges that have a balance not meeting the criteria