Opening Balances: Patients

The function will be used when the practice starts on GoodX for the first time and wants to bring debtors patient closing balances from a previous system. These are amounts that still need to be collected from the patient. This assists the practice and ensures a correct age analysis. 

  • Log in to GoodX Desktop App with your username and password.
  • Double click on the MedDebs module.

  • Click on the Batch transactions tab.


  • From the drop-down, click on the Opening balances: Patients.


  • The Select Period screen will appear.

  • Click on the OK button or F2 on your keyboard.


  • The Opening Balance Input screen will appear.


  • Choose the Patient/Private option in the Post account.


  • Contra account: This will always be SCR1.
  • Click on the Import data button to import the new data.


  • Select From external file (e.g. CSV).


  • There are two options to import a profile:
    • Already saved profile.
    • Create a new profile.
Already saved profile:
  • Click on the ellipse (...) to import the correct file and complete the information.


  • Upload the profile file that you created before.

  • Click on Open to open the Debtors Opening Balance screen.
Please Note: Because the user already created a profile, the system will automatically pull the data through according to the profile created.



  • Click on the Text file to Import ellipse to import the CSV file that the user created.


  • Click on the Open button to continue.


  • The user will again be directed to the Debtors Opening Balance screen.
  • Click on the Process text file button.


  • The Display Report screen will appear.


  • The following information will display on the screen:
    • Records Read: The total amount of records that the system picked up.
    • Records Accepted: The total amount of records that the system accepted. This option needs to be the same as the records read.
    • Records Rejected: If any of the records were rejected it will show on this line.
  • Click on the Close button to continue.


  • The imported data will appear on the Opening Balance Input - Debtors screen.



  • Click on the OK button.


  • A confirmation screen will pop up, click on the OK button.


  • The Journal summary screen will appear.


  • Click on the Close button to exit the Opening Balance screen.


Create a new profile:

  • Complete the following information:



    • Delimiter: It is normally a comma (,) or a dash (/)
    • Data Heading Length: The first few rows of the excel spreadsheet before the data that is captured.
    • Data Footer Length: The total amount of rows left at the bottom of the excel spreadsheet after the data is captured.
    • Debtor Identifier Type: Choose between Account Number or File number. The user will identify the patient via what they selected.


    • Debtor Identifier: Enter the column number of the Excel spreadsheet where the Debtor name is stated.
    • Transaction Description: Enter the column number of where the transaction amount is allocated.
    • Current: Enter the column number of the current amount of the debt that needs to be collected.
    • 30 days: Enter the column number of the amount on 30 days that still needs to be collected.
    • 60 days: Enter the column number of the amount in 60 days that still needs to be collected.
    • 90 days: Enter the column number of the amount on 90 days that still needs to be collected.
    • 120 days: Enter the column number of the amount on 120 days that still needs to be collected.
    • 150 days: Enter the column number of the amount on 150 days that still needs to be collected.
    • 180 days: Enter the column number of the amount on 180 days that still needs to be collected.
  • Click on the Save profile button to save the import profile data.


  • Click on the Process text file button to continue.


  • Click on the Close button.
  • Choose the correct Contra Account and date

  • Click on the OK button
  • Click on OK (again) to confirm journal batch

Last modified: Thursday, 11 March 2021, 11:34 AM