How is the Accounts Receivable KPI calculated?

Description  

On the top of each community page profile, there is a KPI (key performance indicator) for Accounts Receivable. 

That tile gives the percentage of applied funds that have been collected in the community. 

mceclip0.png

When you click the KPI, it will give you the dollar amount of the funds applied and received. 

mceclip1.png

 

How is that percentage calculated? 

 

Total Amount Received divided by Total Charges Applied

In the example, the calculation is:

 $4543.03 ÷ $62251.53 = 7%

 

What is included in the Applied and Received amounts? 

Applied Calculates the sum of amounts of the following types of transactions:

  • Apply Charges
  • Apply Late Fee
  • Apply Interest
  • Apply Prepaids
  • Waive Charge
  • Add Charge
  • Apply NSF
  • Beginning Balance.

Received Calculates the sum of amounts of the following types of transactions:

  • Cash Receipts (Manual Cash Receipts and Lockbock)
  • subtracts the sum of amounts of any Backout Payment transactions

Did you find this article helpful?

1 out of 4 found this helpful