Uploading fund data | FundCentre Reporting (formerly InvestorVision)

  • Updated
InvestorVision is now called FundCentre Reporting.
During this transition, you may see both names in the application and related documentation.
View the FAQ about what's changing

Applies to: General partners
 

You can upload quarterly investment summaries, capital account data, cash inflow/outflow transactions, and underlying holdings data for private equity funds.

I want to

  • Upload fund data
  • Edit holdings data

How to upload fund data

Fund data is uploaded using an Excel spreadsheet. You can download a template that supports full International Limited Partner Association (ILPA) standards. The template includes all investors, IDs, and associated fund accounts. You can use only the fields required for your upload.

Data is managed using the Data tab on the fund page. From the Data tab, you can upload data, view the status of an upload, publish data, un-publish data, and download previously uploaded data.

Data can be saved as a draft or published. Limited Partners (LPs) only see published data.

Uploading data consists of the following tasks:

Uploading fund data

  1. In the left navigation panel, click Funds.
  2. Click the fund to which you want to add data.
  3. Click the Data tab.
  4. (Optional.) To upload cashflow data:
    • Click the Transactions tab. This tab is not displayed if the fund uses hedge data.
    • Click + Data.
    • In the Name field, enter a name for the cashflow.
    • Continue with step 6.
  5. (Optional.) To upload capital account data:

    • Click Capital Accounts. This tab is not displayed if the fund uses hedge data.
    • Click + Data.
    • In the Quarter field, select the quarter to which the data applies.
    • In the Year field, select the year to which the data applies.
    • If you enter the quarter and the year before you download the file, the downloaded file name will contain the fund name, quarter, and year; otherwise, it will only contain the fund name.

    Note: For information on how to rename capital account data fields in the file using PCAP headers, see PCAP headers.

  6. (Optional.) To upload holdings data:
    • Click the Holdings tab. This tab is not displayed if the fund uses hedge data.
    • Click + Holding.
  7. (Optional.) To upload hedge fund data:
    • On the Hedge Summary tab, click + Data. Note that this tab is only displayed for open ended, hedge fund, mutual fund, and SPV fund types.
  8. Download the template by clicking Download Data Template.
  9. Add data to the template.
    • Fields with an asterisk (*) are required.
    •  If a row contains a blank required field, the row will fail the upload.
    •  Dimmed columns in the capital accounts template are formula columns that are not posted as a transaction.
  10. Click Select File to Upload.
  11. Navigate to the spreadsheet file and click Open.
  12. Click Upload.

    Uploading may take a few minutes. You can continue to work in other areas of InvestorVision while the upload is occurring. When the upload is finished, a preview screen is displayed where you can review the upload and decide what to do next.

Previewing the uploaded file

The preview screen is displayed when the upload is complete.

  1. Review the data to ensure accuracy. If there is an error, a message is displayed. For more information, see Viewing and fixing errors in the spreadsheet.
  2. Select one of the following options:
    • Cancel – Cancels the upload.
    • Download – Downloads the uploaded file.
    • Continue without publishing – Saves the uploaded data without publishing. LPs cannot see the data until it is published.
    • Publish – Publishes the data so that LPs can see it. Once published, you can download the spreadsheet or unpublish the data at a later time.

Viewing and fixing errors in the spreadsheet

If the upload fails, the status of the upload is Upload failed.

You can download the spreadsheet to view the errors. Rows with errors are highlighted in red. Each row includes a message explaining the issue.

  1. In the left navigation panel, click Funds.
  2. Click the fund for which you uploaded data.
  3. Click the Data tab.
  4. Click the upload that failed.
  5. Click Download.
  6. View and fix the errors.
  7. Upload the file.

How to work with data

You can edit holdings, publish data, and download data. You can also unpublish data that has been published.

Editing holdings data on screen

You can edit holdings data on the screen.

  1. In the left navigation panel, click Funds.
  2. Click the fund for which you want to edit data.
  3. Click the Data tab.
  4. Click the Holdings tab.
  5. Click View Holdings Draft for unpublished holdings or Edit Holdings for published holdings.
  6. Click in a field to edit it.
  7. Click the three dots menu for the required holding and click Save.
  8. Repeat steps 6 and 7 for each holding you want to update.
  9. Click Publish.

Publishing saved data

  1. In the left navigation panel, click Funds.
  2. Click the fund for which you want to publish previously uploaded data.
  3. Click the Data tab.
  4. Click Transactions, Capital Accounts, or Holdings.
  5. Click the three dots menu for the data you want to publish and select Publish.

Downloading saved data

  1. In the left navigation panel, click Funds.
  2. Click the fund for which you want to download data.
  3. Click the Data tab.
  4. Click Transactions, Capital Accounts, or Holdings.
  5. Click the data you want to download.
  6. Click Download.

Unpublishing data

  1. In the left navigation panel, click Funds.
  2. Click the fund for which you want to unpublish data.
  3. Click the Data tab.
  4. Click Transactions, Capital Accounts, or Holdings.
  5. Click the three dots menu for the data you want to unpublish and select Unpublish.

Additional information

Was this article helpful?