Skip to main content

Credit Balance Report - PM

Generate a report that details guarantor credit due to service overpayment.


  1. Go to Avatar PM > Billing > Billing Reports > Ad Hoc Reports > Credit Balance Report.
  2. In the Effective Date field, enter the report start date. The number of days between this date and the date in the Age From Date field is used to age the credit balance.
  3. In the Date Of Payments field, enter the payment date.
  4. In the Age From Date field, select how the report is aged:
    • The Date - The Service Was Closed - ages from the date the service was closed to the effective date.
    • The Date - The Client Was Discharged - ages from the date the client was discharged to the effective date.
    • The Date - The Service Was Performed - ages from the date of service to the effective date.
    • The Date - The Last Payment/Transaction Was Posted - ages from the last posting date.
  5. In the For Individual Or All Clients field: 
    • Select All Clients to include all client balances.
    • Select Individual to generate credit balance information for a client (Client ID field).
  6. In the Client ID field, enter the client name, and select.
  7. In the Summary Or Detail Report field: 
    • Select Summary Report to generate a the Credit Balance Report (Summary) report.
    • Select Detail Report to generate the Credit Balance Report (Summary), and Credit Balance Report (Detail) reports.
  8. In the Individual Or All Guarantors field: 
    • Select All to include all guarantor balances in the report.
    • Select Individual for a guarantor (Guarantor field).
  9. In the Guarantor field, enter the guarantor name, and select.
  10. In the Service Billing Status field, select the service billing status to display in the report:
    • Select Both Billed and Unbilled Services to include all services.
    • Select Unbilled Services Only to include services that have not been claimed.
    • Select Billed Services Only to include claimed services.
  11. In the Balance Less Than Or Equal To field, enter the amount to determine which services display in the report.
    • Enter “0” to include all guarantors.
    • Enter a negative number for guarantor overpayment. Balances greater than or equal to the amount entered in this field will display in the report.
    • Enter a positive number for debit balances. Balances less than or equal to the amount entered in this field will display in the report.
  12. In the Print Discharged Episodes Only field: 
    • Select Yes to include clients who have been discharged.
    • Select No to include all episodes.
  13. In the Sort By Name Or ID Number field: 
    • Select Client Name to list clients in alphabetical order.
    • Select Client ID Number to list clients by client ID.
  14. In the Additional Sort field: 
    • Select Yes to sort the report by the selection in the Which Item Do You Wish To Sort By field.
    • Select No to sort by client ID.
  15. In the Which Item Do You Wish To Sort By field, select how to sort the report. The list contains all data entry fields in myAvatar PM.
  16. Select Process.

The Credit Balance Report (Detail) contains detailed claim information.

The Credit Balance Report (summary) contains guarantor totals.