Accounts receivable management: from ageing list to work list
An ageing list tells you how much is outstanding. This cockpit tells you who to start with today: a work list sorted by priority, with each customer's payment behaviour taken from their own history, the stage the follow-up is in and a reminder ready to go in the tone that suits that customer. You send it yourself. Nothing goes out automatically.
- Ageing by due date, with DSO, collection effectiveness and the expected receipts per week
- A file per customer with invoices, payment behaviour, call tasks, commitments and payment arrangements
- Reminder, demand notice or notice of default, with interest and collection costs already calculated
Entirely without obligation, no payment details needed.
Openstaande posten, betaalgedrag en opvolging AI Connect verbonden
Op de oudste vervallen post, klik om te filteren
Gesorteerd op urgentie, met de aanbevolen actie
Dagen na de vervaldatum
Vervaldatum plus de gebruikelijke overschrijding per klant
Dertien maanden, countback op gefactureerde bedragen
Gesorteerd op prioriteit: bedrag, ouderdom en betaalprofiel
Betaalt structureel laat, mediaan 31 dagen over de vervaldatum
Vier vervallen facturen geselecteerd
Open facturen min ontvangsten zonder factuur, per relatie
The structure
From portfolio to file, in five parts
The cockpit is built the way you follow up on your debtors. First you see how the portfolio stands and where the risk lies. Then you see how your customers pay and what will come in over the next few weeks. Next comes the work list showing who to contact today, and for each debtor a file from which you create the letter straight away. Finally you see whether every receipt is tied to an invoice and whether the balance matches your accounting. At the top are eight key figures and the points of attention that call for action, with a button to the file.
Part 01
Position and risk
How your portfolio is doing, and where the money is stuck.
Why by due date. A standard ageing list often groups by invoice date. An invoice with a sixty-day payment term already appears in the 31 to 60 days group after forty-five days, while the customer is not even late yet. The cockpit counts from the due date and shows the difference with the ageing list in your package separately, so you know why the numbers are different.
Age of outstanding items
Days after the due date
Part 02
Payment behaviour and expectation
How each customer pays, and what is coming in over the next few weeks.
Why per customer. An average payment term across your entire portfolio tells you little about the customer you need to call today. The expected payment date is therefore the due date plus the usual overrun of that one customer. If an item stays open for more than sixty days, it counts as uncertain and the cockpit does not rely on it.
Expected receipts per week
Based on the payment behaviour per customer
Payment profiles
Part 03
Work list and follow-up stage
Who to start with today, and with which step.
Why not by amount. The largest item is not always the first one to tackle. The priority weighs the overdue amount, how long it has been outstanding and how that customer usually pays. A customer who structurally pays late moves up. A customer who is always on time drops down. This way an item of € 12,480 that has been outstanding for a hundred days can rank above a larger item that has only just become overdue.
Debtors by follow-up stage
Part 04
File and letters
Everything about one debtor, and the letter that goes with it.
Why the interest is already included. A demand without an amount for interest and collection costs is just a second reminder. The calculation tool works out the statutory commercial interest per invoice, or the statutory interest for a consumer, and the collection costs according to the statutory scale. For a consumer, the letter includes the fourteen-day term, which is required before you may charge any costs.
Notice of default, neutral tone
Four overdue invoices selected
Part 05
Reconciliation and matching
Whether every amount is in the right place, and whether it matches your accounts.
Why a loose receipt matters. As long as a payment is not tied to the invoice, that customer appears not to have paid. They then land on the work list and receive a reminder for something that is already in. That is why these receipts are shown separately, and the reconciliation counts them in.
Receipts without a connected invoice
In at the bank, not yet matched
Demo
Open a case yourself
A cockpit from Claude, built on a demo administration. The amounts are made up, everything works: pick a debtor, change the tone of the reminder or calculate the collection costs for an invoice.
The demo comes from Exact Online. Scroll through the work list in the window and open a case, or view it in full screen.
Every chart of accounts
Works with your own chart of accounts
Where the accounts receivable sit varies per administration: 1300 Accounts receivable, 1100 Trade receivables or 1310 Receivables from customers. A fixed number would always miss one. That is why the cockpit recognises the receivables account by the type your software assigns to it, and an invoice by its status and due date. A new customer administration can therefore join straight away, without any preparation.
Administration A
Administration B
Administration C
In the cockpit
Outstanding items and reconciliation
Whatever the number is, the balance ends up in the same place in the work list and in the reconciliation.
Under Reconciliation in the cockpit you see per relation which invoices and receipts have been included, and whether that matches the outstanding items in your accounting package.
Data
Which data the cockpit reads
Ten parts of your administration, nothing more. It only reads; the cockpit writes nothing back.
Invoices, open and paid
Due date, reconciliation date and amount per invoice. The paid invoices form the payment history.
Contacts
Email address, payment terms, credit limit and whether the contact is blocked.
Contact persons
For the salutation and the correct address in the reminder.
Revenue per contact
This year and last year, for a customer's share.
Revenue per month
As a reference alongside the DSO.
Accounts receivable balance
Per period, for your information.
Payment terms
The agreed periods.
Receipts without invoice
Money that has come in but has not yet been reconciled.
Ageing list from your package
For the reconciliation per contact.
Overview of outstanding items
The totals, as a check.
Within your permissions
What you are not allowed to see in your package will not appear in the cockpit either.
Letters stay as drafts
A reminder is prepared as a draft at most. You send it yourself.
Always the current status
Every time you open the cockpit, it retrieves the figures from that moment. If it has been open for a while, just click refresh.
Setup
From instruction to work list
You ask for it in a single sentence. Claude first retrieves your data, checks whether the figures match your bookkeeping and only then creates the work list. That way a customer who has already paid gets no reminder.
The cockpit always counts from today. If you have it rebuilt next week, the connector stays the same and your notes and commitments remain in place.
01
Choose the administrations
Which administration or administrations you want to follow up. If you pick more than one, each administration gets its own tab in the same cockpit.
02
Your data is retrieved
Invoices, payments and customer details from your bookkeeping. After that a check is run to see whether everything is in: if the cockpit counts the same number of invoices as your bookkeeping itself, it continues.
03
How each customer pays is calculated
How quickly they usually pay, which stage the follow-up is in and where they appear on the work list. A day on which a large arrears was cleared in one go does not count, because it says nothing about how a customer normally pays.
04
The amounts are checked
What is outstanding per customer in the cockpit must be equal to what is outstanding in your bookkeeping. If that does not match, you hear about it before you get the cockpit.
05
You get the cockpit and a short summary
The cockpit opens as its own page in Claude. In the conversation you read in a few lines how much is outstanding, what is overdue and which customers you should approach first.
How it is calculated
Four rules that decide who comes out on top
A work list is only as good as the rules behind it. These four are set in the cockpit, with the reason included. If a rule does not match how you follow up, you have it adjusted.
Age from the due date, not from the invoice date
Late is only late after the agreed term. That way a customer with a sixty day term does not end up on your list unfairly.
Payment behaviour from the customer's own history
The profile comes from that debtor's own matched invoices. Days on which an entire arrears was matched off in one go do not count, because they say nothing about how a customer pays. If a customer has an item that is more than thirty days overdue, they never pay on time.
Priority weighs amount, age and profile
The overdue amount counts more heavily the longer it remains outstanding. A customer who structurally pays late gets a factor of 1.3, a customer who pays on time gets 0.8. What falls due within a week counts for one fifth, so you can see a large invoice coming.
The stage follows the oldest overdue item
Up to 14 days a first reminder, up to 30 days a second, up to 60 days a demand for payment, up to 90 days a notice of default, after that transfer to collection.
Every debtor's file shows how their profile and their priority were formed, so you can check why they appear at the top.
Please note
Before you send a letter out
These four things are also in the footer of the cockpit. Here you have them at a glance, so no reminder goes to the wrong customer.
News
Check your package just before sending a reminder
The analysis environment of AI Connect can run up to twenty-four hours behind your accounting package. The ageing list is retrieved live, so on a busy day the connection may show a small difference. If something came in this morning, you will see it in your package sooner than in the cockpit.
Storage
The log is kept in your own browser
Promises, disputes, arrangements and reminders sent are stored per administration in the browser where you open the cockpit. A colleague or another laptop will not see them.
Sending
Nothing goes out automatically
You copy a reminder, open it in your mail program or save it as a draft in Gmail if that connector is enabled. You always send it yourself.
Subscription
Only on Analytics
The cockpit calculates in the analysis environment of AI Connect, which is part of the Analytics subscription. You open it in Claude, with a paid subscription. Compare the subscriptions side by side.
During follow-up
A logbook per debtor
Debtor management is not something you do in one go. Whatever you do, you record it in the customer's file: a reminder sent, a promise made over the phone, an agreed arrangement. Open the cockpit again a week later and you immediately see where you left off, even if new figures have come in since then.
Demand notice prepared Draft
Neutral tone, with interest and collection costs included. Not sent yet.
Called the finance department Promise
Payment promised for Friday 12 September. Not received.
Second reminder sent
Set up as a draft in Gmail, then recorded as sent.
First reminder sent
Friendly tone, for two overdue invoices.
Note
Contact person is on holiday until the end of August.
Example with fictional data.
At the top
What needs action today
Receipts without an invoice, cases that have been open too long, blocked relations, customers without an email address or over their credit limit. Each item opens the right case.
In the timeline
Every step by date
Letters, call tasks, promises, disputes and pauses, with your own notes in between. That way you can also see whether a promise was kept.
Click through
To the relation in your package
From the case you open the relation in your accounting package, as long as you are logged in there in the same browser.
Per administration
Its own log per tab
If you work in multiple administrations, each tab has its own work list and its own timelines.
The log is stored in the browser where you open the cockpit. You set the sender details, default tone and payment term in the letters under Settings.
Ready to use
Your debtor round as a single task
Phases, calculation rules, letters and the layout of the cockpit are all brought together in one skill. You add it to Claude just once. After that, every debtor round begins with a single sentence.
Download the skill
It is a single file; there is no need to unpack it.
Add it to Claude
Via Customize → Skills and then Add. From that moment on it is available in every conversation.
Connect your administration
AI Connect links Claude with your administration. The skill is built on Exact Online.
Ask for your cockpit
In plain language. The skill works out which data belongs with it and from which date the calculation starts.
You are free to open and adjust it. If you want the reminder to go out after 21 days instead of 30, you can change that yourself.
Security
Your data is safe with our ISO 27001 certification
ISO 27001
Certified
Rely on the connector
Try it free for 30 days
Flexible subscription without long-term commitments. Installed within 2 minutes.
Built by specialists
For over ten years we have connected Exact Online, AFAS and Twinfield to other systems. That knowledge of the accounting packages is built into AI Connect too.
Professional support
Install it yourself easily, or choose the installation assistance. Various SLA levels are available for support.
Security guaranteed
The connector meets the highest security standard (ISO 27001 certified).
We are an official partner of
What it costs
One subscription, all dashboards
You pay for the connector, not per dashboard. Whether you create one or ten, and whether you open it every week or once a quarter.
Subscription
AI Connect Analytics
€ 71.10
10% discountper user per month, paid annually
Prefer to pay monthly? Then it is € 79 per user per month.
✓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 trading cockpit. You pay for the connector, not per dashboard.
One administration included
You connect extra administrations as needed. The more you connect, the lower the price per administration.
Your own permissions apply
The connector never sees more than you are allowed to see. A dashboard only reads; any changes happen with your approval.
No setup costs
No configuration needed. You connect it yourself and are up and running within an hour.
For the cockpit you need AI Connect Analytics, plus a paid Claude subscription. On Essentials you can ask in a conversation who is paying late. Compare the subscriptions side by side.
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 consultationCompletely non-binding, no obligations
Instantly confirmed
Relevant blogs
Frequently asked questions
A standard ageing list shows a balance per relation, often sorted by invoice date. The cockpit counts from the due date and adds the payment behaviour, the expected payment date, the stage and the next step for each debtor. The totals are matched to the outstanding items in your package, so you can see that both deal with the same money.
No. You copy a reminder, a dunning letter or a notice of default, open it in your mail program or set it as a draft in Gmail if that connector is switched on. You always send it yourself. Afterwards you record in the file that it was sent, so the next step is correct.
From its own reconciled invoices: how many days it usually goes past the due date and how often it is late. From that follows on time, variable or structurally late, with a reliability based on the number of payments. Days on which a large arrears was reconciled in one go do not count.
The priority weighs the overdue amount, how long it has been outstanding and how that customer usually pays. An item of a hundred days with a customer who structurally pays late takes precedence over a larger item that became due yesterday with a customer who always pays on time.
The calculation tool uses the statutory commercial interest rate, the statutory interest rate for consumers and the statutory scale for collection costs as known at the moment of creation. It is an indication and not legal advice. With a formal letter, always check the current rate on rijksoverheid.nl. With a consumer, the letter first sets the fourteen-day term, which is mandatory before you may charge costs.
In the browser in which you open the cockpit, per administration. If you open it on another laptop, or a colleague opens it, they are not there. Under Settings you can delete them.
Live. Every time you open the cockpit, the figures of that moment come in. If you have had it open for a while, it does not refresh by itself; just click refresh. The data from the analytics environment of AI Connect can lag up to twenty-four hours behind your accounting. Your log stays in place.
Yes. Each administration gets its own tab, with its own work list, its own points of attention and its own log.
No. It only reads. Blocking a relation, reconciling a payment or recording a payment arrangement is something you do in your accounting package itself. If there is a receipt without an invoice, reconcile it first. Otherwise a customer who has already paid gets a reminder.
The cockpit calculates with your entire payment history, per customer and per invoice, and that happens in the analysis environment that comes with Analytics. With Essentials you can ask in a conversation who pays late, but you do not get a work list or a log that stays in place. Compare the plans side by side.
A paid plan. The cockpit is built in Claude and that is where you open it too; AI Connect supplies the data from your accounting package.
They run the cockpit on their own account, with the connector to the same administration. The figures are then the same, but the log is not: notes and commitments are stored per browser.
Exact AI Connect
Connect Exact Online to your AI assistant
Choose your assistant and leave your email address. You will immediately see the right steps.
✓ Details received
Installation instructions
Need help? Check out our help article or get in touch with us.