How do I group totals inside the RA file?

How do I group totals inside the RA file?

The RA file itself does not contain enough data to total different datasets. However, HYPEMedical can combine an RA file with data from its billing tables as a .csv download. The added data can filter the .csv file in MS Excel.

We knew that, eventually, users would need a report that we did not include in the original design of HYPEMedical. That is why .csv/MS-Excel downloads are available every time search results are displayed. The instructions below require access to HYPEMedical and a spreadsheet program like MS Excel, OpenOffice Calculator, WPS OfficeTools etc...  

Grouping RA data with MS-Excel: 
  1. Find the RA you need in Claims \ MCEDT Files \ Remittance Advice Files.
  2. Hover over the red arrow and select CSV [All Sections More Columns].
  3. Open the downloaded file in a spreadsheet (MS Excel) where you can sort, filter and even graph your RA's data. See movie below.







For intermediate MS Excel users:
A faster, more "advanced way" would be to create a Pivot Table with the data in MS Excel.
  1. High light all the columns as you have done above (movie) and choose the Pivot Table command button and click OK.
  2. Use the Pivot Table configuration panel (image to the right) to build an RA report of Submitted Amount and Paid Amount per doctor per clinic.





    • Related Articles

    • Where can find my RAs and transfer them to PDF?

      To Find your RAs click on Claims in HYPEMedical's main menu and choose MCEDT Files. HYPEMedical's main menu Once the MCEDT Files page loads click on the Remittance Advice Files tab. In the Remittance Advice Files tab hover over the red arrow and ...
    • The RA shows it's paid but HYPEMedical doesnt have the claim anymore?

      This most often occurs when users edit a submitted claim and resubmit it. The permision to edit claims in the Submitted status should be reserved for administrators. In the following example the service date was edited after the claim was submitted ...
    • Downloading an RA in Raw OHIP Format

      Did you know that one format HYPEMedical has for downloading an RA is in the same format that OHIP originally released it? Yes, in addition to the usual RA report in PDF and Spread Sheet formats a raw format may be required. A colleague may need to ...
    • I can't find one of my physician's RAs?!

      Search results are limited to 500 over the most recent six months, by default, within the MCEDT Files tabs. Use the Advanced Search Options (green band) to narrow your search. In the example below, limiting the search results with a date range and ...
    • Can I fax Manual Reviews and RA Inquiries?

      Yes. Fax Manual Review and RA Inquiry PDFs to MOHLTC at 905-434-4186, as per Bulletin Number: 210902