AdvancedMD Reporting: What AMD Reports Can’t Tell You

Canned reports, no analytics

Every report answers one question for one date range; nothing is trended or benchmarked. The custom builder can’t answer important questions even with an analyst. Here is where it falls short, with screenshots, and what real AdvancedMD analytics looks like.

Voyant Denials Dashboard on AdvancedMD data

Denials Analytics for AdvancedMD: actionable intelligence by denial code, denial category, payer, CPT, ICD, and much more.

Onboarding in 5 minutesFree 30-day trial

Ten things AdvancedMD reporting can’t tell you

AdvancedMD has a report for almost everything. Each one is a list for a date range. These are the questions the lists don’t answer, with or without AdvancedInsight.

Is this month better or worse than last, and why?

The Financial Dashboard shows an arrow and a sparkline per tile. Every report is a single run for a single date range. Nothing connects the two, so “why” is still a spreadsheet exercise.

Why did denials spike, and which two payers caused it?

Carrier Denial Analysis is a list by carrier for a date range. No trend, no denial rate by CPT × payer × provider, no way to isolate the payers driving a spike.

Who is working the denials, and in what order?

Denial Tracking Detail lists denials. It does not prioritize them by dollars at risk, track appeal outcomes, or tell you which ones nobody has touched.

How productive is my billing team?

Nothing reports productivity by biller or by function, and nothing goes beyond touches to actual results: charges posted, payments posted, claims resolved. You can’t tell a volume problem from a people problem.

Which referral sources produce revenue, not just visits?

The Marketing and Referral reports count referrals. Revenue per referring provider, by location, over time, means joining three exports in Excel every month.

Are payers paying what the contract says?

You can see what each carrier paid. Nothing compares it to what your contract says you should have been paid, by CPT, and hands you the underpayments.

Did every visit become a claim?

Unbilled and Held-in-Unbilled reports show what is sitting in the queue. Visits that never became a charge at all are found by comparing the schedule to charges by hand.

What are my KPIs, and how do they compare?

Net Collection Rate is a report. First-pass rate, denial rate, net collection rate and days in AR trended on one screen, against benchmarks for your specialty and payer mix, is not.

Can I see all my clients together?

If you are a billing company with clients on their own AdvancedMD instances, there is no consolidated reporting across them – and none across AdvancedMD and the Tebra or eCW practice you also bill for.

Why did this claim deny six months ago?

AdvancedMD holds remittance (835) detail for a limited rolling window. After that, the line-level denial reasons for older claims are no longer in the system, so denial trends with any history cannot be built from what AdvancedMD still has.

Reporting is not analytics

As we wrote in How to Create Great Medical Billing Dashboards, what most vendors call “analytics” is standard reporting with a chart on top. AdvancedMD’s Financial Dashboard is a good example: it is better than most, and it still can’t answer a question.

Reporting (what AdvancedMD gives you)

  • What happened: a total, an arrow and a sparkline
  • One report, one date range, one grouping per run
  • Exports to PDF and Excel that you then analyze
  • A custom builder that can’t answer the important questions, analyst or not

Analytics (what the questions above need)

  • Why it happened, where, and what to do about it
  • Trends, comparisons and benchmarks on one screen
  • Drill from a KPI to the payer to the claims
  • Updated for you, every night

The Financial Dashboard

Eight tiles – days in AR, total AR, unbilled, excluded, encounters, charges, payments, adjustments – each with a month-over-month arrow and a sparkline. It is the right idea. Then look at the numbers: Unbilled is 4, down 275%. Excluded is 1, down 600%. Percentage change on a count of four is noise dressed up as a signal, and there is nothing to click. You cannot see which payer moved AR, which provider’s charges dropped, or which claims make up the 120+ bucket on the right.

The AR chart beside it is a snapshot by aging bucket. No trend, no payer split, no comparison to last quarter. The Claims Efficiency grid is days-in-process averages with no list of the claims behind the red cells.

AdvancedMD Financial Dashboard with eight KPI tiles, an AR aging chart and a claims efficiency gridClick to enlarge
AdvancedMD PM Financial Dashboard (AdvancedMD sample data). Arrows and sparklines, no drill-down; “Unbilled 4, down 275%.”

The Report Center: a report for everything, one question at a time

The Report Center is AdvancedMD’s report menu, and it is the system’s real strength: dozens of categories, each with several reports, parameters for office keys, carrier ranges, aging buckets and four different aging dates. It is also where the time goes.

AdvancedMD Report Center home: 27 report categories, recently run reports and recommended reportsClick to enlarge
Report Center home: 27 categories in the left rail, a “Recently Run” list, and AdvancedMD’s own recommendations.

