Accounts Payable Reconciliation Intelligence Dashboard by Yusuf AdetonaAccounts Payable Reconciliation Intelligence Dashboard by Yusuf Adetona

Accounts Payable Reconciliation Intelligence Dashboard

Portfolio project
Yusuf Adetona
Built a full-stack accounts payable reconciliation system from raw transactional data to executive dashboard, covering every layer of the data pipeline.
What was built: • Python pipeline to generate and clean 194,000+ AP records • PostgreSQL database with 6 analytical views (aging, risk scoring, 3-way matching, duplicate detection) • Power BI dashboard across 6 pages: Executive Summary, Exception Analysis, Supplier Risk, Three-Way Matching, Invoice Aging, Invoice Details
Key findings surfaced: • $193.5bn invoiced value · 72.5% payment coverage • 9,933 exceptions flagged · $39.7bn value at risk • 48 high-risk suppliers identified · 340 duplicate payments caught • 88.1% three-way match rat
Tools: Python · PostgreSQL · Power BI · DAX · SQL

0 likes · 0 views · Nov 14, 2026

End-to-end AP analytics, Python pipeline, PostgreSQL, Power BI, tracking $193.5bn across 802 suppliers.

Tags