An older, standalone bank-feed record: one deposit or withdrawal held directly against a bank GL account, with its date, payee, narration and reference. It predates bank statements and statement lines, which are what bank reconciliation works from today. Banking records are in no shipped app or menu, nothing in the platform creates them, and reconciliation never reads or updates them. The record page offers only Edit and Delete. Its match, reconcile, ignore and post actions do nothing. Two things still read these rows: the Bank Movements analytics dataset (folder Treasury, Tax and Assets), and a book-balance summary action that no shipped screen calls. Record bank activity as bank statement lines instead.
Fields
| Field | Label | Type | Required | What it does |
|---|
AccountId | Account | Lookup → Account | | An optional customer or other account linked to the movement, for reference. Nothing in the platform reads it. |
CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created Date | DateAndTime | Yes | |
Date | Date | Date | Yes | The date of the bank movement. Required. The Bank Movements analytics dataset reports it as the transaction date. |
Deposit | Deposit | Currency | | Money into the account, as a positive amount. The signed amount is Deposit minus Withdrawal. The book-balance summary adds up Deposit minus Withdrawal over every banking record on a GL account. |
ExternalId | External | Text | | The identifier the row carried in from a source file or feed. It is stored for traceability only. Nothing de-duplicates or matches on it. |
GLAccountId | GL Account | Lookup → GLAccount | | The bank GL account the movement belongs to. The book-balance summary groups records by this account, so a record with no GL account is left out of it. |
Id | Id | Guid | Yes | |
IsPosted | Is Posted | Boolean | Yes | Defaults to No. Nothing posts a banking record to the ledger, so the flag shows only what a user or an import set. |
IsRecognized | Is Recognized | Boolean | Yes | Defaults to No. Meant to mark the movement as tied to a source document, but the platform never sets it. |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
Name | Name | Text | Yes | The record's identifier. New records are numbered from the Banking Transaction series (prefix BT). |
Narration | Narration | Text | | The bank's description of the movement. For reference only. Nothing matches on it. |
OwnerId | Owner | Lookup → UserAccount | Yes | |
PartnerAccountId | Partner Account | Lookup → Account | | The company the movement belongs to. The Bank Movements analytics dataset carries it, but the book-balance summary selects GL accounts by their own company, not by this field. |
Payee | Payee | Text | | Free text naming who was paid or who paid. For reference only. |
ReceivedVia | Received Via | PickList | | Meant to record the channel the movement arrived through. No values are seeded for this picklist, so it offers nothing to choose until an administrator adds values. Nothing reads it. |
Reference | Reference | Text | | The bank's reference for the movement. For reference only. Bank reconciliation matches statement-line references, not this field. |
Status | Status | PickList | | A label for the movement's review state: Pending, Categorized, Ignored, Unmatched, Match, Review, Reconciled or Exception. The platform never sets it. It holds only what a user typed or an import loaded. The book-balance summary counts records per value, and a blank status counts as Unknown. Values: Pending, Categorized, Ignored, Unmatched, Match, Review, Reconciled, Exception. |
SubStatus | Sub-Status | PickList | | A second status label. No values are seeded and nothing reads or writes it. |
SupplierAccountId | Supplier Account | Lookup → Account | | An optional supplier linked to the movement. The Bank Movements analytics dataset reports the supplier's name. Nothing else reads it. |
UpdatedDateTime | Modified Date | DateAndTime | Yes | |
Withdrawl | Withdrawal | Currency | | Money out of the account, as a positive amount. It is subtracted from Deposit to give the signed amount. |
Actions
| Action | Label | Type | What it does |
|---|
BulkDelete | Delete | Delete | Delete |
Clone | Clone | ServerAction (Clone) | Create a copy of this record |
Delete | Delete | Delete | Delete |
DeleteInList | Delete | Delete | Delete |
Edit | Edit | Edit | Edit |
EditHeader | Edit | Edit | Edit |
EditInLine | Edit | EditInline | Edit In line |
EditInList | Edit | EditInline | Edit |
GetBankReconciliation | Get Bank Reconciliation | ServerAction (GetBankReconciliation) | Returns a book-balance summary for the signed-in user's default company: every GL account of type Bank, its balance as total deposits minus total withdrawals over its banking records, and a count of those records by Status. Only the account type Bank is accepted. The action fails when the user has no resource record, or when that resource has no default company and branch. No shipped screen calls it, and the record page does not show it. |
GetMatchSuggestions | Get Matching Suggestions | ServerAction (GetMatchSuggestions) | Checks that a GL account was given and that the amount is not zero, then returns nothing. The matching logic behind it is switched off. Suggestions in bank reconciliation come from the bank reconciliation record and work on statement lines. |
IgnoreTransaction | Ignore Transaction | ServerAction (IgnoreTransaction) | Refuses a record whose Status is already Ignored. Otherwise it does nothing, and Status is not changed. The Ignore button in bank reconciliation works on statement lines, not on this record. |
New | New | New | New |
PostTransaction | Post Transaction | ServerAction (PostTransaction) | Has no server handler, so running it changes nothing. Banking records are never posted to the ledger. |
ReconcileTransaction | Reconcile Transaction | ServerAction (ReconcileTransaction) | Checks that the record is not already Reconciled, that its amount is not zero and that at least one linked document was passed, then does nothing. Status and Is Recognized are not changed. |
