Exact Online AI koppeling

From a single question to a real analysis

An ordinary question gives you an answer from your records. An analysis goes a step further: ChatGPT combines several pieces of data, such as outstanding items, due dates, revenue and purchase value, into an overview with a conclusion. You ask for it in plain language and get the insight back, without setting up a report yourself, lining up columns or exporting.

These deeper analyses use the Analytics subscription, which is built to calculate across larger volumes of data. You request them on demand: you ask for the analysis when you need it. Below, per analysis, what it does, which data goes into it and what you get back.

Before you start: turn on the connector in the chat. In a new chat, click the plus icon (+) and turn on Exact AI Connect. You do this again for each conversation; if the connector is not on, ChatGPT cannot access your records. Not connected yet? Then first follow the steps in Connecting Exact Online with ChatGPT.

The analyses at a glance

Cash flow forecast

 

Projects how much money comes in and goes out over the coming months, so you can plan ahead. Is there room for a large purchase, or is a tight month on the way?

Which data
Your current cash position as a starting point, your outstanding receivables and payables on their due date, and your average cash flow of recent months as a baseline.
What you get back
An expected balance per month, with a brief conclusion about when things get tightest.
Example: "Create a cash flow forecast for the coming 3 months based on my outstanding items."

Want to look further ahead? This question gives a quick estimate within the conversation. For a fixed liquidity forecast with scenarios there is an extensive dashboard: six months ahead, with sliders for revenue growth, costs, payment terms and investments. 

Ageing analysis of accounts receivable

 

Shows how long your invoices have been outstanding and which customers carry a growing payment risk. A strong basis for your receivables follow-up, because you know straight away who to approach first.

Which data
All your outstanding sales invoices with their due date, grouped by customer.
What you get back
The amounts split by age (0 to 30, 30 to 60, 60 to 90 and 90 days or older), with the biggest risk items highlighted.
Example: "Split my outstanding receivables by age and name the biggest risks."

Gross margin per product group

 

Shows your margin per product group and reveals where it drops the fastest, giving you a basis for pricing and purchasing decisions.

Which data
Your revenue per product group and the matching purchase value over the chosen period.
What you get back
The gross margin per group, with the steepest decliners highlighted.
Example: "Calculate my gross margin per product group and show me where it is dropping."

Costs year-on-year

 

Compares your costs with the same period last year and points out the largest deviations, so you quickly see which items are out of line.

Which data
Your actual costs per general ledger account for the chosen period and for the same period a year earlier.
What you get back
The costs per general ledger account alongside last year, with the largest differences explained.
Example: "Compare my costs per general ledger account with last year and explain the largest deviations."

Smart payments

 

Determines which invoices you can pay later without missing a due date, so you keep cash on hand for longer.

Which data
Your outstanding payables with their due dates.
What you get back
An overview of which payments you can postpone and until what date.
Example: "Which invoices can I pay later without missing the due date?"

Working capital in key figures

 

Calculates your DSO (how quickly you get paid on average), your DPO (how quickly you pay yourself) and your working capital requirement, and compares this with the previous quarter.

Which data
Your outstanding receivables and payables, your revenue and purchasing over the period, and your stock if you hold any, plus the same figures from the previous quarter.
What you get back
Your DSO, DPO and working capital requirement, with the change compared to the previous quarter.
Example: "Calculate my DSO and DPO and compare this with the previous quarter."

Asking follow-up questions about your analysis

An analysis is not an endpoint. You can ask follow-up questions straight away, without running the analysis again. For example:

1"Give me an ageing analysis of my receivables."
2"Focus on the items older than 60 days."
3"Set the payment term to 14 days for those customers."

That is how you move from an analysis to a concrete next step. If it becomes a write action, such as adjusting a payment term, ChatGPT first shows you in the conversation what will change, and only after your approval is it recorded. Would you rather see the result as a chart or overview? Then take a look at creating charts and overviews in ChatGPT.

No Exact AI Connect yet?

Connect your Exact Online administration to your AI assistant and ask your first question within a few minutes. You keep control over every action yourself.

View Exact AI Connect

Frequently asked questions

The deeper analyses use the Analytics subscription, which is built to calculate across larger volumes of data. You can ask separate questions and request short overviews in any subscription.

The analysis calculates with your live Exact Online figures at the moment you request it. So you are not working with an earlier export.

Yes. You can zoom in on a part, choose a different period or ask for a follow-up step, without running the analysis all over again.

No. You request the analysis in plain language and ChatGPT fetches the required data itself. You do not have to build a report or export data.