Billing Troubleshooting

Errors when generating the client invoices:


Household not appearing on the Bill Instance:

  • Confirm that the Household Bill Status is set to Ready
  • Confirm that the Accounts have a fee schedule assigned and are set to Ready to Bill

Household erroring in Bill Instance

  • Confirm that the Household has value as of the last day of the prior period.
  • Confirm that a bill has not already been generated for the client for the same time period.
  • Confirm that the paying account has value if using the Indirect bill option.

Errors are appearing on the Reconciliation Data spreadsheet

  • Confirm that the fee schedule doesn't have a fe over 3%
  • Confirm the Days in Cycle number isn't over 31 if billing Monthly or 91 For Quarterly (92 if in a leap year).
  • Confirm that the net fee is not negative.

Bill Amount Due is not as expected

  • Confirm that the correct fee schedule is assigned.
  • Confirm that all one off and recurring adjustments are accurate.
  • Confirm days in cycle number is correct
  • Confirm bill market value is showing as expected. There may be products or assets that are marked to not be included in the bill market value. You can view these in Billing Audit - Asset Audit/ Product Audit - Excluded.
  • If billing in Advance, confirm all cash flows are marked.


Market Value doesn't match custodian

  • Check for Pending transactions or back dated dividends. Orion will display transactions based on Trade date instead of Settle date which may cause a value difference.
  • Billing using Average Daily Balance? Accounts billing via avg daily balance will not match since the ending market value is based on the average value of the account over the past time period. Use the data query "Average Daily Balance by Account - for Household - for Rep."  They can then total the daily averages, and divide by total days (usually  90 or 91) to find avg daily balance.

Custodian is rejecting the fee file

  • Confirm that all of the accounts have enough cash to cover their invoice. The cash funding report found in Bill Generator is a great tool to use and can be run after a forecast or live bill instance.
  • Confirm that the file format is correct. For example, Schwab accepts CSV or TXT files.