The bank statement wizard imports CSV rows as Payments. It requires the same import permission as the general wizard.

Prepare and map

  1. Export the statement as CSV and check the CSV preparation guide.
  2. Open Data In and Out → Upload a file, then Bank statement. Select the CSV and continue to Map columns; this wizard already uses Payments, so there is no entity-selection step.
  3. Map Amount, Currency, Status, Direction and Date Paid. Use appropriate static values where the statement omits a required field, and check every amount’s sign and meaning.
  4. Map Contact Email or a known Fundraising Activity only when the source supplies a reliable match. A statement description alone is not a verified donor identity.
  5. In Review & submit, confirm the date format for the statement, check mapped/skipped columns, and optionally save a named mapping.
  6. Click Start Import, then inspect the job status and resulting payment records.

Unlike the general CSV wizard, the current bank wizard has four stages: Select file, Map columns, Review & submit, Job status. It does not include the general wizard’s pre-flight stage.

Bank options are currently a prototype

The options panel offers a bank selector, Discard negative transaction amounts, and Attempt to match to fundraising or grant records. These options are displayed in the review, but are not forwarded to the import job. Selecting a bank does not apply a bank-specific parser, negative rows are not removed by the toggle, and the matching toggle does not perform automatic reconciliation.

Prepare the CSV and mappings yourself: remove rows you do not intend to import, use the correct payment direction, and establish any known links explicitly. The job runs the ordinary Payment import using your mappings and date format.

The bank list includes Lloyds Bank, NatWest, Barclays, HSBC, Halifax, Nationwide, Santander, Monzo, Starling Bank, Metro Bank and Other / Generic CSV; the prototype limitation applies to all of them.

For repeat statements, use a stable source transaction identifier where available and check for records already imported. The bank selector and options do not provide duplicate detection. See Saved mappings and Job statuses and errors.