Free and Legal 2020 RVU-RBRVS Calculator

Welcome to the free 2020 RBRVS Calculator.

As you may know, the AMA won’t let anyone provide a free RVU calculator that includes CPT codes due to their CPT copyrights. In an abundance of caution and, because in our unhappy experience, the AMA interprets its rights (in our opinion) overly broadly, we created this tool for those of you who have a CPT license that allows for a use such as this. In theory, that should mean any practice that submits insurance claims.

You can use this spreadsheet with the data that you can download from CMS to make a fairly sophisticated RVU calculator and payment analysis in about five minutes. This will allow you to fairly set your prices, analyze a payer contract, or double-check your expected payments. It also lets you perform a lot of other analysis tricks that the cool kids can figure out.

Why do I do all this work, especially for free?  Because I remain incensed that the very rule set used to determine what and how physicians are paid remains both obscure, obfuscated, and (partially) copyrighted and you either have to pay someone thousands of dollars for weak-ass software or super-nerd your way through it.  Obviously, as part of PCC's mission as a Benefit Corporation, I prefer the latter method and am glad to share my work with you.  

What does it do, technically? It allows you to choose your CMS-driven location, set a Medicare Multiplier, and then, on a code-by-code basis, determine your pricing level relative to Medicare. If you then take the time to include your code volume and pricing, it will determine your practice’s FACF (i.e., how much you charge, on average, relative to Medicare). If you then provide your payment information, it will compare them to the Medicare fee schedule for you.

What would you use this for?  Many things!

  • Ensure that your pricing is logical and supportable.  Enter your fees and see where you don't line up.
  • Compare your pricing to another pricing set - a fee schedule, perhaps, or another practice.  When you get that rate proposal from a payor, how else are you going to judge it?
  • You want to judge the real fee schedule for a payor.  If you have a contract from an insurance company that says you'll be paid 125% of Medicare (or whatever), this is your chance to confirm.  Enter your actual payments to see how they compare.  I always find mistakes from the payors when I compare their contractual fee schedules to what they actually pay!
  • Compare the fee schedules of two payors.  If you create two spreadsheets, one each for two different payors, you can enter in their payment information and conclude something like, "Payor A pays me 110% of Medicare, on average, while Payor B pays me 90%!"

The bottom line is that all insurance companies use the RBRVS, but they use it poorly or in a way that harms you.  Arm yourself with the data!

I've abandoned trying to make working models for both Excel and Libreoffice - I now have one that everyone should be able to use - just download the new version here.

How does it work?

  1. Download the Free 2020 RVU Calculator.
  2. Head to CMS and download the latest 2020 RVU zip file. This link can bring you to the 2020a release list of RVU files CMS hosts - note that this calculator only works for 2020! Look out for newer versions. You have to agree to the license and usage rules from CMS, of course.
  3. Extract the PPRRVU20*.csv file from the zip file. Note that the actual file name will change based on version of the RVU data file you download. You are essentially looking for a file that begins with "PPRVU," has the number 20, and ends in .csv and is larger than 2MB. It will have just under 17,000 CPT codes in it.  Note: the suggestion to import the CSV file is a change from previous years - apparently using the CSV file makes the matching happen more easily, especially for Excel users, due to data type definitions.  You can also open the .xls version, of course.
  4. Cut and paste the entire page of data from the PPRRVU20*.csv file into the tab marked “PPRRVU20_JAN.csv″ in the RVU Calculator spreadsheet. Don’t panic if it seems to freeze for a minute, it’s a lot of data.  Note that with multiple updates to the RVU file every year, you may not have a "JAN" file - that's OK.
  5. Go to the middle tab, "GPCI20."  Scroll down until you find your locality.  Once you locate it, copy the four fields for step 6 - you want the name and then then 3 numbers that follow.
  6. Go back to the first tab, "Front Page," and paste your GPCI results into the cell E6.  It should overwrite the Name and 3 GPCI value fields.
  7. Pick a Medicare Multiplier in B6 or leave it at 100%. Then, enter some CPT codes in column A. Gasp in amazement.
  8. Put some unit volumes, prices, and payments in and watch what happens.

Note that any light green field is where you are expected to add your own information.

Huge Improvements since 2019:

  1. I cleaned up some of the visuals to make it easier to read.  And I changed the layout of the data input fields (columns A-D) to make it a lot easier to add data.
  2. I extended the math to work with up to 240 codes or so, now.  I also cleaned up column headers, etc.  Wow, I was messy.

Go crazy, tell me what you found.

Comments

1 Comment