Skip to main content

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​

ColumnName in RiseactDefaultMeaning
payment idPayment idalwaysIdentifier of the payment
amountAmountyesAmount of the payment
payment datePayment dateyesCollection date
payment statePayment stateyesState (PENDING, PAID, REFUNDED, FAILED)
payment processor feeProcessor feeFee withheld by the processor on the payment, as the processor reports it
payment net amountNet amountamount minus payment processor fee, empty if the fee is not known
payment create datePayment creation dateCreation date of the payment
payment update datePayment update dateLast update date of the payment
payment import idPayment importIdentifier 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

ColumnName in RiseactDefaultMeaning
payment stripe intent idStripe intent idyesStripe payment intent (pi_...)
payment stripe charge idStripe charge idCharge of the intent (ch_... or py_...), the id Stripe reports in payouts and balance transactions
payment stripe payment method idStripe payment method idStripe payment method used (pm_...)
donation stripe subscription idStripe subscription idStripe subscription of the recurring donation (sub_...)

PayPal

ColumnName in RiseactDefaultMeaning
payment paypal order idPayPal order idPayPal order, on one-off donations
payment paypal capture idPayPal capture idyesCapture of the order: the transaction id of a one-off donation in the PayPal dashboard
payment paypal sale idPayPal sale idyesSale of a single installment of a subscription: the transaction id of an installment in the PayPal dashboard
donation paypal subscription idPayPal subscription idPayPal subscription of the recurring donation (I-...)

Satispay

ColumnName in RiseactDefaultMeaning
payment satispay payment idSatispay payment idyesSatispay payment
payment satispay external codeSatispay external codeExternal code of the Satispay payment

SumUp

ColumnName in RiseactDefaultMeaning
payment sumup transaction codeSumUp transaction codeyesSumUp transaction code
payment sumup merchant codeSumUp merchant codeSumUp merchant code
payment sumup device serial numberSumUp device serial numberSerial number of the SumUp device
payment sumup transaction timeSumUp transaction timeTime of the SumUp transaction, in UTC

SumUp data is there only for payments reconciled from a SumUp report.

Card

ColumnName in RiseactDefaultMeaning
payment card brandCard brandCard brand
payment card last4Card last 4 digitsLast 4 digits of the card
payment card exp monthCard expiry monthCard expiry month
payment card exp yearCard expiry yearCard expiry year
payment card fundingCard fundingCard funding type (credit, debit, prepaid)
payment card countryCard countryCard country
payment card fingerprintCard fingerprintCard fingerprint: the same on every payment made with the same card
payment card processor referenceCard processor referenceReference of the card at the processor

Account

ColumnName in RiseactDefaultMeaning
payment bank account last4Bank account last 4 digitsLast 4 digits of the SEPA account
payment bank account processor referenceBank account processor referenceReference 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.

ColumnName in RiseactDefaultMeaning
supporter idSupporter idyesIdentifier of the supporter
supporter external refExternal referenceyesExternal reference, the reconciliation key with an external CRM
supporter donor typeDonor typeSupporter type (INDIVIDUAL, COMPANY, ORGANIZATION, FAMILY, GROUP)
supporter first nameFirst nameyesFirst name
supporter last nameLast nameyesLast name
supporter companyCompanyyesCompany name
supporter date of birthDate of birthDate of birth
supporter place of birthPlace of birthPlace of birth
supporter titleTitleTitle
supporter jobJobJob
supporter codeSupporter codeyesInternal supporter code
supporter full nameFull nameFull name, already composed
supporter sexSexSex
supporter phonePhoneyesPhone
supporter mobileMobileMobile
supporter emailEmailyesEmail
supporter tax identification numberTax identification numberyesTax code
supporter vatVATVAT number
supporter addressAddressyesAddress
supporter address2Address line 2yesSecond address line
supporter cityCityyesCity
supporter provinceProvinceyesProvince
supporter zipZipyesZip code
supporter country codeCountry codeyesCountry code
supporter accepts email marketingAccepts email marketingyesConsent to email communications
supporter accepts sms marketingAccepts SMS marketingyesConsent to SMS communications
supporter accepts phone marketingAccepts phone marketingyesConsent to phone communications
supporter accepts postal marketingAccepts postal marketingyesConsent to postal communications
supporter accepts profilation marketingAccepts profiling marketingyesConsent to profiling
supporter tagsSupporter tagsTags of the supporter
supporter noteSupporter noteNotes on the supporter
supporter donations countDonations countNumber of donations of the supporter, drafts excluded
supporter donated totalTotal donatedSum of the amounts of paid payments
supporter active recurring countActive recurring donationsRecurring donations (monthly or yearly) in active state
supporter first donation dateFirst donation dateDate of the first paid payment
supporter last donation dateLast donation dateDate of the last paid payment
supporter payments countPayments countNumber of paid payments
supporter average donationAverage donationAverage amount per paid payment
supporter archivedArchivedWhether the supporter is archived
supporter create dateSupporter creation dateCreation date of the supporter
supporter update dateSupporter update dateLast update date of the supporter
supporter source campaignSource campaignCampaign the supporter came from
supporter channelChannelChannel (application) the supporter came from
supporter import idImportIdentifier of the import that created it
supporter merged with idMerged withIdentifier of the supporter it was merged into
supporter stripe customer idStripe customer idyesStripe 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.

ColumnName in RiseactDefaultMeaning
donation idDonation idyesIdentifier of the donation
donation external refDonation external referenceyesExternal reference of the donation
donation tagsDonation tagsyesTags of the donation
donation codeDonation codeyesCode of the donation
donation stateDonation stateyesState (draft, pending, active, past_due, done, revoked)
donation amountDonation amountyesAmount of the donation
donation frequencyFrequencyyesFrequency (ONEOFF, MONTHLY, ANNUALLY)
donation noteDonation noteyesNotes on the donation
donation completed dateDonation dateyesCompletion date
donation create dateDonation creation dateCreation date of the donation
donation update dateDonation update dateLast update date of the donation
donation past due datePast due dateDate the recurring donation became past due
donation revoked dateRevoked dateRevocation date
donation channelDonation channelChannel (application) it came from
donation import idDonation importIdentifier of the import that created it
checkout tokenCheckout tokenToken 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​

ColumnName in RiseactDefaultMeaning
campaign nameCampaignyesCampaign title
campaign idCampaign idIdentifier of the campaign
campaign codeCampaign codeyesCode of the campaign
campaign slugCampaign slugyesSlug of the campaign
campaign tagsCampaign tagsTags of the campaign
cost example nameDestinationyesChosen destination
cost example quantityDestination quantityQuantity of the destination
peer campaign slugPeer campaignSlug of the peer-to-peer fundraiser
peer campaign supporter idCollected by (supporter id)yesIdentifier of the supporter who collected the donation
peer campaign supporter nameCollected byyesName 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.

ColumnName in RiseactDefaultMeaning
payment methodPayment methodyesLabel of the payment method
payment method idPayment method idIdentifier of the payment method
payment method processorPayment processoryesProcessor (manual, stripe, paypal, satispay, sumup)
payment method stripe payment typeStripe payment typeStripe payment type of the method
payment method paypal payment typePayPal payment typePayPal payment type of the method
payment method sumup payment typeSumUp payment typeSumUp payment type of the method
payment method include in certificateIncluded in tax certificatesWhether 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).

ColumnName in RiseactDefaultMeaning
privacy_<code>consent labelyesPrivacy consents of the organization, one per definition
custom_<key>field nameyesCustom 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.