Daily performance & revenue reporting
From raw transaction export to a 10-sheet workbook, on a schedule
- Role
- Designer and maintainer
- Period
- 2026 – present
- Status
- Client confidential
Overview
An AI-assisted, scheduled pipeline using Claude, Python and Excel that converts each day's transaction export into a performance and revenue workbook with routing recommendations.
Approach
- 01
What it produces
A BIN-by-MID matrix, MID and card-scheme performance, revenue tracking, poor-performer flags and routing recommendations.
- 02
Rules before charts
Standing data rules for field cleaning, metric definitions and correct roll-up of acceptance rates, documented as a repeatable procedure.
Outcome
- Manual analysis became a repeatable daily process
- Found and fixed a roll-up error that was understating BIN-level merchant acceptance rates
Technologies
- Python
- Excel
- Claude
- Scheduled tasks
Next project
Faktura
Open to consulting engagements
Have a payment problem that needs tracing?
Tell me which providers are involved and what is going wrong, or what needs to go live. I will tell you plainly whether I can help.
- Tell me
- Which providers and markets are involved
- Show me
- What is failing, or what needs to go live
- You get
- A plain answer on whether I can help