Works with Exact Online

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.

Claude logo Debiteurenbeheer Cockpit
Openstaande posten, betaalgedrag en opvolging
AI Connect verbonden
Administratie De Voorbeeld Groothandel ▾ Peildatum 20 september ▾ AllesVervallen
Gemaakt in Claude · cijfers uit je administratieVoorbeeld met fictieve cijfers.
AI assistant Claude logo Claude
Accounting Exact Online logo Exact Online

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.

Outstanding and overdue, with the age in five groups counted from the due date
DSO per month-end over thirteen months, alongside the share caused by late payment
Collection effectiveness: how much of what you could collect this year has actually come in
Concentration: how much of your balance sits with the five largest debtors

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.

Outstanding€ 263.81462 invoices
Overdue€ 105.96240% of the balance
DSO48 daysof which 18 due to late payment
Collection eff.90.8%this year

Age of outstanding items

Days after the due date

Not overdue157.853
1 to 30 days80.262
31 to 60 days8.970
61 to 90 days4.250
More than 90 days12.480

Part 02

Payment behaviour and expectation

How each customer pays, and what is coming in over the next few weeks.

A payment profile per debtor based on their own history: on time, variable or structurally late
A trend, so you can see who has been paying later recently than before
The expected receipts per week, eight weeks ahead, with commitments highlighted
Per month what has been invoiced, how much of that has come in and what is still outstanding

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

wk 3982.570
wk 4030.198
wk 4149.080
wk 4215.082
wk 4338.228
Uncertain16.730

Payment profiles

● Pays on time7 debtors
● Pays variably11 debtors
● Pays structurally late4 debtors
● No history yet2 debtors

Part 03

Work list and follow-up stage

Who to start with today, and with which step.

A work list by priority, showing per debtor the outstanding amount, overdue amount, stage and next action
The follow-up stage on the oldest overdue item, from first reminder to handover to collection
The expected payment date per line
Filters on profile, stage and status, plus a stage strip you click as a filter

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

Awaiting 101st reminder 52nd reminder 5Demand 2Notice of default 1Collection 1
Work listSorted by priority
DebtorOverdueDaysStage
Installatiebedrijf Koopmans12,480105Collection
Bouwmarkt Van Dijk B.V.19,990252nd reminder
Evenementenbureau Feest!10,60065Notice of default
Wijnhandel Bacchus12,74635Demand

Part 04

File and letters

Everything about one debtor, and the letter that goes with it.

The data from your accounting package, the open invoices and all reconciled invoices with their payment date
A reminder, demand or notice of default in a friendly, neutral or firm tone, for the invoices you select
Call tasks, commitments, disputes and a payment arrangement with an instalment schedule
A collection file as text, ready to hand over

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.

Events agency Feest!Structurally pays late, median 31 days past the due date, 26 invoices Notice of default
Outstanding€ 15.587,50
Overdue€ 10.600,00
Credit limit156% used

Notice of default, neutral tone

Four overdue invoices selected

202600506, 65 days overdue4.250,00
202600532, 40 days overdue2.980,00
202600549, 24 days overdue1.015,00
202600556, 18 days overdue2.355,00
Collection costs according to the statutory scale881,00
Statutory commercial interest10,4% per year
CopyDraft in GmailRecord as sent

Part 05

Reconciliation and matching

Whether every amount is in the right place, and whether it matches your accounts.

Receipts booked against a debtor but not yet matched to an invoice, per relation
Which of these have been outstanding for more than thirty days
Open invoices minus those receipts, alongside the debtor balance in your accounts
Expandable per relation, so you can see where a difference lies

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

RelationReceivedSince
Wijnhandel Bacchus1.750,0017-09
Lunchroom Het Hoekje1.180,0014-09
Stichting Buurthuis De Ontmoeting500,0010-08
Together3.430,00
Reconciliation with your accountsMatches
Open invoices263.814,00
Received, not connected−3.430,00
Net position260.384,00
Debtor balance in your accounts260.384,00
 

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.

Claude logo Accounts receivable management demo administration, fictional figures Full screen ↗

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

1300 Accounts receivable Type: receivables

Administration B

1100 Trade debtors Type: receivables

Administration C

1310 Receivables from customers Type: receivables

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.

What you start with Create the debtor cockpit for Van Dijk Groothandel.

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.

TimelineWijnhandel BacchusDemand notice
16 Sep

Demand notice prepared Draft

Neutral tone, with interest and collection costs included. Not sent yet.

9 Sep

Called the finance department Promise

Payment promised for Friday 12 September. Not received.

1 Sep

Second reminder sent

Set up as a draft in Gmail, then recorded as sent.

18 Aug

First reminder sent

Friendly tone, for two overdue invoices.

18 Aug

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.

01

Download the skill

It is a single file; there is no need to unpack it.

02

Add it to Claude

Via Customize → Skills and then Add. From that moment on it is available in every conversation.

03

Connect your administration

AI Connect links Claude with your administration. The skill is built on Exact Online.

04

Ask for your cockpit

In plain language. The skill works out which data belongs with it and from which date the calculation starts.

Create the accounts receivable cockpit for Van Dijk Groothandel.
Skill filedebiteuren-cockpit.skill
Download the skill

91 kB · no installer

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.

No AI Connect yet? Try it free for thirty daysNo payment details needed, and in that time you can create as many cockpits as you like. Required: AI Connect Analytics and a paid Claude subscription.
Request your trial period

Security

Your data is safe with our ISO 27001 certification

ISO 27001 certificationWe meet the strictest ISO 27001 standards, so your data is protected to the highest degree. Work with confidence, knowing that your data is in safe hands.
Privacy guaranteedFor us, privacy is not a side issue but a core value. Our processes are designed to protect your data as much as possible.
Security as a foundationFrom authentication to processing, every part of our solution meets the highest requirements for information security.
ISO 27001 logo

ISO 27001

Certified

Rely on the connector

Kalender met klok

Try it free for 30 days

Flexible subscription without long-term commitments. Installed within 2 minutes.

Handdruk

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.

Tandwiel met sterretjes

Professional support

Install it yourself easily, or choose the installation assistance. Various SLA levels are 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

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% discount

per user per month, paid annually

Prefer to pay monthly? Then it is € 79 per user per month.

Included 1 administration
Setup costs None

✓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.

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 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.