Works with Exact Online

The financial dashboard you do not have to build

Every month you pull the same figures from your bookkeeping and put them in Excel for your management report. That is no longer needed. Ask Claude for a financial dashboard and you get one that you simply open again next month, with the figures from that moment.

  • One question replaces your monthly Excel round
  • Your figures come live from your bookkeeping, not from an export
  • No Power BI licence needed

Entirely without obligation, no payment details needed.

Claude logo Claude Financial dashboard AI Connect connected
Accounts receivable Cash flow Revenue and margin Products
Administration Van Dijk Groothandel B.V. ▾ Period This quarter ▾ Currency EUR ▾
Outstanding
€ 70,000
42 invoices
Overdue
€ 27,900
▲ € 4,100
DSO
41 days
▼ 3 days
Oldest item
131 days
Dekker Montage
Outstanding by age days after invoice date
€42.1k€13.4k €8.2k€4.1k€2.2k 0–3031–60 61–9091–120120+
Within term or overdue outstanding now
60% within term Within term € 42,100 Overdue € 27,900
Largest outstanding items 5 of 42
CustomerInvoiceDaysAmount
Bouwbedrijf Reinders F-2041 47 € 8,240
Technisch Bureau Voss F-2088 71 € 6,115
Installatiegroep Meijer F-2135 22 € 5,870
Van Hoorn Retail F-2150 14 € 4,930
Meijer Holding F-2162 8 € 3,415
Total, 42 invoices € 70,000
Refreshed on opening Example with fictional figures.
AI assistant Claude logo Claude
Accounting Exact Online logo Exact Online

How it works

One question, and your dashboard is there

From question to dashboard, without an export or a pivot table.

Example with fictional figures.

You set nothing up in advance

You do not need to build a report or export anything. You ask in plain language what you want to know and the overview is built around that.

Adjusting takes one sentence

Do you want an extra column or prefer a chart over a table? Then you say so, and the dashboard adapts.

And next month just the same

You open the same dashboard again and the figures of that moment are already in it, or you have it run again with a single command.

In practice

It does not stop at an overview

A report is something you can only view. A dashboard in Claude is something you can also ask questions.

01

You ask for a dashboard

In plain language, and you say what it should cover. If you only want a single figure, there is no need to ask for a dashboard and you simply get your answer in the conversation.

Create a dashboard of my outstanding receivables, with the ageing and the largest items. AI ConnectI'll fetch your outstanding items and build a dashboard from them.
02

You get a dashboard

Claude turns it into a live artifact, a page of its own that you can open separately from the conversation and that stays saved.

Receivables Refreshes on opening
Outstanding € 70,000
Overdue € 27,900
Outstanding by ageing
0–3031–6061–9091–120120+
03

You carry on from the dashboard

Ask for an extra column or a different period, and the dashboard is updated. Ask for a follow-up step, and you first see what happens before you give your approval.

Prepare a reminder for the three items past 60 days.
AI Connect wants to create 3 reminders You see each reminder before anything goes out
Not now Allow

The examples above are about outstanding receivables. For your liquidity or your margins it works just the same.

Examples

Copy a question and see what comes out

Simple dashboards that appear within minutes, with no setup. Copy a question and try it with your own figures. The detailed dashboards are further down.

Outstanding items and DSO

1 example

Who needs to pay, who is falling behind, and whether your average payment term (DSO) is heading in the right direction. This is the dashboard most customers start with, because it brings in money straight away.

  • Ageing analysis
  • DSO
  • Ten largest items
  • Payment behaviour per customer
  • Overdue amount
Receivables this quarter AI Connect connected
Outstanding € 70,000 42 invoices
Overdue € 27,900 ▲ € 4,100
DSO 41 days ▼ 3 days
Within terms 60% ▲ 5%
Outstanding by age days after invoice date
€42.1k€13.4k €8.2k€4.1k€2.2k 0–3031–60 61–9091–120120+
Largest outstanding items 5 of 42
CustomerDaysAmount
Bouwbedrijf Reinders 47 € 8,240
Technisch Bureau Voss 71 € 6,115
Installatiegroep Meijer 22 € 5,870
Van Hoorn Retail 14 € 4,930
Meijer Holding 8 € 3,415
Total, 42 invoices € 70,000

