Running the businessAnalysis
From Spreadsheet to Financial OS: One Invoice, Before and After
A concrete before-and-after for a Belgian freelancer keeping the books in a spreadsheet: one invoice, one partial payment and one question, followed through a spreadsheet and through Dokus. An illustration with invented figures, not a customer story.
- Published
- Updated
- Reading time
- 3 min
A spreadsheet is a reasonable way to start. It is free, familiar and flexible. What it does not do is connect things: the invoice, the payment that settles it, and the receipt behind a cost live in different places, and you are the link between them.
The clearest way to show the difference is to follow one ordinary piece of work through both. The business, figures and dates below are invented for illustration. This is not a customer story.
The example
A freelance designer invoices a client for a logo project:
- Invoice 2026-031, EUR 1,000 plus 21% VAT: EUR 1,210, payment due in 30 days.
- The client pays EUR 605 on time, and the rest three weeks later.
- In between, the designer wonders: who still owes me money?
In the spreadsheet
Sending the invoice. The designer copies last month's invoice, changes the number, the client and the amount, exports a PDF and emails it. The spreadsheet gets a new row: number, client, EUR 1,210, "sent". Nothing checks that 2026-031 follows 2026-030, or that the client is a Belgian company that should receive a structured invoice over Peppol rather than a PDF (see the Peppol guide).
The first payment. EUR 605 appears in the banking app. The designer has to remember which invoice it belongs to, open the spreadsheet, and decide what to write in the status column. "Paid"? "Partly paid"? A note? Next month, the note is easy to miss.
The question. To answer "who still owes me money?", the designer filters the spreadsheet for invoices not marked paid, then checks the bank for anything that came in since the last update. The answer is only as good as the last time both were compared.
In Dokus
Sending the invoice. The designer creates the invoice with the client selected. Numbering follows on from the last invoice. If the client can receive over Peppol, confirming the invoice sends it that way, on every plan. It then shows as sent, with its delivery state.
The first payment. Once the bank transaction is in Dokus, from a live bank feed on Core or an uploaded statement on any plan, Dokus suggests that the EUR 605 belongs to invoice 2026-031 and says why. The designer confirms it. The invoice now shows as partially paid, EUR 605 of EUR 1,210 open. When the second payment arrives, the same suggestion and confirmation close it. Nothing is matched without that confirmation.
The question. The designer asks: who still owes me money? The answer lists the open invoices as records that can be opened, including 2026-031 with EUR 605 outstanding. Ask is on every plan: 15 questions a month on Free, unmetered on Core. Documents are read and classified on infrastructure we operate in Belgium. The optional assistant is the exception: your question, and the records needed to answer it, go to a named external model provider under a data processing agreement, and are never used for training.
Side by side
| Step | Spreadsheet | Dokus |
|---|---|---|
| Invoice number | Typed by hand | Follows on from the last invoice |
| Delivery to a Belgian company | PDF by email, checked by you | Peppol when the client can receive it, sent on confirm |
| Partial payment | A status you choose and a note | Recorded as partially paid, with the open amount |
| Linking payment and invoice | Your memory | Confirmed on its own when the payment names who paid; otherwise a suggestion with its reason, confirmed by you |
| "Who still owes me?" | Filter, then check the bank | Asked, answered with the records |
What does not change
- You still review. Dokus suggests; a person confirms. Someone still looks at the unusual cases.
- Your accountant still decides treatment and files. Dokus keeps the records they work from; it is not an accountant. See working with your accountant.
- Moving is a decision about your own volume. With a handful of invoices a year, a well-kept spreadsheet can be enough.
If you do move
- Pick a cut-off date. Start new invoices and costs in the new tool from that date; do not retype years of history.
- Keep the old spreadsheet as the record of the period before.
- Tell your accountant from which date the records live where.
You can follow this same kind of example on the sample business in the demo, without signing up.