Skip to content

Set up opening data ​

When you take over a building from another syndic or move it from another accounting system, you bring its balances on the takeover date into SNDQ: what owners still owe or get back, the funds, the bank accounts, the suppliers and the other balance items. You enter them yourself in the Opening data setup wizard and confirm them once the balance matches.

This video (4:46, Dutch screens and captions) walks through the whole wizard, from Start setup to a balance that matches, with sample amounts.

Important

Confirming is final: SNDQ then books all opening balances. Check everything before you confirm.

Before you start ​

  1. Confirm the building's chart of accounts. See Set up chart of accounts.
  2. Make sure the building's units and their owners are in SNDQ. When you start, every unit gets a row for its owner.
  3. Have the previous syndic's closing balance sheet on the takeover date at hand (assets and liabilities), with the settlement per owner, the open supplier items and the bank statements.

Excel templates ​

Prefer to collect the data in Excel first, for example to request it from the previous syndic? Use these templates, then enter the amounts in the wizard yourself.

Download all templates (.zip)

#TemplateDescriptionDownload
01Balance sheetFull balance sheet (assets & liabilities) from the previous periodDownload
02Owner balancesOutstanding amounts per owner per unitDownload
03Supplier balancesOutstanding debts per supplierDownload
04Reserve fund & Working capitalHistorical totals per ownerDownload
05Cost settlementPrevious year's cost settlement per owner with payment statusDownload
06New year provisionsProvisions, reserve fund, working capital for the new yearDownload
07Bank transactions — Current accountIBAN, start/end balance, transactionsDownload
08Bank transactions — Savings accountSavings account transactionsDownload

TIP

Fill in all templates carefully. The data must match exactly with your previous system's reports.

How to start ​

  1. Go to Financial, select the building, and open the Dashboard. In the Quick access section, click the opening data setup link.
  2. If the building has no opening data yet, you see an empty page with a start button. Click it: every unit gets a row for its owner, and you then fill in the amounts.
  3. Started before? The wizard opens with what you saved as a draft.

Migration wizard

Migration process overview ​

The migration wizard has 4 steps:

StepNameDescription
1IntroductionOverview of the migration process
2Fiscal yearSet the first fiscal year for the building
3Enter dataReview imported historical data across 7 tabs
4BalanceVerify the final balance (debit = credit) and confirm

Step 1 — Introduction ​

The introduction screen explains the 4-step migration process. Click Next step to proceed.

Step 2 — Fiscal year ​

Set the first fiscal year for the building:

FieldDescription
YearThe fiscal year (e.g. 2026)
Start dateStart date of the fiscal year
End dateEnd date of the fiscal year

Step 3 — Enter data ​

This is the main step. You enter the balances across 7 tabs, item by item from the previous syndic's balance sheet: owner settlements under Owners, the funds per owner under Working fund, Fixed provision and Reserve capital, open invoices and credit notes under Suppliers, bank balances under Bank accounts, and everything else (prepaid costs still to be settled, rounding, interest, a difference with the previous syndic) under Other bookings.

Owners ​

Shows the outstanding balances per co-owner from the previous system's final settlement. Use the filters to view all, positive (owner owes money), or negative (owner has credit) balances.

Verify each owner's settlement amount matches the final settlement from your previous system.

Working fund ​

Shows the working fund contributions per owner — unused provisions carried over to the new fiscal year. Each row shows the owner, unit, debit/credit amounts, and remaining balance.

Fixed provision ​

Shows the permanent buffer per owner — a one-time contribution that forms the working capital. Click on an owner to see the detail panel with historical data, advance requests, incoming payments, and the accounting entries that will be created.

Reserve capital ​

Shows the reserve fund contributions per owner across all historical years. Similar structure to the working fund tab.

Suppliers ​

Here you enter the open amounts per supplier: invoices still to be paid, and credit notes or credits.

  1. Click Add supplier, search for the supplier, pick it and click Add.
  2. In the supplier's row, fill in Debit or Credit as in the previous system: Credit for what the building still owes the supplier, Debit for a credit with the supplier.
  3. Invoices and credit notes opens under the row. For each document choose Invoice or Credit note and fill in Invoice number, Amount incl. VAT and Invoice date. Click Another document to add more.
  4. At the bottom, Difference must show €0,00: the documents then add up to the Legacy balance.

TIP

The Invoice date must fall within the first fiscal year, otherwise you cannot confirm. SNDQ fills in today's date by default: change it when today is outside the first fiscal year.

Bank accounts ​

Shows the bank accounts with their closing balance from the previous period. Verify the IBAN and closing balance match your bank statement.

Other bookings ​

Shows additional balance items not covered by the other tabs — such as rounding differences, prepaid costs, or carried-over funds. You can filter by assets or liabilities, and add additional bookings via Add booking.

Step 4 — Balance ​

The final verification step shows a balance overview with assets on one side and liabilities on the other. Each line shows the account code, name, amount, and source.

The system verifies that total debit equals total credit. When the balance matches, you see a green indicator. If it does not match, review the data in Step 3 and correct any discrepancies.

Click Confirm to finalize the migration. This creates all financial bookings in SNDQ.

What gets created after confirmation ​

Data typeWhat is created
Owner advance requestsOpening advance requests per owner for each fund type
Owner paymentsIncoming payments matching the paid amounts
Cost settlementPrevious year's cost settlement with per-owner allocation
Supplier invoicesOpening balance invoices per supplier with cost category
Bank account balancesOpening balances on bank accounts
Accounting journalsOpening balance journal entries
Fund balancesReserve fund and working capital per owner
ProvisionsNew year provision requests per owner

Good to know ​

  • Save as draft — click Save as draft at any point to save your progress and continue later.
  • Review carefully — once confirmed, the migration bookings are created and difficult to reverse.
  • Balance must match — the total debit must equal total credit before you can confirm.
  • Multiple bank accounts — create a separate file per bank account (current + savings).
  • Accounting codes — SNDQ automatically assigns accounting codes. Verify these are correct.

Need help?

Contact our team at info@sndq.be or use the Get Help option in the SNDQ application.