Example with fictional figures, retrieved live from your administration.

Query

Create a dashboard of my outstanding receivables with an ageing analysis, my ten largest items and the average payment term.

Liquidity for 90 days

1 example

What comes in, what goes out and when your buffer gets tight. You set the limit yourself below which you want to receive a signal.

  • Bank balance
  • Expected income
  • Fixed costs
  • 90 days ahead
  • Buffer warning
Cashflow next 90 days AI Connect connected
Bank balance now € 48,200 3 accounts
Lowest point € 11,900 week 8, below limit
Expected in € 96,500 open invoices + expected turnover
Expected out € 84,100 incl. fixed costs
Expected bank balance per week limit € 15,000
limit 60k30k0 week 8 wk 1wk 12
What moves the balance 90 days
Receipts from debtors + € 96,500
Payments to creditors − € 44,300
Fixed costs incl. wages − € 31,800
Payroll tax and pension − € 8,000
Net movement + € 12,400
Query

Create a dashboard of my bank balance, expected income and fixed costs for the next 90 days, and mark the weeks in which the buffer drops below 15,000 euros.

Result versus budget

1 example

What becomes of your budget, per month and per cost item. Not at the end of the quarter, but the moment the difference arises.

  • Budget versus actual
  • Per general ledger account
  • Per month
  • Largest variances
  • Year to date
Result versus budget year to date AI Connect connected
Revenue € 1,240,000 ▲ 3% on budget
Costs € 1,058,000 ▲ 1% on budget
Result € 182,000 budgeted € 156,000
Variance + € 26,000 ahead of schedule
Result per month actual budgeted
37k JanFebMarApr MayJunJulAug
Largest variances 5 of 84 accounts
General ledger accountBudgetedOn result
4300 Third-party hire € 48,000 − 14,200
8000 Trade revenue € 720,000 + 38,500
4110 Transport costs € 36,000 − 6,900
4400 Marketing € 24,000 + 5,100
4210 Maintenance € 18,000 − 3,400
Net on result + 26,000
Query

Create a dashboard with my result for this year next to my budget, per month and per general ledger account, with the five largest variances at the top.

Growth and margin per customer

1 example

Which customers carry your revenue, which ones are falling back, and what remains at the bottom line. Useful before you start offering discounts or making new arrangements.

  • Revenue per customer
  • Growth per quarter
  • Gross margin
  • Margin per product group
  • Last year alongside
Revenue and margin this quarter AI Connect connected
Revenue € 412,000 ▲ 8%
Gross margin 34.2% ▲ 1.4 points
Largest customer 18% of your revenue
Customers with growth 12 of 28 ▼ 2 fewer
Gross margin per product group last year in grey
Parts Installation Service Trade 41% 33% 29% 22%
Revenue per customer 5 of 28
CustomerGrowthRevenue
Bouwbedrijf Reinders ▲ 34% € 74,100
Installatiegroep Meijer ▲ 21% € 61,800
Van Hoorn Retail ▲ 3% € 48,300
Technisch Bureau Voss ▼ 6% € 39,450
Meijer Holding ▼ 14% € 27,900
Total, 28 customers € 412,000
Query

Create a dashboard with my revenue per customer this quarter, sorted by growth compared to last quarter, and add the gross margin per product group with last year alongside.

Best-selling items

1 example

What sells best, what stays on the shelf, and whether your stock matches. The only topic that leans towards the logistics side.

  • Revenue per item
  • Number sold
  • Margin per item
  • Low stock
  • Not selling
