Nate Moore

Nate Moore, CPA, MBA, FACMPE speaks, consults, records, and writes about Business Intelligence and Microsoft Excel in medical practices throughout the US.

[Nate Moore @PivotTableGuy]

@AskLyft Three Lyft drivers have cancelled on my pickup at the airport tonight. What’s going on?

[Nate Moore @PivotTableGuy]

Today’s podcast describes an unusual challenge — the billing company was not consistently and correctly charging the billed charge per the fee schedule.  The podcast describes how we used Excel’s Pivot Table feature to track variances in billed charges. 
https://t.co/cwsqb4WgTW

[Nate Moore @PivotTableGuy]

Are pre-authorizations giving your practice headaches, too?

https://t.co/k4NYgy01io

[Nate Moore @PivotTableGuy]

Are you tired of seeing payments reduced due to advanced practitioners and incident to billing rules?

You are not alone.

https://t.co/bcNMSFWCwx

[Nate Moore @PivotTableGuy]

Find patients who should have followed up by now but do not have a future appointment.

https://t.co/NVgIYDSCZa

[Nate Moore @PivotTableGuy]

Is estimating patient charges time consuming for your practice?

https://t.co/dXwaVjGxLB

[Nate Moore @PivotTableGuy]

Still thinking about payer transparency data and knowing what your competitors are getting paid?

So am I.

https://t.co/6raxS95OX1

[Nate Moore @PivotTableGuy]

Today’s BIG Idea is another way to look at your practice’s competitor’s contracts.  The graphic accompanying the podcast shows a OBGYN practice in Central Florida and how contracted rates vary widely in two counties.

https://t.co/nd51tIxLRl

[Nate Moore @PivotTableGuy]

Are your competitors being paid more for procedure codes than your practice is?

Would you like to see contracted rates by procedure code, payer, NPI number, and more?  I have an example of the data in the graphic accompanying today’s podcast.

https://t.co/ls8eaA1JVb

[Nate Moore @PivotTableGuy]

How long has it been since you analyzed your practice’s revenue cycle?
https://t.co/vtZZNvCN7a

[Nate Moore @PivotTableGuy]

oday’s podcast is from one of my sessions at the recent MGMA Leaders Conference in Nashville about following patients through your practice.  Which provider does the patient see first?  Where does the patient go next? 

https://t.co/mo5ItIy0Ud

[Nate Moore @PivotTableGuy]

Mine your clinical data. Today's example is from eMDs.

https://t.co/zV4d9l4s8V

[Nate Moore @PivotTableGuy]

Today’s podcast shows an example of a practice tracking new patients’ experience in the practice to see which patients end up being treated and which patients are not treated.

[Nate Moore @PivotTableGuy]

Need a new way to see your practice’s revenue cycle?

Waterfall reports for medical practices are a helpful way to trend payments. 

https://t.co/E4RpsuOnq1

[Nate Moore @PivotTableGuy]

Several podcasts have discussed tracking patients coming to a practice.  Have you tracked how patients leave your practice?

https://t.co/Bzj1IDH9xS

[Nate Moore @PivotTableGuy]

Reason and group codes are the way insurance companies communicate how and why your charges have been adjusted and not paid.  Today’s BIG Ideas podcast encourages you to review those codes to ensure you are being reimbursed appropriately.
https://t.co/ulrnxTjvJf

[Nate Moore @PivotTableGuy]

When you track new patients, you track the lifeblood of many practices. Listen to today's podcast.

https://t.co/ITTV0pAiQk

[Nate Moore @PivotTableGuy]

Today’s BIG Idea is to track urgent care referrals in your practice.  The question is how often the advanced practitioners who staff urgent care refer patients to other providers in the practice and which provider teams get more referrals. 

https://t.co/xht7qjhkIL

[Nate Moore @PivotTableGuy]

Today’s BIG Ideas podcast shows a Pivot Table, slicers, timeline, and Pivot Chart I built for a practice to track their E&M coding levels.

https://t.co/nMvoVactcp

[Nate Moore @PivotTableGuy]

This savvy practice administrator combined prevalence rates with census data to get the number of children by county to calculate an estimate of how many cases the practice could expect by county.
https://t.co/YU8Lu90zDH