Hospital Health Fund Fees – Importing DRG Fees

FYDO now has the option to import DRG fees from an Excel file.
It is important to note that the file must be an Excel file, and must be set out in the same way as the sample template below. 

Or click the link below to download a blank template:

DRG-Import-Example

Using the same column titles as can be seen in this spreadsheet example. 

Column headings need to be:
A – DRG
B – ChargeSD
C – ChargeIP
D – SSTrim
E – SSFee
F – LSTrim
G – LSFee
H – TRF
I – TRFDisc
J – GST

The above layout reflects the content, and order of information, that is displayed in FYDO.

If the file is not formatted in this way, with the exact column titles, the data will not be able to be imported into FYDO, or will upload into the wrong fields.

How to Format an Excel File for DRG Upload

Data from a Health Fund contract can be transferred into the relevant columns of the template, or a copy of a contract can be modified using the following steps:

  1. Save a copy of the contract (do not edit the master copy)
  2. Go to DRG tab or section in the contract
  3. Remove any lines above the DRG header table so that there is only one header row
  4. Delete any columns that do not contain the required information as per the images above
  5. Ensure the names and order of all columns and the header row match the template exactly

How to Upload DRG File into FYDO

  1. Go to Settings & select Fees Setup

  1. Choose your location from the dropdown menu (only applicable to multi-site users)
  2. Select required Fund
  3. Ensure Same Day Fees tab is selected and Click Edit

  1. Update Start of Current Fee and End of Current Fee dates
  2. Click Save

  1. Click DRG Fees tab
  2. Click Edit

  1. Click More Actions and select Click to move all Current fees to Old and follow instructions – this step is optional, however it is recommended as it ensures that episodes prior to the new contract dates are billed at the appropriate rates, otherwise all unbilled episodes will be billed at the newly loaded rates
  2. Click Save

  1. Click Edit
  2. Click More Actions and select Import Fees

  1. Click Fee Type and select Current File

  1. Click Upload DRG Fees File and locate the relevant Excel file to be uploaded
  2. Click Upload

  1. DRG items and fees will populate into the DRG Fees tab
  2. Click Save
  3. Select Print to print or download, then conduct a spot check with the contract to ensure fees have populated correctly

Note:  If a DRG no longer exists in the new fees, but there was an old rate, the line will remain in the fees screen and Current will show as $0 (Old will show the previous rate).  If a DRG has a zero-dollar balance under the Current fees AND the Old fees, FYDO will automatically remove this line from the fees page, as it is no longer required.