Items this quarter AI Connect connected
Product revenue € 268.400 ▲ 6%
Number sold 4.180 across 214 products
Average margin 31,5% ▼ 0,8 point
Low stock 7 products of which 3 best-sellers
Best-sellers next to your stock 5 of 214
ProductNumberMarginStock
Coupling piece 22 mm 612 38% 14 pcs
Insulation board 60 cm 455 29% 208 pcs
Complete assembly set 358 41% 6 pcs
Mounting bracket L 252 22% 140 pcs
Sealing ring set 10 196 35% 92 pcs
Sitting idle no sales 90 days
Adapter plate old € 4.120
Housing type C € 2.860
Cable set 15 m € 1.740
Sensor v2 € 980
Tied up in stock € 9.700
Query

Create a dashboard of my best-selling items this quarter with revenue, quantity and margin per item, and mark the items with low stock.

What you still have to pay yourself

1 example

What you still have to pay yourself and when it leaves your account. This way you see upcoming payments alongside your outstanding invoices instead of separately from them.

  • Outstanding invoices
  • Due date
  • Payment batches
  • Discount term
  • Per supplier
Payables next 30 days AI Connect connected
Outstanding € 52.300 38 invoices
Due this week € 14.600 11 invoices
Already due € 3.900 4 invoices
Discount possible € 410 if paid before 12 Sep
Payable per due period in euros
Already due € 3.900
This week € 14.600
Next week € 11.500
Week 3 € 9.400
Later € 12.900
Total € 52.300
Largest items per supplier 5 of 19
SupplierDueAmount
Groothandel Kramer 16 Sep € 9.140
Transport de Wit 11 Sep € 7.480
Metaalbedrijf Sluis 14 Sep € 6.220
Verpakking Noord 22 Sep € 4.860
Softwarelicenties BV 30 Sep € 3.510
Total, 38 invoices € 52.300
Query

Create a dashboard of my outstanding payables by due date, with the total per supplier and the payments coming up in the next two weeks.

Projects and hours

1 example

Revenue, purchased materials and logged hours per project side by side. This way you see a project move through its budget while it is still running.

  • Margin per project
  • Logged hours
  • Still to be invoiced
  • Work in progress
  • Per branch
Projects and hours ongoing projects AI Connect connected
Ongoing projects 14 across 3 branches
Project revenue € 386,000 ▲ 7%
Average margin 27.4% ▼ 1.9 points
Over budget 1 project € 21,400 over
Budget consumed 5 of 14
ProjectMarginConsumed
New build Reinders 4.1% 118%
Renovation Voss phase 2 11.8% 96%
Installation Meijer Zuid 29.6% 71%
Maintenance Van Hoorn 34.2% 54%
Expansion Holding 38.0% 22%
Hours this month all projects
Logged 1,284 h
Billable 1,061 h
Already invoiced 848 h
Still to invoice 213 h
Outstanding value € 17,900
Query

Create a dashboard of my ongoing projects with revenue, costs, logged hours and margin, and highlight the projects that go over their budget.

Working capital and ratios

1 example

The figures your bank and your accountant look at, without you having to calculate them from the balance sheet yourself. The same setup every quarter, so you see the trend.

  • DSO and DPO
  • Working capital
  • Liquidity
  • Solvency
  • Against last quarter
Working capital and ratios this quarter AI Connect connected
Working capital € 128,400 ▲ € 9,200
DSO 41 days ▼ 1 day
DPO 34 days ▼ 1 day
Liquidity 1.62 rule of thumb above 1.5
DSO and DPO per quarter DSO DPO
47444241 38373534 Q4Q1Q2Q3
Ratios against last quarter from your balance sheet
RatioNowPrevious
Current ratio 1.62 1.54
Quick ratio 1.08 1.11
Solvency 38.4% 36.1%
Inventory days 62 days 55 days
Cash conversion cycle 69 days 62 days
Working capital € 128,400
Query

Create a dashboard with my DSO, DPO, working capital and current ratio, next to the previous quarter.

Reconciliation for your return

1 example

Do your VAT return and your general ledger match, and where is the difference. That saves you the manual check before you file your return.

  • VAT per category
  • General ledger reconciliation
  • Differences
  • Deviating rates
  • Per period
