Avoid duplicate gifts when re-uploading offline donors

This article covers GiveCampus campaign administration. Available controls can vary between the classic and redesigned campaign interfaces.

The individual offline-gift CSV import creates a new gift record for each parsed row. It does not update or skip an existing gift simply because the name and email match. Uploading the same gifts again can duplicate gift records and dollars. Reconcile the upload against existing gifts before approval/import; distinguish a legitimate second gift from a duplicate of the same gift.

Unique donor counting is separate. The unique-donor calculation compares case-insensitive name-and-email pairs, including overlap with online donors. Offline records without an email are counted separately in that calculation. Therefore a duplicate upload may inflate dollars even when it does not add a unique donor; changed names, different emails, missing emails and different report scopes can alter the donor result. Do not assume every repeated name is deduplicated across every leaderboard.

If an upload was repeated, identify the duplicate upload/records and have an authorized administrator reconcile removal, counts and matching effects. Do not remove all gifts from a repeat donor merely because that donor has multiple records.