Revenue Share involves a few steps. First, enter all gains, losses, and fees incurred as a statement voucher in the Z_Revenue Share Holding fund. Then, reconcile your accounts. After that, you can run revenue share. Reconciling bank accounts before running revenue share is strongly encouraged, but it is not required.
If you run revenue share and then find errors, complete the steps below.
- Unpost and delete revenue share.
- Unreconcile the bank account.
- Update the statement voucher.
- Reconcile the bank account.
- Reprocess revenue share.
Run Revenue Share
- Create one or more statement vouchers or vouchers.
- If you have parent accounts, create statement vouchers on the child accounts since the parent account doesn't hold any assets.
- Enter Z_Revenue Share Holding as the fund.
- Reconcile your bank account(s).
- This is not required but is strongly recommended.
- Navigate to the Revenue Share page.
- Click Create in the left-side menu.
- Click a Date Range.
- Edit the Post Date, enter a Description, and select a Date Range for when the fund percentage should be calculated, and then click Next.
- CommunitySuite defaults to an average daily balance over the month, but if your organization allocates earnings or expenses based on the month end balance, then update the Start Date in the Calculation data range to be the same as the end date.
- The revenue share job will populate in the Recent Revenue Share Background Jobs window.
- It may take a few minutes for the job to be completed. You may need to refresh your web browser to see if the background job has finished. It is complete when the message in the image below appears.
- 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. Anna Mitchell).
- CommunitySuite defaults to an average daily balance over the month, but if your organization allocates earnings or expenses based on the month end balance, then update the Start Date in the Calculation data range to be the same as the end date.
- If there are any AP vouchers included in the revenue share, follow these steps. Otherwise, continue to step 8.
- Click the ID of the revenue share entry.
- Click Set Share Details in the left-side menu.
- Check the box(es) next to each account that you want to use to calculate fund sharing percentages, then click Next.
- Click Post All in the left-side menu.
After completing the revenue share process, review the transactions.
If revenue share is calculated using an average daily balance and the money was only in the investment account for one day, then the revenue share process may allocate part of the investment account income or loss to any fund that was in that investment account for any length of time, unless the fund was marked for exclusion from revenue share.