All templates

Automated Verity Contract Pharmacy Claim Recon

Every Monday, WebRun opens Verity Solutions, pulls the past week's contract pharmacy dispense claims, checks each one against the TPA gateway record it should match, logs any discrepancy in Smartsheet, and emails your 340B team a reconciliation report through Outlook.

Deploy this workflow Browse all templates
Runs on WebRun · Strict Lockdown policy
Every Monday at 7:00 AM WebRunorchestrates each step
1 Verity Solutions pull contract pharmacy claims
2 Smartsheet log claim discrepancies
3 Outlook email the reconciliation report
In short

How do I reconcile contract pharmacy claims against TPA gateway records automatically?

WebRun reconciles your contract pharmacy claims every Monday. It pulls the week's dispense activity from Verity Solutions, checks each claim against its TPA gateway record, logs any mismatch or missing match in Smartsheet, and emails your 340B team a ranked reconciliation report in Outlook, so discrepancies get caught weekly instead of piling up until the next audit.

  • Claim mismatches get caught weekly instead of at the next audit
  • Every contract pharmacy claim is checked against its TPA record, not just a sample
  • The largest dollar discrepancies surface first so they get worked first

Built for 340B program managers · contract pharmacy administrators · covered entity compliance officers · health system finance teams

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens app.verity-solutions.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    Verity Solutions - pull contract pharmacy claims
    verity-solutions.com
    WebRun in Verity Solutions: pull contract pharmacy claims
    WebRun opens Verity Solutions to pull contract pharmacy claims.
    • Open Verity Solutions and pull the week's contract pharmacy dispense claims
    • Match each claim against its TPA gateway record
    • Note claims with a missing match, a price mismatch, or a status still pending

    Done when Every contract pharmacy claim from the week has been checked against its TPA record.

  3. 2
    Smartsheet - log claim discrepancies
    smartsheet.com
    WebRun in Smartsheet: log claim discrepancies
    WebRun opens Smartsheet to log claim discrepancies.
    • Log each unmatched or mismatched claim with the pharmacy, NDC, and dollar difference
    • Carry forward any prior week's discrepancy that is still open
    • Mark discrepancies resolved once Verity Solutions shows a clean match

    Done when The discrepancy log reflects every open and resolved item for the week.

  4. 3
    Outlook - email the reconciliation report
    microsoft.com
    WebRun in Outlook: email the reconciliation report
    WebRun opens Outlook to email the reconciliation report.
    • Draft a reconciliation report summarizing matched claims and open discrepancies
    • List the largest dollar discrepancies first
    • Send the report to your 340B team distribution list

    Done when Your team has this week's reconciliation report in their inbox.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
app.verity-solutions.com
ScheduleRuns automatically on this cadence
Every Monday at 7:00 AM
DeliveryHow each run's result reaches you
Reconciliation report · Outlook
OutputWhat each run produces - A weekly list of contract pharmacy claims checked against TPA gateway records, with discrepancies logged and ranked by dollar amount.
Reconciliation report
Setup & safety

Secure by default

Connect once, stays signed in

WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

Does it resolve discrepancies on its own?

No. It logs and ranks every discrepancy so your team can investigate, but resolving a claim in Verity Solutions is always a manual step your team takes.

What counts as a discrepancy?

A contract pharmacy claim with no matching TPA gateway record, a price that does not match, or a status still pending after the expected turnaround.

Does the report go to anyone outside our team?

No. It emails only the internal distribution list you set up. Nothing goes to the contract pharmacy or the TPA directly.

Keep going

Related templates

Automated Verity 340B Recertification Reminders
Every year, WebRun opens Verity Solutions, pulls your covered entity's current registration data, checks it against your HRSA OPAIS profile, and drafts the recertification update in Outlook, leaving it for your authorized official to file.
Verity Solutions›HRSA OPAIS›Outlook
Automated Verity Duplicate Discount Flags
Every few minutes, WebRun opens Verity Solutions, checks new claims against your Medicaid billing indicator, flags anything at risk of a duplicate discount, logs it in Airtable, and posts a Slack alert so your team can resolve it before the claim goes out.
Verity Solutions›Airtable›Slack
Automated Verity HRSA Audit Evidence Packs
When an audit request arrives, WebRun opens Verity Solutions, pulls the policies, claim samples, and contract pharmacy agreements an auditor will ask for, organizes them in Box, and emails your compliance officer the pack to review before anything goes to HRSA.
Verity Solutions›Box›Outlook

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.

Deploy this workflow Talk to us