VAT reconciliation third quarter AI Connect connected
According to return € 24,680 payable
According to ledger € 24,455 account 1500 to 1540
Difference € 225 1 category deviates
Reconciles 4 of 5 categories checked
Return against ledger per category
CategoryReturnLedgerDifference
1a high rate € 41,220 € 41,220 —
1b low rate € 2,480 € 2,480 —
4b acquisition € 1,860 € 1,860 —
5b input tax − € 20,880 − € 21,105 € 225
2a reverse charged € 0 € 0 —
Payable € 24,680 € 24,455 € 225
Where the difference is 3 entries
Purchase invoice without VAT code 2 entries, August € 180
Deviating rate on 1 line 1 entry, July € 45
Together € 225
Query

Create a dashboard that places my VAT return per period next to the VAT accounts in my general ledger, and shows where a difference lies.

Your entire client portfolio

1 example

One overview across all your connected administrations, instead of logging in fifty times. The same dashboard for every client, without setting it up again for each administration.

  • Result per administration
  • Outstanding items
  • Processing backlog
  • Period closing
Client portfolio 62 administrations AI Connect connected
Administrations 62 all connected
Combined result € 1.84 mln ▲ 4%
Combined outstanding € 398,000 1,180 invoices
Behind 7 on processing
Processing status
62 administrations
Up to date 44
Slightly behind 11
Behind 7
Administrations that need attention 5 of 62
AdministrationProcessingOutstanding
Van Dijk Groothandel 6 wks € 70,000
Bouwbedrijf Reinders 4 wks € 48,300
Installatiegroep Meijer 2 wks € 31,450
Technisch Bureau Voss 2 wks € 24,900
Van Hoorn Retail up to date € 19,700
Total, 62 administrations € 398,000

Example with fictional figures, retrieved live from your administration.

Query

Create one dashboard across all my connected administrations showing result, outstanding items and which administrations are behind on processing.

Do you want to see step by step how such a dashboard comes about? Read Creating dashboards in Claude.

Dashboards

The dashboards that are ready now

Each dashboard has its own page: what it contains, how the calculations are made, which choices have already been made for you and what you need to know before drawing conclusions. With a demo on fictional figures that you click through yourself.

01 Liquidity forecast Skill for Exact Online

Where your money goes, and what happens in the coming months

The balance movement with the net change per month, what is tied up in invoices and stock, where the turnover and the costs come from, and a six-month projection with sliders for growth, costs and payment term. The cash flow is calculated using the direct and the indirect method, and the difference between the two is shown alongside.

View the liquidity forecast →
14 overviews arranged around five questions you ask yourself
02 Month-end close Skill for Exact Online

Fourteen checks before you close the month

What is missing compared to the previous months, right down to the customer and the supplier. Whether the bank matches the latest statement and the suspense accounts run to zero. Whether the depreciation, the payroll journal and the VAT are in there. Every check ends up as in order, attention or action, with the supporting detail underneath and a link to the entry in Exact.

View the month-end close dashboard →
14 checks in four groups, with a checklist
03 Accounts receivable management Skill for Exact Online

Who to call first, and why

What is outstanding, sorted by days past the due date, and which customers structurally pay later than agreed. A work list with the next step for each customer, draft reminders you read before they go out, and the reconciliation of the open items with the accounts.

View the accounts receivable management dashboard →
5 components from ageing to a work list per customer
04 Intercompany Skill for Exact Online

Mutual positions within the group, reconciled down to the entry

For each pair of group companies, see whether the current account says the same thing on both sides, and where the difference lies if it does not. Mutual invoices next to the mirror entry at the other party, invoices without a counterpart, and the eliminations you need for a consolidated view.

View the intercompany dashboard →
Per pair current account, invoices and eliminations
05 Management information Skill for Exact Online

How the company is doing, and where the year is heading

Result and margin with the cost breakdown, the balance sheet with liquidity and working capital, your customers and product groups, and the budget alongside the actuals with a forecast for the whole year. All key figures next to the same period last year.

View the management dashboard →
4 sections from result to annual forecast
06 Trading cockpit Exact Online only

Sales, purchasing and stock for a trading company

