To use the Touchpoint export, you must first ask SecureGive to set you to the “CSV Complete” export format. There must be member IDs and fund IDs entered into SecureGive in order for the export to work properly.
To enter fund IDs, go to Categories>Donations. Click the edit pencil for each one and enter the fund ID from TouchPoint - be sure to Save. To add member IDs, go to the All Transactions report and click on the circle in the member ID column by the donor’s name. Enter the member ID from TouchPoint then be sure to click “Update Member ID”.
- Sign in to SecureGive and go to Reporting>All Transactions.
- Select the date range and any other filters you need for the group of transactions to be exported.
- Fill in any missing Member IDs. To make it easy to identify them, you can sort the report by Member ID so that unassigned members are at top of list. Do this by clicking on the top of the Member ID column.
- To add the Member ID, click on the circle with the “!” next to person’s name to open up their details.
- Search for person in Touchpoint.
- If any info in SecureGive (name, email, address) is missing from Touchpoint, you can add that info to Touchpoint.
- Use the member ID from the address bar on their Touchpoint profile to enter into SecureGive then click “Update Member ID” .
- Repeat this process for all SecureGive profiles that do not have a member ID.
- Once all members have an ID in SecureGive, sort the report again by date (ascending)
- Select the “Export to CSV Complete” button.
- We suggest saving your file with a name that indicates the date range of the export to help you keep track.
- In Touchpoint select Administration – Contributions -Management – Upload SecureGive.
- Select “choose file”
- Select the SecureGive file you just exported
- Enter the contribution date.
- In “Fund ID for unmatched contributions,” enter the default fund ID to be used if a contribution does not have a fund ID.
- Click “Submit”.
- Select “Post Bundle/Edit” if you need to edit any individual contributions
- Ensure that the bundle total and all contributions are correct.
- Select the Deposit Date and Close the Bundle when finished.