Skip to content

Reconcile client funds

Updated:

Reconciliation statement as of a date, matching to the bank, attributing and closing quarters.

Open Client funds in Fiatto
In this article

Under Client funds → Reconciliation (/dashboard/derdengelden/aansluiting) bank, ledger and matters sit side by side as of a date — a snapshot taken every night once a client funds account with a known balance exists. This is the statement you show the regulator.

Steps

  1. Check the Reconciliation statement: the balance of the client funds account(s), the ledger and the difference, obligations to clients and the Client funds position (bank minus matter obligations — should never be negative). Payouts the bank has not yet debited appear separately as In transit; the bank balance is based on the latest imported statement.
  2. Under To be attributed, assign bank lines without a matter using Attribute to matter. Fiatto makes a Suggestion based on the matter number in the description, a counter-account used before or an open line of the settlement statement; suggestions by matter number can be assigned in one go.
  3. Under Match to the bank line, match an executed payout or recorded receipt to the later bank line (Match) so no second entry is created; a payout from a SEPA file is recognised by its EndToEndId. Unmatch requires a reason.
  4. After a quarter ends, close the period under Closed periods (Close period): the position and the balance per matter are then fixed with a hash and no entry dated in that period can be posted any more. This cannot be undone.
  5. Export via Export: Reconciliation (CSV), Reconciliation (PDF), Statement (PDF) or Balance list (CSV). Under Statement per quarter you download the statement and balance list of a closed quarter.

Tips

  • Bank and ledger do not tie out? Usually a posting is still pending — walk the bank lines of the client funds account.
  • Unattributed money makes the position artificially positive — attribute it right away. A bank line from a closed period is posted today, with the bank date in the description.
  • Matters below zero were paid with money from other matters: that is a client funds shortfall.
  • Under Liability account in the ledger an administrator chooses the Liability account (a liability account in the chart). Each matter's balance then appears next to the balance on that account; a posting on the liability without a matter is always a difference. With Assigning posts to the ledger immediately, a bank line you assign or match against a payout is posted straight away against the liability account, with the matter as project; reversing or unmatching undoes that posting. You post foreign-currency lines yourself under Bank.
  • A bank line that belongs to no matter, such as bank charges, interest or a top-up by the firm, is marked with Office item. Under Office items you see the net office balance; if it is below zero, a signal reports that the firm still has to top up.
  • Under Counter accounts next to the client account an administrator chooses how Fiatto treats a posting with a different counter account: Warn (default), Refuse or Off, and which suspense accounts are allowed.
Was this article helpful?
View all articles in this topic

Find another answer

A task, feature or short question is enough.