Family office reconciliation against the bank, every morning.

INVARIO reconciles every account against the custodian bank each morning, so the consolidated total the office works from matches the statements behind it.

Office towers reflected in a glass facade

What family office reconciliation means

Reconciliation compares the office's own records with the statements each custodian bank sends. A custodian is the bank that holds the family's securities and cash and reports them in a regular file.

Many offices do this by hand at month end, with statements beside a spreadsheet. INVARIO does it every morning, for every account and entity, and keeps a dated record.

The INVARIO Today screen: what every holding earned since the last close, with profit and loss, return and value

Bank files checked each morning,in three steps.

The same three steps run every morning for every connected bank and entity.

  1. The bank file arrives

    INVARIO collects each bank's file every morning and stores it as received.

  2. INVARIO values each holding

    Quantities, prices and FX rates produce INVARIO's own figure for every holding and account.

  3. The two figures are compared

    Each account is marked matched, outside tolerance or unchecked, and your team sees the result first thing.

The six checks INVARIO runs every day

Each morning INVARIO values each holding from quantities, prices and FX rates, and compares its figure with the bank's own file. The six checks run for every entity and connected bank.

Differences are measured in basis points, one hundredth of one percent.

  • Two independent valuations

    INVARIO values each holding; the bank values it from its own file; the two are compared.

  • A tolerance your office sets

    Your office sets the tolerance at set-up. Anything outside it is raised before a report is built.

  • Bank corrections shown in full

    When a bank corrects a figure, you see the old figure, the new one and the change.

  • Unchecked holdings shown as gaps

    A holding that cannot be checked is flagged as unchecked and shown as a gap, not counted as known.

  • Original bank files kept

    Bank files are stored as received, so any figure can be rebuilt from its source.

  • A nightly self-check

    Every night INVARIO rebuilds the books from the stored bank files and compares them with the live figures.

Who reads the reconciliation

The office team reads the result each morning and works through any difference outside tolerance before a report goes to the family. A difference outside tolerance, a break, closes itself when the next statement no longer shows it.

Auditors can be given read-only access to the dated record of every comparison and the bank files behind it.

Questions about family office reconciliation.

What offices ask about the daily check against the bank.

What happens when the figures don't match?

The difference is listed with the holdings behind it, so your team can see whether it comes from a missing transaction, a price or a correction.

Who sets the tolerance?

Your office does, during set-up. Differences inside the tolerance are not raised; anything outside it is.

Which banks are reconciled?

Every connected bank is reconciled daily. INVARIO connects to Binance, Interactive Brokers (Flex) and Trading 212. Tell us your banks and we will confirm each connection.

Does reconciliation replace our auditor?

No. It gives your auditor a dated record of every comparison and the bank files behind it. The audit itself stays with your auditor.

See a morning reconciliationon anonymised data.

We walk you through one morning's reconciliation, then show how your banks would connect.