Skip to content
NAVdryx docs

Reconcile a bank account

Import a bank or card statement, resolve AI-assisted matches, and produce an audit-grade reconciliation workpaper.

Steps

  1. Import the statement. Bank statements accept CSV, OFX/QFX, BAI2, or MT940; card statements accept the CSV exports from Amex, Brex, and Ramp. PDF statements are not yet supported.
  2. Review proposed matches. Matching runs against your own records — unposted draft journal entries and settled outgoing payments — using amount, date proximity, counterparty, and reference fields.
  3. Confirm proposed matches. One click each; every confirmation records who (or which AI step) proposed it, who confirmed it, and when.
  4. Work the rest by hand. Lines with no proposal can be matched manually or excluded; nothing is auto-confirmed.
  5. Review outstanding items. Statement lines with no match stay open as outstanding items and are listed on the workpaper. Expected clearing dates and an aging view for them are not yet available.
  6. Handle card timing differences. Automatic accruals for a card charge that clears the statement in a later period are not yet available, so record the accrual yourself in the accounting module.
  7. Generate the workpaper. The statement balance, the GL balance you record for the period, and the resulting difference, followed by the matches, the outstanding items, and any exceptions, per reconciliation. A reconciliation is completed by someone other than the person who prepared it.

A non-functional-currency account reconciles in its native currency, translated to the fund’s functional currency at the period’s close-of-period rate.