How do I reconcile funds received with my settlements?

Overview

If you are taking online payments through Passport, you will need to reconcile the funds you receive in your bank account with the settlement payouts that are recorded in your Passport database. This can be done by checking the unique Statement Descriptor that appears on your individual settlements and tax invoices in Passport.



Finding your Statement Descriptor

Your Statement Descriptor will be the unique identifier that you can use to separate your settlement payouts.

Step 1: Open your GameDay settlements

In the left-hand menu, click Finances > MANAGE FINANCES

Then click SETTLEMENT PAYOUTS


Step 2: Find the settlement you want to reconcile

Your settlement list will include each weekly payout you received in your account, including the following information:

  • Paid To: This will indicate the bank account details to which the funds were distributed
  • Start/End Date: The Start Date and End Date fields indicate the date range within which the orders making up this settlement were processed
  • Settlement Date: This is the date on which the funds were settled by Stripe

Note: Depending on bank transfer times, the date you actually received the funds in your account may be up to 3 days after the Settlement Date

  • Amount: This will reflect the amount you received in your bank account


Step 3: View the individual settlement

Next to the settlement you want to reconcile, click the VIEW (magnifying glass) icon


Step 4: Note the Statement Description

In the Details section, you will see a Statement Description. This is the unique identifier that can be matched exactly with the descriptor on your bank statement.


You can also obtain the Statement Description along with any other settlement details by opening the TAX INVOICE in the top-right corner

The Statement Description will appear at the top of the invoice.



Reconciling Settlements through Funds Received Report

To generate a report from Passport that reconciles each of the distributions that have been sent to your bank account, follow the steps below:

Step 1: Configure a Funds Received report

In the left-hand menu, click REPORTS


Click the FINANCE category

Find the Funds Received report and click CONFIGURE


Step 2: Add your fields to the report

Use the + button next to any fields you want to add to the report. For reconciling settlements, we recommend the following field set (plus any others you may want to include):

  • Transaction ID
  • Product Name
  • Payment For
  • Line Item Total
  • Money Received (after fees)
  • Receiving Account Name
  • Payment Date
  • Statement Description
  • Date Funds sent by Stripe


Step 3: Add a grouping option

To clearly separate each individual settlement payout on the report, add the Date Funds sent by Stripe field in the Group By drop-down


Step 4: Set an output option and run the report

In the REPORT OUTPUT section, you can either run the report to display in your browser in a new tab, or you can configure the report to be sent to your admin email as a Tab Delimited (Text) or CSV (Excel) file every time it is run.

When you're ready, click RUN REPORT

You should notice that each group in the report corresponds to the amount you received in your bank account on the date specified.