Browse categories
Explore
Fiverr Pro
English
$
USD
I will automate awp discount and mac pricing reconciliation
Bryan Tracy
About this gig
I will build an automated pharmacy pricing reconciliation workflow that compares contractual pricing rules against claims, invoice, or transaction data.
The system can help identify AWP discount deviations, MAC pricing discrepancies, dispensing fee variances, reimbursement differences, and other pricing exceptions.
I can automate:
- AWP discount validation
- MAC pricing reconciliation
- Contract pricing validation
- Expected vs actual reimbursement
- Dispensing fee checks
- Pricing discrepancy detection
- Exception reporting
- Automated Excel or CSV reports
- Pricing dashboards
The workflow can be designed around your existing data and processes, including Excel, CSV, databases, APIs, or other structured sources.
This service provides software automation and data analysis, not legal, accounting, or regulatory advice.
Send a message today lets get started.
Get to know Bryan Tracy
Bryan Tracy
Healthcare and Pharmacy Automation Specialist
- FromUruguay
- Member sinceSep 2026
Languages
English, Spanish, French, German, Italian
I build healthcare and pharmacy automation systems that simplify complex reconciliation, auditing, and compliance workflows. My expertise includes PBM contract reconciliation, pharmacy claims and pricing audits, AWP discount validation, rebate reconciliation, revenue leakage detection, healthcare payment reconciliation, and product recall workflows. I create practical solutions using APIs, databases, spreadsheets, OCR, and workflow automation to reduce manual work, detect discrepancies, and deliver clear reports, dashboards, and audit trails.
FAQ
Can you automate AWP discount calculations?
Yes. If the applicable AWP values and contractual discount terms are available, I can build a workflow that calculates expected pricing and identifies potential deviations.
Can you reconcile MAC pricing?
Yes. MAC pricing rules can be incorporated into the reconciliation workflow when the relevant MAC data and contractual rules are provided.
Can you compare expected and actual reimbursement?
Yes. The system can calculate expected values based on the supplied rules and compare them with actual transaction or payment data.
Can you work with Excel and CSV?
Yes. Excel and CSV are supported input formats. Depending on the project, I can also work with databases and APIs.
Can you check dispensing fees?
Yes. Dispensing fee rules can be incorporated when the applicable contractual terms and transaction data are available.
Can you identify pricing discrepancies automatically?
Yes. Custom variance rules can be created to flag pricing differences and organize them into an exception report.
Can you create a pricing dashboard?
Yes. Dashboard functionality can be included depending on the selected package and project requirements.
Can you connect the system to an API?
Yes. API integrations can be developed when the required API documentation and access are available.
Can you work with NDC data?
Yes. NDC fields can be incorporated into the reconciliation workflow when they are present in the supplied data.
Does this service provide regulatory or legal advice?
No. The service focuses on software automation, data processing, pricing calculations, reconciliation, and reporting. Legal, accounting, or regulatory interpretation should be handled by the appropriate qualified professional.
