Field reference
Bank Statement Import Log
How to use Bank Statement Import Log 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 internal/admin record in Finance & Accounting → Banking & Payments. Use the link above to open the configured destination; permissions are checked by the destination service.
ERP links open in a new tab. Sign in with your own account; record visibility, actions and approval authority follow your assigned permissions. Screens can differ by company and configuration.
Before you start
Prepare the required information: Bank Account, File.
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 Log 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.
- Add the required child rows. Review each row’s identifiers, linked records and values, using the child-table field reference below.
- 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 |
|---|---|---|
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 |
Filefile | Attach Required | Upload the permitted evidence file. Confirm the record and privacy settings before sharing. |
Statusstatus | Select Optional · Read-only | Choose one of the configured list values. Status fields may be controlled by the record workflow.Available choices
|
Currencycurrency | 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: Currency |
Number of Transactionsnumber_of_transactions | Int Optional · Read-only | Enter a whole-number value. |
Start Datestart_date | Date Optional · Read-only | Choose the business date required for this field. Confirm its relationship to other dates on the record. |
End Dateend_date | Date Optional · Read-only | Choose the business date required for this field. Confirm its relationship to other dates on the record. |
Closing Balanceclosing_balance | Currency Optional | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Total Debitstotal_debits | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Total Creditstotal_credits | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Total Debit Transactionstotal_debit_transactions | Int Optional · Read-only | Enter a whole-number value. |
Total Credit Transactionstotal_credit_transactions | Int Optional · Read-only | Enter a whole-number value. |
Detected Date Formatdetected_date_format | Data Optional · Read-only | Enter the identifier or short text requested by the label. Preserve external reference numbers accurately. |
Detected Amount Formatdetected_amount_format | Select Optional · Read-only | Choose one of the configured list values. Status fields may be controlled by the record workflow.Available choices
|
Detected Header Indexdetected_header_index | Int Optional · Read-only | Enter a whole-number value. |
Detected Transaction Starting Indexdetected_transaction_starting_index | Int Optional · Read-only | Enter a whole-number value. |
Detected Transaction Ending Indexdetected_transaction_ending_index | Int Optional · Read-only | Enter a whole-number value. |
Column Mappingcolumn_mapping | Table Optional | Add the relevant child rows and review required columns, quantities and references before saving. Linked record: Bank Statement Import Log Column Map |
PDF Tablespdf_tables | JSON Optional · Read-only | Per-table extraction data for PDF statements (rows, bbox, page image, column mapping). Edited via the banking app. |
Child tables
Column Mapping — child-row fields
| Field | Type / behavior | How to use it |
|---|---|---|
Header Textheader_text | Data Required | Enter the identifier or short text requested by the label. Preserve external reference numbers accurately. |
Indexindex | Int Required | Enter a whole-number value. |
Maps Tomaps_to | Select Required | Choose one of the configured list values. Status fields may be controlled by the record workflow.Available choices
|
Variablevariable | Data Optional | Enter the identifier or short text requested by the label. Preserve external reference numbers accurately. |
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.