Skip to main content

Add and track investment funds

Learn how to add investment funds, plan buys and sells, and track valuations and realized gains in Agicap.

Written by Sybille Denis

Investment funds let you track your UCITS funds (SICAV, FCP) and money market funds in Agicap, by number of units and unit price. You plan buys and sells in your cash flow forecast, and Agicap calculates the valuation of each investment fund and the realized gain of each sale.

What Agicap tracks for each investment fund

Investment funds are a category of Financial investments, next to term deposits and other instruments. Use it for any investment valued as a number of units × a unit price (OPCVM in France).

For each investment fund, Agicap keeps:

  • the number of units you hold (up to 4 decimals),

  • the unit price at a given date,

  • the valuation of the investment fund: units held × latest known unit price,

  • every buy and sell, with the realized gain of each sale.

The valuation of your investment funds is shown in your Cash Flow Plan, not in Cash Positioning.

Prerequisites for investment funds

  • You need access to Treasury on the entity. To add or change an investment fund, you need write access to Treasury on this entity.

  • To get the real unit price of planned buys and sells, turn on bank reconciliation for investment installments.

  • Investment funds are available on entities only, not in consolidation.

Add an investment fund

  • Go to Financing > Financial investments .

  • Click Add an investment , then Investment funds .

  • Enter the general information of the investment fund.

  • Enter the history of past buys and sells: import the Excel template, or enter each movement manually.

  • Enter the Valuation date and the Latest unit price you know. The valuation date must be before today.

  • Click Add .

Image

Field

What to enter

Name

Free text, for example the name used by your bank. You cannot rename an investment fund after it is created.

Currency

The currency of the investment fund. The valuation and gains are shown in this currency.

Unit price availability

Published if the management company publishes the unit price (NAV), Not published if not.

ISIN

The 12-character code of the investment fund, for example FR0007038138. You can add an ISIN only once per entity.

Gain calculation method

Weighted average cost or FIFO (First in, first out) . You cannot change this method after the investment fund is created.

Notes

Optional, up to 500 characters.

The investment fund appears in the investment funds list, with its name, ISIN, valuation date, unit price, units held and valuation. The category line on the left shows the number of active investment funds and their total value, converted into your entity currency.

Image

Note: an investment fund whose units are all sold stays in the list with a valuation of 0. It is no longer counted in the number of active investment funds.

Enter the history of an investment fund

You can enter the history of an investment fund in two ways, only when you create the investment fund. You cannot import a history into an existing investment fund.

Import a file:

  • In the creation form, click Download a template .

  • Fill in the Buy tab with your buys and the Sell tab with your sells. Both tabs have the same columns: Date , Unit price , Number of units .

  • Drop the file in the import area: one XLSX file per investment fund, 50 MB max.

  • Check the imported movements in the form.

Enter movements manually: for each movement, choose the direction, enter the settlement date, the number of units and the unit price, then click Add movement to add the next one.

Image

Rules for the history of an investment fund, imported or manual:

  • The first movement must be a buy.

  • All dates must be in the past, today is not accepted.

  • The number of units held can never go below zero. A sale larger than the units held is refused.

  • If the file contains errors, the movements are loaded into the form and the invalid cells are flagged. Fix them in the form, or fix the file and import it again.

  • A file that cannot be read is refused: a file that is not an XLSX, a missing or renamed Buy or Sell tab, or missing columns.

Below the history, the Number of units field shows the units held after your last movement, so you can check the history against your own records.

Important: investment funds are modelled without entry or exit fees. If your investment fund charges fees, you can click Book a call in the banner of the creation form to get in contact with us.

Follow an investment fund

In Financing > Financial investments > Investments , click an investment fund in the list. The side panel of the investment fund shows its valuation, the valuation date and two tabs:

  • Movements : every buy and sell (up to 500 movements), with its type, date, number of units, unit price, amount and realized gain. Buys are shown as a positive amount, sells as a negative amount.

  • Details : ISIN, unit price availability, gain calculation method, latest unit price, number of units and notes.

Image

Each movement of an investment fund has a status:

  • Estimated : a planned movement whose settlement date is not reached. Its unit price is an estimate.

  • Confirmed : the movement is settled and its unit price is final.

  • Reconciled : the movement is matched with a bank transaction. Its amount is the amount debited or credited by your bank.

The actions are at the bottom of the side panel: Add movement , Update unit price and Delete (it deletes the investment fund).

You cannot export an investment fund, and the unit price history is not shown as a chart.

Add a buy or a sell to an investment fund

  • Open the side panel of the investment fund.

  • Click Add movement .

  • Choose Buy or Sell .

  • Enter the settlement date, the number of units and the unit price. Agicap computes the amount.

  • If the settlement date is today or later, choose the Bank account . This field is required for a planned movement.

  • Validate.

If the settlement date is in the past , the movement is Confirmed with the unit price you entered. The number of units held is updated right away. No bank account is needed.

If the settlement date is today or later , Agicap creates an expected transaction on the bank account you chose, so the planned buy or sell shows in your cash flow forecast. The movement is Estimated until its settlement date, with the latest known unit price as an estimate.

Image

What happens to a planned movement of an investment fund

  • If bank reconciliation is on for investment installments: once the bank transaction is reconciled with the expected transaction, Agicap takes the amount debited or credited, computes the real unit price (amount ÷ number of units) and marks the movement as Reconciled .

  • If bank reconciliation is off for investment installments: the movement is marked as Confirmed on its settlement date, with the unit price you entered.

Agicap checks planned movements of investment funds every hour between 7:00 and 13:00 (Paris time), on business days only. If the settlement date is on a weekend, or if the reconciliation is done after 13:00, the movement is updated the next business morning.

