One transaction on an imported bank statement: the bank's value date, its narration and reference, and a deposit or a withdrawal amount. Lines are added one at a time or imported in bulk from the statement's Statement Lines tab, and they start with the reconciliation status Unmatched. Bank reconciliation treats deposit minus withdrawal as the line's signed amount and pairs it with a posted journal line on the bank account's GL account carrying the same sign. Confirming a pair records a reconciliation match and sets the line to Matched. Deleting the parent statement does not delete its lines.
Fields
| Field | Label | Type | Required | What it does |
|---|
BankStatementId | Bank Statement | Lookup → BankStatement | | The statement this line belongs to. It is filled in automatically when lines are added or imported from the statement's Statement Lines tab, and it links the line to the bank account whose GL account reconciliation reads. |
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 | | The bank's narration for the transaction, kept for reference. The matching criteria compare the Reference field, not this one. |
Id | Id | Guid | Yes | |
Label | Label | Text | | An optional display label. Matching does not use it. |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
Name | GL Account Name | Text, unique | Yes | The line's identifier. It is required and unique across all bank statement lines, not just within one statement, so imported lines should carry names built from the statement and a line number. |
OwnerId | Owner | Lookup → UserAccount | Yes | The user who owns the line record. |
PartnerAccountId | Partner Account | Lookup → Account | | The partner account the line is scoped to. It is not on the line's create or view form. |
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 |
