BankStatementImport — data reference
All 23 fields BSuit stores for BankStatementImport (Finance & Accounting), with the record types they refer to.
On this page
#About BankStatementImport
BankStatementImport is a record type in the Finance & Accounting area of BSuit. This page lists everything BSuit stores for each bankstatementimport — 23 fields. It is maintained on the “Bank Statement Import & Auto-Match” page.
| Screen | Module |
|---|---|
| Bank Statement Import & Auto-Match | Finance & Accounting |
#Fields
Every field stored for a bankstatementimport. “Stored as” is the technical field name, useful when talking to support or building reports. 2 fields are references to other record types.
| Field | Stored as | Type | Required | Max length | Refers to |
|---|---|---|---|---|---|
| Bank Id | BankId | Text | No | — | Bank |
| File Name | FileName | Text | No | — | — |
| Format | Format | Text | No | — | — |
| Statement Start Date | StatementStartDate | Date | No | — | — |
| Statement End Date | StatementEndDate | Date | No | — | — |
| Opening Balance | OpeningBalance | Number (decimal) | No | — | — |
| Closing Balance | ClosingBalance | Number (decimal) | No | — | — |
| Currency | Currency | Text | No | — | — |
| Status | Status | Text | No | — | — |
| Total Lines | TotalLines | Whole number | No | — | — |
| Matched Count | MatchedCount | Whole number | No | — | — |
| Suggested Count | SuggestedCount | Whole number | No | — | — |
| Excluded Count | ExcludedCount | Whole number | No | — | — |
| Duplicate Count | DuplicateCount | Whole number | No | — | — |
| Imported By | ImportedBy | Text | No | — | — |
| Reconciliation Id | ReconciliationId | Text | No | — | — |
| Company Id | CompanyId | Text | No | — | Company |
| Bank | Bank | Text | No | — | — |
| Lines | Lines | Text | No | — | — |
| Id | Id | Text | No | — | — |
| Created At | CreatedAt | Date and time | No | — | — |
| Updated At | UpdatedAt | Date and time | No | — | — |
| Is Deleted | IsDeleted | Yes / No | No | — | — |
#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.
| Role | Create | Edit | View |
|---|---|---|---|
| Finance Manager | Yes | Yes | Yes |
#About this guide
Generated from BSuit’s data model on the date shown under “Seen on a running system”. Field names, types and lengths come from the model itself. References are inferred from field names (a field called “Ledger Id” is treated as pointing to Ledger); the model does not declare relationships, so an inferred link can occasionally be wrong or missing.
About this guide
- Status
- Partially reviewed
- Application
- BSuit ERP
- Audience
- Administrators, analysts and support staff
- 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
- Not yet
- Help version
- 2026.0.0-preview
- Guide ID
erp:data/finance.bankstatementimport