Help centre
Banking

Import a bank statement

Importing your bank statement brings the bank's own record of your transactions into Sales Scribe, ready to be reconciled against what you have recorded. Statements are evidence…

Import a bank statement

Importing your bank statement brings the bank's own record of your transactions into Sales Scribe, ready to be reconciled against what you have recorded. Statements are evidence only — importing never posts anything to your ledger or changes any balance.

Before you begin

  • Sign in and select your organisation. Anyone can view statements; importing or deleting needs the manage chart of accounts permission.
  • Download a CSV statement from your online banking. Files up to 1 MB / 5,000 rows are accepted.

Import the file

  1. Go to Banking → Bank Accounts and open the account's Statements page.
  2. Choose Import statement and upload your CSV.
  3. On the mapping step, tell Sales Scribe which column is which — every bank lays its file out differently:
    • the date column (common formats are recognised),
    • the description, and optionally a reference and running balance,
    • the amount — either a single signed column, or separate money in / money out columns. If your bank writes payments as positive numbers, use the negate option to flip the sign. A five-row preview shows how your choices read, and your mapping is remembered for the account's next import.
  4. Confirm. The summary shows how many lines were imported, how many were skipped as duplicates, and any rows that could not be read.

[Screenshot required: the column-mapping step with a five-row preview]

Duplicates are handled for you

Import the same file twice, or overlapping date ranges, and the already-imported lines are skipped automatically — you can download overlapping statements without fear of double-counting. Two genuinely identical transactions on the same day within one file (say, two identical coffees) are both kept.

Note: the duplicate check works within the lines each file contains. If your bank splits identical same-day transactions across two separate files, the second may be skipped as a duplicate — check the import summary if a line seems missing.

Manage imports

The Statements page lists each import batch. A batch can be deleted to re-import it — but not once any of its lines has been matched during reconciliation; unmatch those lines first.

Was this article helpful?

Help topics