Skip to main content

Spreadsheet Remittance Posting - PM

  1. Last updated
  2. Save as PDF

Post multiple payments, adjustments, or transfers for a client.

myAvatar PM > Billing > Remittance Processing > Spreadsheet Remittance Posting

  • This form launches a worksheet that provides a graphical overview of client services, and liability distribution.

  • While this worksheet is open for a specific client, you will not be able to access that client in any other cash posting form.

  1. In the Client field, enter the client name, and select.

  2. In the Post By Claim or Episode field, select how information will display in the Select Items to Post Against screen.

  • Select All Episodes to display all client episodes.

  • Select Claim to display a specific claim.
    In the Claim field, select which claim.

  • Select Episode to display a specific client episode.
    In the Episode field, select which client episode.

  1. In the Start Date field, enter the first date of service. This will display in the Select Items to Post Against screen.

    • When selecting All Episodes, this field populates with the first date of service that is in the system for this client, but can be edited as needed.

    • When selecting Claim, this field displays the first date of service that is in the system for this claim.

    • When selecting Episode, this field populates with the first date of service that is in the system for this episode, but can be edited as needed.

  2. In the Stop Date field, enter the last date of charges that have payments due. This will display in the Select Items to Post Against screen. 

    • When selecting All Episodes, this field populates with the last date of service that is in the system for this client, but can be edited as needed.

    • When selecting Claim, this field displays the last date of service that is in the system for this claim.

    • When selecting Episode, this field populates with the last date of service that is in the system for this episode, but can be edited as needed.

Manual Entry

  1. In the Posting Comments field, enter posting comments.

  2. In the Guarantor to Post For field, select the guarantor.

  3. In the Posting Date field, enter the date.

  4. In the Date of Receipt field, enter the receipt date.

  5. Click Launch Work Screen to display the Cash Posting Worksheet.

 

OR

Defaulting Payment, Adjustment, and Transfer Codes

  1. In the Payment/Adjustment Amount to Post field, enter the total dollar amount of payments or adjustments to post.

  2. In the Default Payment Code field, select the code to populate automatically in the Payment Code field.

  3. In the Default Adjustment Code field, select the code to populate automatically in the Adjustment Code field.

  4. In the Default Transfer Code field, select the code to populate automatically in the Transfer Code field.

  5. In the Default Trans. To Guarantor field, select the guarantor to populate automatically in the Transfer Guar field. The guarantor must have been assigned to the client through a financial eligibility form.

  6. In the Posting Comments field, enter posting comments.

  7. In the Guarantor to Post For field, select the guarantor.

  8. In the Posting Date field, enter the date.

  9. In the Date of Receipt field, enter the receipt date.

  10. In the Default Payment/Adjustment Code For Amount To Post field, select the code to populate the Payment Code field.

  11. In the Default Distribute Max Payment Per Service field, enter the dollar amount to populate the posted amount for a service. 

    This amount is applied to the service up to the amount entered in the Payment/Adjustment Amount to Post field.

    If the amount entered in this field is greater than the balance of an individual service, the default amount is posted.

  12. In the Default Distribute % Payment Per Service field, enter the percentage to populate the posted percentage for a service. 

  13. This percentage is applied up to the amount entered in the Payment/Adjustment Amount to Post field.
    If selections were made in both the Default Adjustment Code and the Default Transfer Code fields, the lesser value for the two fields is posted.

  14. In the Manual Receipt field, enter the receipt number. Once this form is filed, the receipt number cannot be edited.

  15. In the Check # field, enter the check number. Once this form is filed, the check number cannot be edited.

  16. Click Launch Work Screen to display the Cash Posting Worksheet.

Finish and File

  • The Posting Summary field displays a snapshot of the information entered, which will be posted when this form is submitted.

  • Click View Client Ledger to generate the Client Account Ledger crystal report, which displays details of the client liability line item(s). This allows you to review the data and details, as needed prior to submitting. Make corrections via the Cash Posting Worksheet.

  • When finished, click Submit to apply the payments, adjustments, or transfers to the client's account.

► Registry Settings