Bank Statement Import
How to use Bank Statement Import in Banking & Payments: access, working steps, fields, related records and troubleshooting.
Purpose and access
Record receipts, payments and transfers with the correct party, accounts, currency and allocation. Reconcile bank activity with ERP entries. A payment record is not a bank transfer instruction unless a separately configured integration performs that action.
This page is a record page in Finance & Accounting → Banking & Payments. Use the link above to open the configured destination; permissions are checked by the destination service.
Before you start
Prepare the required information: Company, Bank Account.
Confirm the company, party, dates, units and source references that apply. Select existing links carefully and check for an existing record before creating a duplicate.
Working steps
- Open Bank Statement Import from Finance & Accounting → Banking & Payments, or use ERP Search.
- Filter the list and open the relevant record. To add a record, use Add/New when your role provides that action.
- Complete the editable fields described below. Required fields and validation conditions must be satisfied; read-only values are set by the system or their source records.
- Save the record and address validation messages. Reload and verify the saved values and relationships.
- Use any additional workflow actions only when the record and your role provide them. Saving this record does not automatically complete a related transaction or external action.
Field reference
These fields come from the installed ERP definition. Hidden fields and password inputs are omitted. Additional conditions, custom scripts and workflow rules can make a field required or read-only in a particular context.
| Field | Type / behavior | How to use it |
|---|---|---|
Companycompany | Link Required | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Company |
Bank Accountbank_account | Link Required | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Bank Account |
Bankbank | Link Optional · Read-only | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Bank |
Import MT940 Fromatimport_mt940_fromat | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
Custom delimiterscustom_delimiters | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
Delimiter optionsdelimiter_options | Data Optional | If your CSV uses a different delimiter, add that character here, ensuring no spaces or additional characters are included. |
Import from Google Sheetsgoogle_sheets_url | Data Optional | Must be a publicly accessible Google Sheets URL and adding Bank Account column is necessary for importing via Google Sheets |
Import Fileimport_file | Attach Optional | Upload the permitted evidence file. Confirm the record and privacy settings before sharing. |
Show Failed Logsshow_failed_logs | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
Troubleshooting
- Not permitted: verify the account, role and source-document permission. Do not share an administrator login.
- Missing record or address: inspect the relevant Link or Dynamic Link fields; a matching title alone does not establish a relationship.
- Cannot save or change status: review required fields, read-only values, document status and the configured approval transition.
- Unexpected report or portal result: review company/date filters, source-document submission and the approved party or Employee link.