Until a planned movement is confirmed or reconciled, it does not count in the number of units held, and a planned sale shows no realized gain.

Note: once a buy or a sell is confirmed or reconciled, its unit price becomes the latest known unit price of the investment fund, and the valuation is updated. A unit price you enter with Update unit price on the same date takes precedence.

Delete a movement of an investment fund

  • Open the side panel of the investment fund.

  • In the Movements tab, delete the estimated or confirmed movement.

Once the movement is deleted , the realized gains of the following sales are recomputed. If the movement was planned, its expected transaction is also deleted from your cash flow forecast.

You cannot edit a movement of an investment fund. To fix a movement, delete it and add it again with the right values.

You cannot delete a reconciled movement, or a planned movement whose expected transaction is reconciled. You cannot delete a buy if the number of units held would go below zero at any date: delete the later sales first.


Update the unit price of an investment fund

  • Open the side panel of the investment fund.

  • Click Update unit price .

  • Enter the valuation date (today at the latest) and the new unit price.

  • Click Validate .

Image

Once you validate , the valuation of the investment fund is recomputed with this unit price, in the investment funds list and in your Cash Flow Plan. If you already entered a unit price on that date, it is replaced.

The latest known unit price of an investment fund comes from a unit price you entered, or from a confirmed or reconciled movement. On the same date, a unit price you entered takes precedence over movement prices. If several movements on the same date have different prices, the highest one is used, and a warning shows on the investment fund.

The unit price of an investment fund does not come from a market data feed, and there is no alert when the latest unit price gets old. Update it every time you receive the NAV from your bank or management company.

How the realized gain of an investment fund is calculated

Agicap computes the realized gain of each confirmed sale of an investment fund with the method chosen when the investment fund was created. The realized gain is shown in the currency of the investment fund, rounded to 2 decimals.

Example for both methods: you buy 4 units at €1,000, then 2 units at €1,200, then 3 units at €1,300. Then you sell 6 units at €1,400 (sale amount: €8,400).

Weighted average cost

The average cost of a unit is recomputed after each buy: total amount bought ÷ total units bought. A sale does not change the average cost. If all units are sold, the average cost starts again from zero at the next buy.

Realized gain = units sold × (sale price − average cost).

In the example, the average cost is €10,300 ÷ 9 = €1,144.44. Realized gain = 6 × (€1,400 − €1,144.44) = €1,533.33. 3 units remain, at an average cost of €1,144.44.

FIFO (First in, first out)

Each buy forms a lot. A sale uses the oldest lots first. If a lot is partly used, the remaining units keep their original price.

Realized gain = sale amount − purchase cost of the units sold.

In the example, the 6 units sold come from the first lot (4 × €1,000) and the second lot (2 × €1,200): purchase cost €6,400. Realized gain = €8,400 − €6,400 = €2,000. 3 units of the third lot remain, at €1,300.

Realized gains are recomputed every time the movements change. If you add or delete a movement with a past date, the realized gains of the following sales are updated.

Agicap shows only the realized gain of each confirmed sale. The unrealized gain, the invested amount and the cumulative realized gain of an investment fund are not displayed.

FAQ

Why was my planned movement confirmed with the estimated unit price?

Bank reconciliation is not on for investment installments on this entity. In this case, a planned movement of an investment fund is confirmed on its settlement date with the unit price you entered. To get the real unit price for the next movements, go to Settings > Treasury > Reconciliation > Reconciliation scope and turn on Investment installments . To fix a movement already confirmed, delete it and add it again with the real unit price.

Why is my planned movement still estimated after its settlement date?

If bank reconciliation is on for investment installments, a planned movement of an investment fund is updated only after its expected transaction is reconciled with the bank transaction. Check these points:

  • Agicap checks planned movements every hour between 7:00 and 13:00 (Paris time), on business days only. There is no refresh button.

  • The bank transaction must be reconciled with the expected transaction.

  • Only these reconciliations confirm a movement: one bank transaction for one expected transaction, or several bank transactions for one expected transaction, with no gap or with the gap ignored. One bank transaction split across several expected transactions, a gap kept open, or bank transactions in different currencies leave the movement estimated.

Why did the valuation of my investment fund change without a unit price update?

A confirmed or reconciled buy or sell updates the latest known unit price of the investment fund, so the valuation changes. If you entered a unit price with Update unit price on the same date, your price is kept.

Why is the unit price of a reconciled movement different from the price I entered?

At reconciliation, Agicap replaces the estimated unit price with the real one: amount debited or credited by your bank ÷ number of units.

Why is my sale refused?

The sale is larger than the number of units held at that date. The number of units held can never go below zero. Planned buys that are not confirmed or reconciled do not count in the units held.

Why can't I delete a movement?

You cannot delete a reconciled movement, or a planned movement whose expected transaction is reconciled. You cannot delete a buy if the units held would go below zero at any date: delete the later sales first. If a reconciled movement is wrong, contact support.

I chose the wrong gain calculation method. What can I do?

You cannot change the gain calculation method of an investment fund. Delete the investment fund and create it again with its history. The import template makes this fast. Deleting an investment fund also deletes its expected transactions.

Why is my ISIN refused?

The ISIN must have 12 characters: 2 letters, 9 letters or digits, and 1 check digit, with no spaces. You also cannot add the same ISIN twice on the same entity: use the existing investment fund. You can use the same ISIN on another entity.

Why does my import show errors?

Common errors: a date that is not in the past, a number of units or a unit price that is empty, zero or negative, a first movement that is a sale, or a sale larger than the units held. Numbers and dates stored as text are read only in the formats 1000.12 and yyyy-mm-dd. Fix the flagged cells in the form, or start again from the template downloaded in the form.

Did this answer your question?