Skip to content
Documentation
English
Open the app

Bank reconciliation

Have NovaFisko propose the invoice paid by each bank transaction, then book the payments and letter the items.

Reconciliation links each bank transaction to the invoice it pays. NovaFisko looks for the match, tells you how certain it is, then records the payment in the financial journal and letters the invoice. Transactions without an invoice (fees, salaries, VAT) are allocated to an account of your choice.

Running the reconciliation

  1. Open the Bank tab.
  2. Click Match.
  3. NovaFisko examines all the "To process" transactions linked to a journal and shows the number of proposals found.

The reconciliation can be run again as often as necessary: once new invoices have been booked, other transactions find their match.

How a proposal is found

NovaFisko compares the transaction with the open items: the unlettered customer (400000) and supplier (440000) lines of validated invoices and credit notes. Money in is compared with receivables, money out with payables. Four criteria are tried in order.

Order Criterion Confidence Label shown
1 The structured communication of the transaction is that of the invoice. Sure Structured communication
2 The shop has linked the transaction to a document already booked. Sure Novadesko justification
3 The amount is exactly that of the item and the third party is recognised by its IBAN or its name. Sure Amount + third party
4 The amount is exact and only one open item carries that amount. Probable Amount only

If no invoice matches, the bank rules of the company file are tried: the first active rule that matches proposes an account, with the confidence "Sure".

An invoice is proposed only once: two transactions of the same amount are not matched with the same invoice. Without a match, the Reconciliation column shows "No proposal".

Note

The Belgian structured communication (+++123/4567/89012+++) is checked by its modulo 97 and compared without its separators. Enter it on your sales invoices: it is the most reliable criterion.

Booking the matched transactions

All at once

  1. Click Book matched transactions.
  2. The confirmation window shows the number of transactions matched with certainty.
  3. Tick Include probable proposals if you also want to process the "Amount only" matches.
  4. Confirm. The summary shows the number of transactions booked and those left pending, with the reason.

One transaction at a time

  1. On the line of the transaction, click Book.
  2. For a "Probable" proposal, confirm the question "Probable match …: book the payment of …?".
  3. The message "Payment booked: …" gives the reference of the entry.

The entry generated

The payment is recorded in the financial journal of the account, at the value date of the transaction. Example for the receipt of 1 210,00 € for a sales invoice:

Account Debit Credit
550000 Bank 1 210,00
400000 Customers (the customer) 1 210,00

The label takes over the reference of the invoice. When the amount of the payment covers the item exactly, the invoice and the payment receive the same lettering code (AAA, AAB, AAC...). The transaction moves to "Booked" with the reference of its entry.

Allocating a transaction without an invoice

For a transaction without a proposal:

  1. Click Book on the line: the Allocate the transaction window opens.
  2. Choose the Account: bank fees (619000), VAT payable (451000), remuneration (455000), refund...
  3. Optionally enter a Third party and a Label.
  4. Confirm.
Account Debit Credit
619000 Bank fees 12,50
550000 Bank 12,50
Tip

If you allocate the same type of transaction by hand every month, create a bank rule: the account will be proposed automatically at the next reconciliation.

Special cases

Partial payment. If the amount of the transaction does not match the item exactly, it is not proposed. Allocate it by hand to account 400000 or 440000 and enter the third party: the item stays open for the balance, without lettering.

Grouped payment. A transfer that pays several invoices is allocated in the same way, to the third party's account. Then letter the invoices and the payment from the third-party record.

Invoice lettered in the meantime. Booking is refused and the transaction stays pending. Run Match again.

"Account not linked" transaction. Fill in the IBAN of the financial journal in Journals: without a journal, the transaction can be neither matched nor booked.

Warning

A booked payment cannot be deleted. To correct it, reverse its entry from Entries: the transaction becomes "To process" again and the lettering of the invoice is removed.

See also