ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Order-to-payout reconciliation
3
Demonstration using synthetic data. September 2026. USD.
4
5
MetricAmount / countActions supported by the sample
6
Imported rows25ORD-1012: reported transfer is $12.50 below the calculated amount.
7
Duplicate copies excluded1ORD-1023 and ORD-1024: no transfer amount supplied; check payout timing.
8
Unique orders24Source row 25: exact duplicate of source row 5; excluded once.
9
Gross merchandise charges$3,260.00All order identifiers were trimmed; numeric text became typed amounts.
10
Discounts$60.00No customer names, addresses or email addresses are needed for this check.
11
Shipping collected$80.00
12
Tax collected$256.00
13
Refunds$75.00Definitions and limits
14
Processing fees$109.74Expected transfer = gross - discount + shipping + tax - refund - fee.
15
Expected net transfers$3,351.26Difference compares reported transfers only with their matching orders.
16
Reported transfers$3,052.41Blank transfer amounts remain unknown; they are never replaced by zero.
17
Expected for reported rows$3,064.91Refund is total cash refunded, including any tax/shipping adjustment.
18
Unexplained difference($12.50)This checks supplied exports. It does not measure profit or verify a bank balance.
19
Orders awaiting transfer data2
20
Expected transfers still unmatched$286.35
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100