Reports- Paysafe Reconciliation

The purpose of this guide is to assist an organization's accounting department in interpreting the data contained in the reconciliation report between Spordle ID and Paysafe. This report compares and reconciles online registrations made via Spordle ID with the financial transactions processed by Paysafe's Netbanx platform, to ensure a match between the amounts recorded and the direct debits made.

Whether your organization adopts cash accounting (based on bank deposits) or accrual accounting (based on platform registrations), this report accommodates both accounting approaches.

Since the majority of sports organizations prefer the cash accounting method, which mainly refers to deposits in the bank account, this guide offers detailed explanations on how to analyze the following reports:

  • Reconciliation report between Spordle ID and Paysafe

  • Paysafe Netbanx monthly summary report

  • Paysafe Netbanx account statement

This information is essential to ensure accurate and efficient management of your organization's finances.

How to access the PAYSAFE reconciliation report

This additional role provides access to the PAYSAFE report. When your organization has a PAYSAFE account, at least one user has this role, and can delegate it to others if necessary.

 

  • Go to the'Report' tab.

  • Choose'Paysafe Reconciliation Report'.

  • Select the merchant account for which you wish to view the report.

  • Enter the start and end dates of the report.

 

image-20241022-183418.png
  • You can then search by date or by batch.

    • By date: This report shows all transactions in their original order, with credits and debits displayed successively.

    • By batch: This report provides an overview of all transactions included in a LOT, which is directly associated with a funds transfer from Paysafe to the organization's bank account. With this report by LOT, you can justify the entries corresponding to the deposits appearing on your bank statement.

Defining columns in transaction details

  • To use this report effectively, it's essential to understand that it combines initial transaction data from the Spordle platform (registrations) with that from Paysafe's NetBanx platform (payments). The first five and last three columns of the report are from NetBanx, while columns 6 to 17 are from Spordle.

  • Columns are ordered from right to left:

    • C1: Sequence: Paysafe Sequence

    • C2: Paysafe Transmission Date: Date for which the transaction was accepted and transmitted by Paysafe

    • C3: Paysafe Transaction #: Transaction number in the Netbanx reports

    • C4: Transaction Group: Identification of the transaction category

    • C5: Description: Description of the Paysafe transaction

    • C6: Platform: The Spordle platform with which the transaction was initiated

    • C7: Spordle Invoice Date: Date for which the transaction was initiated

    • C8: Spordle Invoice #: The invoice number from the Spordle platform

    • C9: Invoice Type: Invoice type from the Spordle platform

    • C10: Member Type: Type of member for whom the transaction was initiated

    • C11: Member Name: Name of the member for whom the transaction was initiated

    • C12: Activity Name: Name of the activity as available in the item catalog in the shop on the Spordle platform

    • C13: Category: Member category (if applicable)

    • C14: Division: Member division (if applicable)

    • C15: % of Spordle Invoice Payment: The percentage of the transaction according to the initial invoice

    • C16: Paysafe Transaction Fee: The amount of the Paysafe fee related to the transaction amount

    • C17: Spordle Platform Fee: The amount of the Spordle fee related to the transaction amount

    • C18: Credit: Your organization's revenue for this transaction

    • C19: Debit: The charge to your organization for this transaction or the amount transferred by Paysafe to your organization's bank account

    • C20: Balance: Balance following the transaction of the respective line, according to its sequence.

Data source for the Paysafe reconciliation report

  • The following data visible on the Spordle report comes from the Paysafe Monthly Summary Report - NetBanx Platform and the Paysafe Account Statement - NetBanx. You'll notice that the data is identical.

    • FEES: The number of charge transactions and the total fees debited for the selected period.

    • CREDITS: The number of refunds and the total fees credited for the selected period.

    • REVENUE: The number of revenue transactions and the total revenue credited for the selected period.

    • EFT SENT: The number of Paysafe disbursements and the total sent to the organization's bank account for the selected period.

    • OPENING BALANCE: The opening balance for the selected period.

    • CLOSING BALANCE: The closing balance for the selected period.

Download and export

  • You have the option to download or export the reconciliation report in various formats (PDF, CSV, Excel) for further analysis or archiving.

  • Click on the three (3) dots located at the top right of the "Transaction Details" section, just below the "Transactions Graph".

  • Choose "Download full results" and then select the file format you wish to download.

image-20241022-192327.png

Webinars

Webinar summary

 

Objective: Introduce the new financial reconciliation report combining Spordle ID and NetBanx data to simplify accounting monitoring for organizations.

 

Key findings

 

  • Report features: The report combines Spordle ID and NetBanx data, simplifying financial reconciliation, with two views (by date and by batch) and CSV/Excel export formats.

 

  • Transaction details: Includes income, charges, credits and detailed member information.

 

  • Access and navigation: Available from your Spordle ID reporting dashboard access, under Finance > "Paysafe Reconciliation Report".

 

  • Additional features: In November, added columns for member number, clinic number, taxes (GST/QST) and GL number.

Topics covered

 

  • Overview: The report combines Spordle iD and NetBanx (Paysafe) data, and offers two viewing modes (by date and by batch) to simplify month-end reconciliation.

 

  • Transaction details: Displays date, amount, member, category, opening and closing balances, as well as totals by transaction type. Due to banking processes, transactions may take up to five days to appear.

 

  • User experience: Véronique Baril reported a significant time saving; some formatting adjustments are required for export (replacement of decimal points by commas).

Upcoming features (November)

 

  • Member number column

  • Column for clinic number for regional/provincial authorities

  • Columns for GST and QST on taxable products

  • Column for GL number to facilitate accounting

 

Need more information? Listen to the webinar again! It was recorded for you. These are in french only.

View recording of October 28, 2024 in

See the recording of November 6, 2024 ­

Back to the session

 

You now have access to the following resources:

 

See the presentation guide

­

Thank you once again for your confidence and for taking part in this webinar. We're happy to encourage simpler, more transparent financial practices.

Â