Payment Settlement Summary Report

Modified on Thu, 6 Feb at 10:12 AM

Overview

Managing settlement data across multiple products, platforms, and operators can be complex and time-consuming. The Payment Settlement Summary Report simplifies this process by providing a centralized, comprehensive view of key financial details, all in one place. With this report, you can:

  • View remittance schedules, transaction origination points, batch identifiers, and settlement dates across multiple products
  • Easily align settlement data with third-party financial systems
  • Select multiple operators and products for a consolidated view, reducing manual effort
  • Schedule reports for delivery via email and export data as needed
  • Access structured insights that empower more confident and efficient settlement management

This guide walks you through key features of the Payment Settlement Summary Report, including how to navigate, apply filters, options, schedule report delivery, export data, FAQ, and important terminology.

Key Features & Functionality

Navigating the Report

The Payment Settlement Summary Report is designed for quick access to settlement details. Learn how to:

  • Locate key settlement data
  • Manage a consolidated view across all products
  • Use reconciliation tools to track where and when transactions were settled and funded

Filtering Your Report

Use filters to refine settlement data based on date, remittance schedule, product type, and more.

Scheduling Report Delivery

Set up automated report deliveries to receive settlement summaries directly your inbox.

Downloading Reports

Export settlement dats in multiple formats for deeper analysis and financial reconciliation.


Frequently Asked Questions (FAQ): Use Cases for Leveraging the Payment Settlement Summary Report

How do I reconcile the ACH amount deposited into my account?

  1. Set the Settlement Date and Product Type to match the funding tied to the ACH deposit.
  2. Use the Passport Managed Product filter to refine results (YES - includes transactions originating from a Passport Point Solution ; NO - includes transactions from a third-party solution (Pay stations, POS devices, non-Passport Text-to-Pay)
  3. Validate that all filters are set correctly.
  4. Click Run Report and review the results
  5. Note: For transaction-level reconciliation, use the Settlement Detail Report instead.

How can I view data separately for my Card Present Products?

  1. Set the Settlement Date filter to the desired range.
  2. Set the Passport Managed Product filter to NO (for transactions originating from third-party solutions such as Pay stations, POS devices, or non-Passport Text-to-Pay).
  3. Ensure all filters are correctly applied.
  4. Click Run Report and review the results.

How can I see all my products in a single Settlement Summary report?

  1. Set the Settlement Date filter to the desired range.
  2. Select all valid Product Types by checking the corresponding boxes.
  3. Ensure all other filters are set to “Is Any Value” to avoid incomplete data. (Failure to do so may result in inaccurate results.)
  4. Click Run Report and review the results.

Why don't my Settlement Summary totals match my ACH report? 

  1. Ensure the Settlement Date matches the ACH deposit date. If incorrect, update it and click Run Report or Refresh.
  2. If the date is correct, check other filters—default settings should be “Is Any Value”.
  3. Verify that multiple Product Types or incorrect Operators have not been selected.
  4. Click Run Report or Refresh again to update results.

My totals still don't match. What should I do?

  1. Open the Payments Settlement Detail Report.
  2. Set the Settlement Date to the correct range.
  3. Select all valid Product Types by checking the appropriate boxes.
  4. Ensure all other filters are set to “Is Any Value” (failure to do so may cause discrepancies).
  5. Click Run Report or Refresh to update results.
  6. If discrepancies persist, contact support (billing@passportinc.com for invoicing and fees only ; submit a ticket through the support portal for all other questions)

Report Vocabulary

  • Product Type: The Product associated to the transaction
    • Parking
    • Enforcement
    • Permits
  • Operator: Name assigned to a contracted Passport customer that identifies which city or partnership they own
  • Account Name: A custom name created by the payment system that helps quickly identify which product and operator the transaction is linked to.
  • Batch ID: A unique identifier assigned to a group of payment transactions processed together for tracking, reconciliation, and reporting purposes
  • Remittance Schedule: Outlines the timing and frequency at which funds are transferred to a merchant's account from processed transactions
    • Daily
    • Monthly
  • Settlement Date: Specific date on which a group of transactions is processed and settled
  • Status: Refers to the current state of batch within the settlement processing workflow, indicating the progress and actions required and is determined by the remittance schedule and automation settings in place 
    • Closed
    • Review
    • Funding
    • Accruing: For a monthly settlement customer, their batch file remains in an "accruing" status throughout the month as the file stays open, accumulating the ongoing transactions until the designated funding date, at which point the batch is Closed and funding is processed
  • Transaction Count: Total number of individual Sale or Captured transactions processed within a specific batch or time period
  • Gateway Count: Total number of individual authorizations and extensions processed within a specific batch or time period
  • Transaction Revenue: Gross revenue from a transaction, excluding any additional service or convenience fees charged to the user
  • Convenience Revenue: Income from fees charged to customers for using alternative payment methods or channels that provide added convenience, such as online or mobile transactions
  • Gross Processing Revenue: Total revenue from all payment transactions processed before any deductions, including transaction fees, service charges, and convenience fees
  • Net Fees: Total amount of all fees deducted from Gross Processing Revenue according to a Daily Net Fee schedule including transaction fees, service charges, merchant processing fees, gateway fees, and convenience fees
  • Net Settlement Amount: Final amount transferred to a merchant after deducting applicable fees, chargebacks, and adjustments from the gross transaction value
  • Refund Count: Total number of individual refunds processed within a specific batch or time period
  • Refund Amount: Total value of refunds issued to customers for previously processed transactions, deducted from the merchant’s Gross Processing Revenue
  • Chargeback Count: Total number of chargebacks or disputes processed within a specific batch or time period
  • Chargeback Amount: Total value of transactions reversed by the payment processor due to disputes or fraud claims (this amount is returned to the customer, and the merchant is responsible for covering it, often along with additional fees)
  • Adjustment: Any modifications to a batch, such as credits or refunds, applied during settlement to be paid to the merchant
    • Balance Adjustment: Made by payment operations
    • Transfer Adjustment: Made due to wallet and/or validations
    • Fee Adjustment: Made due to free parking
  • Adjustment Count: Total number of adjustments made within a specific batch or time period, including wallet transactions, validations, or free parking
  • Adjustment Amount: Total value of changes applied to a batch due to adjustments
  • Invoice Fees: Sum total of all fees deducted from Gross Processing Revenue of all payment transactions processed by the payment platform that are tied to a Gross Remittance, including transaction fees, service charges, merchant processing fees, gateway fees, and convenience fees
  • Account Key: A unique identifier assigned to an operator when an account configuration is created


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article