Financial Report Recipe: Exclude Refunds
There may be scenarios where you want to pull a financial report that does not include refunded donors:
- Navigate to Reports and select Financial
- In the Report drop-down menu, select Transactions
- Enter the appropriate Transaction Date range
- In the Transaction Type window, include Monetary Contribution and Refunded Contribution
- In the Columns window, add a column for Net Worth Impact
- In the Aggregate Option drop-down menu, select Aggregate by Entity
- Generate
The Net Worth Impact column will provide a column with the net donation amount minus the refund amount. Any zeros in this column can be deleted.