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.
Â
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.