Services

Five areas, one model underneath.

Each service reads from the same data model, so you can start with one and add the rest without rebuilding anything.

01 · Pipelines

Data pipelines and data model

We connect your EHR or practice management system, billing, bank and general ledger and land them in one model with written definitions.

What we deliver

  • Scheduled pipelines from each source
  • A documented model in Power BI or Microsoft Fabric
  • Late-file alerts that name the file
  • A data dictionary your team can read

What we need from you

  • Read access to exports or APIs
  • One person who knows where each file comes from

What changes for you

Reports stop depending on one person's spreadsheet.

Example architecture from source systems to a model and three outputs. EXAMPLE ARCHITECTURE EHR / PMBillingBankGeneral ledger Pipelines On a schedule Late file One alert names the file Model EncountersClaimsPaymentsGLBoard packMonthly reportsAI briefing
Example architecture from source systems to a model and three outputs. EXAMPLE ARCHITECTURE EHR / PM Billing Bank General ledger Pipelines, on a schedule Late file Model Encounters · Claims Payments · GL Board pack Monthly reports AI briefing

02 · Power BI

Power BI and reporting

The monthly reports and the board pack, built on the model and published after the close.

What we deliver

  • Board pack
  • Manager reports by site, provider or payer
  • One definition per measure
  • Access set by role

What we need from you

  • Your current reports, even rough ones
  • Who reads what

What changes for you

Everyone reads the same figures.

Board pack summary page. Sample with made-up numbers. Board pack March SAMPLE · MADE-UP NUMBERS Net revenue 1,842,610 +2.4% Collections 1,610,440 +1.1% Days in AR 41 -3 days Operating margin 18.6% +0.8 pt Net revenue, trailing 12 months J F M A M J J A S O N D This year Prior year Payer mix Commercial 42% Medicare 31% Medicaid 16% Other 11% Top denials Timely filing 42 Billing Auth missing 28 Front desk Coding 19 Coding Duplicate 11 Billing Eligibility 8 Front desk

03 · Close

FP&A and the monthly close

We run the month-end close with your accountant, keep a rolling forecast and track cash.

What we deliver

  • A close checklist with owners
  • P&L matched to the general ledger
  • Variance explained in plain words
  • Rolling forecast and cash view

What we need from you

  • General ledger access
  • Your accountant's close calendar

What changes for you

The close finishes with the variance explained.

Example architecture of the monthly routine, in step order. EXAMPLE ARCHITECTURE Monthly routine 01 Files refresh 02 Reconcile 03 Close and variance 04 Publish board pack Who does the step DDH Your team In step order

04 · Reconciliation

Reconciliation and accounts receivable

Deposits, remittances and the general ledger matched every month, with the open money assigned to people.

What we deliver

  • Monthly bank-to-remittance-to-ledger match
  • Weekly view of claims past 90 days
  • Underpayments checked against contract rates
  • A denials list with an owner per item

What we need from you

  • Remittance files and bank statements
  • Your payer contract rates

What changes for you

You know where the cash is and who is chasing it.

Reconciliation summary

October

SourceStatusAmount
Bank depositsMatched1,842,610
Remittances matchedMatched1,836,440
General ledgerMatched1,836,440
Still openOpen6,170
PayerOpen itemStatusAmount
AetnaShort payOpen2,140
MedicareUnmatchedUnmatched3,410
CignaClears next monthOpen620
Sample with made-up numbers

05 · Automation

AI and automation

Scheduled reports, late-file alerts and a short briefing email from your Outlook, built in your environment.

What we deliver

  • Scheduled report delivery
  • Late-file alerts
  • A weekly or monthly briefing email
  • Written prompts and checks you can review

What we need from you

  • A Microsoft 365 tenant
  • Who should receive what, and when

What changes for you

The numbers arrive before anyone asks.

Start with the free Reporting Review

Send the short form. We reply the same day, find a time for a call, and send you a written assessment of your reporting. It costs nothing, and you keep it whether or not we work together.

Prefer email? contact@ddhbiconsulting.com · Or book a call