Specialty pharmacy
Texas
Three systems, one source of truth
- The problem
- Pharmacy software, PBM remittances and payment summaries never agreed. Finding short-paid and unpaid prescriptions meant weeks of manual cross-checking in spreadsheets.
- What we built
- A desktop app that ingests all three sources, matches every prescription, compares expected and actual payment claim by claim, and builds payment cascades by month.
- The result
- Month-end reconciliation became a one-click run, with short and unpaid claims visible instead of buried.
- Data reconciliation
- Python
- Desktop app
- Excel export