SQL Workbench
Execute ad-hoc SQL queries against live PostgreSQL data · Read-only mode (SELECT queries only)
Template Queries:
1. Find all mismatches across all runs
2. Top 10 largest amount discrepancies
3. Transactions missing in bank
4. Unresolved issues older than 7 days
5. Match rate by run summary
6. Daily upload volume
7. Transactions by currency breakdown
8. Full reconciliation results for latest run
SELECT rr.transaction_id, rr.match_status, rr.bank_amount, rr.internal_amount, rr.amount_diff, run.bank_filename, run.run_date::date FROM reconciliation_results rr JOIN reconciliation_runs run ON rr.run_id = run.id WHERE rr.match_status != 'matched' ORDER BY ABS(rr.amount_diff) DESC NULLS LAST;
Press
Ctrl + Enter
to execute
Run Query