Works with Exact Online

Month-end close checklist: fourteen checks before you close

A checklist for your month-end close, drawn from your own administration: what is missing compared to previous months, whether the balance sheet reconciles, and whether the period entries are in place. Each check results in OK, attention or action, with the supporting details below it and a link to the entry in Exact.

  • Consistency per ledger account and per relation: which customers and suppliers are missing
  • Reconciliations on the balance sheet: bank, suspense accounts, current account and provisions
  • Runs in every administration without you having to set up a model or chart of accounts first

Completely without obligation, no payment details needed.

Claude logo Maandafsluiting
Consistentie, aansluiting en periodeboekingen
Close-periode augustus 2026
Administratie Van Dijk Groothandel ▾ Vergelijking mei t/m juli ▾ Alle controlesAlleen signalen
Gemaakt in Claude · cijfers uit je administratieVoorbeeld met fictieve cijfers.
AI assistant Claude logo Claude
Accounting Exact Online logo Exact Online

The structure

Four groups, fourteen checks

The dashboard is laid out the way you work through a period close: does the picture match the previous months, does the balance sheet add up, are the period entries in place, and are the open items correct. At the top you only see what needs attention or action, so that is where you start. For each check you expand the supporting detail.

Part 01

Consistency and trends

What is missing compared to the preceding months.

Consistency per general ledger account, against the average of the three preceding months
Consistency per customer: which recurring customers have no turnover this month
Creditors check: which regular suppliers are missing
Logical monthly trend of turnover, costs and result, also against last year
Notable entries in the month

Why also per relation. One missing invoice disappears into the total at account level. At relation level it does not: this is an analysis per relation, the turnover and costs per debtor and creditor in a monthly matrix, where a customer who had turnover three months in a row and nothing this month stands out. That is exactly the gap you would otherwise only find in the quarterly review.

Analysis per relation, turnover per customerMonth to be closed against the three preceding months 2 relations with a signal
RelationMayJunJulAugSignal
Meridian Supply B.V.18.4k17.9k18.6k0disappeared
Hoogendijk Techniek12.1k11.8k12.4k7.2k−41%
Vandenberg Retail9.4k9.6k9.1k9.8kok
Norhaven Logistics0006.3knew
De Wit Installaties4.2k4.4k4.1k4.3kok

Deviation per general ledger account

Month to be closed against the average of May through July

8020 Trade turnover low−100%
4310 Vehicle costs+62%
4400 Office costs−38%
8000 Trade turnover high+4%
4210 Marketing+2%

Part 02

Reconciliations on the balance sheet

Whether the balance sheet does what it should.

Bank balances per journal against the latest statement
Suspense accounts that do not clear to zero, and accrual accounts with a balance older than one period
Current account between your administrations, mirrored
Provisions: addition recorded and the level in relation to turnover or debtors

Why against the statement. A bank balance in the general ledger means nothing until you place it next to the latest statement. The dashboard takes the latest statement per journal up to and including the month being closed and adds the difference. Under one euro of difference is fine; above that you immediately see which journal it concerns.

Bank balances per journalGeneral ledger end of August against the latest statement 2 of 3 journals reconcile, cash n/a
JournalGeneral ledgerStatementDifference
ING business242.700242.7000
Rabobank savings198.900198.9000
ING credit card4.1802.9401.240
Cash1.210no statement—

Suspense accounts, balance end of August

Should clear to zero

2010 Payments in transit12.700
2000 Transit entries3.420
2100 Query items860
1999 Still to be investigated0

Part 03

Period entries

The entries that should recur every month.

Depreciation, compared with your asset register
Payroll journal and the payroll balance accounts
VAT position, and which part does not come from the current filing period

Why alongside the asset register. Just checking whether depreciation has been entered is too easy. The dashboard calculates per asset what should have been depreciated up to this month and places it next to the register. That way you also see whether the register still covers the fixed assets on your balance sheet.

Depreciation per month

August is missing; according to the asset register this should show € 4,900

May4,900
June4,900
July4,900
August0

