MedDebs - Invoices Outstanding Report Settings and Parameters

A Credit Controller will generate this Report at least weekly to follow up on Outstanding Invoices.

The Invoices Outstanding Report displays all the Outstanding Invoices on the system and the Age of the outstanding balance as per the information selected from the Report Set-Up.

The Invoices Outstanding Report indicates all the outstanding Invoices of both Medical Aid and Patient Outstanding accounts. 

The Invoice Outstanding Report assist in following up with the Medical Aid or the Patient on outstanding Invoices. It can assist in limiting stale Claims and Bad Debts if the Invoices are followed up and collected before 60 days of age.

The Invoices Outstanding Report can be found in MedDebs Module.

  • Open the MedDebs Module.
  • Click on Print and select Invoices Outstanding from the list.


Profile Options and Function

  • The following Invoices Outstanding Profiles will be loaded by default with new installations.

  • Click on New to add a New Profile.

  • Click on Edit to edit an Existing Profile.


  • Click on Delete to delete an Existing Profile.

  • Click on Print Direct to print the Report directly to your printer without viewing the Report.

  • Click on Print to Grid to view the Report in a grid format.

  • Click on Set as Default to set a specific Report Profile as the default, the system will highlight the Report that is set up as the default Report when the Invoices Outstanding Report profiles have been opened. 
  • When a Report is set up as the default Report the Report cannot be deleted. The default Report must first be removed, by using the options button and then only the Report Profile can be deleted.

  • Click on Options, 3 options will be available.


  • Rename - Will allow to rename the Report profile that is highlighted.
  • Save as - Will take the Report Setting from the profile that is highlighted and save a duplicate of the Report with the new name that was entered.
  • Unset current default - Will take the default Report of but not delete the Report, only remove the default option from the Report.

Option button

  • Click on Close to exit the Invoices Outstanding Profile list.

  • The following Report Setting is available to minimize the information in the Report to the correct result that is wanted.

The Report Parameters


Date Settings

  • Select the Timespan for Report.

TAKE NOTE: Tick the Default Date/Period block to default the report profile Setup to the current Financial Year and Period. The Report will always default the current Period and the Financial Year according to the computer date.

  • Select the Financial Year.
  • Select the Type of Dates (From the beginning when the system was used until the date in this section). Invoices Outstanding can be pulled for All dates (the period the Practice has been running for) or between dates. 
  1. All dates - The financial period.
  2. Between Capture dates - The date the transaction was captured on the system.
  3. Between Transaction dates - The date the Patient was treated and when the treatment took place.
  4. Between Weeks - This option will work via the Transaction date - The date the Patient was treated and when the treatment took place.

NB: Please Take Note of the differences between the types of Dates:

  1. Capture date: the date on which the transaction is captured onto the system (is not necessarily the same as the transaction date).
  2. Transaction date: the treatment date, when the patient was treated.

  • When the Capture date or Transaction date Options are used the following extra setting will display to put in the date of the last transaction must be included.


  • The different date Setting will not have the same information and Invoices, these Reports cannot be compared with each other. The information is using different parameters and will not be the same information displayed.
  • Depending on the set up in the Report Parameters some extra screen will need information before the report will print or display.

Invoice Types to Print
  • Select the relevant tick boxes under Invoices Types to Print.

  • The following options can be included or excluded from the Report information when the tick is on the information will display, if there is not tick mark the information will not be included.
    • Consults/Procs - The procedure and consultations that were charged on the patient account. This is billed from the Tariff lists in GoodX.
    • Medicine - The medicine that was billed (used) on the patient.
    • Technical - Only for Oncology equipment rent or Lab equipment what is rented.
    • Prescription - The prescriptions that were made on the patient's account, this will be normally billed as a Zero amount when the billing was done.
    • Other - Any other transactions that were billed on the account that is not included in the top settings.
    • MedFd (/P) - All the transaction that was posted on a medical aid on the patient account, the Invoice will post with a "/P" after the invoice number.
    • Pat Pays (/Q)- All transactions that were posted as a tariff 2, 3, 4, of 5. The invoice number will have a "/Q" at the back of the invoice number.
    • Private (/X) - All transactions that the Medical aid was set to post as Private in the Medical aid option, or when the patient file was marked as a private patient file of when an item on the billing screen was marked to post as private. The invoice number will have a "/X" at the back of the invoice number.
Grouping Options

  • Select the Grouping Options and the Column Grouping Order to choose how the Report should display.
  • The Column Grouping will show when 2 or more Grouping options were selected.

Grouping Age

