Daily Payment Reconciliation Patterns
159 daily snapshots • 6 channels • focus on approved vs pending/failed and fraud
Approved
Pending/Failed
Declined (Fraud)
Total Reconciled Flow
$711.2K
5,000 transactions across the full window
Feb 27, 2025 to Aug 20, 2025
Approved Value
$611.0K
Approved transactions cleared most of the throughput
85.9% of total value
Issue Exposure
$100.2K
Pending/Failed + Declined (Fraud) across 426 transactions
14.1% of total value
Highest-Risk Channel
D/A
$28.2K issue value concentrated here
21.1% of that channel's value
What stands out
- Issue value runs higher than issue count: 14.1% of value versus 8.5% of transaction volume.
- D/A carries the largest issue exposure, with $28.2K unresolved or failed value.
- The single biggest issue day was Jul 24, 2025 at $7.0K across 2 transactions.
Where breakdowns concentrate
- The top three channel-status slices already account for 42.6% of all issue value.
- The top six slices together explain 70.7%, so remediation can stay focused on a short list of patterns.
- Use the heatmap and Pareto views below to isolate whether concentration comes from steady channel friction or isolated spikes.
Daily trend by reconciliation status
Toggle between monetary value and transaction volume to compare status movement over time.
Channel status mix by value
100% stacked bars show how much of each channel's total value lands in approved versus issue states.
Pending/failed vs fraud amount by channel
Absolute issue value makes it clear which channels drive the largest reconciliation gaps.
Issue heatmap across time and channel
Darker cells mark days where pending/failed or fraud values spike for a specific channel.
Pareto view of issue-driving slices
Bars rank channel-status combinations by issue value; the line shows cumulative contribution.
Risk matrix: channel issue rate vs issue amount
Top-right channels combine high issue share and high absolute impact, making them the most urgent candidates for review.
Highest issue days
Largest combined pending/failed and fraud days by value.
| Rank | Date | Issue Value | Issue Volume |
|---|---|---|---|
| 1 | Jul 24, 2025 | $6,969.69 | 2 |
| 2 | Apr 17, 2025 | $4,040.76 | 4 |
| 3 | May 01, 2025 | $2,903.13 | 12 |
| 4 | May 17, 2025 | $2,652.59 | 12 |
| 5 | May 25, 2025 | $2,652.37 | 7 |
| 6 | Jul 08, 2025 | $2,484.68 | 1 |
| 7 | May 03, 2025 | $2,362.42 | 6 |