Period entries in August

Three checks

●Depreciation. Nothing entered in August, while the register expects € 4,900 per month.
✓Payroll journal. Entered on 28 August, € 61,400; the net wages have been paid and the payroll tax balance due is exactly one month.
●VAT position. Balance € 21,860, of which € 3,140 from before the current filing period.

Part 04

Outstanding items

What is outstanding, and whether it matches the general ledger.

Age of accounts receivable and payable by due period
Reconciliation of outstanding items with the ledger balance, including DSO and DPO

Why the difference is stated explicitly. The outstanding items are a snapshot of the moment you run them, while the ledger stands at the end of the month being closed. The two usually differ, because payments and invoices have gone through since then. The dashboard calculates that difference and names it, rather than pretending it is zero.

Age of outstanding receivables

€ 184,570 across 148 invoices, balance as at 31 August

Not due112,400
1 to 30 days40,800
31 to 60 days19,100
61 to 90 days7,900
Older than 904,370
Largest outstanding itemsSorted by amount, with days overdue ReceivablesPayables
RelationDue dateDaysAmount
Meridian Supply B.V.18 Jun744,900
Hoogendijk Techniek01 Jul612,850
Vandenberg Retail24 Jul382,700
Norhaven Logistics23 Aug82,450
De Wit Installaties22 Aug92,350
 

Demo

Click through it yourself

This is the closing of a demo administration, made in Claude. The amounts are made up, the rest really works. Open a check, tick it off, and see where a signal comes from.

Claude logo Month-end close — Exact Online demo administration, fictional figures Full screen ↗

Made in Exact Online, for August. Scroll through all fourteen checks within the window, or open it in full screen.

Why it works everywhere

No setup per set of accounts

A suspense account is called 2000 Clearing items in one set of accounts and 2100 Queries in another. If you search by number, you miss half of them. That is why every check looks at the type of the account and at the words in the description, which in every package tell you what an account does. This means you can run the checks straight away on a set of accounts where nothing has ever been configured, whether that is your own bookkeeping or that of a new client.

Administration A

2000 Suspense items Type: interim account

Administration B

2100 Query items Type: interim account

Administration C

1999 Still to be sorted out Type: interim account

In the dashboard

Interim accounts and accrual accounts

Three different numbers, the same check. Without anyone having set that up in advance.

Which account ends up in which check is shown in an expandable view next to the check itself, so you can see why something was or was not included.

Data

What it pulls from your administration

Eight types of data, nothing more. The dashboard only retrieves what it needs to carry out the checks. Nothing is written away or changed.

Chart of accounts

Type, balance category and description per account. This is what classification is based on.

Journal entries per period

For consistency, the monthly trend and the entries that stand out.

Revenue and costs per contact

For the customer check and the creditor check.

Open items

The subledger of debtors and creditors, for ageing, DSO and DPO.

Bank statements

The closing balance per ledger, to reconcile with the balance sheet.

Ledgers

Which ledger belongs to which bank account.

Asset register

Purchase value, method and depreciated amount per asset.

Control totals

Totals per account type, to see whether nothing dropped out along the way.

Your own rights apply

The connector sees no more than you are allowed to see in your accounting package.

The dashboard only reads

At most, corrections are suggested. You post them yourself, or in a conversation with your approval.

The figures are live

When you open it, the dashboard retrieves the current status from your administration. If you have had it open for a long time, just refresh the page.

Setup

How the dashboard comes together

One instruction is enough to get started, but what happens next is fixed. First it is verified and only then is it judged, because a closing that gets signed off while the figures are wrong is more dangerous than no check at all.

The first time takes longer than you are used to from a report, because real calculation and verification take place. Next month you run it again and the same connector appears, with that month's figures.

01

Choose the administrations

Which administration or administrations you are closing. Several become tabs in the same dashboard, and the current account is then mirrored between those administrations. The period to be closed is always the month before today.

Where you begin Check the monthly closing of Van Dijk Groothandel and Van Dijk Holding.

02

The data is retrieved

