Bookkeeping
What a Trial Balance (Kolommenbalans) Is and When Every Dutch Entrepreneur Needs One
What is a kolommenbalans (trial balance) in Dutch bookkeeping? See the four-column structure, a worked example, and when you need one.
•
15 mins
Intro
At the end of every accounting period, a Dutch bookkeeper faces the same challenge: turning hundreds of individual ledger entries into a coherent set of financial statements. The kolommenbalans, literally the "columnar balance," is the working paper that makes this step visible and verifiable rather than something that happens invisibly inside software.
Think of it less as a report and more as a control tool: a single sheet where raw bookkeeping entries get checked, netted off, sorted into profit-and-loss or balance sheet, and turned into numbers you can actually trust. This article walks through what it is, how the four-column structure works with a real worked example, how to build one step by step, and when, if ever, you actually need to touch it yourself.
What the Kolommenbalans Actually Is (and What It Is Not)
The kolommenbalans is a bookkeeper's working paper that brings together four related financial overviews in one document. It is the bridge between daily ledger entries and the final financial statements, and the side-by-side column structure is what makes the whole flow, from raw entry to finished account, visible on a single sheet rather than scattered across separate calculations.
Key takeaway: The kolommenbalans is a working document, not a published report. It is not submitted to the Belastingdienst, not filed with the KvK, and not legally required by Dutch law. It is the internal worksheet that makes building the jaarrekening transparent and verifiable.
Four related but distinct documents get confused constantly in this space. Here is how they actually relate to each other:
Document | Dutch term | What it shows | Used for | Legally required? |
Trial balance (raw) | Proefbalans | All debit and credit entries per account, not netted off | Checking all entries balance | No |
Net balance | Saldibalans | Net balance per account (debet or credit, not both) | Starting point for the kolommenbalans | No |
Columnar balance | Kolommenbalans | Proefbalans + saldibalans + resultatenrekening + eindbalans in one sheet | Period-end working paper; building financial statements | No |
Closing balance | Eindbalans | Assets and liabilities at period end | Formal balance sheet; basis for jaarrekening | Yes, as part of the jaarrekening |
The eindbalans is the output. The kolommenbalans is the process that gets you there. One of these documents eventually gets published; the other stays in the working file. If you want to see what the eindbalans looks like once it becomes a formal document, how to prepare a balance sheet covers that side of the process.
The Four-Column Structure: What Goes Where
A full kolommenbalans contains four pairs of debet and credit columns, eight columns in total. Each pair serves a specific purpose, and every account moves through the document in a defined sequence. Understanding which column receives which account is really the entire skill.
Column pair | Name | Debet contains | Credit contains |
1 | Proefbalans | Sum of all debet entries per account | Sum of all credit entries per account |
2 | Saldibalans | Net debet balance (if debet > credit) | Net credit balance (if credit > debet) |
3 | Resultatenrekening | Expense accounts (kosten) | Revenue accounts (opbrengsten) |
4 | Eindbalans | Asset accounts (activa) | Liability and equity accounts (passiva + eigen vermogen) |
Here is a worked example to make this concrete. Bakkerij de Haan BV is closing its quarter, and three accounts illustrate how the structure works:
Account | Proefbalans D | Proefbalans C | Saldibalans D | Saldibalans C | Resultatenrekening D | Resultatenrekening C | Eindbalans D | Eindbalans C |
Bank (asset) | 18,500 | 6,200 | 12,300 | 12,300 | ||||
Omzet (revenue) | 42,000 | 42,000 | 42,000 | |||||
Inkoopkosten (costs) | 28,000 | 28,000 | 28,000 | |||||
Totaal | 46,500 | 48,200 | 40,300 | 42,000 | 28,000 | 42,000 | 12,300 |
The proefbalans totals do not match here because this is a simplified three-account slice, not the full ledger; in a complete kolommenbalans, proefbalans debet always equals proefbalans credit exactly. The number worth focusing on is the resultatenrekening: 42,000 credit minus 28,000 debet leaves 14,000 euros, which is the period profit. That 14,000 euros does not just sit in the resultatenrekening columns; it flows across to the eindbalans credit side as an addition to eigen vermogen, and that transfer is exactly where most manual kolommenbalans exercises go wrong.
Watch out: Every account goes into either the resultatenrekening columns OR the eindbalans columns, never both. Revenue and cost accounts go to the resultatenrekening. Asset, liability, and equity accounts go to the eindbalans. If an account appears in the wrong column pair, the eindbalans will not balance.
How to Build a Kolommenbalans Step by Step
Building a kolommenbalans manually follows a defined sequence. Modern software does all of this automatically, but understanding each step is genuinely useful when you need to verify software output or troubleshoot a result that refuses to balance.
Extract the proefbalans from the grootboek. List every account with its total debet and total credit entries for the period. The sum of all debet totals must equal the sum of all credit totals; if they do not, there is a bookkeeping error to find before you go any further.
Net off to the saldibalans. For each account, subtract the smaller side from the larger. The remaining balance goes in the saldibalans column matching the larger side. An account with 8,000 debet and 3,000 credit shows 5,000 in the saldibalans debet column, nothing on the credit side.
Classify each account as resultaat or balans. Revenue and expense accounts, the result accounts, move to the resultatenrekening columns. Asset, liability, and equity accounts, the balance sheet accounts, move to the eindbalans columns.
Calculate the period result. In the resultatenrekening columns, the difference between total credit (omzet) and total debet (kosten) is the period profit or loss. Profit means credit is greater than debet.
Transfer the period result to the eindbalans. The profit or loss from step 4 has to appear in the eindbalans credit column as an addition to eigen vermogen if it is a profit, or in the debet column if it is a loss. This balancing entry is what makes the eindbalans actually balance.
Verify. Eindbalans debet total must equal eindbalans credit total. If it does not, either an account has landed in the wrong column pair, or the period result transfer from step 5 has simply been skipped.
Key takeaway: The period result calculated in the resultatenrekening (step 4) must be manually transferred to the eindbalans eigen vermogen (step 5). This transfer is the most commonly forgotten step and the most common reason a kolommenbalans does not balance on the first attempt.
Do You Actually Need to Do This Manually? A Decision Checklist
The kolommenbalans is a fundamental bookkeeping concept, but most Dutch entrepreneurs never actually build one by hand. Modern bookkeeping software generates it automatically from the grootboek. Whether you need to engage with it directly depends entirely on your situation.
You need to engage with the kolommenbalans manually if:
You do your own bookkeeping in Excel or a spreadsheet
Your bookkeeping software produces an unbalanced kolommenbalans and you need to find the error
You are learning bookkeeping from scratch and want to understand the full accounting cycle
Your accountant or boekhouder asks you to review their working papers
You are a bookkeeper or accountant preparing manual accounts for a client
You do NOT need to build it manually if:
You use modern bookkeeping software: it generates the kolommenbalans automatically from every entry you make
You have outsourced your bookkeeping entirely: your boekhouder handles all period-end working papers
You are only reviewing your financial position: use the eindbalans or winst- en verliesrekening directly instead
For most Dutch BV founders using bookkeeping software, the kolommenbalans runs silently in the background. It is worth understanding conceptually, but it is rarely something you interact with directly unless something goes wrong. If you are deciding how much of this to handle yourself versus hand off entirely, accountant or bookkeeper covers where that line typically sits.
Watch out: Even if your software generates the kolommenbalans automatically, you should periodically verify that the eindbalans output balances and that the period result in the resultatenrekening matches what you expect. Software errors and incorrect account classifications do occur, and they show up as an unbalanced kolommenbalans.
The Kolommenbalans in the Dutch Bookkeeping Cycle
The kolommenbalans sits at a specific point in the Dutch bookkeeping cycle, the boekhoudcyclus, that runs from opening balance to closing balance every reporting period. Seeing where it sits explains why the document exists at all and what specific problem it is solving.
The cycle runs like this: the opening balance of a new period, the beginbalans, is simply the closing balance carried over from the previous one. During the period, every transaction gets recorded in the dagboeken, the journals, and posted through to the grootboek, the general ledger. At period end, the bookkeeper extracts the proefbalans to confirm that total debet equals total credit across the whole ledger. That proefbalans then gets netted off into the saldibalans.
This is where the kolommenbalans earns its keep: it extends the saldibalans by classifying every account into either the resultatenrekening or the eindbalans, calculating the period result, and producing a complete set of financial statements in one document rather than several disconnected ones. The eindbalans that comes out of this process becomes the basis for the formal jaarrekening, the published financial statement filed with the KvK for medium and large BVs, or simply retained internally for small BVs and eenmanszaken. The kolommenbalans itself is never published anywhere; it lives permanently in the accountant's working file.
Key takeaway: The kolommenbalans can be prepared monthly, quarterly, or annually; there is no legal frequency requirement. Quarterly preparation is the most common practice for Dutch BVs because it aligns with the BTW return cycle and gives regular insight into profitability without the workload of a full monthly close.
Since quarterly kolommenbalans preparation lines up so closely with the BTW filing calendar, it is worth reading alongside when to file VAT if you have not mapped out your own filing rhythm yet, and the resulting figures ultimately feed into ratios like the ones covered in annual accounts Netherlands, where balance sheet and profit figures get turned into performance measures.
Common Errors and How to Spot Them
An unbalanced kolommenbalans is always the result of one specific, findable error. The challenge is finding it efficiently rather than re-checking everything from scratch. Three causes account for the overwhelming majority of cases.
Error 1: an account placed in the wrong column pair. A debtors account, debiteuren, is a balance sheet account and belongs in the eindbalans debet column. If it accidentally lands in the resultatenrekening columns instead, the eindbalans will not balance and the period result will be wrong too. The fix is to recheck the classification of every account where the misplaced amount is close to the size of the imbalance.
Error 2: the period result never transferred to the eindbalans. The profit or loss calculated in the resultatenrekening columns has to appear as a balancing entry in the eindbalans eigen vermogen. Forgetting this single step is the most common reason a kolommenbalans fails to balance on the first attempt, and the eindbalans will show a debit or credit imbalance that is exactly equal to the period profit or loss, which makes it easy to spot once you know to look for it.
Error 3: an original bookkeeping error that the proefbalans never caught. A transposition error, booking 1,650 as 1,560, will not show up in the proefbalans if both sides of the entry are wrong by the same amount. It surfaces later instead, as a mismatch between the kolommenbalans result and the entrepreneur's actual cash position or bank statement. This kind of error needs reconciliation back to source documents; the kolommenbalans structure itself cannot catch it.
Watch out: A kolommenbalans that balances is not proof that the bookkeeping is correct. It only proves that debet equals credit. An account booked on the wrong side of the ledger, a credit posted as a debit, will not cause an imbalance at all; it will simply produce an incorrect profit or asset figure. Regular bank reconciliation and supplier statement matching are the checks that actually catch these errors.
Period-end error checklist:
Proefbalans debet total equals proefbalans credit total
Every account appears in either resultatenrekening OR eindbalans columns, not both
Period result (profit or loss) transferred to eindbalans eigen vermogen
Eindbalans debet total equals eindbalans credit total
Eindbalans totals reconciled to bank statement and debiteuren/crediteuren balances
Since profit calculated at this stage flows directly into your VPB liability at year-end, it is worth understanding how that connection works; see how much tax you pay for how period profit turns into an actual tax bill.
Get Your Bookkeeping Cycle Running Cleanly, End to End
The kolommenbalans is a small piece of a much larger cycle, but it is the piece that catches errors before they turn into a jaarrekening that does not add up or a VPB return based on the wrong profit figure. Whether you build one by hand once to understand the mechanics or never touch one directly because your software handles it, knowing what it is protects you from confusing a working paper with a finished report, or missing a transfer that quietly throws your whole closing balance off.
If you want your bookkeeping cycle running on software that generates a correct kolommenbalans automatically at every close, rather than wondering whether last quarter's numbers actually reconcile, book a demo and we will walk through how your current setup handles period-end closing. If you are earlier in the process, our team can also help you incorporate your BV or set up bookkeeping and payroll correctly from your very first entry.
FAQs
What is a kolommenbalans in English?
The nearest English equivalent is an "extended trial balance," or more literally a "columnar balance." It is a Dutch bookkeeping working paper that combines the trial balance, net balance, profit and loss account, and closing balance sheet in one document.
What is the difference between a kolommenbalans and a balans?
A balans, specifically the eindbalans, is the final balance sheet: assets on one side, liabilities and equity on the other, at a single point in time. The kolommenbalans is the working paper that produces that balans, containing several extra columns showing how the figures were checked and calculated along the way.
What is the difference between a proefbalans and a saldibalans?
A proefbalans shows the raw sum of all debet and credit entries per account, with both sides displayed. A saldibalans nets those off so each account shows only its net balance, either debet or credit, never both. The saldibalans is effectively the starting point for building the kolommenbalans.
How many columns does a kolommenbalans have?
Eight columns in total: four paired sets of debet and credit columns, covering the proefbalans, saldibalans, resultatenrekening, and eindbalans in sequence.
Is a kolommenbalans legally required in the Netherlands?
No. There is no mandatory format under BW2, AWR, or Wet OB 1968. The jaarrekening that eventually results from this process is legally required for a BV, but the kolommenbalans itself is purely an internal working document.
Does my bookkeeping software generate a kolommenbalans automatically?
Yes, in almost all modern Dutch bookkeeping software. It is generated continuously or at period-end directly from your grootboek entries, which is why most BV founders using software never interact with it directly.
How often should I prepare a kolommenbalans?
There is no legal frequency requirement. Quarterly is the most common practice among Dutch BVs, since it lines up naturally with the BTW return cycle, though monthly and annual preparation are both common depending on how closely a business wants to track profitability.
Why does my kolommenbalans not balance?
The three most common causes are an account placed in the wrong column pair, the period profit or loss never transferred to the eindbalans, or an underlying bookkeeping error that the proefbalans did not catch because it affected both sides of an entry equally.
What is the difference between a kolommenbalans and a jaarrekening?
The kolommenbalans is an internal working paper used to build the figures; it is never published. The jaarrekening is the formal, published annual account that results from that work, filed with the KvK where required by law.
Written by
Nick Knuppe
CEO & Founder
