How Do I Post and Reconcile Investment Activity by Investment Pool?

This article is for customers without the Investment Portfolio Module. If you have the Investment Portfolio Module, instead of entering investment information at the pool level, you will enter and reconcile activity for each manager statement. See this article for instructions: How Do I Post and Reconcile Investment Activity with the Investment Portfolio Module?


During the posting process, Balance allocates the investment activity for the period back to the individual funds based on the number of units each fund holds in the investment pool at that time. Read the following instructions to guide you through posting in Balance.  If you have any issues posting or need assistance resolving Due To/Due From issues, please contact our support team.

The Checklist for Posting Transactions and Investment Activity can help walk you through the closing process. Before you can post investment activity, you must add any new funds, make income distributions (if any), and enter gifts and other transactions.

Steps to Post & Reconcile Investment Activity by Pool

  1. Once you have completed those steps, navigate to Accounting on the left side panel in your  database, then select the Investment activity tab. 
  2. Select the investment pool you want to work on from by clicking the 'Edit Activity' button. Investment activity needs to be entered for each investment pool before you can close the period.

     
  3. The following screen will open when you click on the 'Edit activity' button at the pool level. The beginning market value will be populated; enter your activity in the other applicable fields and click on the Save values button.

    A screenshot of a computer

Description automatically generated

    Balance will perform a reconciliation when you save your values by calculating the ending market value and comparing it to the statement market value you entered.  If the difference is not zero, that row in the summary will change from green to pink and there will be a warning icon.  In the example below, the ending market value was not initially populated.

    A screenshot of a computer

Description automatically generated

    With the correct ending market value populated and saved, the pool is in balance as shown below.

Was this article helpful?

Reply

null

Content aside

  • 4 mths agoLast active
  • 183Views
  • 1 Following