Migrating from WinBooks to Odoo without losing a cent
Chart of accounts, customers and suppliers, VAT, invoices and scanned documents. How we migrate a WinBooks file to Odoo, and how we prove nothing is missing.
WinBooks is used by a large share of Belgian accounting firms and SMEs. Many are considering a move to Odoo but get stuck on the same question: what happens to the history, the invoices, the scanned documents and the VAT already filed?
Here is how we migrate a WinBooks file to Odoo, step by step, and above all how we prove that the figures are identical.
1. Start from the WinBooks backup, not manual exports
There is no need to export dozens of files by hand. We start from the file’s WinBooks backup, which the software produces itself. It contains everything we need:
- the chart of accounts and the journals;
- customers and suppliers, with their VAT numbers;
- VAT codes and file settings;
- every entry of the financial year;
- the scanned documents attached to the entries.
You send us one file, and that is it.
2. Mappings, approved by you
Before anything is written to Odoo, we draw up three mapping tables: accounts, journals and VAT codes. They are submitted to you for approval.
For VAT, mapping is never based on a code’s name, which is often misleading from one package to another, but on the VAT return grids it feeds. A purchase that fed grids 81 and 59 in WinBooks must feed the same grids in Odoo, full stop.
3. Real invoices, with their PDFs
Sales, purchases and credit notes are recreated as real Odoo invoices, not as plain journal entries. They can therefore be viewed, matched and followed up like any other invoice. The PDF scanned in WinBooks is attached to each document.
The opening balance and miscellaneous operations are migrated as journal entries.
An important detail: VAT is migrated exactly as it was entered from the invoice, to the cent, and not recomputed. The supplier’s rounding is respected, and totals stay identical.
4. Check before writing, then after
This is the core of the method.
- Before: a full simulation computes what each document will give in Odoo and compares it with the WinBooks general ledger. Nothing is written while any difference remains.
- During: documents are created as drafts first, and every saved document is read back.
- After: the balance of every account is compared with the general ledger, and the VAT grids, quarter by quarter, with the returns actually filed.
On a first real file, more than 500 documents were migrated with zero difference to the cent, on the accounts as well as on the VAT grids.
5. An Odoo database already in use? Not a problem
Sometimes the client already uses Odoo, for example for invoicing, when the accounting is migrated. In that case we compare first and import only what is missing. Existing customers and suppliers are reused, nothing is renamed or duplicated.
6. Matching, to start again with clean accounts
Once invoices are migrated, they still need to be matched with the payments already in the bank journal. We suggest the matches (structured reference, amount, partner name), you approve them, and they are applied. The result: matched customer and supplier accounts, with nothing left in a suspense account.
What about confidentiality?
During the migration, the file’s documents are sent to no external reading service: cloud-based recognition is switched off for the duration of the import. Processing runs on our own servers, in Belgium.
Not Odoo? The same method applies
Odoo is our reference destination, but the method is the same for any open software, open source or with a documented API: start from the source, have the mappings approved, reconcile to the cent.
Working with WinBooks and thinking of switching? Discover our migration method or book a demo on one of your files.