Overview
The Funds Received report allows administrators to build a customised report to track and reconcile their settlement payouts.
Note: Unlike the Settlement Payouts list (in the Finances > Manage Finances section) which only track settlement payouts distributed via Stripe, the Funds Received report will track all settlements paid out from Stripe payments plus other online gateways such as Braintree or PoliPay
Step-by-Step
Step 1: Open the Funds Received report
In your GameDay Passport database, go to Reports > Finance > find the Funds Received report, then click CONFIGURE
Step 2: Decide which fields you want on your report
You can add fields to the report by clicking the + button on the left-hand side to add each field into the Selected Fields section. You can choose from any of the fields below:
- Transaction ID
- Product Name
- Payment For (who paid for the products - either member or team name)
- Payment For ID
- Payment From
- Line Item Total
- Money Received (after fees)
- Receiving Bank Code (BSB)
- Receiving Account Number
- Receiving Account Name
- Payment Gateway Reference
- Payment Log ID
- Payment Date
- Distribution ID
- Date Funds Sent by GameDay
- Association
- Club Payment For
- Transaction Club
- Cost Centre
- Product Type
- Product Items
- Product Item Selections
- Payment Type
- Voucher Code
- Rebated Amount
- Promotion Code
- Line Item Promo Discount Amount Applied
- Order Promo Discount Amount Applied
- Stripe Payout ID
- Date Funds sent by Stripe
Step 3 (optional): Format the report for reconciliation
To format the report in a way that allows you to easily reconcile the lump sum distributions made to your bank account, apply the following settings:
- Sort By = Payment Date
- Group By = Distribution ID
The Distribution ID is unique identifier that displays on your organisations bank statement
Step 4: Run the report
Once you're satisfied with your report, click RUN REPORT, and it will open in a new tab
Step 5 (optional): Export and/or save the report
You can export your report by setting the Report Output to 'Email', then choosing CSV as the file format and entering your email address in the space provided - Learn More
If you want to save the report to use on an ongoing basis without having to rebuild the whole thing again, you can use the save option at the bottom of the report builder - Learn More