...
Label | Description |
---|---|
Credit To | Ability to select where the Transaction/Donation will be added to. It could be to a specific Fundraiser Page or just a regular donation to the site. |
Amount | Dollar Amount to be donated |
Type | Select the form of payment if its Cash, Check or Wire Transfer |
Gift Date | Able to select the date of when the transaction occurred. |
Donor Information | This would be the Supporter Fields or the Information about the donor. |
Comment | Any internal comments or details about the transaction could be added in the space. |
Anonymous Donation | Able to check/uncheck if the transaction will be labeled as anonymous. |
Adding Bulk Offline Transactions
...
You can import a Bulk Offline Gift directly to the site from the Donation Block. Simply click on the Bulk Upload Offline Gifts button and a pop-up window will reflect with information on how to import your offline transactions/gifts. Donations can be attributed to a site, team or individual based on Page ID, with fallback option of email address for fundraisers and teams. You just need to follow the guide given to ensure you import the correct information needed without running into any issue/error during the import:
...
Here is a quick guide of what to expect on the Template CSV:
CSV Header | Details | Expected Values / Format |
Page ID | If present, overrides Supporter Email Address |
|
Credit To |
| Fundraiser, Team or Site |
Supporter Email Address | Required if no page id is present and Credit To = Fundraiser or Team |
|
Transaction ID | Required |
|
Transaction Date/Time | Required | YYYY-MM-DD HH:MM:SS |
Amount | Required |
|
Currency | Required |
|
Payment Type | Required |
|
Made in Honor |
| Y | N |
Honoree Name | String if Y in Made in Honor |
|
Appeal Code |
|
|
Tracking |
|
|
External Reference 6 |
|
|
External Reference 7 |
|
|
External Reference 8 |
|
|
External Reference 9 |
|
|
External Reference 10 |
|
|
Donor First Name | Required |
|
Donor Last Name | Required |
|
Donor Email | Required |
|
Donor Address 1 |
|
|
Donor Address 2 |
|
|
Donor City |
|
|
Donor State |
|
|
Donor Postal Code |
|
|
Donor Country |
|
|
Comment |
|
|
Anonymous Donation |
|
|
Donor Origin Source |
|
|
Check the file for the following characters that can cause the upload to fail: pipe (|), double quotes (“), backslash (\), exclamation mark (!) .