One bank statement for one bank account: its statement date, the bank's opening balance and a closing balance calculated from its lines. It owns the bank statement lines that bank reconciliation pairs with posted journal lines on the bank account's GL account. Statements are created from the Bank Statements list in the Banking app, from a bank account's Bank Statements tab, or by the Import statement dialog in the Bank Reconciliation workspace. Saving is refused when another statement exists for the same bank account and date, or when an entered opening balance differs from the closing balance of that account's latest earlier statement. Status defaults to Imported and nothing in the system changes it, so it does not show reconciliation progress.
Fields
| Field | Label | Type | Required | What it does |
|---|
BankAccountId | Bank Account | Lookup → BankAccount | Yes | The bank account the statement reports. Only active bank accounts are offered. Reconciliation reads the GL account linked to this bank account, so a bank account with no GL account gets no match suggestions. A bank account that has statements cannot be deleted, only deactivated. |
ClosingBalance | Closing Balance | Calculated (calculated) | | Calculated: the opening balance (blank counts as zero) plus deposits minus withdrawals over all the statement's lines. It is recalculated whenever the statement or one of its lines is saved, so a figure typed on the form or in the workspace Import statement dialog is replaced by the calculated one. Compare it with the closing balance printed on the bank's statement to check the lines are complete. |
CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created On | DateAndTime | Yes | |
Id | Id | Guid | Yes | |
Label | Label | Text | | An optional description of the statement. The workspace Import statement dialog calls it Description. Matching does not use it. |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
Name | Name | Text, unique | Yes | The statement's identifier, typed by the user. It is required and unique across all bank statements. The workspace Import statement dialog suggests one in the form BS-MON-YYYY-001 from the statement date. |
OpeningBalance | Opening Balance | Currency | | The bank's opening balance. It is optional on the record form but required in the workspace Import statement dialog, which pre-fills it from the previous statement's closing balance. When it is filled in, it must equal the closing balance of the account's latest earlier statement or the save is refused; the check runs on every save, so changing an earlier statement's lines can block saving a later one. |
OwnerId | Owner | Lookup → UserAccount | Yes | The user who owns the statement record. |
PartnerAccountId | Partner Account | Lookup → Account | | The company the statement belongs to. It is not on the statement's forms; the workspace Import statement dialog copies it from the bank account. |
RecordTypeId | Record Type | Guid, hidden | | |
StatementDate | Statement Date | Date | Yes | The as-at date of the statement. It must not be later than today, only one statement per bank account and date is allowed, and the opening-balance check compares with the latest statement for the account dated strictly before it. |
Status | Status | PickList | | Defaults to Imported when the statement is created and is never changed by the system: reconciling lines does not move it. The record form shows it as a free-text box, so a value someone types is kept. The workspace's Reconciled up to figure reads statements whose Status is Reconciled, so it stays at Not yet unless someone types that value. Values: Imported. |
UIProps | UI Props | Text | | |
UpdatedDateTime | Updated On | DateAndTime | Yes | |
Actions
| Action | Label | Type | What it does |
|---|
AutoReconcile | Auto Reconcile | ServerAction (AutoReconcile) | Not shown on any shipped screen, and nothing on the server carries it out. Automatic matching happens in the Bank Reconciliation workspace when a statement line is opened, driven by matching rules with auto-match turned on. |
BulkDelete | Delete | Delete | Delete the selected records. |
Clone | Clone | ServerAction (Clone) | Not on the statement's record page in the shipped layout. |
Delete | Delete | Delete | Delete |
DeleteInList | Delete | Delete | Delete in a list page |
Edit | Edit | Edit | Edit |
EditListRow | Edit | Edit | EditListRow |
New | New | New | New |
SuggestMatches | Suggest Matches | ServerAction (SuggestMatches) | Not shown on any shipped screen, and the statement has no server action of this name. Match suggestions come from the Reconcile panel of the Bank Reconciliation workspace, one statement line at a time. |
Validations
| Validation | Applies to | Error message | Notes |
|---|
| XM_BankStatementFutureDateValidation | StatementDate, Error | Future-date is not allowed. | Future-dated bank statement validation. |
Lookup filters
| Filter | Lookup field | Notes |
|---|
| Bank Account Filter | BankAccountId | |
