Reconcile client funds
Updated:
Reconciliation statement as of a date, matching to the bank, attributing and closing quarters.
Open Client funds in FiattoIn 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
- 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.
- 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.
- 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.
- 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.
- 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.