Works with Exact Online

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.

Claude logo Cashflow Cockpit
Kasstroom, werkkapitaal en scenario's
AI Connect verbonden
Administratie Van Dijk Groothandel ▾ Periode 12 maanden ▾ MaandKwartaal
Gemaakt in Claude · cijfers uit je administratieVoorbeeld met fictieve cijfers.
AI assistant Claude logo Claude
Accounting Exact Online logo Exact Online

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.

Liquidity trend with the net change per month
Cash flow per activity
Waterfall from opening balance to closing balance
Cash flow statement per month, switchable between the direct and the indirect method

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

326k+194k−86k+34k−30k438k
Opening balanceOperatingInvestingFinancingTechnicalClosing balance
Cash flow statementPer month, with a total column ✓ methods matchIndirectDirect
ItemMay 26Jun 26Jul 26Aug 26Total
Profit before tax12.4k9.8k18.2k16.1k168.5k
Depreciation4.9k4.9k4.9k053.9k
Change in provisions01.4k01.8k5.3k
Change in working capital−8.1k3.2k−5.4k1.9k−34.2k
Operating cash flow9.2k19.3k17.7k19.8k193.5k
Investing cash flow−7.4k0−12.1k−4.8k−86.0k
Financing cash flow−7.2k−37.2k−7.2k−7.2k34.0k
Opening and closing entries0000−30.0k
Net change−5.4k−17.9k−1.6k7.8k111.5k

Part 02

Working capital

What is tied up in invoices and stock, and with whom.

Working capital development per month
Ageing of outstanding receivables
Ageing of outstanding payables
Largest outstanding items, with days overdue

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

Not due112,400
1 to 30 days40,800
31 to 60 days19,100
61 to 90 days7,900
Older than 904,370
Largest outstanding itemsSorted by amount ReceivablesPayables
RelationDue dateDaysAmount
Meridian Supply B.V.18 Jun744,900
Hoogendijk Techniek01 Jul612,850
Vandenberg Retail24 Jul382,700
Norhaven Logistics23 Aug82,450
De Wit Installaties22 Aug92,350

Part 03

Result and mix

Where the revenue and the costs come from.

Revenue per month against last year
Revenue breakdown per general ledger account
Cost breakdown per general ledger account
Budget versus actuals

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.

Revenue breakdownTotal financial year € 1,548,200 ChartTable
Trade revenue high742,100
Trade revenue low386,400
Service subscriptions228,900
Assembly and installation141,700
Other income49,100

Budget versus actuals

Only for the months for which a budget has been entered

No budget was found in this administration. As soon as there are budget lines in your package, the comparison per month will appear here, with the variance in euros and in percentages. Budgets are only read; you enter them in your accounting package itself.

Part 04

Outlook

What happens when you adjust the dials.

Cash projection six months ahead
Three scenarios plus your own scenario
Sliders for revenue growth, costs, payment terms and investments
The assumptions and the calculation model available in a drop-down

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.

Scenarios, cash projection for the next 6 monthsNormalised run-rate over the last six full months BaseCautiousAmbitious
augsepoctnovdecjanfeb
BaseCautiousAmbitiousBuffer threshold
Revenue growth p/m0%
Cost change p/m0%
Debtor payment term0 days
Investments p/m€ 0
Expected balance +6 mo€ 545,000
Lowest point€ 431,000
Drops below buffernot within this horizon
Balance negativenot within this horizon

▾ Assumptions and calculation model

Part 05

Substantiation

Why you can trust the figures.

Six checks on reconciliation and completeness
The classification from account type to cash flow category
An explanation of the method used

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

✓Direct and indirect method. Both arrive at the same amount in all twelve months, difference € 0.
✓Movement matrix. The sum of all movements per type reconciles with the totals from the accounts.
✓Opening balance. Built up from the liquid movements before September 2025, € 326,450.
✓Open items. 148 receivable and 62 payable invoices, reconcile with the ledger balance for accounts receivable and payable.
●Classification. One account type falls outside the standard classification; the cash effect of € 2,100 is included in the Opening and closing entries line of the waterfall.
●Current month. August has not yet been fully processed; further bank entries may still be added.

▾ 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.

Claude logo Liquidity forecast demo administration, fictitious figures Full screen ↗

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

8000 Revenue trade goods Type: revenue

Administration B

4200 Sales services Type: revenue

Administration C

3010 Revenue subscriptions Type: revenue

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.

What you start with Create a cashflow dashboard for Van Dijk Groothandel covering the last twelve months, with a forecast for the coming six months, scenarios and budget included.

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.

01

Download the file

One file, which you don't need to unpack.

02

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.

03

Turn on the connector

AI Connect links Claude to your administration. The skill is built on Exact Online.

04

Ask for your dashboard

In plain language. The skill knows the rest.

Create a cash flow dashboard for Van Dijk Groothandel covering the last twelve months, with a forecast for the coming six months, scenarios and a budget included.
Skill fileai-connect-cashflow.skill
Download the skill

48 kB · no installer

You may open and adjust it. There is no key or licence inside, only the method.

No AI Connect yet? Try it free for thirty daysNo payment details required, so you can see the forecast on your own figures first. The skill runs on AI Connect with the Analytics subscription, plus a paid Claude subscription.
Request your trial period

Security

Your data is safe with our ISO 27001 certification

ISO 27001 certificationWe meet the strictest ISO 27001 standards, so your data is protected to the highest degree. Work with confidence, knowing your data is in safe hands.
Privacy guaranteedFor us, privacy is not a side issue but a core value. Our processes are designed to protect your data as much as possible.
Security as a foundationFrom authentication to processing, every part of our solution meets the highest information security requirements.
ISO 27001 logo

ISO 27001

Certified

Rely on the connector

Kalender met klok

Try 30 days for free

Flexible subscription without long-term commitments. Installed within 2 minutes.

Handdruk

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.

Tandwiel met sterretjes

Professional support

Install it easily yourself, or choose the installation assistance. Various SLA levels are available for support.

Geopend hangslot

Security guaranteed

The connector meets the highest security standard (ISO 27001 certified).

We are an official partner of Exact Online AFAS Twinfield

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% discount

per user per month, with annual payment

Prefer to pay monthly? Then it is € 79 per user per month.

Included 1 administration
Set-up costs None

✓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.

Free, 30 minutes

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 consultation

Completely non-binding, no obligations

Choose your own time

MoTuWeThFrSaSu

Instantly confirmed

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.