Transaction Calculations for Arrears Billing

Transaction Calculations for Arrears Billing

Transaction Calculations for Arrears Billing

If a deposit happens mid-period, because you bill in arrears, BillFin takes the actual end of period account value and then subtracts the result of the amount of the deposit multiplied by the number of days in the period prior to the deposit divided by the number of days in the period. For withdrawals, it takes the end of period account value and adds the result of the withdrawal amount multiplied by the days that money was managed divided by the number of days in the period. I hope this is helpful.

 

Simple Deposit Example:

Account 1 holds $1,000,000.00 on 3/31/18

Deposit of $40,000.00 on 3/27/18

Billable Asset Calculation: 1M - (40K * (85/90)) = $962,222.22

So that $962K is the billable asset that goes into the normal fee calculation. 


Simple Withdrawal Example:

Account 1 holds $1,000,000.00 on 3/31/18

Withdrawal of $40,000.00 on 3/27/18

Billable Asset Calculation: 1M + (40K * (86/90)) = $1,038,222.22

So that $1.03M is the billable asset that goes into the normal fee calculation.