Order intake alongside invoiced revenue and margin, what still has to be delivered and what is overdue. A purchasing recommendation based on the expected stock, the stock value with dead and negative stock, and how many days your money is tied up between purchase and payment. Because it is about stock and orders, this one works only on Exact Online.

View the trading cockpit →
4 tabs with signals and detail per item, customer and supplier
07 Purchase Invoice Cockpit Exact Online only

Which purchase invoices you can post, and which you cannot

All open posting proposals from Scan & Recognise alongside what you previously posted from the same supplier. For each proposal you see whether the invoice number is already in the books, whether the amount differs and whether it is actually a receipt, with advice to post, check first or reject. Alongside that you see the invoices that may have been posted twice, and your creditors including what is still in the queue. Because it concerns the posting proposals in Exact, this works only on Exact Online.

View the purchase invoice cockpit →
4 tabs with advice and an assessment per proposal

All in the same subscription

You pay for the connector, not per dashboard. More will follow, and those are simply included too.

The difference

Why this is faster than a reporting project

Most dashboards come from one of these three corners. The difference lies in who builds it, and who you need when you want to add a column next week.

 
 
Our connector AI dashboard via Claude
Power BI or BI project
Standard report in your accounting
First dashboard
The same afternoon
Weeks, after an intake
Immediately, but only what already exists
Who builds it
You, with a question
A consultant or BI specialist
No one, it is fixed
Changing something
One sentence in the chat
Change request and hours
Not possible
Extra licence
No BI licence
Power BI licence per user
No
Where you view it
In Claude, no extra portal
New portal, new login
In your accounting software
New question no one had anticipated
Just ask it
Back to the builder
Export to Excel
Multiple administrations
In one overview
Often extra work
Limited, varies per package
Sorted Possible, with a workaround Not without help or extra costs

A broad comparison. What is possible in your situation depends on your package and your setup.

Adjusting

This is what it sounds like when you want to change something

The conversation alongside shows a dashboard with revenue per product group. The user wants the previous period next to it and one filter removed, and after that the biggest decliners at the top.

Add or remove columns, periods and filters
Include a new ledger account or administration
Sort differently, or put the biggest deviations at the top

Put the previous period next to it and remove the country filter.

Done. The same period from last year now sits alongside each product group, and the country filter is gone. Two groups are down more than ten percent compared to last year.

Put those two at the top, with the difference in euros included.

Adjusted. The two decliners now sit above the table, with the difference in euros and in percentages.

Sample conversation with fictional figures.

Without having to watch for it

Some figures you don't want to look up, you want them sent to you

You open your dashboard whenever you want to take a look. For the figures you don't think about every day, you set up a scheduled task. It asks your administration the same question at fixed moments and sends you the answer.

Even when your laptop is closed

You choose hourly, daily, weekly or on working days. The task runs on schedule, even on days when you are not sitting at your computer.

You set the task up once

You tell it what the scheduled task should check, for example which items are more than sixty days overdue. Claude follows that instruction every time.

The answer is in the notification

You decide what the notification should mention, for example the five largest items with amounts. You receive it on your phone or on your computer, so you only need to open Claude when you want to dig deeper.

More about this in Scheduled tasks in Claude.

Security and control

Your figures stay yours

Creating a dashboard means that Claude reads your records. That is why it is set out what is and is not allowed, and where the limits lie.

Your own rights apply

The connector sees no more than you are allowed to see in your accounting package. Per user you set which administrations and data are available.

Changes only with your approval

A dashboard only reads. If you ask for a follow-up action, it is prepared as a proposal and nothing changes before you approve it.

You need a paid Claude subscription

A dashboard that refreshes itself lives in Claude, so the connector has to be in your own Claude account. Asking questions and making one-off overviews is also possible in ChatGPT, Copilot, Gemini and Perplexity, only the dashboard does not refresh there.

Sharing with those who have no connector

A dashboard that refreshes itself can only be shared with colleagues who have the connector themselves. If you want to share a status with your bank or accountant, you make a snapshot: a fixed status with date, as a link or attachment.

Want to know more? Read Working safely with the AI connector.

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 over ten years we have been connecting Exact Online, AFAS and Twinfield to other systems. That knowledge of the accounting packages is built into AI Connect too.

