With Click & Pledge you may run template reports, create custom reports, and download reports anytime you wish into an easy-to-use Excel compatible CSV (comma separated value) file.
Pre-built reports are available on your account and campaign dashboards. To access the full reporting area, go to Launcher, then to Transactions & Reports.
Custom and System Reports
Declined Transaction Report
With reports you may use filters to pare into your data further. One popular use of this would be for creating a report with reasons for declined transactions. The Decline Reason is the response received back from the bank.
To run a report on declines you can:
1. Choose a System Report like the Quick Report or Consolidated Report.
Or if you prefer to create a custom report, be sure to include the field "Decline Reason" in a column.
2. Choose your date(s)
3. Click Add Filter
4. In Field Name select Payment Status
5. In Operator select Equal
6. In Value select Declined
7. Click Run Query button
8. Click an option. Click Save Report to be able to recall the report or Download to download it to your computer. in the report the Decline Reason column will show the bank's decline reason.
Stripe (Deposit) Reports
You may download a report by month or Payout Date. Note that the "Fund Date" field is the day funds are released to your bank account. Individual banks may vary on when those funds may show as a deposit.
ProPay Reports
If you use the ProPay Gateway, you may run reports for those transactions that share the same Sweep ID. If your account has a deposit fee then the amount reflected in the your organization’s bank deposit for that day will be the Sum of your Net Amount minus the deposit fee.
Your downloaded settlement report is a comma-separated file (CSV) that can be opened in a spreadsheet program like Excel or Google Sheets.
What Gateway do I use?
To verify your Gateway Type:
- Click Launcher icon.
- Select Settings.
- On the left side menu, click Account Information.
- Your Gateway will be provided.
If you have questions concerning Gateways, please submit a ticket to support .
Download the Report
To access Settlement Reports, click the Launcher icon and choose Transactions & Reports.
You may pull a report for each settlement day or by month.
- Click the Settlement Reports tab.
- Select a Year and Month from the dropbox list.
- You will be provided a list of Settlement Reports available during your selected time frame. Choose a report and click Download. This will download the report to your device.
Settlement Terms & Field Definitions
Your Settlement Reports download as "comma delimited text" (.csv) files, an industry-standard way to distribute data that can be opened by many data tools. The most common tool to open a .csv is Excel.
Calculate the amount of an expected batch from a day's Settlement Report (Current Pricing) :
Gross Amount - Per Transaction Fee - Discount Fee - Per Deposit fee = Deposit Amount
Your organization's bank may list more than one batch as a single deposit, typically grouping deposits made over a weekend or holiday.
Calculated Fields at the top of the report
- Transaction Count - Number of transactions in the "sweep."
- Gross Amount - Total of the gross amount received in the sweep or month.
- Per Transaction Fees - Total of the per transaction fees in the sweep or month.
- Discount Fees - Total of the percentage fees charged for each transaction. Does not include the per deposit fee.
- Net Amount - Total of the calculated Gross Amount minus Per Transaction Fees minus Discount Fees
- Sweep Count (month report only) - Number of batches, multiply by the per deposit fee to calculate total Deposit fees.
Report Fields
- Sweep ID – ProPay’s unique ID for the daily batch of transactions grouped for deposit to your organization’s bank account.
- Order Number – Your Click& Pledge unique ID for the transaction.
- C&P Transaction Date (Eastern Time) - Time stamp applied when the transaction was logged to the C&P account, then sent to ProPay for authorization.
- First Name & Last Name – Added for your reference.
- Fund Date (Mountain Time) - ProPay's timestamp for when a transaction is authorized for distribution.
- Gross Amount – Amount the Patron's card was charged.
- Per Transaction - the fee charged for each transaction, including pre-authorizations, declines, and credits (Current Pricing)
- Discount Fees - "percent per transaction" fee
- Net Amount - Gross Amount of the transaction minus the Total Fees (Per Trans and Disc Fees).
Additional fields from ProPay are available in Custom Reports under "Settlement Information":
- ProPayTransaction Date (Mountain Time) - Time stamp applied when the transaction was received by ProPay from your C&P Account
- Response Code - Codes provided by ProPay that will have a corresponding description.
- Response Code Description - A description provided by ProPay that the Response Code represents. Typically it indicates whether the transaction was successful or the reason for a transaction failed to process.
The Donor Management (PaaS) app includes pre-configured reports in the C&P PaaS Reports folder to assist with Propay Settlements :
- ProPay Deposits - Last Month - YYYYMM*
- ProPay Deposits - This Month - YYYYMM
- Daily ProPay Bank Deposit
- Daily ProPay Bank Withdrawal