How do I report on admin fees?
  • 04 Jun 2023
  • Contributors
  • Dark
    Light
  • PDF

How do I report on admin fees?

  • Dark
    Light
  • PDF

Article summary

How can I report on the total admin fees we have charged? How do I know if admin fees have been posted?  The admin fee reports only run monthly.

Answer:
The information for the actual fees charged is found in the General Ledger, not the Funds module.  The easiest report to run is either a Consolidated Trial Balance or the Trial Balance. To run:
  1. Navigate to General Ledger > Reports.
  2. Select either Consolidated Trial Balance (for a total of all admin fees) or Trial Balance (for detail by fund with a grand total)
  3. In the window that pops up, select the appropriate year and period that you want to report on. If you want the entire year, change the period to 12.
  4. On the selections tab, select seg:account and enter the appropriate GL account for the management or administrative fees.  Typically it will start with a 5.
  5. Once the account is added to selections, click Run report.
  6. The report will display.

Was this article helpful?