Synthetic month, seed 11 · 16 planted mistakes

FileDetected asEvidence
stripe_payout_reconciliation.csvStripe payout reconciliation report (itemized CSV)generated in the PSP's own format
mollie_settlements.jsonMollie settlements (JSON)generated in the PSP's own format
adyen_settlement_details.csvAdyen settlement details report (CSV)generated in the PSP's own format
bank_camt053.xmlBank statement (ISO 20022 camt.053 XML)generated in the PSP's own format
exact_transactionlines.jsonExact Online TransactionLines (REST JSON)generated in the PSP's own format

Excel workbook Exact import file breaks.json report.html Another month

Payout reconciliation · 1 Aug – 31 Aug 2026

Data as of 7 Sep 2026 · generated by payrecon M0
2,244settlement lines
73payouts
98bank lines
1,548ledger postings
1,672matches
14breaks to review
2in transit
0unexplained

Clearing-account proof

Expected closing = opening + sales + refunds + chargebacks + fees + payouts arrived. The difference to the ledger must be fully explained by the breaks below.

PSPOpeningSalesRefundsChargebacksFeesPayouts arrivedExpected closingLedger closingDifferenceExplainedUnexplained
Adyen€3,555.12€94,768.49-€1,502.41-€280.12-€1,294.43-€88,767.31€6,479.34€6,339.48-€139.86-€139.86€0.00
Mollie€6,811.31€82,202.74-€2,691.93-€283.55-€242.27-€74,480.51€11,315.79€11,637.41€321.62€321.62€0.00
Stripe€9,777.81€97,009.14-€3,397.70-€402.09-€1,882.66-€91,681.16€9,423.34€11,229.21€1,805.87€1,805.87€0.00

Review · 16 open · 0 confirmed · 0 changed · 0 dismissed

Confirm a break as the engine classified it, change its class when you know better, or dismiss it. Amounts are never edited here; a change only re-labels the break. In this demo your decisions are kept in your browser only.

Missing payout · 1 · €1,702.89

PSPAmountWhat happenedProposed entryStatusDecision
Stripe €1,702.89 Stripe payout po_sugt5vujziw0nb6ojdgk82he (€1,702.89) paid on 23 Aug 2026 was due by 26 Aug 2026 and has not arrived. Contact Stripe.
— open

Unknown bank credit · 1 · €507.86

PSPAmountWhat happenedProposed entryStatusDecision
Stripe €507.86 €507.86 from STRIPE PAYMENTS EUROPE LTD on 20 Aug 2026 ("STRIPE TRANSFER") matches no payout in the Stripe data. It is booked on the clearing account.
Dr 1105 €507.86
Cr 2999 €507.86
open

Sale unbooked · 2 · €290.50

PSPAmountWhat happenedProposed entryStatusDecision
Adyen €158.58 Adyen charge QZZ1LL8FF7T8BMW8 for €158.58 (order ORD-102236, 21 Aug 2026) has no booking.
Dr 1107 €158.58
Cr 2999 €158.58
open
Mollie €131.92 Mollie charge tr_5de6dh7xh9 for €131.92 (order ORD-102288, 22 Aug 2026) has no booking.
Dr 1106 €131.92
Cr 2999 €131.92
open

Duplicate posting · 1 · €233.37

PSPAmountWhat happenedProposed entryStatusDecision
Mollie €233.37 Order ORD-101892 (€233.37) is booked twice; posting 26000811-1 on 16 Aug 2026 is the duplicate.
Dr 2999 €233.37
Cr 1106 €233.37
open

Chargeback unbooked · 1 · €58.80

PSPAmountWhat happenedProposed entryStatusDecision
Mollie €58.80 The customer disputed order ORD-101067: Mollie took back €58.80 on 6 Aug 2026. Not booked.
Dr 4420 €58.80
Cr 1106 €58.80
open

Refund unbooked · 2 · €32.35

PSPAmountWhat happenedProposed entryStatusDecision
Adyen €16.22 Refund of €16.22 on order ORD-102034 (19 Aug 2026) was paid out by Adyen but is not booked.
Dr 8010 €16.22
Cr 1107 €16.22
open
Stripe €16.13 Refund of €16.13 on order ORD-101667 (28 Aug 2026) was paid out by Stripe but is not booked.
Dr 8010 €16.13
Cr 1105 €16.13
open

Refund cross-period · 2 · €362.54

PSPAmountWhat happenedProposed entryStatusDecision
Mollie €161.37 Refund of €161.37 on 4 Aug 2026 for order ORD-100657 relates to a sale from 29 Jul 2026; it is not booked and affects revenue cut-off for that earlier period.
Dr 8010 €161.37
Cr 1106 €161.37
open
Stripe €201.17 Refund of €201.17 on 3 Aug 2026 for order ORD-100156 relates to a sale from 22 Jul 2026; it is not booked and affects revenue cut-off for that earlier period.
Dr 8010 €201.17
Cr 1105 €201.17
open

Fee unbooked · 1 · €1,882.66

PSPAmountWhat happenedProposed entryStatusDecision
Stripe €1,882.66 Stripe charged €1,882.66 in fees between 1 Aug 2026 and 31 Aug 2026; none are booked on the clearing account.
Dr 4410 €1882.66
Cr 1105 €1882.66
open

FX variance · 1 · €213.77

PSPAmountWhat happenedProposed entryStatusDecision
Stripe €213.77 120 GBP sales were booked at the ledger's exchange rate, which values them €213.77 more than the euro amounts Stripe actually settled at its own conversion rate.
Dr 8900 €213.77
Cr 1105 €213.77
open

Amount mismatch · 1 · €2.50

PSPAmountWhat happenedProposed entryStatusDecision
Adyen €2.50 Adyen payout adyen-batch-228 of €3,193.59 arrived as €3,191.09 on 18 Aug 2026, €2.50 short; likely a bank charge.
Dr 4411 €2.50
Cr 1107 €2.50
open

Payout integrity · 1 · €500.00

PSPAmountWhat happenedProposed entryStatusDecision
Adyen €500.00 Adyen payout adyen-batch-226 (€1,536.31) is €500.00 below the €2,036.31 net of its transactions: a reserve was withheld.
Dr 1150 €500.00
Cr 1107 €500.00
open

In transit · 2 · €11,982.52

PSPAmountWhat happenedProposed entryStatusDecision
Adyen €3,895.78 Adyen payout adyen-batch-242 (€3,895.78) was paid on 31 Aug 2026 and reached the bank on 1 Sep 2026, after period end. No action.
— open
Mollie €8,086.74 Mollie payout stl_w94ho62b5i (€8,086.74) was paid on 31 Aug 2026 and reached the bank on 1 Sep 2026, after period end. No action.
— open