How to Import GiveCampus Donations into Veracross Using Custom Reports – University

This guide explains how to use GiveCampus's pre-built Veracross report templates to import donations into Veracross using its Donation Import Batch tool.

Step 1: Set Up in Veracross

Before exporting data from GiveCampus, set up Veracross to recognize these gifts:

Create a Gift Payment Category in Veracross named “GiveCampus.”
This label will help identify gifts coming from GiveCampus forms during import.

Step 2: Set Up in GiveCampus

GiveCampus provides pre-formatted custom report templates specifically designed to work with Veracross.

Go to:
Online Giving > Reporting > Custom Reports > GC-Created Templates
Look for these two templates:
- Veracross Gift Import – Gift Row Report
- Veracross Gift Import – Designation Row Report
  - Don’t see them? Email support@givecampus.com to have them enabled.
Make a copy of the template. It will then appear in your Custom Reports and is ready to use for donation or deposit-based exports. For more information about using custom report templates, click here.

Choosing the Right Template

Use this template if...	Choose
You want one row per donation	Gift Row Report
Donors can give to multiple designations, and you need to track each separately	Designation Row Report

You can learn more about these types of reports here.

Key differences:

Gift Row Report	Designation Row Report
1 row per gift	1 row per designation
Only first designation will be in fund field	Each designation gets its own row and fund value
Donor-covered processing fees included in receipt_amount	Donor-covered processing fees included in its own row

Field Mapping: GiveCampus → Veracross

The templates include "aliases"—custom column names that match Veracross's required field names. This makes the import process easier.

The Gift Row report template contains the following fields with their corresponding Veracross aliases:

GiveCampus field	Veracross field
first_name	donor_first_name
last_name	donor_last_name
payer_email	person_email
phone	person_mobile_phone
date_of_capture	receipt_date
donation_amount	receipt_amount
veracross_payment_method	payment_method
veracross_payment_category_type	payment_category
veracross_credit_card_type	credit_card_type
unique_identifier	fundraising_activity
designation_name_1	fund
in_honor_of	in_honor_of
in_memory_of	in_memory_of
anonymous	anonymous
incentive	reward_type
fmv_of_incentive	reward_fmv_amount
note_content	notes

We include several blank columns to make the import process smoother in Veracross. These are fields in the Veracross import template that GiveCampus currently does not capture and will be blank in the report:

from_both
organization_id
organization_name
receipt_number
receipt_printed_date
receipt_letter_template
check_number
check_date
in_kind_gift_description
batch_id
solicitor_id
solicitor_name
giving_channel
acknowledgement_date
acknowledgement_type
stock_sale_date
stock_sale_value
stock_name
stock_symbol
stock_number_of_shares
stock_broker_fee
profile_code_1
profile_code_2

Customizing the Report

You can:

Rename your custom report
Add or remove fields
Swap fields like date_of_capture for date_of_deposit, if preferred

Downloading and Importing the Report

Download your report from Online Giving > Reporting > Donations or from Online Giving > Reporting > Deposit-Based Reports
Filter by date/time or select a specific deposit to download
Follow Veracross’s standard instructions to complete the Donation Import Batch

Automating Your Reports

If you'd like to automate this report via SFTP, reach out to support@givecampus.com.