Understanding Average Daily Values In BillFin
When electing to bill on Average Daily Values at the firm or client level, BillFin will take the average of the daily values received by your custodian to find the account's billable value. That value is then used to calculate a fee based on your client/account rules and fee schedule setup in BillFin.
Understanding Values Sent to BillFin:
- Most Custodians do not send values when markets are closed which means
that they normally provide positions for around 65 days a quarter.
- Some Custodians may not include a value if there is $0 in the account
- All Custodians do not provide values for accounts prior to being opened or days after an account is closed. You will need to utilize the inception and termination functions in BillFin to handle these.
- Inception Billing (Billing a New Account for a Partial Opening Period Fee)
- How to Terminate/Close Accounts
How to Confirm Average Daily Values in BillFin:
- Navigate to the Fees page
- Sync asset values if you have not already
- Hover over the pencil next to the client and click “View
Asset Values”
- Click “View in Excel” in the slide out window
- Open the spreadsheet to view all the daily positions
provided by your custodian in that billing period for that client's
accounts.
- If you sum the positions for each account on each day, and
then average those sums, you should match BillFin's "Billable Assets"
value.
- A pivot table is useful for getting the sums and then
averaging