Canonical model

One model for every payment provider.

A canonical payment model is one shared language for every provider’s messages and statements: the same status, amount, time and identifier, whatever the provider called them. Reconora translates every callback, response and statement line into it, so a payment from any provider can be reconciled the same way.

Why one model

Think of a group with dozens of subsidiaries, each keeping books in its own chart of accounts. Consolidation is impossible until everything is mapped to one chart. Payment providers are those subsidiaries: each speaks its own dialect. The canonical model is the group chart of accounts for payments.

Three layers

  1. Event — one fact: “this source, at this moment, reported this”.
  2. Transaction — all events about one payment, folded into one line with one outcome.
  3. Reconciliation — the transaction matched with the provider’s statement line, ending in a named outcome.

One fragment: four providers, one “success”

Provider (code)Where the status sitsRaw valueCanonical
Provider 1transaction.statusSUCCESSSUCCEEDED
Provider 2stateconfirmedSUCCEEDED
Provider 3statuspaidSUCCEEDED
Provider 4payment.statussuccessSUCCEEDED

Across one day, 318 raw values like these reduce to 9 meanings.

Promises the model keeps

  • Nothing is lost. Every input record is either translated, skipped by a named rule, or quarantined with a reason — and the balance is checked on every run.
  • Nothing is guessed. An unknown status, error code, currency or unit stays “unknown” until a person confirms it.
  • Money is exact. Amounts are integers in minor units with their currency and precision; no floating-point rounding.
  • Discrepancies are never smoothed. They are flagged, and a person decides.

The full model — its fields, dictionaries and provider rules — is Reconora’s own and is not published.

Try it on one day of your data

One day of your data, reconciled, and the report stays with you whether or not you continue.

By Reconora Research · Updated