Why PSP and MSB Reconciliation Breaks at Scale

Reconciliation is manageable for payment service providers (PSPs) and money services businesses (MSBs) in the early stages of growth. Transaction volumes are low, entity counts are small, and a spreadsheet can hold the process together. That changes as settlement rails, currencies, legal entities, and jurisdictions are added. At some point, the spreadsheet stops being a solution and becomes the point of failure.

This is not primarily a technology problem. It is an architecture problem. Below is why reconciliation breaks down at scale, and what finance teams that close cleanly do differently.

Why It Breaks

Most PSPs and MSBs start with a core platform that processes transactions, a bank account that settles them, and a general ledger that records the results. At low volumes, those three systems stay in sync manually. Scale introduces three variables manual processes cannot absorb:

  • Volume. A single analyst can typically clear roughly 200 reconciliation exceptions a day. A business generating 500 daily exceptions is already short-staffed before any backlog builds, and exceptions do not wait for capacity to catch up.
  • Structural complexity. Card networks, bank transfers, stablecoin settlements, and internal ledger movements each produce records in different formats and timelines, with different fees and settlement finality. Matching amounts is not enough; timing and float have to be understood too.
  • Organizational growth. Each new legal entity adds a ledger that must reconcile internally and against the group. Intercompany positions and currency translation add variance, often faster than finance headcount grows.

The Inflection Point

Most PSP and MSB finance teams hit a breaking point tied to transaction volume, entity count, or both. Below that threshold, discipline compensates. Above it, gaps in the architecture become unavoidable.

Multiple Ledgers, One Truth Expected

A scaled PSP or MSB typically runs three distinct records of financial activity. The operational ledger is the payment platform's real-time transaction record. It is authoritative for operations but knows nothing about the chart of accounts, accruals, or entity structure. The accounting subledger sits between the operational ledger and the general ledger, applying classification, accruals, and entity attribution to produce structured journal entries. At many finance teams, this layer does not exist as a formal system; it is a set of spreadsheets rebuilt each period. The general ledger, whether NetSuite, SAP, QuickBooks, or Xero, is only as reliable as what the subledger posts to it.

Common Scenario

A Controller closing month-end sees $4.2M in net settlement from the operational system, $3.9M received per the bank statements, and $4.1M posted to the GL. All three figures are defensible in isolation; none agrees with the others. The cause: settlement timing differences, an unreconciled fee-netting entry, and an unaccrued float position. None of this is unusual, and all of it is avoidable with the right architecture.

Multi-Jurisdiction Complexity

Operating across jurisdictions is not simply repeating one process in different currencies. Three problems compound: entity attribution (which legal entity is the counterparty when wallets and bank accounts are shared across entities), currency translation (manual, period-end translation lets errors compound silently through the month), and regulatory reporting (each regulator has its own transaction reporting, AML, and audit trail requirements). Producing clean, entity-level records from the point of transaction is far more defensible than reconstructing them at period-end.

Where Audits Get Difficult

  • Balance history. A reconstructed spreadsheet is not the same as a contemporaneous, system-generated record. Auditors ask for the latter.
  • Customer liability reconciliation. For PSPs holding client funds, any gap between customer liability and safeguarded funds is a regulatory issue, not just an accounting one.
  • Audit trail. Spreadsheets get modified and formulas break. A subledger maintains a timestamped log that persists regardless of later corrections.
  • Close speed. Manual, spreadsheet-driven reconciliation with period-end entity attribution routinely extends the close well beyond what better-resourced teams achieve, and most of that time goes to work a properly configured subledger would automate.

What Best-in-Class Teams Do

  • Enforce entity attribution at the point of transaction processing, not at period-end.
  • Run a formal subledger, not a spreadsheet, reconciled continuously to both the operational ledger and the GL.
  • Reconcile daily or intraday so breaks are resolved in hours, not investigated retroactively weeks later.
  • Maintain contemporaneous evidence, so the audit file is a system report rather than a reconstruction.

The Architecture

Operational Ledger → Real-time transaction record. Authoritative for operations, not accounting.

Accounting Subledger → Classification, entity attribution, currency conversion, accruals. Reconciles to the operational ledger.

General Ledger / ERP → Receives journal entries, applies period-end adjustments, produces financial statements.

Reporting Layer → Regulatory reports and audit files drawn from the GL and subledger. Evidence is system-generated.

The subledger is the critical layer. Without it, moving from raw operational data to a clean GL falls on the finance team manually. For PSPs and MSBs running crypto or stablecoin rails, this matters even more: on-chain data is unstructured by default and needs normalization and entity attribution before it can post anywhere.

What to Look For in a Platform

  • Systematic entity attribution across wallets, bank accounts, and processor connections, not a filter applied after the fact.
  • A traceable, timestamped audit log that cannot be altered without a history, exportable in a format auditors can use.
  • Consistent multi-currency handling based on a defined rate methodology, not a manual spreadsheet step.
  • Direct GL integration that maps to the chart of accounts without manual reformatting.
  • A rules engine that absorbs transaction growth without proportional increases in analyst time.
  • Support for the data export formats regulators in the relevant markets require.

The Window Is Shorter Than It Looks

Finance teams at growing PSPs and MSBs tend to underestimate how quickly manual reconciliation stops being viable. Volume thresholds arrive faster than planned, audits can land before infrastructure is ready, and regulators may request records that were never maintained in the required format. Teams that avoid this invest in accounting infrastructure one cycle before they need it, while the close is still manageable.

How Cryptoworth Fits

Cryptoworth is an accounting subledger and reconciliation platform for PSPs, MSBs, fintechs, and digital asset businesses operating at scale. It sits between operational systems and the general ledger, normalizing transaction data, enforcing entity attribution, automating classification, and producing the journal entries and audit trail that GL systems and auditors require.

The platform supports multi-entity structures, multi-currency reporting, and integration with modern finance stacks, including Rillet, Campfire, and Dual Entry, alongside NetSuite, QuickBooks, and Xero. For businesses running crypto or stablecoin rails, it connects to on-chain data sources and institutional custody and infrastructure providers, including Fireblocks and Utila.