Convert your P&L into a cashflow forecast
Davide Lacara avatar
Written by Davide Lacara
Updated over a week ago

Have you already prepared your P&L to be imported on Agicap? Let's convert it then ✨

⚠️ Before starting, you should also ensure that the VAT rates were set up correctly so that the amounts can be accordingly converted into including-tax amounts. How to do so?

You just need to go to the Category tab, then for each category:

  1. Click on the "..." to display options

  2. Set-up VAT

  3. Choose the correct rate

1️⃣ Matching Categories

In order to be able to convert the P&L amounts into cash forecasts, we first have to match its P&L lines (revenues and charges) with the categories in Agicap (inflows and outflows).

  1. Find the categories to match

  2. You can also split revenues and charges between different categories by a percentage that you can choose

  3. When this process is done, click on next step

💡 Amortization, totals... should not be matched to any categories

2️⃣ Setting delays and due dates

For each line matched with an Agicap category, multiple delays and deadlines can be set for a fraction of the amount.

  1. Click on Add delay or due date

  2. Select whether it is Payment term (a number of defined days for example 45 days) or a deadline (the following month, 2 months later, 3 months later, ...)

  3. Select the % of the amount affected by the delay and the delay itself

  4. Click on Next step once you are done

💡 Deadlines are better suited than payment terms for expenses such as wages or taxes

3️⃣ Add elements that are not included in the P&L

Investments and funding do not appear on the P&L forecast, as they have an impact on the balance sheet. However, they are likely to have a very significant impact on cash.

For investments:

  1. You can add an investment by clicking on Add investment

  2. Give a name to the investment

  3. You choose an Agicap category

  4. Insert the amount and choose a date for the cash outflow

  5. Click Confirm

For upcoming funding:

  1. Add the funding by clicking on Add an upcoming funding

  2. Choose a name

  3. Select the type of funding

  4. If it is a bank loan, you have to set up the date when they plan to receive the money, the rate of the loan, the length, a deferred payment if relevant, and the categories where we'll put the associated inflow and outflows

If the loan is already in progress, select Add a current loan and select the remaining due dates, the amount and the next due date.

Once you are done, you can click on Create my forecast 🎉

Did this answer your question?