AdvancedMD’s own advice: run a report every month and work it by hand

The Report Center recommends the Missed Visits report “monthly, to generate a list for the billing staff to identify appointments that do not yet have charges posted”, to be used “as a worklist”. That is the vendor describing visit-to-claim reconciliation as a monthly manual job. In an analytics product it is a nightly exception list that empties itself.

Below it, Unbilled Claims is recommended “daily”, again as a list for a biller to work through. Daily report, daily list, daily person.

AdvancedMD Report Center showing the Carrier A/R Detail report parameters: office keys, carrier range, aging buckets and aging dateClick to enlarge
Report Center, Carrier A/R Detail. Pick the office keys, the carrier range, the aging buckets and the aging date. Run. Export. Repeat for the next question.
One date range, one answerEvery report is a snapshot for the range you entered. To see whether AR by payer is getting better or worse you run the same report for six months and line the exports up yourself.
Carriers by code range, not by nameCarrier selection is a low-to-high code range. Comparing three specific payers means three runs, or one run and a filter in Excel.
Grouped by office key, exported groupedMulti-key reports group by key. The export carries the grouping, so the first thing you do with the file is flatten it.
Run, wait, download, repeatA Carrier A/R Detail run in our recording sat on “Report is being generated” for 24 of 48 seconds, then produced an Excel file. Ten clients, five reports each, once a month: that is a day.
Nothing talks to anything elseCarrier Denial Analysis, Collector User Productivity, Net Collection Rate and the referral reports each live on their own. The question that spans two of them is a manual join.
24 secof a 48-second screen recording spent on “Report is being generated” for one Carrier A/R Detail run
4reports to answer “why is AR up”: Carrier AR Detail, Carrier Denial Analysis, Unbilled Claims, Elapsed Time
6×the same report, to get a six-month trend of anything
0benchmarks, anywhere in the Report Center
1office key group per export, flattened by hand

Stop running Report Center jobs by hand. See your own data in a real dashboard in about 5 minutes.

AdvancedInsight: pay extra, hire an analyst, still no answers

AdvancedInsight is the custom report and dashboard builder, and it is a separate package: CPT and modifier level reporting isn’t in the base product. With an analyst you can build more – which is expensive, and most practices and billing companies don’t have one. Even with one, the questions above stay unanswered, because the data model underneath has sharp edges.

Build from scratchA charges-detail, payments or balances report starts empty. You pick the source, drag the fields, set the prompts and fix the layout. Each practice wants it slightly different.
Copying a report means copying XMLTo reuse a report in another login you copy it to the clipboard as XML, paste it into Word, open the other login, create a blank report and paste the XML back. That is the supported path.
No last-modified dateThere is no reliable last-modified field on charges and payments, so there is no way to pull only what changed since yesterday. Every refresh is a full re-extract.
Entry date means two thingsThe entry (post) date is defined differently for a charge and a payment. Put both in one report and each lands on its own row with its own entry date.
Keys that don’t holdOn one extraction we found multiple visit numbers for the same patient, date of service, CPT and modifier – and two different records sharing one visit number. Every downstream join has to be defensive.
Permissions you have to ask forCustom reports need access to the underlying data sources, and that access is not on by default. Until AdvancedMD support grants it, Select Source shows an empty folder and the report builder is a dead end.
The basic report that isn’t thereA charges-detail report with encounter and line-item fields is the most basic thing a billing team needs. The standard reports do not have one with enough fields, so it has to be built in AdvancedInsight.
Another package to buyCPT and modifier level reporting is not in the base product. You pay extra for AdvancedInsight, and what you get is a blank canvas.
2definitions of “entry date” in the same report
0last-modified dates to drive an incremental refresh
7steps to move one custom report to another login
800patients with duplicate visit keys in one quarter of one client’s data

Every problem above, answered

The pages in the Voyant application, connected to your AdvancedMD data. Demo data shown.

RCM

AR by payer, provider and age bucket, trended nightly. Days in AR by payer.

Voyant RCM pageClick to enlarge

Denials Dashboard

Denial rate by CPT, diagnosis, payer and provider, trended, with the payers driving a spike one click away. Built from 835 remittances captured continuously at scale, parsed and normalized into Voyant’s central database, so denial history does not disappear when AdvancedMD’s window rolls over.

Voyant Denials Dashboard pageClick to enlarge

Drill Down – Denials

Denial patterns, appeal success rates, affected claims prioritized by dollar value.

Voyant Drill Down - Denials pageClick to enlarge

Marketing – Sales

