Skip to main content

Generate Client Ledger report - PM

  1. Last updated
  2. Save as PDF

Generate the Client Ledger report for viewing or printing. The report contains the following information:

  • Posted services with liability distributed to guarantors
  • Claim numbers
  • Remaining balances
  • Balance transfers
  • Posted payments, payment reversals
  • Balance adjustments

Note: Charges with a $0.00 usual and customary fee do not display on the client ledger, unless a payment is posted against them.

  1. Go to: Avatar PM > Client Management > Account Management > Client Ledger or Billing > Remittance Processing > Client Ledger.
  2. In the Select Client screen, enter the client name or ID, and select.
  3. Select one option in the Claim/Episode/All Episodes field:
    • All Episodes for all services rendered in all client episodes.
    • Claim for a single claim number (Claim Number field).
    • Episode for a single client episode (Episode Number field).
  4. Based on the selection in the Claim/Episode/All Episodes field, enter the corresponding information.
  5. For Ledger Type, select the report output: Simple (system report displays codes only) or Crystal (Crystal Report displays codes, descriptions, and additional details).
  6. For Include Zero Charges, select whether to include zero charges. The system default is 'No'.
  7. For Exclude Roll-Up Component Services, select whether to exclude component roll-up services. The system default is 'Yes'.
  8. The From Date and To Date fields display dates based on the Claim/Episode/All Episodes criteria and can be edited.
  9. Select whether to Generate 99999 Services Report.
  10. Select whether to Include Closed Services for 99999 Report.
  11. Select Export. 
  12. Enter information to save the CSV file.
  13. Select Process.
► Client Ledger Report
  • Line Number
  • Episode Number
  • Date of Service
  • Service Code
  • Units
  • Service charge
  • Guarantor
  • Guarantor Liability
  • Payments/Adjustments/Transfers
  • Posting Code
  • Date Posted (Pay/Adj/Tra)
  • Date Billed (Claim)
  • Claim Number (Billing Status)
    • OPEN - the charge is open and the accounting period is open
    • UNBILLED - the service is closed but not claimed (Note: a service is closed when a payment, adjustment, or transfer is applied and when the accounting period is closed)
    • Numbers only (12345) - service is claimed. 
    • Numbers followed by R (12345R)- claim has been rebilled
    • numbers followed by V (12345V)- claim has been voided
  • Line Balance
  • Posted payments
  • Balance adjustments.
► Registry Setting
► Test Script

For implementing new systems or new functionality, download the following standard test script for this feature. Please contact your Netsmart representative for more information about Test scripts.