System of record & ledger
Who owns the truth, and how do systems reconcile?
Every industry has a place where the official answer lives, and it is rarely your database. Knowing who owns the truth tells you which system wins an argument, and where reconciliation will eat your team's week.
What it is
The system of record is the place whose answer counts when two systems disagree. A ledger is the append-only history of what changed and why. Most industries have several systems of record, each owned by a different party, and a lot of the work is keeping them in step.
Your product's data is usually a copy of someone else's truth, plus a reconciliation job.
Where you'll see it
| Industry | Whose truth you reconcile against |
|---|---|
| Payments | Your ledger vs the processor's settlement files vs the bank statement |
| Payroll | The payroll register vs the general ledger vs tax filings |
| Telco | Your number inventory vs the national porting database vs carrier records |
| Healthcare | The provider's chart vs the payer's claim history |
| Legal | The court docket vs the firm's matter system |
Questions to ask in week one
- For each key entity, which system's answer wins?
- Which of those systems do we own, and which belong to a counterparty or a regulator?
- How often do we reconcile, and who fixes the breaks?
- Is history append-only, or can records be edited in place?
- What does an auditor ask to see first?
The trap
Assuming your database is the source of truth because it's the one you can query. When a regulator, a network or a court holds the official record, your system is the copy, and "fixing" it on your side changes nothing.
In the Field Guides
AI agents: orchestration platforms
Several records describe what an agent did, and they disagree by design.
| Fact | System of record |
|---|---|
| What the agent changed | The system acted on (CRM, ERP, payments), stamped with the agent's identity |
| Why it did it | The platform's trace: sampled, metadata-only by default, retention-limited |
| What the model received | The lab's request logs: 0 to 30 days, none under zero retention |
| What it cost | The invoice, not the trace |
| What it remembers | Memory store, vector index, checkpoints, the lab's stored state |
A trace isn't a ledger: a ledger is complete, append-only and kept; traces are sampled, expire, and become personal-data stores once content capture is on. AWS says observability explains activity but isn't a billing report, and OpenAI warns that its usage and cost data may not reconcile.
Logs become evidence. On May 13, 2025, a US court ordered OpenAI to preserve API output logs it would otherwise have deleted (zero-retention customers exempt), an obligation lifted going forward on September 26, 2025. The EU AI Act makes deployers of high-risk systems keep logs at least six months. Keep eval results outside any console that can close.
Sources: AWS harness, OpenAI's usage API (search result), Duane Morris, AI Act Art. 26.
The system acted on is the ledger and the trace is the explanation: stamp every write with the agent's identity and run ID so the two can be joined.
Ask an expert: when the trace says the agent issued a refund but the payments system disagrees, which wins, and who reconciles?
B2B payments: cross-border payouts
Every fact has an owner, and the payout company owns fewer than its dashboard suggests.
| Fact | System of record |
|---|---|
| Customer's dollar balance and payout liability | The provider's ledger, over a pooled or safeguarded account |
| Local-currency balances at each partner | The partner's statement |
| FX position between quote and bulk purchase | The provider's treasury |
| Proof the money moved | The rail: SPEI's CEP, gpi's UETR status, Pix end-to-end ID, card settlement file |
| Gross to net, payslips | The payroll engine; in Mexico the CFDI is payslip and tax record |
A public remittance company's filing says it may keep prefunding balances with disbursement partners, earns no interest on them, and could lose them if a partner fails to disburse: the money you count isn't in your bank. So each currency needs a three-way reconciliation (ledger, partner statement, rail confirmation). The classic breaks: FX rounding, partner fees netted from balances, returns in pesos against a dollar payout, statements cut in different time zones.
Regulators test the ledger. Model state laws require permissible investments at least equal to outstanding obligations; the UK's safeguarding rules (PS25/12, since May 7, 2026) require daily reconciliations and a resolution pack retrievable within 48 hours; Canada's RPAA requires end-user funds in trust or insured. When ledger and banks disagree, end users lose: the 2024 collapse of a banking-as-a-service middleware company (see spend management) left a gap estimated at up to $95M, and the CFPB allocated $46.2M, about half.
Sources: FCA, Bank of Canada; the remittance company's 10-K under "Cited without links".
The partner's statement says what money exists, your ledger says whose it is, and the rail says whether it moved: reconcile all three, per currency, every day.
Ask an expert: what breaks your reconciliation most often (FX rounding, netted partner fees, returns or time zones), and how long do breaks stay open?
B2B payments: order to cash
Every fact has an owner, and few of them are you.
| Fact | System of record |
|---|---|
| Quotes and contract terms | The CRM |
| Customer master, credit limits, orders, invoices, AR subledger, general ledger | The seller's ERP |
| Proof of delivery; deduction backup | The warehouse or transport system and carrier; the retailer's portal |
| Cash | The bank, in BAI2 or ISO 20022 camt.053 statement files |
| Card authorizations, funding, fees, chargebacks | The card processor |
| Check images and stub data | The lockbox file |
| Insured limit per customer; borrowing base | The credit insurer; the lender |
| Payments in flight, and who owns what in a pooled for-benefit-of (FBO) account | The AR platform's ledger, which must sum daily to the FBO balance |
| Remittance | Nobody |
The classic breaks: card deposits arrive net and batched against gross invoices; a lockbox deposits one total for fifty checks; an ACH return arrives after the cash was applied; a payer deducts its wire fee. Book fees, returns and corrections as their own entries, never edits. When the ERP and the bank disagree, the bank wins for cash and the ERP for what's owed.
The ledger also carries the loss reserve. CECL (ASC 326) applies to trade receivables: lifetime expected loss from day one, pooled by risk, never zero on current balances, with price concessions and credit memos stripped from loss history. ASU 2025-05 (July 2025) lets any company assume current conditions persist for current receivables, and private companies may also count collections after the balance-sheet date, for years beginning after December 15, 2025.
Nobody is the system of record for remittance or for deduction reasons, so whoever captures them best owns the matching and a clean loss history.
Sources: Deloitte on CECL, KPMG on ASU 2025-05 (July 2025).
Ask an expert: when CRM contract terms and ERP customer terms disagree, which wins, and who fixes it?
B2B payments: procure to pay
Every fact has an owner, and the buyer's ERP owns fewer of them than it seems.
| Fact | System of record |
|---|---|
| POs, receipts, the AP subledger, the vendor master, the general ledger | The buyer's ERP |
| Invoice images, workflow and approval history (audit evidence) | Often the AP automation tool |
| Cash out | The bank, in BAI2 or ISO 20022 camt.053 statement files |
| Which checks were issued | The Positive Pay issue file the buyer sends its bank |
| Virtual card payments and rebates | The card issuer |
| Funds in transit at a payment hub | The provider's ledger over a pooled for-benefit-of (FBO) account |
| Supplier finance balances | The ERP plus the funder's platform; disclosed under ASU 2022-04 |
The classic breaks:
- Tool and ERP disagree. The AP tool shows an invoice paid; the ERP still shows it open.
- Received, not invoiced. Goods arrived, the invoice hasn't, and the accrual is a month-end chore.
- Outstanding checks. The ERP says paid; the bank hasn't seen the check.
- Card timing. A virtual card was issued, not yet charged, and nobody can say where the cash sits.
As on the seller's side, the bank wins for cash and the ERP wins for what's owed; corrections post as journal entries, never edits. For audit, the approval trail matters as much as the payment record: auditors test who approved and who released, not only whether the money moved.
Ask an expert: when the AP tool and the ERP disagree on an invoice's status at close, which one wins, and who posts the fix?
B2B payments: spend management
Every fact has an owner, and few of them are the platform.
| Fact | System of record |
|---|---|
| Authorizations, clearing records, card status | The issuer processor |
| The legal receivable; settlement with the network | The sponsor bank |
| Balances, limits, rewards; the participation in the receivable | The program manager's ledger |
| Prepaid and just-in-time funds | A pooled for-benefit-of (FBO) account at the bank, sub-ledgered by the platform |
| Purpose, approvals, receipts, coding | The expense tool |
| Books, accruals, close | The ERP |
| Taxable amounts (W-2, T4, Quebec's RL-1) | Payroll |
The classic breaks: processor and bank disagree on what settled; card spend is still uncoded at close; unsubmitted out-of-pocket spend is accrued as a guess, or ignored. And pooled funds stop adding up. Synapse, a banking-as-a-service middleware company, failed in April 2024 with its ledger out of step with its banks'. Shortfall estimates ran from $60M to $95M; after suing and reaching a stipulated judgment in 2025, the CFPB allocated $46.2M from its Civil Penalty Fund to those affected. Prepaid cards and spend-platform cash accounts use the same pooled structure.
The FDIC proposed daily reconciliation of custodial accounts in 2024; its agenda lists the final rule as "To Be Determined". Banks demand it by contract anyway: a law firm's August 2026 summary lists real-time, auditable ledger reconciliation among sponsor banks' standard asks.
Sources: American Banker and Banking Dive on Synapse, FDIC proposal and agenda, National Law Review (Aug 2026).
Four ledgers describe one purchase: the bank's wins for what's owed, the expense tool's for why, the ERP's for the books, and someone has to reconcile them every day.
Ask an expert: what daily reconciliation break do you watch most, and who wins when the processor and the bank disagree?
Telco: numbers and senders
Your inventory database is a copy. Nearly every fact a customer cares about is owned by someone else.
| Fact | System of record | Run by |
|---|---|---|
| Which carrier holds a number block | LERG (the national routing guide) | iconectiv |
| Where a ported number routes | NPAC | iconectiv, porting administrator since May 2018 |
| Number assignments, reassigned numbers | NANPA, Pooling Administrator, Reassigned Numbers Database | SomosGov (current contract option runs to Nov 30, 2026) |
| Toll-free ownership and text-enablement | TFNRegistry, TSS Registry | Somos |
| Text-enablement of hosted long codes | NetNumber's registry (per providers) | NetNumber |
| 10DLC brands, campaigns, vet scores | TCR, plus each carrier's provisioning | TCR, DCAs, carriers |
| Short code leases | US Short Code Registry; txt.ca in Canada | CTIA; Canadian Telecommunications Association |
| Provider robocall certifications | Robocall Mitigation Database (RMD) | FCC |
| 911 caller location | ALI or, in NG911, LIS (the databases 911 centers query) | 911 service providers |
| WhatsApp assets, limits, charges | WhatsApp Manager, webhooks, pricing analytics | Meta |
| RCS agents, launch state, billable events | Google's console and daily billing reports | |
| Alpha senders abroad | India's DLT ledgers, Singapore's SMS Sender ID Registry (SSIR), ACMA's register, CNMC's alias registry | Operators or regulators |
Sources: NANPA 2025 annual report, iconectiv, Somos TSS, Google billing FAQ.
One ledger is only yours. Consent records are the sender's own system of record, and in a lawsuit or a carrier audit they're the only defence. CTIA's short code handbook expects opt records kept six months after an opt-out. The reassigned-number safe harbor protects only callers who can prove they checked the Reassigned Numbers Database, so keep those query logs too.
Ask an expert: when your inventory disagrees with the NPAC, TCR or Meta, which one do support agents trust, and how often do you reconcile against each?
Field Guides are learning notes, not legal or compliance advice. Rules and fees change; check the cited primary sources before you act on anything here.