One bank-side transaction from an imported statement: value date, description, reference, and a deposit or a withdrawal amount. The engine treats deposit minus withdrawal as the line's signed amount (deposit positive) and pairs it with a posted journal line on the bank's GL account whose debit minus credit carries the matching sign.
Fields
| Field | Label | Type | Required | What it does |
BankStatementId | Bank Statement | Lookup → BankStatement | | |
CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created On | DateAndTime | Yes | |
Deposit | Deposit | Currency | | Money into the account per the bank. The engine works with deposit minus withdrawal as the line's signed amount, so a deposit is positive and pairs with a ledger debit on the bank's GL account. |
Description | Description | Text | | |
Id | Id | Guid | Yes | |
Label | Label | Text | | |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
Name | GL Account Name | Text, unique | Yes | |
OwnerId | Owner | Lookup → UserAccount | Yes | |
PartnerAccountId | Partner Account | Lookup → Account | | |
ReconciliationStatus | Reconciliation Status | Text | | Unmatched, Matched or Ignored, defaulting to Unmatched. Only an Unmatched line is eligible for match suggestions, and confirming a match sets it to Matched; nothing sets Ignored automatically, and nothing resets it to Unmatched when the underlying reconciliation match is deleted. |
RecordTypeId | Record Type | Guid, hidden | | |
Reference | Reference | Text | | The bank's reference for the line, and the only text the matching criteria compare — the reference criterion tests it against the journal line's narration and the document-number criterion tests it against the journal's voucher name. Both use a case-insensitive substring test in either direction, so a short or generic reference can overlap unrelated ledger lines. |
TransactionDate | Transaction Date | Date | | The bank's value date for the line. The date criterion measures the whole-day gap between it and the journal's date, and a smaller gap also ranks a candidate higher among the survivors. |
UIProps | UI Props | Text | | |
UpdatedDateTime | Updated On | DateAndTime | Yes | |
Withdrawal | Withdrawal | Currency | | Money out of the account per the bank, giving a negative signed amount that pairs with a ledger credit on the bank's GL account. The direction criterion compares only the sign, not the magnitude. |
Actions
| Action | Label | Type | What it does |
Clone | Clone | ServerAction (Clone) | Create a copy of this record |
Delete | Delete | Delete | Delete |
DeleteRecord | Delete | Delete | Delete |
Edit | Edit | Edit | Edit |
EditInline | Edit | EditInline | Edit |
EditListRow | Edit | Edit | Edit |
Import | Import | UIAction | Opens the dedicated bank-statement-line import layout to load statement lines in bulk against a statement. Imported lines land with reconciliation status Unmatched and are not paired with anything — matching is a separate step run from the reconciliation entity afterwards. |
New | New | New | New |