Blog

Timing Differences in Payment Reconciliation: When to Investigate

Ignacio Berardi Jun 21, 2026

A timing difference in payment reconciliation is a gap between when a transaction is recorded in one system and when it appears in another. The transaction has occurred and will eventually match, but the two records do not yet align because the systems involved operate on different settlement cycles, batch processing windows, or posting schedules. Timing differences account for the majority of unmatched items in payment operations, and distinguishing them from genuine discrepancies is the core operational challenge in running a reliable reconciliation workflow.

How settlement cycles, batch windows, and cut-off times create timing gaps

Payment transactions do not move through a single continuous system. They pass through a processor, a card network, an acquiring bank, and a receiving bank, each of which operates on its own schedule for processing, clearing, and posting. Finextra explains that even in real-time payment systems, funds settlement can be near-instant while transaction posting follows an entirely separate batching schedule, with an inbound payment staying as pending until a bank’s internal posting window closes, sometimes hours later. A transaction that settles instantaneously at the inter-bank level may not appear as a hard descriptor in the bank statement until the following business day.

Electronic Payments International describes how reconciliation breaks accumulate from timing mismatches where messages arrive out of sequence, files close before all entries are present, and cut-off windows are missed by seconds rather than hours. A transaction authorized before a processor’s daily batch cut-off will appear in that day’s settlement file. A transaction authorized one minute after the cut-off will appear in the next day’s file. Both transactions occurred on the same calendar day, but they sit in different settlement periods, creating a one-day timing difference that reconciliation software must hold open until the second file arrives.

The authorization-to-settlement gap is the most referenced example of a structural timing difference. Authorization settlement accounting covers how finance teams link each authorized transaction to its eventual settlement record, accounting for the days that can separate authorization from capture, and capture from final settlement. The gap between those events is not a discrepancy. It is a structural feature of how card payments move through the network.

Why timing gaps multiply across fragmented payment systems

PYMNTS reports that a single online purchase may involve an authorization record, a capture transaction, processor fees, settlement batches, and potential refunds or chargebacks, each appearing in a different system at a different time. Finance teams reconciling across payments platforms, ERP systems, billing tools, treasury systems, and banks must stitch together multiple sources of records, each operating on its own schedule.

Finextra notes that fragmented, inconsistent, and incomplete data forces finance teams to manually cross-reference files to piece together what should be obvious from the source data. For timing differences specifically, this means that the same gap shows up independently in multiple places: the processor file does not match the bank statement, the bank statement does not match the ledger, and the ledger does not match the internal transaction system. What is structurally one timing difference becomes three separate open items if the reconciliation system treats each source pairing independently. Payment settlement reconciliation handles the matching of payment events across processor files and bank deposits, and relies on a configured time window to prevent normal settlement lags from generating false exceptions.

The three structural sources of timing gaps in payment operations

Three system-level behaviors produce most timing differences in payment operations:

Processor batch windows determine when transactions captured during a given period are grouped into a settlement file and submitted for clearing. Processor reconciliation covers how processor settlement files are structured and how batch timing affects the period in which transactions appear. When a finance team’s reporting period and a processor’s batch window do not align, transactions that occurred in one period appear in the next period’s settlement file.

Banking cut-off times determine when a bank accepts incoming settlement transfers for same-day posting. Bank reconciliation automation explains how multi-bank setups and cut-off differences create timing gaps between when a settlement transfer is sent and when it posts to the bank statement. A settlement initiated by the processor at 5pm may not post to the bank account until the following morning.

Ledger posting dates determine when an accounting system records a transaction as posted versus pending. Ledger reconciliation covers how internal ledger entries are matched against external data sources, including how posting date differences between the ledger and the bank statement create timing gaps that must be managed across reporting periods.

How to distinguish a timing difference from a genuine discrepancy

Electronic Payments International explains that a delayed settlement becomes a merchant relationship issue, a pending reversal becomes a customer confidence issue, and a reconciliation break becomes a finance truth issue when it is not resolved within an expected window. The practical test for distinguishing a timing difference from a genuine discrepancy is whether the open item resolves automatically when the next settlement file, bank statement batch, or ledger posting run arrives.

A timing difference has three characteristics: it involves a transaction that is confirmed as having occurred, it is expected to appear in a future file or posting run within a defined window, and it carries no indication that the transaction failed, was reversed, or was misrouted. A genuine discrepancy has at least one of the following: the transaction cannot be confirmed as having occurred in the source system, the expected matching entry has not arrived within the normal settlement window, or secondary evidence suggests the amount or counterparty may be incorrect. Finance teams that do not formally distinguish between these two categories investigate timing differences as though they were discrepancies, consuming investigation capacity that should be reserved for genuine breaks.

How reconciliation software manages open timing items across reporting periods

Reconciliation software manages timing differences by holding unmatched items in an open items queue with a configured resolution window. Items that resolve within the window are automatically matched when the corresponding entry arrives and removed from the queue. Items that remain open beyond the window are escalated as exceptions for finance team review. The resolution window must be calibrated to the actual settlement behavior of each processor and bank: a processor that consistently settles within two business days should have a two-day window; a processor with a three-to-five day settlement cycle requires a wider window to avoid false exceptions.

