Run Revenue Share

Written by Nick Miles

Last published at: January 30th, 2020

CommunitySuite allows foundations who manage funds in investment pools to share investment revenue, losses, and fees on a monthly, quarterly and yearly basis.

Revenue share can be run for both statement vouchers and/or traditional vouchers. Follow the steps below and select the correct path depending on whether you're running revenue share for statement vouchers or traditional vouchers.

  • Revenue share cannot be run unless there are statement vouchers and/or traditional vouchers (to be paid from the Revenue Share Holding Fund) for the dates that you select.
  • The revenue share feature identifies the funds (and their percentage) within a specific investment/banking account, then calculates the average daily balance for each day (instead of only once or twice per month). The system calculates fund balances out eight (8) decimal places, so 5,000 would be calculated as 5000.00000000.
  • Balances sometimes need to be rounded because interest calculations often result in fractions of a penny. These fractions of a penny are deposited into the fund with the most assets. 
  1. Select Revenue Share from the Home page.
  2. Click Create.
  3. Select a Date Range.
  4. Edit the post date, enter a description, and select a date range for when the fund percentage should be calculated, then click Next.
  5. At this time, the revenue share job will populate in the Recent Revenue Share Background Jobs window.
    Refresh your web browser to check if the background job has finished. It may take a few minutes for the job to finish.
  6. Once the job has finished, the individual revenue share entries will display in the Revenue Share window. The process for posting these entries will differ, depending on whether the entry is for a statement voucher or a traditional voucher. Statement vouchers will display an account number and name (e.g. 1100-Investment Asset - Charles Schwab (A); while traditional vouchers will display the name of the entity / vendor (e.g. Blake Mitchell).
    If all revenue share entries that you're posting are for statement vouchers, you can click Post All. However, if you have both traditional vouchers and statement vouchers to post, clicking Post All will give you an error message.

Post Revenue Share for Statement Vouchers

  1. Click the ID of the revenue share entry.
  2. Click Post.


Post Revenue Share for Traditional Vouchers

  1. Click the ID of the revenue share entry.
  2. Click Set Share Details.
  3. Check the box(es) next to each account that you want to use to calculate fund sharing percentages, then click Next.