Office - Membership - AR Aging Error

Table of Contents


Overview

  • The AR activity in a Member’s profile shows the Club the balance and history behind the balance on the Member’s profile.

Required Permissions

  • Membership

  • Add/Edit/Delete SJ Batches

  • Add/Edit/Delete CR Batches


Accessing the Tool

Accessing the Tool

To access this information and correct the error, follow the steps below:

  1. Click on Membership icon.

  2. This will open the Manage Members tab.

  3. Double-click on the Member’s profile in question.

  4. In the Member’s profile, click on AR Activity.

  5. Click on the arrow beside the AR Ledger field. 

    1. Select each available AR account to help pinpoint where the credit lies and where the charges are sitting. Make notation of the account with the credit and of the account with the balance due.

  6. Navigate to the Items module by clicking the Items icon,

  7. Select New. This image references steps 8-12.

  8. Name the item Transfer to AR #### (whatever the AR account number is).

  9. Switch it to a billing item.

  10. Put it in a non-taxable category.

  11. In the AR override field, select the AR account referenced in the name.

  12. Save & Exit out of the new item.

  13. Repeat Steps 8-12 with the other affected AR account information.

  14. Once completed, go to Membership again.

  15. Click on the Member Charge Wizard.

  16. Click Quick Add to create a new batch.

  17. Set charge batch date to fit needs and make sure to leave the Use Items option selected.

  18. Select Next. This image will show steps 19-22.

  19. On the next screen, on the first line, input the Member, Area, and one of the transfer Items we just created.

  20. On the second row, input the same Member, area, and the other transfer item created.

  21. In the price section of the first row make sure to put the opposite balance in place.

    1. In our example: AR account 1130 has a credit of $200 in place so a charge of equal balance needs to be in place.

    2. In our example: AR account 1190 has a balance due in place, so the credit amount of AR 1130 which is -$200 needs to be put in place as a credit on this row.  

  22. Select Finish.

  23. Post the Batch on the next screen and the balance will transfer to the proper AR account. 

Please Note: If there is only one AR account under the AR Ledger, you still switch to view the singular AR account and see the balance change, then that means the issue is related to the clearing account and the AR account. The best option would be to un-post the incorrect payment batch and correct it before reposting it.

If they cannot find the payment batch causing the error, a specialist will have to go in and correct the balance, but the client will need to make sure they have the ledger side of things correct.


Best Practices

  • Try to find the error payment batch and try to un-post it before taking the above steps. Correcting the unposted payment batch and reposting it is the easiest way to correct this issue.

FAQs

Q: Why does incorrect AR aging happen?
A: A payment was applied to the wrong AR account, so the payment needs to be transferred to the proper account.

CE footer.png

Â