Hardware FixRecommendedDevice not working? Your driver may be the problemCheck updates for common hardware issues.Fix DriversHalloween DealsAmazon USHalloween week deals: useful picks before month-endAmazon US: current deals, useful picks and tech finds.Check DealsPC HealthRecommendedCrashes, freezes, slowdowns? Check your PC nowSpot repairable issues before they interrupt work.Check PC×
FREEDOM251

Freedom251 › Blog › Adyen

How to Investigate Payment Reconciliation Mismatches Caused by Settlement Cutoffs

By Freedom251 Team · · 5 min read

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

A payment reconciliation mismatch near a settlement cutoff is not automatically a missing payment. First identify which stages and timestamps you are comparing, then check the processor’s sales-day boundary, payout model, business-day schedule and adjustments. Only escalate a shortfall after the expected batch and bank-funding window have passed.

What exactly is mismatching?

Reconciliation follows the movement of funds through distinct stages: authorization, capture, settlement, payout or funding, and bank credit. A transaction recorded at capture is not necessarily settled yet, and a settled transaction is not necessarily already visible in the business bank account. Adyen defines reconciliation as matching documentation to the actual movement of funds from payment initiation until they reach the account (Adyen Help Centre).

As an Amazon Associate I earn from qualifying purchases.

Before investigating, write down the two records that disagree. Include amount and currency, merchant or balance account, transaction and batch identifiers, and the timestamp field on each record. That field might be capture time, processor event time, batch close, payout instruction, bank posting, or accounting date. Also label each amount as gross sales, a batch total, net payout, or bank credit; these are not interchangeable.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Check the sales-day cutoff and timezone

A processor’s “day” may not match the day in your ledger. Adyen defines a sales day as a 24-hour period and documents a default midnight-to-midnight boundary in the balance account’s local timezone; the closing time can be configured to a later time (Adyen sales-day payout documentation). Check the setting for the relevant account rather than assuming the default applies.

Compare that boundary with the timezone and date rule used by your accounting system. If the processor groups by local sales day while the ledger groups by UTC, a transaction near midnight can fall on different dates in the two systems. That is a likely grouping difference to test—not evidence by itself that the payment is missing.

  1. Find the account’s configured sales-day closing time and timezone in the processor settings or account documentation.
  2. Identify the timestamp your ledger uses to assign a transaction to a day, such as capture time in UTC or local accounting date.
  3. Re-group transactions around the cutoff using the processor’s boundary, then compare totals for the same window.

Identify the payout model before matching totals

The payout model determines whether a sales-day total should map neatly to a payout. Adyen documents two different patterns; do not assume they apply to other processors or to every Adyen account.

Rank #2
Free Fling File Transfer Software for Windows [PC Download]
  • Intuitive interface of a conventional FTP client
  • Easy and Reliable FTP Site Maintenance.
  • FTP Automation and Synchronization
Model How funds are grouped Reconciliation implication
Sales-day settlement Captured funds are assigned to batches associated with a sales day. Compare the sales-day activity with its corresponding batch, then account for the configured settlement delay.
Pass-through payout Funds follow scheme and payment-method timelines; one sales day can be paid in multiple batches. Do not expect one sales day to equal one payout. Adyen says this model does not support reconciliation by day totals and requires automated reconciliation (Adyen Pass-through payout).

Confirm the model for the account and the relevant payment methods. Under pass-through payout, a payout may also combine activity from multiple sales days, so matching only daily totals can conceal the actual batch composition.

What’s actually slowing this PC down?

Pick the symptom - the matching free tool is one click away.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Recalculate the expected settlement window

Use the account’s configured delay and working-day calendar, not a simple count of calendar days. Adyen says available funds are settled on working days, excluding bank holidays, and its examples show holidays moving settlement later. In one documented example, a two-business-day delay moves Monday sales to Wednesday; when Tuesday and Wednesday are bank holidays, settlement shifts to Friday (Adyen sales-day payout documentation).

Rank #3
Express Schedule Free Employee Scheduling Software [PC/Mac Download]
  • Simple shift planning via an easy drag & drop interface
  • Add time-off, sick leave, break entries and holidays
  • Email schedules directly to your employees

Adyen’s typical payout-delay examples are provider-specific: the documentation describes two business days for accounts meeting a stated currency and acquisition-region condition, and three business days for other stated typical accounts, with exceptions. The same documentation says currency and acquisition region affect the delay. These figures are not a universal schedule; account configuration and applicable terms determine the expected date.

Stripe’s educational overview describes card settlement as typically one to three business days and funding as two to three business days in its typical timeline, while noting that arrangements vary by processor, payment method, and bank (Stripe: Payment processing explained). Treat that as general educational context, not a promise about a specific Stripe account or a substitute for its payout schedule.