Payment reconciliation across multiple processors and banks requires maintaining separate resolution windows per counterparty, because a two-day timing difference that is normal for one processor may indicate a genuine problem for another. Reconciliation software that applies a single universal window generates false exceptions for slower processors while missing genuine breaks at faster ones.

When a timing difference becomes an exception requiring investigation

A timing difference requires investigation when it has not resolved within the expected settlement window for the counterparty in question, when the amount is material enough to affect reported cash positions or financial statements, or when the same item has remained open across multiple reporting periods without a documented reason. The investigation should confirm whether the transaction is pending in the source system, whether the processor or bank can confirm the status of the expected settlement, and whether any communication from the counterparty explains the delay. Items that cannot be confirmed as pending are reclassified as discrepancies and escalated accordingly.

How Rexi handles timing differences in payment reconciliation

Rexi holds unmatched transactions in an open items queue with configurable resolution windows set per processor and bank counterparty. When a matching entry arrives within the window, the Reconciler agent automatically closes the open item and logs the match. Items that remain open beyond the configured window are escalated as exceptions and routed to the finance team with the transaction record, the expected counterparty, and the number of days outstanding. Resolution windows are updated independently for each counterparty as settlement behavior changes, without requiring engineering involvement to adjust the configuration.

Frequently Asked Questions

How long should a timing difference stay open before becoming an exception?

The threshold depends on the settlement cycle of the counterparty involved. For card processors that settle on a next-business-day cycle, an unmatched item that has not resolved after two business days warrants investigation. For processors or banks with two-to-three day settlement cycles, the threshold should be four to five business days. The threshold should be set per counterparty rather than applied universally, because normal settlement behavior varies significantly across processors, card networks, and banking partners. Items that remain open beyond the threshold after accounting for weekends and public holidays should be treated as exceptions regardless of amount.

What is the difference between a timing difference and a missing transaction?

A timing difference involves a confirmed transaction that has not yet appeared in a counterparty’s records because of a settlement or posting lag. A missing transaction involves a transaction that has not appeared in any expected system within the normal settlement window and cannot be confirmed as pending. The practical difference is that a timing difference resolves automatically when the settlement file or posting run arrives; a missing transaction does not resolve on its own and requires active investigation with the processor or bank to determine whether the transaction was processed, failed, or was misrouted. Finance teams should avoid treating long-outstanding timing items as timing differences if no confirmation of pending status is available from the source system.

How do weekends and public holidays affect timing differences in payment reconciliation?

Weekends and public holidays extend timing differences because banks and processors do not process settlement transfers on non-business days. A transaction captured on a Friday before a bank holiday weekend may not post to the bank account until the following Tuesday. Reconciliation software must account for calendar-adjusted settlement windows to avoid flagging these items as exceptions when they are within the normal range for a business-day-adjusted settlement cycle. Finance teams running period-end reconciliation on or immediately after a holiday weekend should expect a higher volume of open timing items than on a standard business day.

How do timing differences in payment reconciliation affect month-end close?

Timing differences create a cut-off problem at month-end close: transactions that occurred before the period end may not appear in the bank statement or ledger until the following period. Finance teams must decide whether to accrue for these items in the current period or wait for them to settle in the following period. The decision depends on the materiality of the amounts and the accounting standard applied. Reconciliation software that tracks open timing items with their expected resolution dates gives finance teams the information they need to make accurate accrual decisions at close rather than estimating based on historical averages.

Can a timing difference be caused by time zone differences between systems?

Yes. When a transaction occurs near midnight, the time zone used by the processor to assign a transaction date may differ from the time zone used by the bank or the internal system, causing the same transaction to be recorded on different calendar dates across systems. A transaction authorized at 11pm EST appears on Monday’s date in an EST-based processor file but on Tuesday’s date in a GMT-based bank system. This one-day timing difference is structural and will recur for every transaction in that time window unless the reconciliation system normalizes timestamps to a common time zone before applying matching logic.

About the Author
Ignacio Berardi
Ignacio Berardi
Ignacio Berardi is a fintech operator and Co-Founder and CEO of Rexi, an AI-native agentic orchestration platform that helps operationally complex businesses reconcile, investigate, and account for money movement across fragmented systems. He leads distribution and go-to-market for Rexi.

Before Rexi, Ignacio served as Chief of Staff at Comun, where he built the company's reconciliation process from scratch, and as Product Manager at Bitso. He previously worked at Bain & Company advising financial services companies across Latin America, and at NXTP Ventures in portfolio support and deal screening. He holds an MBA from Harvard Business School, where he was a member of the Rock Center for Entrepreneurship and Harvard Innovation Labs.
Ignacio Berardi Jun 21, 2026
Share this post

Stay in the loop

New posts on reconciliation, fintech infrastructure, and financial ops.

Subscribed
Read More
Payment Reconciliation Software for Fintech and Payment Companies
Ignacio Berardi · May 17, 2026
Automating Reconciliation from Data Ingestion to Exception Resolution
Ignacio Berardi · May 19, 2026
How Fintechs and Payment Companies Detect Revenue Leakage in Reconciliation
Ignacio Berardi · Jun 4, 2026