Tandwiel met sterretjes

Professional support

Install it yourself with ease, or choose the installation support. Various SLA levels 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

Subscription

Dashboards are part of Analytics

You can ask questions about your administration with every subscription. If you want a dashboard that you build, save and reopen later, then you need Analytics.

Monthly Yearly 10% discount
For dashboards

Essentials

Control over your daily administration

Analytics

Drive on numbers, margins and trends

Questions & daily management

Questions about your administration

Direct answers about invoices, orders, VAT and customers

Plus insight into your entire administration

Create, edit & delete
iNothing is carried out without you confirming it first.

✓

✓

Financial reports & overviews

✓

✓

Insight into your figures

Analyses

On request, per customer or period

Automatically across your entire administration

Margin per item

-

Automatically calculated from invoices, items and cost price

Trends & comparison per period

-

✓

Scope & limits

Depth of your analyses

Short overviews per question

Deep analyses across large volumes

Included administrations

1

1

Monthly usage allowance
iEach time a dashboard retrieves the figures, it uses a few requests. So a dashboard you open daily counts towards this.

5,000 requests

15,000 requests

Dashboards

Answer to your question within the conversation itself

✓

✓

Create and reopen a dashboard
iThe dashboard lives in Claude and retrieves fresh figures when you open it.

-

✓

Scale of the figures in the dashboard

-

Your entire administration, even across multiple years

Multiple administrations in one dashboard

-

✓

€ 26,10 per user / month

Try 30 days for free

No setup costs · cancel monthly

€ 71,10 per user / month

Try 30 days for free

No setup costs · cancel monthly

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 financial dashboard brings the figures you steer by together on one screen: revenue, costs and result, what is outstanding with customers and suppliers, your bank balance and how it develops over the coming months. The difference with a report is that a dashboard is kept up to date and that you can click through it. Here the dashboard comes straight from your administration in Exact Online, so you do not have to make an export or maintain an Excel model. If you want an extra column or period, you simply ask for it in the conversation.

Yes, that is what most customers use it for. You ask once for a management dashboard with, for example, result against budget, revenue per customer, outstanding items and liquidity, and after that you open the same dashboard again every month with the figures of that moment. Every chart also has a table view, so you can copy the figures straight into your own reporting. If you do not want to retrieve the figures yourself, you set up a scheduled task that sends them to you at a fixed time.

With Claude a dashboard is a file that keeps existing. Open it again and Claude retrieves the figures itself. Other assistants can answer your question and create an overview, but they do not store that overview as something that updates itself. So asking questions and making individual overviews is also possible in ChatGPT, Copilot, Gemini and Perplexity.

No. There is no extra licence, no new portal and no setup process. You need the connector and a paid Claude subscription, and with that you build the dashboard yourself with a question.

A dashboard that refreshes itself can only be shared with colleagues who have the connector in their own Claude account. If you want to share a position with your bank or accountant, you create a snapshot: a fixed position with a date, as a link or attachment.

A dashboard only reads. If you ask for a follow-up action, for example reminders for customers who are falling behind, it is prepared as a proposal and you see exactly what would happen. Nothing changes before you give your approval.

Yes, and for accountancy firms that is the main reason to use it. You connect all your administrations under one account and ask the question once, with one overview across all clients as the result.

Live. When you open it, the dashboard pulls the current figures from your administration through the official API. As long as you keep the dashboard open, it does not refresh on its own. If you enter something in the meantime, just refresh the page and you will see the new figures. For the more extensive dashboards (liquidity forecast, month-end closing) your administration is prepared once the first time, so they can calculate across your entire administration in seconds, even over multiple years.

That is actually the easy case. Start with one of the example questions on this page, see what you get, and adjust until it looks the way you want. A correction takes one sentence, so you do not need to know in advance exactly what you are looking for.

The subscription is per user per month and includes one administration. For every extra administration you pay a fixed amount per month, regardless of how many users you have, and that amount drops as you connect more. An annual subscription adds a 10 percent discount on top of that.