Per administration the eight types of data from the previous section, together with the control totals. What comes in is kept raw, so an error in the retrieval stands out instead of quietly being counted along.

03

The fourteen checks run

Each check has fixed limits and ends in action, attention, in order or n/a. N/a is an outcome and not a gap: no current account in your scheme does not mean something went wrong.

04

The outcome is verified

Revenue and costs are retrieved separately once more via the reporting balance and compared with what the dashboard has calculated. If they differ, you hear about it before you get the dashboard.

05

You get the dashboard with a status overview

The dashboard appears as its own page in Claude. Along with it you get in a few sentences how many checks need action or attention, the most important points with amounts, and which checks were n/a and why.

Calculation choices

Four choices that have already been made

Every check has a threshold, and that determines how long your list becomes. In most reports you never see them. These four are shown here with the reason behind them, and you can have them adjusted if your situation calls for it.

Compare against three months, not one

Looking back one month makes every seasonal month suspect. The month being closed is set against the average of the three preceding months, and a report is only raised at a difference of 25% and € 250. That keeps the list short enough to actually work through.

A missing relation is action, a deviation is attention

A customer that had turnover in at least two of the three preceding months and now has none is flagged for action. A customer that is present but deviates by 40% is flagged for attention. New and occasional customers are listed for information and do not count towards the score.

The period to be closed is always the month before today

The current month is never assessed, because by definition it is not finished. If you want to review an earlier month, you ask for that explicitly.

N/A is an outcome, not a gap

No current account in your chart, no staff costs, no provisions: then the check shows N/A with the reason attached. That is something other than in order, and something other than left out.

For each check there is an expandable view showing exactly what was compared and against which limit. This lets you verify for yourself why something ended up as action or attention.

Please note

What you need to know before acting on a signal

Four things determine how you should read the results. They also appear in the overview itself, but knowing them in advance saves you a search.

News

The dashboard is live

When you open it, the checks run on the current state of your records. As long as you keep it open, it does not refresh by itself. If someone posts something to the closed month in the meantime, refresh the page. The link stays the same.

Data

The first time takes longer, after that it does not

Before any calculations can run, your records are prepared on Analytics once for a new connector, which can take up to twenty-four hours. After that a check runs in seconds. Data is only read, nothing changes.

Limits

What the connector does not do

The status of your journals and the actual closing of a period do not run through the connector. You do that in your own package. The dashboard tells you when it is possible.

Subscription

Dashboards require Analytics

A closing check only runs on the Analytics subscription, and you need a paid Claude subscription to open the overview. Compare the subscriptions side by side.

During the closing

It is your checklist too

You rarely complete a closing in one go. Once you have reviewed something you tick it off, and that stays recorded per administration and per month, so you can step away in between and carry on later.

Points of attention at the top

Only what needs attention or action, sorted by urgency, with a button for each point leading to the check itself. So you do not start at check one, but at what stands out.

The supporting detail below

Each check opens up to the figures behind it: which accounts, which contacts, which amounts per month, with colour on the month that deviates. So you see where a signal comes from, not just that there is a signal.

Through to the entry in Exact

From a general ledger account or a contact you click through to the entries in Exact Online, with the correct period already set. This works as long as you are logged in to that administration in the same browser.

Multiple administrations side by side

If you add more, they become tabs in the same dashboard, with status dots per tab. The current account is mirrored between those administrations, so a difference is immediately visible on both sides.

If you want an extra check, a different limit or your own group, you simply ask for it in the conversation. What you change is still there next month.

Ready to use

All fourteen checks in one file

The checks, the thresholds they respond to and the way the outcome is built are all held in a single skill. You set it up once in Claude, and after that every month-end close is a one-sentence task.

01

Download the file

One file, which you do not have to unpack.

02

Add it to Claude

Go to Customize → Skills, click Add and choose the file. You only do this once, after that it is ready in every conversation.

03

Turn on the connector

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

04

Ask for your check

In plain language. The skill knows which month and which checks.

