Do you already have a forecasted P&L and you want to create your cash flow forecast based on this information? It’s possible on Agicap!✨
1️⃣ Activation of the P&L to cash option
First, make sure that when you hover over 'Cashflow' on the top left of your screen in the blue banner, you have a line: P&L conversion
If this is not the case, it simply means that the feature is not yet activated. Just write us on the Chat via the blue tab at the bottom right of your page, so that we can activate it in a few clicks. 💪
If so, here we go!
2️⃣Preparation of the file to be imported
Hover your mouse over 'Cashflow' in the top left in the blue banner
Then click on P&L conversion to start setting up!
Once you are in the module, click the blue text 'Download a template' in the center of your page
You can then fill in this template with the rows of your P&L.
Remember to follow the following instructions:
Keep the layout of the template
Lines that correspond to disbursements must include negative amounts. Conversely, the lines corresponding to collections must always be positive.
Pay attention to the instructions in cell A1 of the model. ✅
3️⃣ Import of the income statement
It’s alright, you can import your forecast in Agicap! 🎉
To do this, go back to the P&L Conversion page by placing your mouse on 'Cashflow' at the top left of your screen in the blue banner
Then by clicking on 'Import Excel file' (if it is the first time you do it) or 'Convert' if you need to update
Then select your file
💡 Good to know: It is important to convert your forecasted P&L into cash in order to properly take into account VAT, payment delays or investments.
💡💡 Good to know: Once you have imported your first P&L, do not forget to update your cash flow forecast from your new income statement regurlarly.