If you need to do a mass refund, potentially because you or your client decided not to run, you can use the Bulk Refunds Quick Import format to import refunds into ISP.
Step 1: Export transactions using the Financial transactions report.
- Under the Reports menu, select Financial.
- In the Report drop-down menu, select the Transactions report.
- Put Monetary Contribution in the Transaction Type box.
- Add Columns for Transaction ID, Amount, and Date.
- Hit Generate at the bottom and export to Excel.
Step 2: Note the refund amounts and dates you wish to issue in the export file:
- Do the appropriate math to determine how much to refund each person.
- Edit the downloaded spreadsheet to make the following changes:
– Make no changes to the TransactionID field
– Ensure there are only one Amount column and Date column
– Complete the Amount and Date columns with the amount and date that should be recorded for each refund - Any other columns in the file can be deleted before upload.
Step 3: Upload the edited file using the Bulk Refunds format:
- Install the Bulk Refunds format. On the Quick Imports page, underneath the Tools menu, click Add New Import Format in the bottom left. Locate the Bulk Refunds format and select it.
- Ensure that your file for upload now only contains one Amount field, one Date field, and that the TransactionID column was unedited. The only columns that will be used in the import are Transaction ID, Amount, and Date. All other columns will be ignored.
- Using this format, import the Excel file you exported and edited.
Step 4 (Optional)
- If you need to print refund checks, navigate to Print Checks under the Accounting menu and print check for the newly recorded refund transactions.