Check the month-end close for Van Dijk Groothandel and Van Dijk Holding.
Skill fileai-connect-maandafsluiting.skill
Download the skill

42 kB · no installer

You may open and adjust it. If you want a threshold to be different, for example reporting from 10% instead of 25%, you can change that yourself.

No AI Connect yet? Try it free for thirty daysNo payment details required, so you can use it for your next monthly closing right away. The skill runs on AI Connect with the Analytics plan, plus a paid Claude plan.
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 your data is in safe hands.
Privacy guaranteedPrivacy is not an afterthought for us 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 in the field of information security.
ISO 27001 logo

ISO 27001

Certified

Rely on the connector

Kalender met klok

Try 30 days for free

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

Handdruk

Built by specialists

For over ten years we have been connecting Exact Online, AFAS and Twinfield to other systems. That knowledge of the accounting packages is also built into AI Connect.

Tandwiel met sterretjes

Professional support

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

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 on sign-up

✓Monthly or annually, you choose

All dashboards included

Liquidity forecast, month-end closing, accounts receivable management, intercompany, management information and the trading cockpit. You pay for the connector, not per dashboard.

One administration included

Add more administrations as you like. The more you connect, the lower the price per administration.

Your own permissions apply

The connector sees no more than you are allowed to see. A dashboard only reads; changes happen with your approval.

No setup costs

No configuration needed. You connect it yourself and are up and running within an hour.

Dashboards only work on Analytics. On Essentials you can still ask questions about your administration. On top of that you need a paid Claude subscription, because that is where the dashboard lives. 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

Yes, that is exactly the idea. The fourteen checks follow the fixed checklist that most administrations use when closing a month: reconciling the bank with the latest statement, clearing suspense accounts to zero, mirroring the current account, adding to provisions, posting depreciation and the payroll journal, checking the VAT position, reconciling outstanding items with the general ledger, and comparing the consistency of revenue and costs against the previous months, down to the customer and the supplier. What you have reviewed you tick off, and that remains in place per administration and per month. What is not included are the steps outside your administration, such as a stock count or reviewing contracts; those you keep on your own list alongside.

Would you like to read the checklist separately, with a note for each step on what you check and why? Read The month-end closing with AI: complete checklist and time savings.

Always the month before today. The current month is never assessed, because by definition it is still missing postings. If you want to review an earlier month, for example because you are correcting retroactively, you ask for that explicitly.

Live. When you open it, the checks run on the current state of your administration. As long as you have the dashboard open, it does not refresh by itself: if you have posted or corrected something in the meantime, refresh the page and the checks run again. The link stays the same.

No. The checks recognise for themselves what a suspense account, a revenue account or a provision is, based on the type and on the description you already use. So you do not have to connect or classify anything in advance.

That the check does not apply to your administration: no current account in the chart, no staff costs, no provision accounts. The reason is stated alongside. N/A is therefore something different from in order, and something different from omitted.

Yes. Each administration gets its own tab, with the status dots per check on each tab. The current account is mirrored between the loaded administrations, so you see a difference straight away on both sides.

No. You set a soft close or a hard close in your package itself, and that does not run through the connector. The dashboard is about the step before that: checking whether everything is correct before you close the period.

No. Flagging and posting are deliberately separated here: the check reads and calculates, and at most prepares a correction proposal. If you really want to make that posting, it happens in a separate conversation and only after you have approved it.

Because a closing check calculates across your entire administration, often over two financial years, and that takes more than answering a question in a conversation. On Essentials you can easily ask separate questions about your figures, but you do not get a page that you reopen after the weekend with your ticks still in place. View the subscriptions side by side.

Yes, both. AI Connect is the connector with your bookkeeping package; Claude is the place where the checks run and where your overview stays in place. Without a paid Claude subscription you have no environment to open it in.

A dashboard that refreshes itself can only be shared with colleagues who have the connector in their own Claude account. If you want to share a status with your bank or accountant, you create a snapshot: a fixed status with a date, as a link or attachment. You can also forward the results themselves: under each check you find the supporting data as a table, ready to copy into your closing file.