With ChatGPT you get more out of your figures than just isolated answers. From cash flow forecasts to gross margin per product group, you ask the analysis in plain language and get the figures plus a conclusion back, without building a report yourself.
From a single question to real analysis
A normal question gives you an answer from your records. An analysis goes one 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 over larger amounts of data. You run them on demand: you ask for the analysis when you need it. Below is what each analysis does, which data goes into it and what you get back.
The analyses at a glance
Cash flow forecast
Projects how much money will come in and go 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 dates, and your average cash flow over the past months as a baseline.
What you get back
An expected balance per month, with a short conclusion about when things get tightest.
Example: "Make a cash flow forecast for the coming 3 months based on my outstanding items."
Accounts receivable ageing analysis
Shows how long your invoices have been outstanding and which customers carry the mounting payment risk. A solid basis for following up on your receivables, because you know right away who to approach first.
Which data
All your outstanding sales invoices with their due dates, 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 largest 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 most, 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 biggest fallers 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 highlights the biggest 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 biggest differences explained.
Example: "Compare my costs per general ledger account with last year and explain the biggest deviations."
Smart payments
Determines which invoices you can pay later without missing a due date, so you keep money in your account for longer.
Which data
Your outstanding creditors with their due date.
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 it with the previous quarter.
Which data
Your outstanding accounts receivable and payable, 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 it with the previous quarter."
Asking follow-up questions about your analysis
An analysis is not an endpoint. You can ask follow-up questions right away, without running the analysis again. For example:
1"Give me an aging analysis of my accounts receivable."
2"Focus on the items older than 60 days."
3"Draft a payment reminder for those customers."
This is how you move from an analysis to a concrete next step. If that becomes a writing action, such as drafting a reminder, it will first be prepared as a draft for you to approve. Would you rather see the result as a chart or an overview? Then take a look at creating charts and overviews in ChatGPT.
Don't have Exact AI Connect yet?
Connect your Exact Online administration to your AI assistant and ask your first question within a few minutes. You stay in control with every action.
The deeper analyses use the Analytics subscription, which is built to calculate across larger amounts of data. You can ask individual questions and get 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 export from earlier.
Yes. You can zoom in on a part, choose a different period or ask for a follow-up step, without running the entire analysis again.
No. You ask the analysis in plain language and ChatGPT retrieves the necessary data itself. You do not have to build a report or export data.