LogoLogo
  • Getting Started
  • Sources
    • Overview
    • Data Ingestion
  • Transaction Matching
    • Overview
    • Matching Rules
  • Reconciliation
    • Overview
    • Payment Flows
  • INTEGRATION GUIDES
    • Payment Service Providers
      • How-to Guide: Generating Amazon Pay’s Payments Report
      • How-to Guide: Generating Braintree’s Transaction Report
      • How-to Guide: Generating Braintree API Credentials
      • How-to Guide: Generating Checkout's Settlement Reports
      • How-to Guide: Generating Checkout.com API Token
      • How-to Guide: Generating Klarna’s Settlements Report
      • How-to Guide: Generating Klarna’s SFTP Credentials
      • How-to Guide: Generating Method's API Key
      • How-to Guide: Generating PayPal’s Activity Report
      • How-to Guide: Generating PayPal API Credentials
      • How-to Guide: Generating Recurly’s Transactions Report
      • How-to Guide: Generating Stripe’s Payout Reconciliation Report
      • How-to Guide: Exporting Stripe Invoices
      • Generating & using Stripe API key
      • How-to Guide: Generating Worldpay's Settlement Report
      • How-to Guide: Generating Vitesse API Token
      • How-to Guide: Generating Adyen's API Token
      • How-to Guide: Generating Ramp API Credentials
    • Banks
      • How-to Guide: Generating Mercury’s API Token
      • How-to Guide: Generating Wells Fargo’s Account Activity Report
      • How-to Guide: Connect Bank of America CashPro to Ledge
    • ERPs & Platforms
      • How-to Guide: Set Up the Ledge Integration on NetSuite
      • How-to Guide: Connect NetSuite to Ledge (without installing a bundle)
      • How-to Guide: Connect Sage Intacct to Ledge
      • How-to Guide: Generating Shopify API token
    • Databases & Data Warehouses
      • How-to Guide: Locating The Required Details to Connect Snowflake
      • How-to Guide: Locating The Required Details to Connect Postgres
      • How-to Guide: Locating The Required Details to Connect Microsoft SQL Server
  • API Reference
    • Getting Started
    • Fundamentals
      • Authentication
      • Fine-Grained Permissions
      • Pagination
      • Status Codes
      • Error Handling
    • Sources
    • Transactions
      • Querying
  • Changelog
    • 2024
      • Fall Product Releases
      • Spring Product Releases
Powered by GitBook
On this page
  1. Reconciliation

Overview

Reconciliation is the process of verifying that all expected transactions have been accounted for through one or more Payment Flows. While the Payment Flow score is a key metric, it is not always sufficient to determine if a transaction is fully reconciled. In some scenarios, multiple Payment Flows may need to be considered to achieve a comprehensive reconciliation.

A transaction is considered reconciled when one or more Payment Flows associated with it result in a satisfactory explanation of the total expected amount. By default, if a transaction achieves a score of 1 in at least one Payment Flow, it is considered reconciled.

A transaction is considered partially reconciled if the underlying Payment Flows were satisfied with a score that is lower than 1. This means that only a part of the amount is explained.

By default, if a transaction receives a score that is greater than zero in at least one Payment Flow, it is automatically marked as reconciled.

Types of Reconciliation Scenarios

Single-Flow Reconciliation

In simple cases, reconciliation can be achieved through a single Payment Flow. If the transaction receives a Payment Flow score of 1, it is automatically considered reconciled.

Example:

A payment is initiated and settled successfully, with no fees or other flows involved. This one-to-one relationship allows for reconciliation via a single Payment Flow.

Multi-Flow Reconciliation

More complex cases may require multiple Payment Flows to be satisfied for the transaction to be considered reconciled.

Examples

  • Scenario 1: ACH Payment with Multiple Possible Flows - An ACH transfer can either be settled or returned. Since only one of these flows is possible, the reconciliation must consider both flows. If the settlement occurs, the settlement flow score would be 1, and the reconciliation is achieved. If the transfer is returned, the return flow would be satisfied, and reconciliation would still be achieved. As long as one of these flows receives a score of 1, the transaction is considered reconciled.

  • Scenario 2: Payment with Fees and Taxes - In cases where a payment involves fees or taxes, reconciliation requires multiple flows to explain the total amount: (1) Payment settlement, (2) Fee deduction, and (3) Tax collection. If the sum of these flows fully explains the expected amount, the reconciliation is achieved. This requires multiple Payment Flows working together to provide a complete explanation of the transaction.

PreviousMatching RulesNextPayment Flows

Last updated 4 months ago