Here is a simple excel sheet that you can use to calculate the total RVUs you made in a particular day.
Just enter the number of patients you saw with a particular billing and it shows the total number of RVUs. It also calculates the total number of patients you saw on a particular day so you don’t miss any RVUs.
I got the actual RVU values from CMS website page “Search the Physician Fee Schedule” and then I added to the excel sheet.
Medicare stopped recognizing and paying for old consult codes. Per Medicare, consult codes need modification as below. [So the RVU for consults is not very clear at this point. The excel has RVU for consults based on old info.]
Citation from CMS | Inpatient Hospital Services
The CMS Claims Processing Manual, Chapter 12, §30.6.9 F
Physicians may bill initial hospital care service codes (99221-99223), for services that were reported with CPT® consultation codes (99241 – 99255) prior to January 1, 2010, when the furnished service and documentation meet the minimum key component work and/or medical necessity requirements.
Physicians may report a subsequent hospital care CPT® code for services that were reported as CPT® consultation codes (99241 – 99255) prior to January 1, 2010, where the medical record appropriately demonstrates that the work and medical necessity requirements are met for reporting a subsequent hospital care code (under the level selected), even though the reported code is for the provider’s first E/M service to the inpatient during the hospital stay.
Download the Hospitalist Physicians Daily RVU calculator Excel sheet below