How to import health fundĀ fees from an excel file

This tutorial will show you how to import MBS Item Number fees into eClaims for a health fund from an excel file.

 

Got to the main menu and click Maintenance and Miscellaneous from the left side of the screen.

 

Enter the system password. If you donā€™t know the system password please check with the Practice Manager or have them contact ACSS support.

 

2015-05-21_9-25-22

 

The Miscellaneous Tools screen will open.

Click on the Admin tab at the top of the screen and then click on the second line Fee Import.

 

2015-07-22_16-07-31

 

2015-07-22_16-17-05

 

Select Health Fund to under Filter Type to import fees from a specific health fund.

 

File Format

 

Please make sure that the file has the following headings:

Column ā€“ Column Name:
A ā€“ ItemĀ Code
B ā€“Ā MBS Fee
C ā€“ HF Fee
D ā€“Ā HF %

 

It is not necessary to create the fields in the same order. As long as the title of the header is the same as listed above and the data is presented in a Microsoft Excel 5.0/95 Workbook (*.xls) format it will import correctly.

IEĀ 

ItemĀ Code,MBS Fee,HF Fee,HF %

Item Code MBS Fee HF Fee HF %
104 77.25 102.55 0.00

 

Create the file in excel and save it as Microsoft Excel 5.0/95 Workbook

 

2015-07-23_10-43-21

 

Set the Filter Type to HFĀ and click on the icon

2015-07-22_17-27-49Ā toĀ select the file to be imported.

 

2015-07-23_10-31-25

 

Click on the file so that the name is added in data file and OK to continue.

 

eClaims will display a Message. Click Yes to continue or No to discard changes and return to the previous screen.

2015-07-22_17-32-40

 

The import process may take several minutes. When it is completed eClaims will display the Fee Import ā€“ Update screen. Click OK to close eClaims.

2015-07-22_17-36-40

 

Start eClaims as you normally would.

 

To verify that the data has been imported correctly go to the MBS item numbers by clickingĀ Patient and MBS/Item Codes from the menu on the left side of the screen.

Select an item number that had data imported and verify that the updated amounts are listed.

In the example above data was imported for item number 104 and placed under Fee Schedule 8.

 

2015-07-23_10-41-59