The Investment Portfolio Module was designed to enable organizations to organize and reconcile multiple investment statements. The module features the following:
  • A simple way to organize funds
  • The ability to track alternative investments
  • Enhanced reports

This article showcases some of the most valuable features of the Investment Portfolio Module.  If you are interested in adding this feature, contact Balance Support at [email protected]!


Switching from pool-level management to the Investment Portfolio Module is easy and can be done with the click of a button:


Once you provide us with your investment manager data in an Excel template, we will upload the data for you. As you can see below, you can also manually add managers as your organization begins investing with them. 
Each manager record contains information on investment type, custodian name, and other data that is helpful for your reporting purposes.


You can also choose to classify a manager as a Due-to Due-From account. Note: if you switch to the manager module and have any Due-to Due-from funds, those will need to be deactivated.




In the DOCUMENTS tab, you can store important documents related to each manager, such as statements or other important paperwork. Multiple file formats are supported, including Word, Excel and PDF.


In the Investment Portfolio History tab, you can see balances and activity by posting period for each manager.


Investment activity can be entered directly from your statements on the MANAGER DATA ENTRY tab.


Each manager is entered separately and then reconciled.


If you have several managers that you need to enter activity for, there is an import feature available. You simply enter all of the manager activity into the Excel template and load it.  If you are interested in having the Standard Manager Investment Activity import added to your database, please reach out to Balance Support.



This is what the reconciliation view looks like.


On the POST tab, the reconciled manager data is rolled up to a pool-level view. When everything ties, the period can be posted.


Upgrading to the Investment Portfolio module opens up a new suite of detailed, portfolio-level reports.


For example, the Manager and Investment Pool Reconciliation report allows you to see a big picture view of each manager (or custodian)'s investment activity.