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:
Click on the "..." to display options
Set-up VAT
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).
Find the categories to match
You can also split revenues and charges between different categories by a percentage that you can choose
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.
Click on Add delay or due date
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, ...)
Select the % of the amount affected by the delay and the delay itself
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:
You can add an investment by clicking on Add investment
Give a name to the investment
You choose an Agicap category
Insert the amount and choose a date for the cash outflow
Click Confirm
For upcoming funding:
Add the funding by clicking on Add an upcoming funding
Choose a name
Select the type of funding
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 🎉