Rank #4
POS Software iOS Point of Sale System Cash Register Inventory Management Receipt Printing Order Delivery Cloud Printing for Small Businesses Retail Grocery Restaurant Coffee Shop Uber eats Door dash
  • SERVICES: This iOS POS software doesn't need any installation. As long as you have an idle pad, you can use it.It supports iOS Mac Pad. We offer professional customer service and free software updates
  • SOFTWARE: Once purchased, you can enjoy 1 months of remote support and iCloud. No contracts or mandatory fees
  • MULTIFUNCTION: This POS software offers a wide range of features, including ordering, customizable receipts, calculation of different tax rates, integration with multiple food delivery platforms, QR code ordering and more. It meets all your needs
  • Mobile APP: With the mobile app, you can enjoy cloud backup and mobile reporting services. Check on your store anytime, anywhere—it’s simple, convenient, and easy to get started with
  • EASY to USE: This POS software is compatible with various point-of-sale devices, such as cash drawers, barcode scanners, and printers. It supports cloud printing, no distance limits, you can print store receipts from anywhere. There’s no need to purchase an expensive POS cash register—saving both money and space
  • Confirm the configured settlement or payout delay and whether its unit is business days.
  • Check the currency and acquiring region if the provider uses them to determine timing.
  • Apply the relevant working-day calendar and bank holidays to the expected date.
  • Compare the expected batch or payout date with the processor’s event and bank-posting records.

Bridge gross sales to net funding with adjustments

A net payout need not equal the gross captured sales for the same sales day. Fees, refunds, chargebacks, reversals, and other adjustments may enter a batch when they occur, even when they relate to a transaction from a different sales day. Adyen’s documentation describes these adjustments in its payout and reconciliation guidance (sales-day payout; pass-through payout).

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
  1. Start with captured gross activity for the relevant batch or period.
  2. List fees and each refund, chargeback, reversal, or other adjustment as a separate line.
  3. Match each adjustment using its own event date, batch, and transaction reference; do not assign it automatically to the original sale day.
  4. Compare the resulting net amount with the payout instruction and then the bank credit.

This bridge helps distinguish an explained net difference from an unaccounted-for transaction. If your accounting ledger uses a different date for adjustments than the processor, note that rule explicitly in the comparison.

Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Support on Ko-Fi

Choose the report that answers the question

For Adyen, use the Settlement Detail Report to reconcile a payout by payable batch. For detailed invoice reconciliation, use the Payment Accounting Report. Adyen warns that other reports may not have the granularity or timezone cutoffs needed for a complete invoice match (Adyen Help Centre: How reports help with reconciliation).

The Payment Accounting Report includes event, payment-method, fee, and payable-batch fields useful for checking transaction and fee lines. Its interactive version supports a specified date range and timezone; Adyen’s help page says the invoice timezone is AMS. Use the report’s stated timezone when matching invoice dates rather than silently comparing them with a ledger grouped in another timezone.

Classify the mismatch and decide whether to escalate

  • Timing boundary: The activity appears in a later sales day or expected batch after applying the correct timezone and cutoff.
  • Expected settlement delay: The batch or funds are still within the configured business-day window, including applicable bank holidays.
  • Explained net difference: Recorded fees, refunds, chargebacks, reversals, or other adjustments account for the gap.
  • Unresolved exception: The expected batch, amount, or bank credit remains absent after checking the model, schedule, cutoff, adjustments, and appropriate report.

For an unresolved exception, contact the processor or bank with a specific discrepancy: account and currency, expected and actual amounts, batch and transaction identifiers, relevant timestamps with timezones, and the expected settlement or posting date. A precise evidence trail is more actionable than a daily sales total that may not correspond to the provider’s payout structure.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Compare these settings when reviewing multiple accounts

For a multi-account or multi-provider reconciliation process, keep the operational differences visible rather than applying one universal rule:

  • Payout model: sales-day batching or pass-through.
  • Sales-day closing time and timezone.
  • Configured settlement or payout delay and payout frequency.
  • Currency, acquisition region, and applicable working-day and holiday calendar.
  • How and when adjustments enter batches.
  • Report granularity and the timezone used by the report.

Published provider examples explain how a schedule can work; the account’s actual settings and terms govern an individual payout.

Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.

Adyenfinance operationspayment reconciliationpayoutssettlement cutoff

Leave a Reply

Your email address will not be published. Required fields are marked *

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Recommended PC Tool
Recommended PC Tool
PC Slower Than It Used to Be?Free scan - under a minute
Outdated Drivers Are Slowing You DownFree scan - exact matches

Two free Windows tools

One Free Minute Could Fix That PC

Before you go - each of these free tools takes about a minute and tackles what quietly slows a Windows PC down.

Special offer. View Outbyte info, uninstall instructions, EULA, and Privacy Policy.