1️⃣ Import Your P&L Forecast
Start by importing your Profit and Loss (P&L) forecast into Agicap.
Format requirements:
The P&L must be built on a monthly basis (one column per month).
Use our provided template to ensure correct formatting.
Important considerations:
You can add up to 600 lines and forecast up to 36 months.
All months must be indicated using the first day of the month, and each month should appear only once.
Ensure that two P&L lines do not have the same name, and there must be at least one P&L line.
Cash outflows should be written in parentheses, e.g.,
(6000), not with a minus sign-6000.
2️⃣ Match P&L Lines to Agicap Categories
Next, match your P&L lines with Agicap categories to align your data accurately.
How to match categories:
Select a P&L line and click the matching button to choose the corresponding Agicap category.
You can also bulk match multiple lines at once.
Guidelines for matching:
Match revenue and expense lines with the appropriate inflow and outflow categories.
If a P&L line has no impact on cash (e.g., depreciation), do not match it to any category.
You can split a P&L line between multiple categories by assigning percentages.
About VAT:
Agicap uses VAT rates from categories to convert amounts excluding VAT (in your P&L) to amounts including VAT (for your cash flow plan).
Ensure that VAT rates are correctly set for each category.
3️⃣ Set Delays and Due Dates
Define when payments occur to accurately reflect cash movements.
Payment terms and deadlines:
For each P&L line, you can set multiple delays and deadlines for portions of the amount.
The total percentages must add up to 100%.
Options available:
Delay: Set a payment term in days (e.g., 30 days after the invoice date).
💡 Note: Payment terms are applied proportionally based on the days in the month.
Monthly deadline: Choose a specific day each month when payments are made.
Quarterly deadline: Set payments to occur on a specific day each quarter.
Yearly deadline: Schedule annual payments on a specific date.
Example:
If you pay wages on the 30th of each month, set a monthly deadline for the wages category on day 30.
4️⃣ Add Investments, Upcoming Funding, and Loans
Include significant cash events not present in your P&L forecast.
🚜 Investments
Purpose: Add planned investments that impact your cash flow but are not in your P&L forecast.
How to add:
Specify the investment amount, date, and the Agicap category.
VAT will be applied based on the category's VAT rate.
💵 Upcoming Funding
Types of funding:
Bank loans
Current account contributions
Subsidies
Capital increases
How to add a bank loan:
Enter the loan amount, date of receipt, interest rate, loan term, and any deferred payment.
Agicap calculates repayment amounts and schedules outflows accordingly.
Note:
Ensure the VAT rate for funding categories is set to 0%, as funding does not include VAT.
💵 Loans in Progress
Purpose: Include existing loans that impact your cash flow.
How to add:
Specify repayment recurrence (monthly, quarterly, yearly).
Enter the amount per repayment, next due date, and remaining number of payments.
Assign the appropriate outflow category.
5️⃣ Choose the Period and Scenario
Finalize the conversion and update your cash flow plan.
Select the period:
Decide whether to update forecasts from the current month onwards or include past periods.
💡 Including past periods can improve accuracy for current forecasts if payments are delayed.
Select the scenario:
Choose the cash flow scenario where you want to apply the forecast.
✅ Note: You cannot update a frozen scenario using this feature.
💡 Tips
Import past P&L data: Importing 1 to 3 months of past P&L data can enhance the accuracy of your current cash flow forecast.
Updating settings: After changing settings in steps 2️⃣, 3️⃣, or 4️⃣, remember to complete the conversion process to apply changes to your forecast.
Resetting forecasts: If needed, you can reset forecasts by deleting them manually or using the "Reset all future forecasts for imported categories" option during data import.
FAQ ❓
What happens if I change the structure of my P&L file?
If you import a new P&L file with changes (new or removed lines), Agicap will prompt you to confirm the changes. Your previous settings will be preserved where possible.
Can I have different P&L structures for different scenarios?
No, it is not possible to have different P&L structures for different scenarios. The P&L structure is shared across scenarios.
How does Agicap handle VAT in the P&L to Cash conversion?
Agicap uses the VAT rates set in your categories to convert amounts excluding VAT (from your P&L) to amounts including VAT in your cash flow plan.