Payments export
One row per payment, so one for each installment of recurring donations, with donation, supporter, campaign, payment method and processor identifiers. It is the export for reconciliation with the processors.
The first column is always payment id. Deleted payments never appear.
It requires the Payments Export permission, separate from the donations one.
The tables list every available column. Default marks the ones already selected when you open the export dialog (or ask for the fields through the API); the others are added by hand. The default selection differs from the supporters and donations exports.
Payment columns
| Column | Name in Riseact | Default | Meaning |
|---|---|---|---|
payment id | Payment id | always | Identifier of the payment |
amount | Amount | yes | Amount of the payment |
payment date | Payment date | yes | Collection date |
payment state | Payment state | yes | State (PENDING, PAID, REFUNDED, FAILED) |
payment processor fee | Processor fee | Fee withheld by the processor on the payment, as the processor reports it | |
payment net amount | Net amount | amount minus payment processor fee, empty if the fee is not known | |
payment create date | Payment creation date | Creation date of the payment | |
payment update date | Payment update date | Last update date of the payment | |
payment import id | Payment import | Identifier of the import that created it |
amount and payment date have the donations importer names, which it uses to
create the payment.
Processor fee and net amount
payment processor fee is filled in only for Stripe and PayPal payments recorded
from 2026-10-31 onwards. Earlier payments do not have it and it is not
rebuilt, and Satispay, SumUp and manual payments never have it: in these cases
payment net amount is empty too, not equal to amount.
- Stripe: the fee of the charge's balance transaction, read when the payment is recorded. If Stripe has not created the balance transaction yet at that moment, the fee stays empty.
- PayPal: the fee of the capture for one-off donations, the fee of the sale for each installment of a subscription.
The fee is in the organization's currency: if the processor settles it in another currency it stays empty. On a refunded payment it stays the fee of the collection, and the net amount does not account for the refund.
The Riseact fee is not included: it is invoiced separately every quarter, not withheld from the payment. The net amount is therefore what the processor credits to the organization.
Processor identifiers
One column per identifier, grouped by processor. The payment ... identifiers
belong to each installment. Subscriptions (donation stripe subscription id,
donation paypal subscription id) belong to the donation and are the same on every
installment.
Stripe
| Column | Name in Riseact | Default | Meaning |
|---|---|---|---|
payment stripe intent id | Stripe intent id | yes | Stripe payment intent (pi_...) |
payment stripe charge id | Stripe charge id | Charge of the intent (ch_... or py_...), the id Stripe reports in payouts and balance transactions | |
payment stripe payment method id | Stripe payment method id | Stripe payment method used (pm_...) | |
donation stripe subscription id | Stripe subscription id | Stripe subscription of the recurring donation (sub_...) |
PayPal
| Column | Name in Riseact | Default | Meaning |
|---|---|---|---|
payment paypal order id | PayPal order id | PayPal order, on one-off donations | |
payment paypal capture id | PayPal capture id | yes | Capture of the order: the transaction id of a one-off donation in the PayPal dashboard |
payment paypal sale id | PayPal sale id | yes | Sale of a single installment of a subscription: the transaction id of an installment in the PayPal dashboard |
donation paypal subscription id | PayPal subscription id | PayPal subscription of the recurring donation (I-...) |
Satispay
| Column | Name in Riseact | Default | Meaning |
|---|---|---|---|
payment satispay payment id | Satispay payment id | yes | Satispay payment |
payment satispay external code | Satispay external code | External code of the Satispay payment |
SumUp
| Column | Name in Riseact | Default | Meaning |
|---|---|---|---|
payment sumup transaction code | SumUp transaction code | yes | SumUp transaction code |
payment sumup merchant code | SumUp merchant code | SumUp merchant code | |
payment sumup device serial number | SumUp device serial number | Serial number of the SumUp device | |
payment sumup transaction time | SumUp transaction time | Time of the SumUp transaction, in UTC |
SumUp data is there only for payments reconciled from a SumUp report.
Card
| Column | Name in Riseact | Default | Meaning |
|---|---|---|---|
payment card brand | Card brand | Card brand | |
payment card last4 | Card last 4 digits | Last 4 digits of the card | |
payment card exp month | Card expiry month | Card expiry month | |
payment card exp year | Card expiry year | Card expiry year | |
payment card funding | Card funding | Card funding type (credit, debit, prepaid) | |
payment card country | Card country | Card country | |
payment card fingerprint | Card fingerprint | Card fingerprint: the same on every payment made with the same card | |
payment card processor reference | Card processor reference | Reference of the card at the processor |
Account
| Column | Name in Riseact | Default | Meaning |
|---|---|---|---|
payment bank account last4 | Bank account last 4 digits | Last 4 digits of the SEPA account | |
payment bank account processor reference | Bank account processor reference | Reference of the SEPA account at the processor |
Stripe charges and PayPal sales are recorded only since they were introduced: on earlier installments they are empty, and for PayPal only the subscription id is left.
Supporter columns
Every supporter column has the supporter prefix. In the export dialog the label
is the one of the supporters export: supporter first name is First name.
| Column | Name in Riseact | Default | Meaning |
|---|---|---|---|
supporter id | Supporter id | yes | Identifier of the supporter |
supporter external ref | External reference | yes | External reference, the reconciliation key with an external CRM |
supporter donor type | Donor type | Supporter type (INDIVIDUAL, COMPANY, ORGANIZATION, FAMILY, GROUP) | |
supporter first name | First name | yes | First name |
supporter last name | Last name | yes | Last name |
supporter company | Company | yes | Company name |
supporter date of birth | Date of birth | Date of birth | |
supporter place of birth | Place of birth | Place of birth | |
supporter title | Title | Title | |
supporter job | Job | Job | |
supporter code | Supporter code | yes | Internal supporter code |
supporter full name | Full name | Full name, already composed | |
supporter sex | Sex | Sex | |
supporter phone | Phone | yes | Phone |
supporter mobile | Mobile | Mobile | |
supporter email | yes | ||
supporter tax identification number | Tax identification number | yes | Tax code |
supporter vat | VAT | VAT number | |
supporter address | Address | yes | Address |
supporter address2 | Address line 2 | yes | Second address line |
supporter city | City | yes | City |
supporter province | Province | yes | Province |
supporter zip | Zip | yes | Zip code |
supporter country code | Country code | yes | Country code |
supporter accepts email marketing | Accepts email marketing | yes | Consent to email communications |
supporter accepts sms marketing | Accepts SMS marketing | yes | Consent to SMS communications |
supporter accepts phone marketing | Accepts phone marketing | yes | Consent to phone communications |
supporter accepts postal marketing | Accepts postal marketing | yes | Consent to postal communications |
supporter accepts profilation marketing | Accepts profiling marketing | yes | Consent to profiling |
supporter tags | Supporter tags | Tags of the supporter | |
supporter note | Supporter note | Notes on the supporter | |
supporter donations count | Donations count | Number of donations of the supporter, drafts excluded | |
supporter donated total | Total donated | Sum of the amounts of paid payments | |
supporter active recurring count | Active recurring donations | Recurring donations (monthly or yearly) in active state | |
supporter first donation date | First donation date | Date of the first paid payment | |
supporter last donation date | Last donation date | Date of the last paid payment | |
supporter payments count | Payments count | Number of paid payments | |
supporter average donation | Average donation | Average amount per paid payment | |
supporter archived | Archived | Whether the supporter is archived | |
supporter create date | Supporter creation date | Creation date of the supporter | |
supporter update date | Supporter update date | Last update date of the supporter | |
supporter source campaign | Source campaign | Campaign the supporter came from | |
supporter channel | Channel | Channel (application) the supporter came from | |
supporter import id | Import | Identifier of the import that created it | |
supporter merged with id | Merged with | Identifier of the supporter it was merged into | |
supporter stripe customer id | Stripe customer id | yes | Stripe customer of the supporter (cus_...) |
The statistics belong to the supporter, not to the payment: they are computed over all their paid payments, with payment dates rather than creation dates, and are empty for supporters with no donations. They repeat unchanged on every row of the same supporter.
Donation columns
They belong to the donation the payment is part of, so they are the same on every
installment. That includes checkout token: the checkout opens the donation, so
every installment of a recurring donation reports the same token.
| Column | Name in Riseact | Default | Meaning |
|---|---|---|---|
donation id | Donation id | yes | Identifier of the donation |
donation external ref | Donation external reference | yes | External reference of the donation |
donation tags | Donation tags | yes | Tags of the donation |
donation code | Donation code | yes | Code of the donation |
donation state | Donation state | yes | State (draft, pending, active, past_due, done, revoked) |
donation amount | Donation amount | yes | Amount of the donation |
donation frequency | Frequency | yes | Frequency (ONEOFF, MONTHLY, ANNUALLY) |
donation note | Donation note | yes | Notes on the donation |
donation completed date | Donation date | yes | Completion date |
donation create date | Donation creation date | Creation date of the donation | |
donation update date | Donation update date | Last update date of the donation | |
donation past due date | Past due date | Date the recurring donation became past due | |
donation revoked date | Revoked date | Revocation date | |
donation channel | Donation channel | Channel (application) it came from | |
donation import id | Donation import | Identifier of the import that created it | |
checkout token | Checkout token | Token of the checkout the donation was made with, the ?co= parameter of its URL. Empty for donations that did not go through the checkout, such as imported or manually entered ones |
Campaign
| Column | Name in Riseact | Default | Meaning |
|---|---|---|---|
campaign name | Campaign | yes | Campaign title |
campaign id | Campaign id | Identifier of the campaign | |
campaign code | Campaign code | yes | Code of the campaign |
campaign slug | Campaign slug | yes | Slug of the campaign |
campaign tags | Campaign tags | Tags of the campaign | |
cost example name | Destination | yes | Chosen destination |
cost example quantity | Destination quantity | Quantity of the destination | |
peer campaign slug | Peer campaign | Slug of the peer-to-peer fundraiser | |
peer campaign supporter id | Collected by (supporter id) | yes | Identifier of the supporter who collected the donation |
peer campaign supporter name | Collected by | yes | Name of the supporter who collected the donation |
Payment method
The payment method is the one of the payment, not of the donation: a recurring donation can change method and each installment keeps the one it was collected with.
| Column | Name in Riseact | Default | Meaning |
|---|---|---|---|
payment method | Payment method | yes | Label of the payment method |
payment method id | Payment method id | Identifier of the payment method | |
payment method processor | Payment processor | yes | Processor (manual, stripe, paypal, satispay, sumup) |
payment method stripe payment type | Stripe payment type | Stripe payment type of the method | |
payment method paypal payment type | PayPal payment type | PayPal payment type of the method | |
payment method sumup payment type | SumUp payment type | SumUp payment type of the method | |
payment method include in certificate | Included in tax certificates | Whether the payments are included in tax certificates |
Privacy and custom fields
One column for each privacy consent and each custom field defined in the
organization, all selected by default. They do not have the supporter
prefix: consents belong to the supporter, custom fields belong to both the
supporter and the donation, with the same custom_<key> convention (the key is
unique in the organization, so they never overlap).
| Column | Name in Riseact | Default | Meaning |
|---|---|---|---|
privacy_<code> | consent label | yes | Privacy consents of the organization, one per definition |
custom_<key> | field name | yes | Custom fields of the supporter and of the donation, one per field |
Filters and segments
The filters of the payments list apply: search, date, state and payment method. A saved segment, for example "PayPal payments", can be exported every month by updating the date filter.
Re-importing
The file cannot be re-imported: the donations importer creates one donation per row, so each installment would become a donation.