Giving
No personal information is stored about your donors within Google Sheets. This is by design to keep everything as anonymous as possible when viewing and sharing data.
You are required to be a Giving Admin for this connector to work.
The PCO Giving connector supports downloading your donations in a transaction list. If your donors give to more than one fund in a transaction you'll see this broken into separate lines.
Setup
Enable this module within the Settings screen of the sidebar. You can follow the instructions in step 2 of the configuration guide.
Ideas to Use
These are just some ideas and by no means the only way to use this information. If you find new and creative ways to look at your data we would love to hear from you! Email us at hello@savvytoolbelt.com
Viewing your giving by month or week
Calculating the total fees
Combining this data with People data to understand giving based on a profile field.
Giving based on age
Giving based on campus
Giving based on a list parameter.
You can create a list in PCO and use that as a parameter to filter gifts.
Giving Field Descriptions
Field Name
Description
Donation ID
A unique ID that's generated per donation. There will be multiple duplicate values for a split donation.
Person ID
This is the unique value for each person assigned by PCO.
Received At
This is when the donation was marked as received. Use this as your primary date column.
Refunded
True / False based on if the amount is refunded or not.
Payment Method
Card/Cash/Check/ACH. This will be how this was received into PCO"
Payment Method Type
This will show if the card was credit or debit.
Payment Channel
Showing if the gift came in through Batch or Stripe
Status
Payment Status within PCO.
Card Brand
This is the brand of the card your donor is using.
Source
These are the payment sources within PCO.
Labels
If you've assigned a payment a label, you'll get a list of those labels here.
Fund Name
The Fund Name this donation belongs to.
Ledger Code
This is the ledger code you've configured in PCO to represent your Chart of Accounts code.
Amount
This is the gift amount BEFORE the fee is removed.
Fee
This is the total amount for the fee
Net Amount
This is the amount after the fee is deducted.
FAQ
How can I use labels?
Currently, labels are downloaded in a list into the label field on Google. If you're looking to filter based on a label with GDS we suggest adding a parameter to filter the data. Find more information on parameters in the GDS guide.
Screenshots
Last updated