Referral sources, marketing ROI, and your most valuable referral relationships.

Voyant Marketing-Sales pageClick to enlarge

Charge Recon

Encounters that never became claims, tracked until resolved.

Voyant Charge Recon pageClick to enlarge

Payment Integrity

Underpayments and contract variances by payer and CPT, caught automatically.

Voyant Payment Integrity pageClick to enlarge

Productivity

Charges posted, payments posted, claims worked per biller and per provider, trended. Try the free RVU calculator for the compensation math.

Voyant Productivity pageClick to enlarge

Benchmarking

First-pass, denial, net collection and days in AR, trended, with targets by specialty and payer mix.

Voyant Benchmarking pageClick to enlarge

Workflow

Worklists by age, balance, payer and denial code so nothing falls through the cracks.

Voyant Workflow pageClick to enlarge

Practice Management

Charges, payments and AR as trends against a working-day baseline.

Voyant Practice Management pageClick to enlarge
QuestionAdvancedMDVoyant AdvancedMD Analytics
Productivity by biller and by function, results not touchesNoYes
Denial rate by CPT × payer × providerList by carrierYes, with drill-down
Denial worklists prioritized by dollars, appeal trackingNoYes
Revenue by referral source, by location, trendedReferral countsYes
AR by payer, trendedSnapshot per runYes, nightly
Visit-to-claim reconciliationUnbilled queue onlyAutomatic
Underpayment detection vs. your contractNoYes
KPIs trended, with benchmarksNo benchmarksYes
Clients on separate AdvancedMD instances, and other PM systems, in one viewNoYes
Same claims by four date types, side by sideOne per runYes
Incremental nightly refreshFull re-extractYes

Start free 30-day trial

How onboarding works

1

Sign the HIPAA BAA and provide AdvancedMD credentials. Less than 5 minutes. No IT department required.

2

We extract your historical data. Typically 3–5 days depending on size, due to AdvancedMD system limitations.

3

Data updates automatically – every night, or in real time, depending on your needs. You keep using AdvancedMD for billing exactly as today.

Built by people who understand healthcare data

We understand RCM

Our founders built and sold a large national medical billing company. Every feature solves a problem we lived with.

Actionable data, not data vomit

Your denial rate spiked; here are the 2 payers causing it, the procedures, and the claims to work.

Permissionless access

No AdvancedMD fees, no clearinghouse contracts. We extract the data you’re entitled to without vendor cooperation.

Plug-and-play

Already built and proven. Extract your history and you’re running in days, not months.

AI, on data that is ready for it

We use AI to flag anomalies, classify denials and surface what to work next. It works because the data underneath is clean and structured first; that is the part most RCM AI projects skip.

Multi-system consolidation

Several AdvancedMD office keys, or AdvancedMD plus Tebra, eClinicalWorks or any other PM system, in one dashboard.

Connect AdvancedMD in 5 minutes. Free 30-day trial, nothing charged until day 31.

Frequently asked questions

Does this work with my AdvancedMD setup?

Yes. We work with current AdvancedMD PM instances, with or without AdvancedInsight, and across any number of office keys. If you have an unusual configuration, book a call and we’ll confirm.

Do I need AdvancedMD’s permission, the API, or AdvancedInsight?

No. We extract the data you already have access to by connecting directly to your system. No API license, no AdvancedInsight subscription, no vendor cooperation, no clearinghouse contract.

Can I combine several office keys, or AdvancedMD and another system like Tebra or eClinicalWorks?

Yes. Any number of keys and systems roll into one reporting platform. This is especially useful for billing companies with clients on several systems, and practices with multiple EHRs or a legacy system that want to keep data integrity.

How long does setup take?

Onboarding takes less than 5 minutes. Historical data extraction typically takes 3–5 days depending on size. Once live, data updates every night, or we have a real-time option.

Is my data secure?

We are fully HIPAA compliant and keep all data strictly confidential. We never sell your data.

Do I need to change my billing workflow?

No. You keep using AdvancedMD for billing exactly as you do today. Voyant is the analytics layer on top, and can also provide opportunities for improved workflow. Talk to us to learn about our Workflow module or automation tools.

How much does it cost?

Pricing depends on the number of providers and systems, and whether you are a practice or a billing company. Every plan includes a free 30-day trial and a 30-day money-back guarantee. Book a call for full pricing.

Can I cancel anytime?

Yes. No long-term contracts, cancel anytime, and a 30-day money-back guarantee.

Also for Tebra / Kareo users: Tebra dashboard. eClinicalWorks users: eCW reporting. Other systems: RCM analytics.