Maandfacturatie uit een Excel-lijst: van 6 tot 8 uur naar hooguit een uur.
Back to blog

Monthly invoicing from an Excel sheet: from 6 to 8 hours to an hour at most

At one of our clients, an invoice is drawn up every month per category from an Excel sheet, with the detail sheet as an attachment. Their process was right and took 6 to 8 hours a month. Now their own platform reads the sheet and gets the attachments ready in Excel and PDF. The team checks everything and draws up the invoice itself. The whole job now takes an hour at most, with zero AI costs to keep it running. Building it took 2 to 3 days, because the rules were already settled.

Gaëtan Steijaert
Written by Gaëtan Steijaert Process analyst and software architect from Ghent

At one of our clients everything ends up in an Excel sheet every month, and invoices get drawn up from it. It's a fixed moment in their month.

The starting point

The team drew up those invoices from the sheet themselves: one invoice per category, with the detail sheet attached. And everything got checked before an invoice went out. A careful way of working, and it took 6 to 8 hours a month.

The sheet was good and the rules were settled. That's a solid base to build on.

What we built

We built a part of their own platform that reads the Excel sheet itself. You open the month and you see a preview per category. If it looks right, the platform makes the attachments for the invoice, in Excel and as a PDF. Then someone on the team checks everything, the way they always did (that stays a human job). The team draws up the invoice itself, with those attachments, and sends it via Peppol. In a next phase, the invoice itself will also be made and sent after that check, via their accounting package.

Excel sheet every line of the month Platform reads the sheet itself Preview per category Attachments Excel and PDF
From an Excel sheet to finished attachments, with a preview in between to check.

What it gave back

What used to take 6 to 8 hours a month is now done in an hour at most.

There's no AI in it. It's fixed rules in code, so keeping it running costs zero euro in AI. No tokens, no subscription ticking along every month.

Building it took 2 to 3 days. That went fast because their way of working was already clear: a sheet goes in, attachments come out, and someone checks them. The rules were there already, thanks to how carefully they work.

Monthly invoicing from an Excel sheet: from 6 to 8 hours to an hour at most. Every month an Excel sheet, one invoice per category with a detail sheet. The rules were already clear, built in 2 to 3 days. Sheet in, attachments out: read it in, preview per category, attachments in Excel and PDF. The check stays human work, sending via Peppol. Next phase: after the check the invoice goes out by itself. Before 6 to 8 hours, now 1 hour at most, zero euro in AI costs. Is there a monthly job at your place with clear rules?
The whole story in 8 slides. Scroll or swipe sideways.

What about you?

Is there a monthly job at your place where the rules are already completely clear, and that mostly just eats time? Let us have a look. The first look is free, no strings.