Payment Summary Report

You can use the payment summary report to view transactions based on a set of criteria you select. For example, you can view all transactions for a specific time period, view all the transactions using a specific payment method (for example, Visa or ACH), or view all transactions in a specific status (for example, failed or returned).

You can run a payment summary report ad hoc (as needed) or using a set of saved criteria.

  • When you run an ad hoc report, you are defining the criteria when you run the report.

  • When you run a saved criteria report, the criteria was defined when the report was saved.

You must have the Access to Payment Summary Report permission or the reports superuser permission to be able to generate the report.

If you need access, please contact the Flywire administrator at your institution or contact Flywire Support at [email protected].

A user is considered a reports superuser when they are given the Ability to review all reports permission. The superuser permission includes the following individual permissions:

  • Ability to access Communication Campaign Report

  • Ability to download PDFs from S3

  • Ability to view a report of staff notes

  • Access to Account Reconciliation Summary Report

  • Access to Authorized User Report

  • Access to Cash Flow Report

  • Access to Mobile/Email Updates Report

  • Access to Payment Plan Rebalance Report

  • Access to Payment Plan Summary Report

  • Access to Payment Summary Report

  • Access to Recently Defaulted Payments Plans Report

  • Access to Soon To Default Payment Plans Report

  • Access to User Access Report

  • Access to Users Viewing Offers, Not Completing Report

  • Access to the Bad Email Addresses Report

  • Access to the eRefund Enrollment Report

  • Access to the eRefund Status Report

  • Access to the Financial Responsibility Agreement Report

  • Access to the Payment Plan Installment Report

Finding the report

  1. Select the Actions menu and click Reports.

  2. On the Report List page:

    • Click the Run Ad Hoc link to run a new report.

    • Click a report name under Payment Summary Saved Criteria to run a saved criteria report.

    • Click Create a Saved Criteria link to create a new saved criteria report.

Running a report

  1. Complete the fields to set your report criteria.

  2. Click Submit.

  3. On the Payment Summary Results page, you can click any heading in the first column to view individual transactions in that category.

  4. On the Transaction Search Results page, you can:

    • Click the blue plus to expand the transaction result to see additional details.

    • Click a transaction ID to view transaction details for an individual transaction.

    • Click the payer's name to view their account summary.

On the page

The fields are the same between the Add Payment Summary Report Saved Criteria page and the ad hoc Payment Summary Report page, but they are presented in a different order.

Time Frame to group by Select the time frame you want to use to group the results. You can group the results by Day, Week, or Month.
Institutions

Select which institutions you want to use to populate the report.
View Date Types

Select which date type you want to use to populate the report.

  • Transaction Date

  • Effective Date

  • Funding Date

The date the payer completed the transaction, also known as the calendar date. Reports using transaction date will show all transactions for the selected dates, regardless of whether the transaction was received or processed after your institution’s pre-determined cut-off time. Transaction date reports may differ from your bank account statements for the same time period.

The effective date is the date your payments are processed by your bank or card processor based on your institution's cut-off time. Transactions posted after the cut-off time will be considered effective the next day. Transactions posted after the cut-off time on Friday are considered effective Monday. Effective date is intended to support reconciliations.

The effective date is available for:

  • ACH payments

  • credit card payments when your institution is in the US and you are the merchant of record.

When the effective date is not available, use the Funding Date instead.

The funding date is the date the payment is delivered to your institution. It is calculated based on the date the transaction is posted to your bank plus the number of days it takes for you to receive the funding. Funding date is intended to support reconciliations.

The funding date is available for:

  • credit card payments when your institution is in the US and you are the merchant of record

  • international payments

  • institutions in the UK and Canada

When the funding date is not available, use the Effective Date instead.
Payment Method Select which payment methods you want to include in the report.
Transaction Type

Select which transaction types you want to include in the report.

Transaction types are a way to categorize the different types of transactions within the SFS. Different transaction types correspond to particular functionality within the SFS.

Many transaction types will have an associated transaction type for a return or refund of that transaction.

A payment is returned when the bank cannot process a transaction.

A refund means you are returning funds back to a payer through Flywire.

The available list will be based on your system setup. You may not have all options available.

Regular

Standard payment transactions.
Refund The transaction is a refund of a transaction.
Return

The transaction is a return from the associated banking institution.

E-Refund The transaction is a payment from the eRefunds feature.
Charge The transaction is a charge to the payer. For example, if a payment is returned by the bank
Charge Return The transaction is a return of a charge.
Down Payment

The transaction is a down payment for a payment plan.

A down payment is a portion of the balance that is required to be paid at the time of sign-up. The down payment amount is paid to the institution.
Down Payment Refund

The transaction is a refund of a down payment.
Down Payment Return

The transaction is a return of a down payment.
Sign-up Fee

The transaction is a sign-up fee for a payment plan.

A sign-up fee is a one time fee paid by the payer when they sign-up for a payment plan. Sign-up fee amounts are paid to Flywire.
Return Sign-up Fee The transaction is a return of a sign-up fee payment.
Refund Sign-up Fee The transaction is a refund of a sign-up fee payment.
Service Charge The transaction is a service fee for a credit card.
Refund Service Charge The transaction is a refund of a service charge.
Pay In Full Fee The transaction is a fee for paying a payment plan balance in full.
Return Pay In Full Fee The transaction is a return of a pay in full fee.
Refund Pay In Full Fee The transaction is a refund of a pay in full fee.
NSF Fee

The transaction is an NSF (nonsufficient funds) fee.

An NSF fee is charge when the bank does not have sufficient funds to cover a transaction.
Return NSF Fee The transaction is a return of an NSF fee.
Refund NSF Fee The transaction is a refund of an NSF fee.

 
Transaction Application Select whether to include transactions applied to payment plan installments.
Transaction Status

Select the statuses for the transaction to include in the report.

The state of a transaction within the SFS. It does not reflect the status of any transaction outside the Flywire system.

Success

The transaction completed successfully.
Failure The transaction failed.
Error

The transaction was not processed due to an error.
Unknown The transaction was requested but no response has been received.
Void The transaction was cancelled (voided) before the effective date.
Charge Back

The transaction was refunded due to a dispute from the payer.

This transaction status is only available for credit card transactions.
Voided Charge Back

The charge back transaction was voided before the effective date.

This transaction status is only available for credit card transactions.

Payment Summary Report page only

From Date

Select the dates you want to use to populate the report.

  • Select the start date in the From Date field.

  • Select the end date in the To Date field.
To Date

Add Payment Summary Report Saved Criteria page only

Saved Criteria Name Add a name for the report. This name will display for you to access and reuse this report.
Relative Date

Select the date criteria to use in the report. When the report is run, the date will be populated based on this option. The relative date options are:

  • Yesterday - All transactions from any time yesterday. Does not include today's transactions.

  • Last 7 Days - The start date is 6 days ago and the end date is today. Does include today's transactions.

  • Last Week - Transactions from the last calendar week, defined as start date Monday and end date Sunday. Does not include today's transactions.

  • Last Month - Transactions from the last full month (for example, today is July 7th, the last month would be June 1 - June 30). Does not include today's transactions.

All criteria settings work the same way as they do when the report is run ad hoc, except for the date criteria. Instead of choosing an absolute date, you must choose a relative date setting.
Send an email summary

Select if you want the report to be an automated email summary. The frequency of the summary email is based on the selection in the Relative Date field:

  • If Yesterday is selected, the email is sent daily.

  • If Last Week is selected, the email is sent weekly on Monday.

For security reasons, emails can only be sent to the domain matching your log in.