Your cash flow forecast in 1 question
Fourteen overviews from your own administration: where your balance is heading, what is tied up in invoices and stock, and how your liquidity looks over the coming six months when you adjust the settings. At the bottom each check shows whether the figures add up, so you know it is correct before you send it to your bank or accountant.
- Six-month cash flow forecast, with working capital, cash flow and result alongside it
- Works in any administration, because the layout is based on account type and not on ledger number
- The cash flow is calculated using two methods and the difference is shown
Entirely without obligation, no payment details needed.
Kasstroom, werkkapitaal en scenario's AI Connect verbonden
Saldo einde maand, met de netto mutatie eronder
Operationeel, investeringen en financiering per kwartaal
Waterval over de gekozen periode
Indirecte methode, laatste vier maanden
€ 184.570 over 148 facturen
€ 98.764 over 62 facturen
Met het aantal dagen na de vervaldatum
Totaal boekjaar € 1.548.200
Totaal boekjaar € 1.264.900
Alleen over de maanden waarvoor budget is ingevoerd
Genormaliseerde run-rate over de laatste zes volledige maanden
Het dashboard controleert zichzelf en laat zien wat het niet weet
The structure
Five questions, fourteen overviews
The dashboard is organised around the questions you ask yourself: where is my balance heading, what is tied up in invoices, where does the revenue come from, what if things go wrong, and do the figures add up. For each part you can read what you see and how it was calculated. Every chart can also be shown as a table, for the exact amount.
Part 01
Liquidity
Where your balance is heading, and what is driving it.
Why this adds up. The two methods must by definition arrive at the same result, because the change in your liquid accounts is the net cash flow. The dashboard calculates them both and shows the difference per month. That is exactly the check you would have to carry out yourself with a hand-made overview.
From opening balance to closing balance
Waterfall over the selected period
Part 02
Working capital
What is tied up in invoices and stock, and with whom.
Why from the open items. DSO and DPO come from your outstanding invoices and not from the general ledger balance, because that can produce a number of days that makes no sense.
Ageing of outstanding receivables
€ 184,570 over 148 invoices, balance as at 31 August
Part 03
Result and mix
Where the revenue and the costs come from.
Why the budget card can be empty. The comparison only covers the months for which you have entered a budget. If there is no budget in your package, the card stays empty with an explanation instead of with zeros.
Budget versus actuals
Only for the months for which a budget has been entered
Part 04
Outlook
What happens when you adjust the dials.
Why the projection is normalised. The calculation uses a normalised run-rate, so a wave of collections or a catch-up effort is not projected forward as if it were structural.
▾ Assumptions and calculation model
Part 05
Substantiation
Why you can trust the figures.
What makes this different. Every check is shown with its outcome. What the dashboard does not know is flagged rather than left out: an account type that falls outside the classification does not disappear, but gets its own line with its cash effect.
Data quality and reconciliation
Six checks on the data used
▾ Classification: account type to cash flow category ▾ Explanation of the method
Demo
Click through it yourself
A real dashboard from Claude, built on a demo administration. The figures are made up, but the filters, the tabs and the sliders work exactly as they would with your own figures.
The demo was made in Exact Online. You scroll through the entire dashboard within the window, or you open the full screen.
Why it works everywhere
No setup per administration
Ledger numbers differ per administration: 4000 is staff costs for one and purchasing for another. The type and role of the account is recorded by every package, and those mean the same thing everywhere. The classification is based on that, which is why the same setup works in your administration, that of your holding company and that of your client, without anything needing to be connected in advance.
Administration A
Administration B
Administration C
In the dashboard
Operational cash flow
Three different numbers, the same place in the cash flow statement. Without anyone setting that up in advance.
The full breakdown from account type to cash flow category is shown in a collapsible section at the bottom of the dashboard, so you can check where an amount ends up.
Data
What it pulls from your records
Six types of data, nothing more. A dashboard only retrieves what it needs to calculate; nothing is written away or changed.
Movement matrix
The change per account type per month. This is where all cash flow calculations and the balance development come from.
Opening balance
The liquid movements from before the chosen period. That is the starting point of the waterfall and of the development.
Ledger detail
The profit and loss accounts per month, for the revenue build-up and the cost build-up.
Open items
The accounts receivable and accounts payable sub-ledger, for your DSO and DPO, the ageing and the largest outstanding items.
Budget lines
If they are in your package, for the comparison between budget and actuals. They are read, never written.
Control totals
Totals per account type and per ledger account. These are used to check whether nothing was lost along the way.
Your own permissions apply
The connector sees no more than you are allowed to see in your accounting package.
Opening entries separate
These are not cash flow, but they do count towards your balance. That is why they get their own line.
Only the dashboard reads
The connector itself can do more. Changes happen in a conversation, with your approval.
Setup
How the dashboard comes together
You start with a single instruction, but behind it sits a fixed order. The check deliberately comes before the building: a dashboard with the wrong figures is worse than no dashboard.
The first time takes longer than you are used to with a report, because things are genuinely calculated and checked. After that you open the same dashboard again and no longer need to ask that question.
Want to see step by step how to request and save such a dashboard yourself? Read Creating dashboards in Claude.
01
Set out what you want to see
Which administrations, which period, and whether the scenarios and the budget should be included. By default that is last year plus the current year, with both switched on.
02
The data is retrieved
Per administration the six types of data from the previous section, including the control totals. Each result is recorded literally rather than summarised, so a transfer error becomes visible instead of being counted along.
03
The figures go through the checks
Do the totals add up? Is a month missing? Is the number of outstanding items correct? If something does not match, it is first resolved in the figures themselves, not hidden away in the dashboard. Only when everything is correct does the building start.
04
The dashboard is built and reviewed
From a fixed, tested setup, with your own name and logo in the bar. After that the key figures are compared with the outcomes of the check, so what you see at the top matches what has been calculated below.
05
You receive the dashboard with a summary
The dashboard sits as its own page in Claude. Alongside it you get a few sentences on what stands out: where your balance is heading, the biggest movements, your DSO and DPO, and whether the base scenario drops below your buffer.
Calculation choices
Four choices that have already been made
Every overview contains assumptions. In most reports you never see them. These four are listed here with the reasoning behind them, and you can have them adjusted when your situation calls for it.
DSO and DPO from the outstanding invoices
Not from the general ledger balance. That can run negative because of a payment received in advance or one that has not yet been reconciled, giving a number of days that makes no sense. The trend chart does use the ledger balances, because only those have a history.
The forecast runs on a normalised run-rate
The median of profit plus depreciation over the last six full months, working capital neutral. Projecting on the bare operating cash flow would carry a collection surge or a payment catch-up forward as if it were structural.
Budget only over the months for which a budget has been entered
Otherwise you place ten months of actuals next to six months of budget and there seems to be a variance that is not there. If your package holds no budget, that card stays empty with an explanation instead of with zeros.
Not a single number sits only in a tooltip
Figures that only appear in a tooltip cannot be checked and cannot be passed on. That is why the table is simply available with every chart, so you can copy an amount without hovering your mouse over a bar.
At the bottom of the dashboard you will find the full explanation of the method, plus the breakdown from account type to cash flow category. That way you can check for yourself where an amount comes from.
Please note
What you need to know before drawing conclusions
A few things determine how you should read the figures. The dashboard points them out itself, but it helps to know them in advance.
Current status
The current month is not yet complete
Bank entries for this month have often not all been processed yet. The dashboard marks that month, so you do not count it as a full month in your trend or your average.
First time
The first retrieval takes longer
On Analytics your figures are prepared once so they are ready to calculate with, so the dashboard works through hundreds of thousands of lines in seconds instead of minutes. That first time can take up to twenty-four hours. After that it is done, and every time you open the dashboard the current figures come in. If you connect a new administration later, that one is prepared again. It keeps reading, and nothing changes in your administration.
Check
Check the opening balance once
Compare the opening balance with the actual opening figure from your bank. If it matches, the whole waterfall is correct, because everything after that is built up from it. If it does not match, the cause is almost always the chosen start date.
Subscription
Dashboards require Analytics
Dashboards only work on the Analytics subscription. On Essentials you can ask questions about your administration and get an answer in the conversation, but no dashboard is built that you open separately. You also need a paid Claude subscription. Compare the subscriptions side by side.
Adjusting
It doesn't stop at delivery
If you want to see something different in an ordinary report, someone usually has to step in and adjust it. Here you simply ask Claude. These are the four things people ask for most often, and what changes as a result.
Set my lower limit at two hundred thousand instead of one hundred and fifty thousand.
The dotted line in the scenario graph shifts and the row below recalculates whether you drop below that limit within this horizon.
Show the revenue breakdown per customer instead of per account.
The same card, a different layout. For this your records do need to have been booked per customer or per cost centre.
Where does that dip in May come from?
Nothing changes on the dashboard. You get your answer in the conversation, with the bookings underneath. If you like it, you ask whether it can be added as a fixed card.
Create a scenario for if that big order goes through.
Alongside the three fixed scenarios, a custom scenario is added, with your own assumptions under the sliders. The rest of the dashboard stays untouched.
What you change stays saved. Open the dashboard again next month and your own layout is still there, with the figures from that moment.
Ready to use
The whole dashboard in one file
Everything above sits in a skill: which data is retrieved, how calculations are done, which checks run and how it looks. You set it up once in Claude and after that it is a one-sentence instruction.
Download the file
One file, which you don't need to unpack.
Add it to Claude
Go to Customize → Skills, click Add and select the file. You do this once, after that it is ready in every conversation.
Turn on the connector
AI Connect links Claude to your administration. The skill is built on Exact Online.
Ask for your dashboard
In plain language. The skill knows the rest.
You may open and adjust it. There is no key or licence inside, only the method.
Security
Your data is safe with our ISO 27001 certification
ISO 27001
Certified
Rely on the connector
Try 30 days for free
Flexible subscription without long-term commitments. Installed within 2 minutes.
Built by specialists
For more than ten years we have been connecting Exact Online, AFAS and Twinfield to other systems. That knowledge of the accounting packages is also built into AI Connect.
Professional support
Install it easily yourself, or choose the installation assistance. Various SLA levels are available for support.
Security guaranteed
The connector meets the highest security standard (ISO 27001 certified).
We are an official partner of
What it costs
One subscription, all dashboards
You pay for the connector, not per dashboard. Whether you build one or ten, and whether you open it every week or once a quarter.
Subscription
AI Connect Analytics
€ 71,10
10% discountper user per month, with annual payment
Prefer to pay monthly? Then it is € 79 per user per month.
✓Thirty days free trial
✓No payment details when you sign up
✓Monthly or annually, you choose
All dashboards included
Liquidity forecast, month-end close, accounts receivable management, intercompany, management information and the trade cockpit. You pay for the connector, not per dashboard.
One administration included
Add more administrations as you need them. The more you connect, the lower the price per administration.
Your own permissions apply
The connector sees no more than you are allowed to see. A dashboard only reads; changes happen with your approval.
No set-up costs
No configuration needed. You connect it yourself and are up and running within an hour.
Dashboards only work on Analytics. On Essentials you can still ask questions about your administration. You also need a paid Claude subscription, because that is where the dashboard lives. Compare the subscriptions side by side.
Still have questions? Schedule a free consultation
In 30 minutes, we'll review your situation together and show you live what the connector can do for you. You'll speak directly with one of our specialists.
Schedule your free consultationCompletely non-binding, no obligations
Instantly confirmed
Relevant blogs
Frequently asked questions
A liquidity forecast shows how your bank balance develops over the coming months: what comes in, what goes out and when things get tight. You usually make this in Excel, with expected income and expenses per month that you fill in and maintain yourself. You can read how to do this step by step in creating a liquidity forecast yourself: steps and example.
Here the forecast comes from your administration itself. The dashboard starts from your current balance and your outstanding items, and then calculates six months ahead on a normalised run rate from the last six full months, so that a one-off collection wave or payment catch-up is not projected as if it were structural. With the sliders for revenue growth, costs, payment term and investments you create your own scenario, and the assumptions are shown in a collapsible section next to the calculation model.
A liquidity budget is the plan. You usually make it once a year, often for the bank or when making an investment, and in it you record what you expect to come in and go out. A liquidity forecast is the updated expectation: it starts from what is actually in the bank and outstanding right now, and looks a few months ahead from there.
It is best to put them side by side. If the forecast deviates from the budget, you know where to adjust. If there is a budget in your administration, the dashboard also shows the actuals next to your budget.
At least every month, after the bank has been updated, and more often if things get tight or a large payment is coming up. A forecast you do not update falls behind reality within a few weeks.
With this dashboard you do not have to update anything yourself: every time you open it, it calculates with your balance and outstanding items at that moment. Do make sure your bank entries are up to date, because that is where the forecast starts.
As supporting evidence, yes. The dashboard shows the balance trend over the past twelve months, the cash flow per activity and a six-month projection with the underlying assumptions, and every chart has a table view that you can drop straight into your own document. If the bank asks for a fixed format, you fill it in with these figures. What the dashboard does not do is complete a budget for you: it calculates with what is in your records and with the scenarios you set yourself.
Live. Every time you open the dashboard, the figures of that moment come in. If you already have it open, it does not refresh on its own; just refresh the page to see new entries. If your accountant posts something in November relating to October, you will see that straight away. The current month is marked, because bank entries are often still missing there. Only the very first time does it take longer, because your records are then prepared to be calculated with.
No. The breakdown is based on the type of the general ledger account, and that field is already in your records. So no model needs to be built and no ledger numbers need to be connected.
Dashboards are part of Analytics. On Essentials you can ask questions about your records and get an answer in the conversation, but no dashboard is built that you can open separately and review again later. That difference comes down to computing power: a dashboard covers your entire administration, often over several years, and for that your data is prepared at Analytics. View the subscriptions side by side.
Then the budget versus actuals card stays empty, with an explanation instead of zeros. Budget lines are only read, so you enter them in your accounting package itself. If you do want a comparison, you can compare with last year instead of with budget.
Yes. In the filter bar you choose an administration, or you place them side by side or add them together. The checks run separately per administration, so you see straight away which entity has something that does not match. The subscription includes one administration; you connect more alongside it, and the more you connect the lower the price per administration.
No. A dashboard retrieves and calculates, it writes nothing back. The AI Connect connector itself can do more than read, but changes always happen in a conversation and only after you have given your approval.
Exact AI Connect
Connect Exact Online to your AI assistant
Choose your assistant and leave your email address. You will immediately see the right steps.
✓ Details received
Installation instructions
Need help? Check out our help article or get in touch with us.