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

Instructions coming soon!

Was this article helpful?

Reply

null

Content aside

  • 4 mths agoLast active
  • 71Views
  • 1 Following