All templates

Automated Dolbey DNFB Days Reconciliation

Every Monday, WebRun opens Dolbey, calculates the average DNFB days across last week's discharged accounts, lines it up against finance's patient accounting number in Google Sheets, and drafts a summary email in Outlook flagging any gap worth investigating before it reaches a leadership report.

Runs on WebRun · Strict Lockdown policy
Every Monday at 6:00 AM WebRunorchestrates each step
1 Dolbey calculate DNFB days
2 Google Sheets reconcile against finance's number
3 Outlook draft the discrepancy summary
In short

Why do our DNFB days numbers differ between HIM and finance, and how do we reconcile them?

WebRun reconciles your DNFB days number before finance has to ask why it's different. Every Monday it opens Dolbey, calculates last week's average DNFB days, lines it up against finance's patient accounting figure in Google Sheets, and drafts an Outlook summary explaining any gap, left for the HIM director to confirm and send, so leadership sees one trusted number, not two competing ones.

  • Leadership sees one reconciled DNFB days number, not two disagreeing ones
  • Discrepancies get explained with likely accounts, not left a mystery
  • The HIM director confirms every explanation before finance sees it

Built for HIM directors · revenue cycle analysts · patient financial services · hospital 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 www.dolbey.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    Dolbey - calculate DNFB days
    dolbey.com
    WebRun in Dolbey: calculate DNFB days
    WebRun opens Dolbey to calculate DNFB days.
    • Open Dolbey and pull last week's discharged accounts still in DNFB status
    • Calculate the average DNFB days using your standard formula and exclusions
    • Note any account excluded for a documented reason, like a payer hold

    Done when Last week's Dolbey-calculated DNFB days figure is ready to compare.

  3. 2
    Google Sheets - reconcile against finance's number
    google.com
    WebRun in Google Sheets: reconcile against finance's number
    WebRun opens Google Sheets to reconcile against finance's number.
    • Paste finance's patient accounting DNFB days figure into the reconciliation tab
    • Calculate the gap between the two numbers and by how many accounts
    • Highlight the gap in red whenever it exceeds your tolerance threshold

    Done when Both numbers sit side by side with the gap calculated and flagged if it's out of tolerance.

  4. 3
    Outlook - draft the discrepancy summary
    microsoft.com
    WebRun in Outlook: draft the discrepancy summary
    WebRun opens Outlook to draft the discrepancy summary.
    • Draft a summary email explaining the gap, if any, and which accounts likely cause it
    • Leave the draft unsent in the HIM director's Outlook drafts folder for review
    • Send only after the director confirms the explanation with finance

    Done when A reviewable draft explanation exists whenever the two DNFB days numbers disagree.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
www.dolbey.com
ScheduleRuns automatically on this cadence
Every Monday at 6:00 AM
DeliveryHow each run's result reaches you
DNFB reconciliation · Google Sheets
OutputWhat each run produces - A side-by-side reconciliation of Dolbey's and finance's DNFB days numbers, with the gap explained.
Text
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

Will it send the reconciliation to finance without review?

No. The explanation is always drafted and left unsent in Outlook. The HIM director reviews and confirms it before it ever reaches finance.

Why would Dolbey and finance disagree on DNFB days?

Usually different exclusions, like payer holds or self-pay accounts counted differently. The reconciliation sheet shows the gap and the likely accounts behind it, instead of leaving it a mystery.

What if the two numbers match?

Then no discrepancy draft is needed that week. The sheet still logs both numbers so the match itself is on record.

Put this on autopilot.

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