Using the Payment Import Tool

Learn how to use the Payment Import tool to update multiple payments in GivingData with relevant information from an external accounting system.

Required Permissions

In order to import payments, a user must belong to a user role with permission to batch-edit payments. Additionally, the user must have at least one other permission within the Admin Tools & Settings Permissions section. 
Screen Shot 2023-01-19 at 5.15.10 PM

Navigating to the Payment Import Tool  

Click on the gear icon within the Quick Navigation Menu to access Admin Tools & Settings.

Screen Shot 2022-11-10 at 4.44.07 PM-1

Select “Payment Import” from the Data Import section.

Screen Shot 2022-11-10 at 4.57.16 PM

 

Note: The Settings area may look different from this image depending on your user permissions and GivingData subscription.

Importing Payment Data

On the Payment Import page, click “Import Payment Data”.

Screen Shot 2022-11-10 at 5.11.53 PM

In the modal that appears, click “Select File” or drag and drop the file that contains the payment information provided by the accounting system. Then click “Next.”

Note:  Payment Import files must be in .csv format

Screen Shot 2022-11-10 at 5.16.13 PM-2


A preview screen will appear so the user can verify that the data from the .csv file appropriately align with the template set up in GivingData.  If any errors are spotted, the user can click “Cancel” to end the process.  Otherwise, select “Update Payments”.

Screen Shot 2022-11-10 at 5.26.14 PM


A notification will appear for the user informing them that GivingData is processing the payment import.

Screen Shot 2022-11-10 at 5.29.42 PM

When the import is complete, the user will receive a notification in their GivingData inbox.  The notification will inform how many of the payments were successfully updated.  If any payments were not updated, the notification will specifically list which payments did not update.

Screen Shot 2022-11-11 at 10.15.39 AM

Successfully updated payments will contain the data points included in the .csv file used for import, and the payment statuses will be updated to “Paid.”