Reconciliation for direct debit payments

Direct debit payments, both one-off and recurring, may have one of the following statuses when using the Stripe gateway:

• Awaiting reconciliation - Payment has not yet reconciled.
• Completed - Payment has successfully reconciled.
• Failed - Payment has not been reconciled, and staff intervention is required.

Reviewing recurring membership payment transactions

Do the following to review recurring membership payment transactions:

1. Go to Membership > Automatic payments > Review payments.
2. Select a query from the drop-down:
   • Payment history for automatic renewals – This query returns all current payment information, including ongoing, failed, and payments less than 90 days old.
   • Payment history for automatic renewals (archived) - This query returns successful payments that are older than 90 days.
3. Search for automatic renewal payments using your desired parameters.
4. Review records for the invoice (using the Invoice column) and other payment details, such as Result, Gateway Transaction ID, and Member information.

Reviewing recurring donation payment transactions

Do the following to review recurring donation payment transactions:

1. Go to Fundraising > Automatic payments > Review payments.
2. Select a query from the drop-down:
   • Payment history for recurring donations – This query returns all current payment information, including ongoing, failed, and payments less than 90 days old.
   • Payment history for recurring donations (archived) - This query returns successful payments that are older than 90 days.
3. Search for automatic payments using your desired parameters.
4. Review records for the invoice (using the Invoice column) and other payment details, such as Result, Gateway Transaction ID, and Donor information.

Reviewing one-off direct debit payment transactions

Do the following to review one-off direct debit payments:

1. Go to Finance > Pay Central > Find payments.
2. Select a query from the drop-down. See Searching for payments for the available queries.
3. Review the payment details, including the payment status.

Submitted payments can also be reviewed in Pay Central Live. See Using Pay Central Live to review payments. Also see Reconciling unsuccessful ACH/Direct debit transactions for more information regarding reconciliation.