- Create an export
- Export the pledges and write-offs
- In the export parameters, unmark the Use gift balance instead of gift amount option
- In Excel or Crystal Reports, set up a formula to subtract the write-off amount from the pledge amount
It may occasionally be necessary to export the original pledge amount minus write-offs. This can be done using export and formulas in Excel.