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.





    • Related Articles

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

      To Find your RAs hover over 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 ...
    • 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 ...
    • Updating QuickClaim with a new SOB zip file

      Updating QuickClaim with a new SOB zip file UNZIP the downloaded SOB file. Please note that this file is only meant to be machine readable. Please do not open the file after you unzip it. Open QuickClaim Click on Codes Have Disk Browse (to the ...
    • How can I find the claims that OHIP has rejected?

      HYPEMedical automatically downloads and processes your OHIP reports. One of these reports, the Error Report, is automatically downloaded and processed by HYPEMedical. Processing the Error report flags claims with errors as Rejected Claims. To find ...
    • OHIP Explanation Codes 55 and 57

      There are cases where OHIP determines that certain service codes were “not paid properly” on past claims. The processes that OHIP uses to fix such cases can seem to be confusing. Explanation codes 55 and 57 seem to show that OHIP pays and then takes ...