Cybooks Help Centre

Import a bank statement

Upload a supported statement, map its columns when needed, and review duplicate rows before import.

Upload a supported bank statement and review its pending preview before Cybooks starts an import.

Before you start

You need permission to view bank accounts and manage imports. Select the bank account that the statement belongs to.

Upload a statement

  1. Open the selected account and choose Bank feed.
  2. Open Manage account and select Import bank statement.
  3. In Upload bank statement, choose the account and statement file.
  4. Continue to Preview & validate.
Bank feed view with the Import bank statement action highlighted in the Manage account menu

The uploaded rows stay in a pending preview. Cybooks does not start the import until the final action.

Map statement columns

If automatic mapping is incomplete, the wizard shows Confirm column mapping.

  1. Map the required Date and Amount columns.
  2. Review any optional column mappings.
  3. Continue to produce the pending preview.
Confirm column mapping step with Date and Amount fields and the source sample highlighted

Confirming the required date and amount columns advances the statement to preview without starting an import.

Review duplicate rows

In Preview & validate, open Duplicates to review rows that match existing transactions.

Duplicate rows stay skipped unless you explicitly choose the per-row option to import one anyway. No import job starts while you are reviewing the preview.

Preview and validate step with the Duplicates filter and matching duplicate row highlighted

Was this helpful?

Contact support