What it does

The Cashflow Prognose skill automates the generation of monthly liquidity forecasts for financial professionals. By processing a CSV of recurring and one-off income/expense items through a dedicated Python execution engine, it transforms raw data into a structured monthly planning overview. It identifies months with potential deficits and tracks cumulative balances over a defined horizon (up to 60 months).

Why use this skill

Standard LLM prompting often struggles with precise multi-month calculations, especially when handling varying frequencies like quarterly VAT payments or annual insurance premiums alongside monthly recurring costs. This skill uses a logic-based Python script to ensure mathematical accuracy and consistency. It specifically addresses "what-if" scenarios by allowing you to quickly rerun simulations with different starting balances or investment timings.

Key Features

• Automated calculation of monthly net cashflow and closing balances.
• Support for multiple frequencies: monthly, quarterly, annual, and one-time events.
• Automatic deficit signaling for early warning on liquidity issues.
• Structured Dutch-language reports suitable for communication between accountants and clients.
• Scenario support for optimistic vs. pessimistic forecasting.

Output

The skill generates a detailed monthly table (Revenue, Expenses, Net, Balance), a prominent list of months where the balance drops below zero, and a clear list of assumptions used in the model to ensure transparency and accountability.