Grouping Options:

  1. Per Medical Aid Administrator - Group the accounts according to the Medical Aid Administrator.
  2. Per the Medical Aid Scheme  -  Group the accounts according to the Medical Aid Scheme, this grouping assists in following up on all the outstanding account that is at the same medical aid. 
  3. Per Medical Aid Option - Group all accounts according to the plan or option the invoice was posted.
  4. Per Treating Practitioner - Grouping the accounts according to the Practitioner who did the treatment. This grouping assists in follow up on the outstanding accounts on the treating doctor when it is a Group Practice. 
  5. Per Referring Practitioner - Grouping the accounts according to the Dr who referred the patient to the practice.
  6. Per Service Centre - Grouping the accounts according to the Service centre the patient was treated in.
  7. Per Billing Group - Grouping the accounts according to the Billing Group what the invoice was done on. The billing group is for example 300% on the standard rate.
  8. Per Scheme Group - Grouping the accounts according to the grouping on the Medical aid schemes that are set up. The Medical scheme can be linked to a group to assist in allocating a group of schemes to one person to follow up on the outstanding accounts.
  9. Per Credit Control Path - Grouping the accounts according to the Credit control assistant path set up. The Path the account follows in the Credit control assistant. The Credit Control assistant must be set up before this Grouping can be used.
  10. Per Credit Control Phase - Grouping the accounts according to the Credit control assistant phase the accounts are in. The Credit Control assistant must be set up before this Grouping can be used.
  11. PMB - Grouping the accounts according to if the account is a PMB or not.
  12. Per Debtor Status - Grouping the accounts according to the status the Debtor is linked to.
  13. Per Credit Control Assistant - Grouping the accounts according to the Credit control assistant what is linked to the account. The Credit Control assistant must be set up before this Grouping can be used.
  14. Per Handover Status / Per third-party Status - Grouping according to the handover process. 
  15. Per Case/Visit - Grouping for hospitals and when cases are used.
  16. Case Ct.Ctrl. Status - Grouping the accounts according to the case credit control status that is set up on the Case.
Column Grouping order

  • Click on the Move Up or Move Down buttons depending on which order the Grouping should display.
  • Show in Groups - All Grouping means that the Report will show in the order of the Grouping Options selected.
  • Show in Groups - Select Grouping means that you can select (in this case) which Medical Aid Scheme and which Service Center should display.

Grouping Values can be chosen for:

  • As per Transaction level - Reports are drawn with the information reflected on the Invoices posted in the system.
  • As per Debtor data - Reports are drawn with the information captured for the debtor to ignore the invoice data, specifically the Doctor, Referring Doctor, and Service Centre as captured on the debtor information screen.
Debtors

  • Select the Debtors to display on the Report.

TAKE NOTE:  When printing the Report, a screen will display where you can make your selection.

  • All:  Displays all the Debtors with an account balance.
  • Choose:  To print from a specific debtor to a specific debtor. The Debtors Surname can be filled in the columns and the Debtors will be included in the report.

Debtors choose

  • List of Debtors: Will populate a screen where a list of debtors can be selected. The account number or surname can be typed in, the patient details will complete if the correct debtor can be selected, otherwise, the list of all Debtors will open and the correct Debtor can be selected.

List of debtors

  • Import file - A list can also be imported from a notepad file or a file that was saved previously by clicking on the Import file button.
  • Delete Row - A Row can be Deleted if the incorrect Debtor was chosen.
  • Save data - The list can be saved and imported next time when the list function is used.
  • Clear all - Will clear all the Debtors in the list and can start again with a new list.

Buttons on list

  • OK - Will take the list and show the information on this Debtors.

ok button

  • Single Debtor: To select a specific debtor.

Debtor single

  • The Debtor Surname or Account number can be used.

Report Order

  • Select the Report Order on how the Report should display.


  • Alphabetic: The Report displays in Alphabetical order (ABC on Debtor Surname).
  • Numeric: The Report displays in Numeric order (Account number order).
  • File Number: The Report displays in File number order.
Columns

  • Select which column to display on the Report.

  • Total: This will reflect the total amount outstanding on the Debtor, Patient plus Medical Aid liable. The columns will display Green in the report. No Medical aid or Patient split will display on the Report.
  • Medical Aid: This option will reflect only on the Debtor, Medical Aid liable accounts. The columns will display Blue in the Report.
  • Patient: This option will reflect only on the Debtor, Patient liable accounts. The columns will display Grey in the Report.
  • All three options can be tick and all three will display on the Report in different columns according to the colours.
Amounts

  • This will assist in shortening the information in the Report to target the accounts that you want to see.
  • Select the Amounts to reflect on the Report.


  • All: Will reflect all the outstanding amounts - Debits, Credits as well as the Zero balances.
  • Specific Amount (Total): This option will enable you to specify the amounts to reflect on the report. The following option is available when the Specific amount is chosen:

on amount

  1. Equal to - Will only display the amount that is the same as the amount that has been entered.
  2. Not Equal to - Will display all the amounts except the amount that was entered. This can be used to filter out all the Zero accounts.
  3. Greater than - Will display only the amount that is bigger than the amount that was entered. This can allow that only amounts bigger than R 10.00, for example, can be displayed.
  4. Greater or Equal to - Will display only the amount that is bigger than the amount that was entered and will include the amount that was entered.
  5. Less than - Will display only the amount that is smaller than the amount that was entered. This can allow that only amounts smaller than R 5000.00 for example, can be displayed.
  6. Less or Equal to - Will display only the amount that is smaller than the amount that was entered and will include the amount that was entered.
  7. Between - Will display 2 fields to put in amounts, and only the amounts between that 2 amounts will be displayed.
  • To Add a New Profile:
    • Highlight the BLANK Report Profile
    • Click on New
    • Enter the Name of the Report Profile
    • Click OK
    • Select the Report Parameters
    • Click on Save Profile
  • To Print the Report:
    • Highlight the Report Profile
    • Click on Print to Grid
    • Choose the applicable options under the drop-down boxes
    • Click Next
  • The Report will display as follows:


  • When clicking on Print the Report will display as follows:
    • From here you have the option to E-mail, Print Preview, Save or Print the Report.



Last modified: Wednesday, 28 October 2020, 9:01 AM