Reconciliation & Data matching

As data flows are fragmented in cards & payments industry, it rapidly becomes complex to reconcile figures with diverse data sources such as settlement, clearing, bank accounts, accounting, disputes, scheme fees, service fees and interchange, currency exchange or mark-up data.

With B-CEPHAL, you can get rid of manual reconciliation without effort:

  • Load your files (CODA, CAMT, MT940/42, SPD, FPD, VSS, processor, core system, accounting files,…) automatically in the tool
  • Create dedicated multi-panels screens to compare different sets of data
  • Reconcile manually data
  • Create automatic reconciliation jobs via reconciliations keys that you define easily
  • Isolate no matched data for issue fixing or reporting

Function 1 : Sourcing

  • Load the data sets to reconcile:
    • Through industry dedicated APIs (eg clearing & settlement date)
    • Trough automatic file transfers (eg scheme invoice, QMR, QOC,…)
    • Through forms (eg billing event parameters, dispute case,…)
  • Clean the data and perform the data prep (data enrichment)
  • Create the connexion between the different data set without code

Function 2 : Reconciliation

  • Reconciliation algorithm definition:
    • Reconciliation key between the different data sets
    • Interval of tolerance for reconciliation (expressed in absolute or relative figure)
    • Conditions for reconciliation (one-to-one, one-to-many, many-to-many)
  • Automatic reconciliation pattern parameterization
  • Reconciliation log
  • Reconciliation reset

Function 3 : Reporting & analytics

  • Non matched items logs
  • Non matched amount evolution per reconciliation item types
  • Case management

Server & client environment 

  • Require following components
    • ETL Server (Java)
    • Core B-Cephal server (Java)
    • Reconciliation module (Java)
    • B-Cephal client (.net)
  • Installation available on site or in SaaS mode
  • Runs on Windows (client and server) or Linux (only server)

Technical DB

  • The default DB is PostgreSQL

Miscellaneous

  • Multi user 
    • Native authentication and log in function
    • Possibility to integrate corporate Single Sign On protocol
  • Archive and purge
    • Native archive function to schedule DB back-up
    • Native purge function to reduce DB size without impacting business operations

Merchant acquirer Case

Discover

ATM acquirer Case

Discover

BIN sponsor Case

Discover

See all modules

Reconciliation & Data matching

Discover

Scheme invoice forecast

Discover

Billing & Collection

Discover

Profitability & Performance

Discover

Schedule demo

There is nothing like a demo. Don’t hesitate to contact us and we will be glad to organize a demo shortly

Ask for consultant

Do you need expertise in cards and payment? We will be glad to help

Get the Brochure

More information about our solutions? Ask our dedicated brochures