How Do I Post and Reconcile Investment Activity with 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. If you want to know how to enter investment activity at the pool level, please see this article.

 

Manual Method

To enter your investment activity manually, go to Accounting on the left side panel, then select the Investment activity tab.

 Post Activity by Pool

To edit Investment Activity for the pool, click on 'Edit Activity' next to the pool.

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.

 Entering Activity by Manager

If your pool is set up to be reconciled at the manager level, it will have a triangle button before the pool name.  Click on the pool name to expand or collapse the list of managers within that pool.  To enter investment activity for a manager, click on its 'Edit activity' button. 

There are three additional fields available when entering activity at the manager level (see highlighted fields below), but the functionality is the same as inputting activity at the pool level.  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. The Difference line will show as green if the difference is zero.

 If the difference is not zero, that row in the summary will change from green to pink and there will be a warning icon.

 

Import Method

Users can use the standard Investment Manager Activity import template to record investment activity by individual managers in each period (i.e. monthly, quarter). The template allows a bulk upload of manager activity instead of keying in entries one manager at a time. This feature is only available to those clients that subscribe to the Investment Portfolio Module and enter investment activity by manager vs. by investment pool.

See the following article for instructions:

How Do I Use the Investment Manager Activity Import?

Was this article helpful?

Reply

null

Content aside

  • 7 mths agoLast active
  • 114Views
  • 1 Following