Accountant: automate customer portfolio analysis

In brief

A typical Belgian accountant spends between 2 and 4 hours per client per year preparing the annual accounts presentation meeting: extracting figures, computing ratios, comparing with previous years, identifying anomalies, writing commentary. Over 100 clients, that is 300 to 400 hours of low-value work — time that should go to strategic advice, not calculation mechanics. Here is a 5-step methodology to automate 80% of that load.

The hidden cost of manual analysis

Run the numbers for your practice:

Task	Avg time / client / year
Pull NBB annual accounts	5 min
Enter rubrics into Excel	15 min
Compute 12 ratios	10 min
Compare with N-1 and N-2	15 min
Identify warning signs	15 min
Write commentary	30 min
Format the report	20 min
Prepare the meeting	30 min
Total	2h20

Over 100 clients: 233 hours. At a senior accountant's average hourly rate (€120/h), that is €28,000 of capacity absorbed by repetitive work. And that assumes you do not restart from scratch each year. In practice, many practices redo the input every year.

Step 1 — Connect the API to the NBB

The Central Balance Sheet Office at the NBB exposes a public API for filed annual accounts. No more chasing PDFs — a single HTTP call returns structured rubrics (XBRL) for the 10 most recent fiscal years.

The Company Belgium API industrialises this access:

Code

GET /api/companies/{enterpriseNumber}/financial-intelligence

A single call returns:

The full BCE identity (registered office, establishment units, directors, status, UBOs)

The last 10 fiscal years with all NBB rubrics

The 12 financial ratios already computed

The academic scores Altman Z'' and Conan-Holder with consensus

The dormancy score and the suggested credit limit

No more Excel entry, no spreadsheet to maintain: NBB updates flow through automatically.

Step 2 — Build your portfolio dashboard

With the API in place, all the practice's clients can be displayed in one view:

Client	Year	Health score	Z''	C-H	Trend	Alert
ACME Consulting SRL	2024	78/100	3.20	0.20	↗	—
Bricoland SA	2024	42/100	1.80	0.06	↘	Tight liquidity
Cuvée Belge SC	2023	—	—	—	❓	2024 accounts not filed
Demolition Pros SRL	2024	25/100	0.90	−0.03	↘	Distress + negative equity
...	...	...	...	...	...	...

The accountant's eye goes straight to the red rows. Exactly the opposite of today's flow, where you spend as much time on a healthy client as on a struggling one.

Step 3 — Auto-generate client reports

Each closed fiscal year triggers the generation of a ready-to-use PDF report including:

Cover page with practice logo, client name, fiscal year

Overview: global health score, academic scoring, dormancy

Summary balance sheet over 3 to 5 years with evolution charts

Income statement over 3 to 5 years

Table of the 12 ratios with verdicts (✅ ⚠️ ❌)

Auto-generated commentary based on indicators (which you can review and complete)

Strategic recommendations based on detected anomalies

This report replaces hours of formatting — all you have to add is your personalised advice in the closing section, exactly the value-add the client pays for.

Step 4 — Set up event-driven monitoring

A client can experience a BCE event between two closings:

Director change (governance signal)

Registered office transfer

Capital change (increase, decrease)

Belgian Official Gazette publication (transformation, merger, dissolution)

Change of beneficial owners in the UBO register

Setting up a BCE webhook across your portfolio alerts you in real time. No more manual file checks — you are notified only when something moves.

Use case: a client moves its registered office → you get the notification → you verify immediately whether it matches a real evolution (operational move) or a warning signal (move to a suspect domiciliation).

Step 5 — Integrate AML scoring for the legal obligations

Accountants are subject to the 18 September 2017 anti-money-laundering law. This implies ongoing vigilance about:

The real identity of the client and beneficial owners

Client profile (consistency of activity / figures / wealth)

Atypical transactions

Automation enables:

Auto-checking UBOs against PEP and sanctions lists

Recomputing the risk profile at each annual closing

Flagging inconsistencies: a client declares "consulting" but has an asset turnover typical of trading

Logging every check in an audit journal ready for an FSMA review

This turns AML from a time-consuming burden into an automatic safety net, without weighing on your daily workload.

Typical ROI of automation

For a 100-SME-client practice:

Item	Before automation	After automation	Saved
Annual meeting preparation	233 h	50 h	183 h
Continuous AML vigilance	80 h	20 h	60 h
Report drafting	50 h	10 h	40 h
Customer event monitoring	30 h	5 h	25 h
Yearly total saved			308 h

At the average billing rate (€120/h), that is €37,000 of freed capacity per year. To reinvest in strategic advice (transmission, tax planning, wealth optimisation) — the highest-margin activity and the one clients value most.

How to get started

Scope the perimeter: how many clients, in which accounting software, at what hourly cost

Pick a pilot module on 10-20 clients to validate data quality and report format

Connect the Company Belgium API to your accounting software via REST endpoints (Winbooks, Sage BOB, Octopus, etc. — many already provide connectors)

Adapt the standard report to your branding and usual commentary

Roll out gradually to the full portfolio, ideally targeting clients with staggered closings first to spread the load

To start technically, see the API documentation and our article on financial analysis via the Central Balance Sheet Office. For sister professions (notaries, lawyers), see also our dedicated checklist for notaries on UBO verification before an act.

Frequently asked questions

Isn't automating financial analysis the same as replacing the accountant's work?

No. Automation handles the calculation, formatting and consolidation mechanics — exactly what has no value to the client. Strategic advice, sector context interpretation, recommendations on tax and wealth arbitrages: all remain 100% human and are exactly what the client pays for. The goal is to free time for advisory, not to replace the accountant.

What initial investment for a 50-client practice?

The Company Belgium API uses a subscription with metered call cost. For 50 clients with a yearly update + event monitoring, the cost is in the order of a few dozen euros per month. Compared to the 100+ hours saved yearly, ROI is immediate. The main investment is time: 1 to 2 days to connect the API to your accounting software and calibrate the standard reports.

Can my accounting software (Winbooks, Sage BOB, Octopus, ...) connect to the API?

Yes. All major Belgian accounting softwares support REST APIs. The connection is made via a connector (sometimes provided by the vendor, sometimes built in-house or with a technical partner). The connection effort is marginal — complexity lies mainly in defining business rules (alert thresholds, report templates, customer follow-up triggers).

How is client data confidentiality preserved in the automation?

The Company Belgium API queries only public data (BCE and annual accounts filed at the NBB) — no confidential client data. Internal data (correspondence, tax files) stays in your accounting software and never transits to the API. Accounting professional secrecy is fully preserved. For AML, PEP/sanctions checks on UBOs are also run against public lists, with no information shared with third parties.