With ChatGPT you get more from your figures than isolated answers. From cash flow forecasts to gross margin per product group, you ask for the analysis in plain language and get the numbers plus a conclusion in return, without building a report yourself.
From single question to real analysis
A regular 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 in plain language and get the insight back, without setting up a report yourself, placing columns side by side or exporting anything.
These deeper analyses use the Analytics plan, which is built to calculate over larger volumes of data. You request them on demand: you ask for the analysis when you need it. Below is what each analysis does, what data goes into it and what you get back.
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 coming up?
Which data
Your current cash position as a starting point, your outstanding accounts receivable and payable on their due dates, and your average cash flow of 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 with which customers the payment risk is building up. A strong basis for your receivables follow-up: you know right away who to approach first.
Which data
All your outstanding sales invoices with their due date, grouped per 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 accounts receivable by age and name the biggest risks."
Gross margin per product group
Shows your margin per product group and where it drops the most, as support for pricing and purchasing decisions.
Which data
Your revenue per product group and the associated purchase value over the chosen period.
What you get back
The gross margin per group, with the sharpest drops highlighted.
Example: "Calculate my gross margin per product group and show where it drops."
Costs year over year
Compares your costs with the same period last year and points out 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 paying
Determines which invoices you can pay later without going past a due date, so you keep money in the bank longer.
Which data
Your outstanding accounts payable with their due date.
What you get back
An overview of which payments you can postpone and until which date.
Example: "Which invoices can I pay later without going past 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 need, and compares with last quarter.
Which data
Your outstanding accounts receivable and payable, your revenue and purchasing over the period, and your inventory if you keep it, plus the same figures from last quarter.
What you get back
Your DSO, DPO and working capital need, with the change compared to last quarter.
Example: "Calculate my DSO and DPO and compare with the previous quarter."
Asking follow-up questions on 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 an ageing 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 go from an analysis to a concrete next step. If that becomes a writing action, such as drafting a reminder, it is first prepared as a draft that you approve. Would you rather see the outcome as a chart or overview? Then take a look at making charts and overviews in ChatGPT.
Frequently asked questions
Are these analyses available in every plan?
The deeper analyses use the Analytics plan, which is built to calculate over larger volumes of data. You can ask single questions and short overviews in every plan.
How current are the figures in an analysis?
The analysis calculates with your live Exact Online figures at the moment you request it. So you are not working with an earlier export.
Can I ask follow-up questions on an analysis?
Yes. You can zoom in on a part, choose a different period or ask for a next step, without running the analysis completely again.
Do I have to set up or configure the analyses myself
.png){kind=icon}
.png?width=46&height=46&name=vecteezy_artificial-intelligence-ai-processor-chip-vector-icon-symbol_6662139%20(1).png){kind=icon}
