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
| Outcome | Payments | Share | What it means |
|---|---|---|---|
| Matched | 5,014 | 83.0% | Amount and outcome agree on every side. |
| Differs in money | 13 | 0.2% | The amount differs; the difference is stated. |
| Differs in facts | 130 | 2.2% | One side only, or reversed outcomes. |
| Nothing to reconcile against | 702 | 11.6% | No statement, none for the currency, or an incomplete one. |
| Awaiting | 182 | 3.0% | No final status yet, or the payment falls into the next day’s statement. |
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.
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
| Payment | Provider | Reason | Your log | Statement | Source rows |
|---|---|---|---|---|---|
PAY-9D1C2 | Provider B | amount differs | 54.00 CUR-2 | 51.75 CUR-2 | log.csv · row 438stmt_B.xlsx · row 50 |
PAY-E4EBA | Provider B | amount differs | 61.00 CUR-2 | 59.68 CUR-2 | log.csv · row 1,304stmt_B.xlsx · row 159 |
PAY-23B60 | Provider G | charged, not credited | 275.00 CUR-2 | 275.00 CUR-2 | log.csv · row 45stmt_G.xlsx · row 4 |
PAY-C2C7B | Provider B | charged, not credited | 274.00 CUR-2 | 274.00 CUR-2 | log.csv · row 75stmt_B.xlsx · row 8 |
PAY-9CE0D | Provider J | credited, never paid | 215.00 CUR-5 | 215.00 CUR-5 | log.csv · row 240stmt_J.xlsx · row 9 |
PAY-77FDD | Provider J | credited, never paid | 52.00 CUR-2 | 52.00 CUR-2 | log.csv · row 382stmt_J.xlsx · row 12 |
STL-7C93 | Provider G | settled, no record | — | 61.00 CUR-4 | stmt_G.xlsx · row 263 |
STL-5BA9 | Provider P | settled, no record | — | 192.00 CUR-3 | stmt_P.xlsx · row 122 |
PAY-F3393 | Provider P | confirmed, then missing | 48.00 CUR-3 | — | log.csv · row 452 |
PAY-A76CE | Provider O | confirmed, then missing | 123.00 CUR-5 | — | log.csv · row 687 |
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
| Payment | Amount | Log | Notification | Statement | Source rows |
|---|---|---|---|---|---|
PAY-BC449 | 91.00 CUR-3 | declined | declined | success | log.csv · row 81stmt_C.xlsx · row 10 |
PAY-C49E6 | 21.00 CUR-3 | declined | declined | success | log.csv · row 780stmt_C.xlsx · row 70 |
PAY-310A8 | 37.00 CUR-3 | declined | declined | success | log.csv · row 1,537stmt_C.xlsx · row 137 |
PAY-FCCCC | 79.00 CUR-3 | declined | declined | success | log.csv · row 1,571stmt_C.xlsx · row 138 |
PAY-96883 | 344.00 CUR-3 | declined | declined | success | log.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.
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
| What | Detail | Payments |
|---|---|---|
| No statement at all | Provider Q | 106 |
| No statement at all | Provider S | 106 |
| No statement at all | Provider T | 101 |
| No statement for a currency | Provider D · CUR-1 | 223 |
| Incomplete statement | Provider H: 57 of 223 payments in the statement | 166 |
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