Payments
      Back to home
      1. GivingData Knowledge Base
      2. GivingData Building Blocks
      3. Payments

      Import Payment Data

      Update multiple payment records in GivingData with data from an external accounting system.

      A user must have the following permissions in order to import payment data: 

      • Batch Edit Payments
      • At least one other permission that gives the user access to Admin Tools & Settings.

      Data can be imported into your GivingData site from an external accounting system to update payment records in GivingData with payment information. Updated payments in GivingData are set to the Paid status after the import is complete.

      Article Sections

      Configure the Import Template

      Prepare the Data to Import

      Import the Data

      The payment import tool is available in Admin Tools & Settings.

      1. Click the gear icon in the quick navigation menu.
      2. Click Payment Import.
        Payment Import option

      Configure the Import Template

      Before importing payment data, configure the fields to include on the import template. These are the payment record fields that will be updated with data from an external system.

      1. Click Add Column.Add Column button

      2. Complete the fields, and then click Save.
        1. Insert After Column - Determine where this column of data should be inserted in the template.
        2. Column Data Options - Select Use column data to update a field in GivingData if the data entered into this column should update the corresponding field in the GivingData payment records. Select Ignore column data if the data in this column is simply for reference while completing the template. 
        3. Check the box for the field in GivingData to add to the import template.Save button

      3. Add as many additional columns as needed to the import template.

      Prepare the Data to Import

      Once the import template is configured, download the template and prepare the data to import.

      1. Click Download Template.Download Template button

      2. Add the data from the external system into the template spreadsheet.
      3. Save the updated template spreadsheet to your computer in a .csv format.

      Import the Data

      The final step is to import the completed template spreadsheet into GivingData.

      1. Click Import Payment Data.
        Import Payment Data button

      2. Select the file to upload, and then click Next.Next button

      3. Review the data to verify that it aligns correctly with the GivingData fields, and then click Update Payments.
        1. If there are errors, click Cancel and correct the data before restarting the steps. Update Payments button

      The system delivers a notification when the import is complete. The notification provides the number of payment records that were successfully updated, and lists any payments that were not updated.