Saved Queries
Your library of saved, shared, and scheduled data queries
Total Queries
8
4 shared with team
Starred
4
Quick access favorites
Scheduled
3
Auto-running queries
Total Runs
223
Across all queries
Daily KRA Collections Summary
ScheduledAggregated daily collections for Kenya Revenue Authority across all channels
Bill AllelaLast run: 2025-06-14 06:0042 runs
KRADailyCollections
Failed Transactions — Last 7 Days
All failed transactions across MCDAs in the past week for investigation
Bill AllelaLast run: 2025-06-14 09:1518 runs
FailedInvestigation
M-Pesa High-Value Transactions
M-Pesa transactions exceeding KES 10M for compliance monitoring
Jane MuthoniLast run: 2025-06-13 14:3031 runs
M-PesaHigh-ValueCompliance
County Revenue Comparison
Side-by-side revenue comparison for all county governments
Peter KamauLast run: 2025-06-12 11:0015 runs
CountyComparison
Unreconciled Transactions > 48hrs
ScheduledTransactions pending reconciliation for more than 48 hours
Bill AllelaLast run: 2025-06-14 08:0028 runs
ReconciliationAgingAlert
PSP Settlement Performance
Settlement timing and success rates by Payment Service Provider
Jane MuthoniLast run: 2025-06-13 16:0022 runs
PSPSettlementPerformance
NTSA Revenue by Service Type
Breakdown of NTSA collections by individual service type
Peter KamauLast run: 2025-06-14 07:3012 runs
NTSAService Breakdown
Monthly Trend — All MCDAs
ScheduledMonthly collection trends for all MCDAs over the past 12 months
Bill AllelaLast run: 2025-06-14 06:3055 runs
TrendMonthlyAll MCDAs
Select a query to view details
Click on any query from the list