Check or Cash:Choose this option to import historic/offline cash or check transactions.

After choosng your type, you will need to pick a frequency.

NOTE: For Check/Cash donations, only single donations can be imported

If you are importing Recurring Donations you will need to import the initial donation first followed by a second import of the subsequent donations.

Click to proceed.

Uploading the data

You’ll now be taking to a screen where you’ll need to choose the donation page you want to import these gifts into and your CSV file. For more information about the file format please see here.

Click the Upload button to continue.

Mapping the data

You’ll now be taking to a screen where the software will do predictive mapping if the header row names match the transactional field names. It will also show a sample of the mapping based on your first row of data in the file.

NOTE: Be sure to double check the mapping and re-map any rows that you want to update.

If you don't want to import certain columns, then leave the 'map to' dropdown set to 'unmapped'.

If you would like to save this format for future use. Just tick the box to do so and provide a saved format name.

Click to proceed.

You will now get a popup confirming the number of donations and amount you are about to import.

If you are happy, press Confirm or you can cancel to update.

Checking the status of your import

The file that is being imported is sent to the servers as a 'Job'.

Go to 'Jobs' > 'Jobs monitor' and you will see a list of all the current jobs in your account (for imports, exports, broadcast email sends and message uploads).

When your job has completed, you will can click the cloud icon in the 'Results' column. If you click on this link a file will download and you'll be able to see if any records failed to be imported, generally because the email address was in an invalid format. The file will give you the email address to fix, so you can go back to your spreadsheet, tidy up the records in question, and re-upload them.

If your import was 100% successful, the file you download from the 'Jobs monitor' will be blank.

Undo an import

If for any reason you wish to undo the transactional data import, you can use our 'Rollback' feature to remove the imported transactional data.

Go to 'Jobs' > 'Job History' and you will see a list of all the jobs that you have run in the account.

Once the job has imported you will see a "rollback" option on the right hand side.

You can click 'Rollback' to undo the import process. You will be prompted to confirm that you do wish to remove the imported transaction.