General > Import data > Import participants

This import function becomes available with the Funds module of Mill7.

The following fields can be allocated.

1. Fund code *
2. Investor code *

3. Entry date

4. Exit date

5. Commitment

6. GL account

7. Cost centre

8. Contact person

Required

See also the help topic Funds manager.

Only lines with status OK are processed.

Entry date, Exit date and Commitment cannot be changed by importation when a capital call, a distribution notice or a commitment transfer is present for the fund.

After a commitment transfer, an involved investor will participate multiple times within a fund. Two or more participants will then be linked to this investor. When a field is changed for this investor by importation (after a commitment transfer, that can only be GL account, Cost centre en Contact person), the field will be overwritten with the new value for all linked participants. In the case that the values for the participants were not equal before the importation, they will be equalized by the importation. When it is intended for the values to differ from each other, then it will be necessary to correct this in the Funds manager after the importation.

1. Fund code

The fund code must exist in the current bookkeeping.

2. Investor code

The investor code must exist.

When the combination Fund code - Investor code does not yet exist a new participant for the given Fund code is created.
It is not possible to add a new participant when there is a distribution notice present for the fund.

When the combination already exists, the participant data in Mill7 will be overwritten with the data in the import file.

When a Mill7 field is not connected to an import field, it will be unchanged.

When a connected field in the import file is blank, the corresponding field in Mill7 will be cleared.

3. Entry date

The entry date is required when the combination Fund-Investor code does not yet exist.

It may not be cleared when the combination Fund-Investor code already exist.

An entry date cannot be changed once a capital call, a distribution notice or a commitment transfer has been created for the fund.

The entry date

•must be equal of greater than the start date of the fund

•and must be after the date of latest notice of the fund.

4. Exit date

An exit date cannot be changed once a capital call, a distribution notice or a commitment transfer has been created for the fund.

5. Commitment

The commitment amount must be equal or greater than the 'Initial call threshold' as set for the fund.
The commitment cannot be changed once a capital call, a distribution notice or a commitment transfer has been created for the fund.

6. GL account
This general ledger account must exist in the current bookkeeping.

7. Cost centre

The cost centre must exist in the current bookkeeping.

8. Contact person

The contact person at the fund.