Bank Statement Import & Auto-Match

Upload CSV / OFX / QFX / MT940 → auto-match to book entries → apply to a reconciliation

On this page
Screenshot of the Bank Statement Import & Auto-Match page
The Bank Statement Import & Auto-Match page in BSuit.

#About Bank Statement Import & Auto-Match

Upload CSV / OFX / QFX / MT940 → auto-match to book entries → apply to a reconciliation. This is a working page: a list or workspace where you find and act on records in BSuit ERP (Finance & Accounting). It is used by staff (internal users). What you can see and do depends on your role and permissions.

#How to open it

In BSuit ERP, open Finance & Accounting and choose “Bank Statement Import & Auto-Match”, or go directly to the address /finance-management/bank-statement-imports.

#What you can do here

These controls are present in the page’s implementation. Whether you see a given one also depends on your permissions and on the data shown.

  1. Bring records in from a file.
  2. Attach or upload files.
  3. Search within the page.
  4. Filter the data shown.
  5. Sort by a column.
  6. Page through long lists.
  7. Open dialogs or drawers for detail and confirmation.

#Who can do this

Super Admin and other superuser accounts can always see and do everything, regardless of this list. For everyone else, these are the standard roles that have been granted a permission here in this system’s current setup — an organisation can add, remove or customise roles and their permissions, so treat this as an example, not a guarantee.

Roles with a permission on finance.bankstatementimport, as seeded (2026-09-22)
RoleCreateEditView
Finance ManagerYesYesYes

#Data stored for each record

The form layout of this page could not be read from its source, so here is everything BSuit stores for a bankstatementimport (see also the BankStatementImport data reference). Which fields appear on screen depends on the page and your configuration.

Fields stored for BankStatementImport
FieldStored asTypeRequiredMax lengthRefers to
Bank IdBankIdTextNo—Bank
File NameFileNameTextNo——
FormatFormatTextNo——
Statement Start DateStatementStartDateDateNo——
Statement End DateStatementEndDateDateNo——
Opening BalanceOpeningBalanceNumber (decimal)No——
Closing BalanceClosingBalanceNumber (decimal)No——
CurrencyCurrencyTextNo——
StatusStatusTextNo——
Total LinesTotalLinesWhole numberNo——
Matched CountMatchedCountWhole numberNo——
Suggested CountSuggestedCountWhole numberNo——
Excluded CountExcludedCountWhole numberNo——
Duplicate CountDuplicateCountWhole numberNo——
Imported ByImportedByTextNo——
Reconciliation IdReconciliationIdTextNo——
Company IdCompanyIdTextNo—Company
BankBankTextNo——
LinesLinesTextNo——
IdIdTextNo——
Created AtCreatedAtDate and timeNo——
Updated AtUpdatedAtDate and timeNo——
Is DeletedIsDeletedYes / NoNo——

#Observed on a running system

On 2026-09-21 this page was opened in a browser as a test administrator. This is what was visible on screen under the heading “Bank Statement Import & Auto-Match”. Your own view can differ with your role, data and settings.

Buttons visible on the page
Button
CSV columns ▼
Upload

#If something is missing or fails

  1. No data: confirm the company or context selected in the top bar, and any filters or date range in use.
  2. An action is hidden or disabled: it usually needs a permission your role does not have. Ask an administrator to check your effective access.
  3. An error message appears: note the message, the page address and what you were doing, and contact support with those details (never include passwords).

#About this guide

This guide was generated from the page’s implementation. It has not yet been reviewed by a person against a running system, so treat it as a reference for what the page contains rather than a complete procedure.

About this guide

Status
Partially reviewed
Application
BSuit ERP
Audience
Staff (internal users)
Owner
BSuit documentation team
Reviewer
Not yet reviewed
Last verified
Never
Checked against
Generated from source revision a36c7a086 on 2026-10-02
Seen on a running system
2026-09-21
Help version
2026.0.0-preview
Guide ID
erp:/finance-management/bank-statement-imports
Need more help?If feedback above cannot be sent, email support and quote guide ID erp:/finance-management/bank-statement-imports.
Email support