Pilot

What you get after one day — a sample pilot report.

A pilot report shows one day of your payments in four outcomes, the payments a lookup cannot see, a discrepancy queue with the source rows of every line, claim candidates ready to send and the blind spots where no statement exists. This sample is built from a synthetic day, so every figure is invented.

This is the web version of the sample pilot report (PDF). The day is synthetic: fictional providers (Provider A…T), placeholder currencies (CUR-1…CUR-5), invented identifiers and amounts. In a real pilot every figure opens down to its source file and row, and the report is decoded at your site with your own table.

1. Your day in four outcomes

Every payment and statement line ends in exactly one outcome. In this synthetic sample, shares are by number of payments; a real pilot report gives shares of turnover in scope, with counts alongside. Amounts stay in their own currency and are never summed across currencies. “Awaiting” is not a discrepancy: the provider has not reported an outcome yet, or the payment falls into the next day’s statement.

Synthetic data

OutcomePaymentsShareWhat it means
Matched5,01483.0%Amount and outcome agree on every side.
Differs in money130.2%The amount differs; the difference is stated.
Differs in facts1302.2%One side only, or reversed outcomes.
Nothing to reconcile against70211.6%No statement, none for the currency, or an incomplete one.
Awaiting1823.0%No final status yet, or the payment falls into the next day’s statement.
Synthetic day: 6,041 payments and statement lines from 20 fictional providers (Provider A…T), placeholder currencies CUR-1…CUR-5. Amounts are never summed across currencies.

Why it matters to finance: the matched share is what you can book with confidence; the rest is named, not hidden. A lookup-based reconciliation reports only “found” or “not found”. The four outcomes

2. Invisible without Reconora

These payments look normal in a lookup because their ID exists somewhere. Only comparing amount and outcome across all three sources reveals them.

Synthetic data

  • 54Player charged, not creditedDeclined for you, successful at the provider.
  • 12Credited, never paidSuccess on your side, declined at the provider.
  • 41Settled, no record at your sideThe provider settled a payment you have no trace of.
  • 23Confirmed, then missingConfirmed by callback, absent from the statement.
  • 166Incomplete statementThe statement holds only part of the provider’s payments — request the full statement instead of booking debts.
  • 104No final statusThe provider never reported an outcome.
Synthetic day: 6,041 payments and statement lines from 20 fictional providers (Provider A…T), placeholder currencies CUR-1…CUR-5. Amounts are never summed across currencies.

Why it matters to finance: a player charged but not credited is a support ticket and a refund waiting to happen; a payment credited but never paid is money you booked and did not receive. Reversed outcome

3. Discrepancy queue

Every line has a reason and the address of its source rows: the log row and the statement row it came from. In the product the queue is filtered by reason, provider and age.

Synthetic data

PaymentProviderReasonYour logStatementSource rows
PAY-9D1C2Provider Bamount differs54.00 CUR-251.75 CUR-2log.csv · row 438stmt_B.xlsx · row 50
PAY-E4EBAProvider Bamount differs61.00 CUR-259.68 CUR-2log.csv · row 1,304stmt_B.xlsx · row 159
PAY-23B60Provider Gcharged, not credited275.00 CUR-2275.00 CUR-2log.csv · row 45stmt_G.xlsx · row 4
PAY-C2C7BProvider Bcharged, not credited274.00 CUR-2274.00 CUR-2log.csv · row 75stmt_B.xlsx · row 8
PAY-9CE0DProvider Jcredited, never paid215.00 CUR-5215.00 CUR-5log.csv · row 240stmt_J.xlsx · row 9
PAY-77FDDProvider Jcredited, never paid52.00 CUR-252.00 CUR-2log.csv · row 382stmt_J.xlsx · row 12
STL-7C93Provider Gsettled, no record—61.00 CUR-4stmt_G.xlsx · row 263
STL-5BA9Provider Psettled, no record—192.00 CUR-3stmt_P.xlsx · row 122
PAY-F3393Provider Pconfirmed, then missing48.00 CUR-3—log.csv · row 452
PAY-A76CEProvider Oconfirmed, then missing123.00 CUR-5—log.csv · row 687
Synthetic day: 6,041 payments and statement lines from 20 fictional providers (Provider A…T), placeholder currencies CUR-1…CUR-5. Amounts are never summed across currencies.

Why it matters to your team: nobody re-does the investigation — the evidence is already attached. Discrepancy queue

4. Claim candidate

Payments with the same problem at the same provider are grouped into one claim with its evidence, ready to approve and send.

Synthetic data

Provider C · players charged, not credited · 18 payments · 5,681.00 CUR-3

PaymentAmountLogNotificationStatementSource rows
PAY-BC44991.00 CUR-3declineddeclinedsuccesslog.csv · row 81stmt_C.xlsx · row 10
PAY-C49E621.00 CUR-3declineddeclinedsuccesslog.csv · row 780stmt_C.xlsx · row 70
PAY-310A837.00 CUR-3declineddeclinedsuccesslog.csv · row 1,537stmt_C.xlsx · row 137
PAY-FCCCC79.00 CUR-3declineddeclinedsuccesslog.csv · row 1,571stmt_C.xlsx · row 138
PAY-96883344.00 CUR-3declineddeclinedsuccesslog.csv · row 1,951stmt_C.xlsx · row 176

…and 13 more in the CSV register. Status: not filed. Next step: approve and send the package to the provider.

Synthetic day: 6,041 payments and statement lines from 20 fictional providers (Provider A…T), placeholder currencies CUR-1…CUR-5. Amounts are never summed across currencies.

Why it matters to finance: a claim with row-level evidence can be checked by the provider line by line; a complaint without it usually cannot. Claims

5. Blind spots

Volume with nothing to reconcile against: providers that sent no statement, statements missing for a currency, and statements that hold only part of the provider’s payments for the day.

Synthetic data

WhatDetailPayments
No statement at allProvider Q106
No statement at allProvider S106
No statement at allProvider T101
No statement for a currencyProvider D · CUR-1223
Incomplete statementProvider H: 57 of 223 payments in the statement166
Synthetic day: 6,041 payments and statement lines from 20 fictional providers (Provider A…T), placeholder currencies CUR-1…CUR-5. Amounts are never summed across currencies.

Why it matters to finance: this volume is neither matched nor a debt until a document lets you verify it. Naming it tells you which statements to request first. Statement coverage

Try it yourself

Pick any payment from a synthetic day and see the three sources side by side in the sandbox. To see this report for one day of your own data, request a free pilot.

Try it on one day of your data

One day of your data, reconciled, and the report stays with you whether or not you continue.

By Reconora Research · Updated