A bank reconciliation worksheet: a hand-kept header for one bank account and statement, holding the closing balance per bank, the closing balance per book and the difference, with its reconciling items on the Line tab. Every figure on it is typed by the user; nothing fills the balances from the statement or the ledger, and no shipped screen recalculates the difference or completes the worksheet. The same entity also carries the server actions behind the Bank Reconciliation workspace (Banking > Bank Reconciliation): the bank-account overview, the per-line match suggestions and the match confirmation. The workspace runs those actions without creating a worksheet record, so a user needs the action grants on this entity to use the workspace, but the worksheet and the workspace never read or update each other.
Fields
| Field | Label | Type | Required | What it does |
|---|
BankAccountId | Bank Account | Lookup → BankAccount | | The bank account the worksheet is for. The picker is not filtered by company. It is on the New form only, not on the record page, and no check compares it with the chosen statement's account. |
BankStatementId | Bank Statement | Lookup → BankStatement | | The bank statement the worksheet covers. The picker lists every statement and is not narrowed to the chosen bank account. It is on the New form only, not on the record page. |
ClosingBalancePerBank | Closing Balance Per Bank | Currency | | The bank's closing balance, typed by you from the statement. It is not copied from the statement record. |
ClosingBalancePerBook | Closing Balance Per Book | Currency | | The ledger balance of the bank's GL account at the statement date, typed by you. Nothing recalculates it from posted journals, so update it after posting late entries. |
CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created On | DateAndTime | Yes | |
Difference | Difference | Currency | | Bank minus book, typed by you on the shipped screens. A summary routine in the platform can stamp it as closing balance per bank minus closing balance per book, but no shipped button runs it. |
Id | Id | Guid | Yes | |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
Name | Name | Text | Yes | The worksheet's name, typed by you. There is no automatic numbering, so use a name that identifies the account and statement period. |
OpeningBalance | Opening Balance | Currency | | An opening balance recorded for reference. Nothing reads it. |
OwnerId | Owner | Lookup → UserAccount | Yes | The user who owns the worksheet record. |
PartnerAccountId | Partner Account | Lookup → Account | | The company the worksheet belongs to. The picker lists active partner (company) accounts only. It is on the New form but not on the record page, so it cannot be seen or changed after saving on the shipped screens. |
RecordTypeId | Record Type | Guid, hidden | | |
StatementDate | Statement Date | DateAndTime | | The date the worksheet is drawn up at. It is not on the New form and is not copied from the statement; set it from the record page's Details tab with the field pencil. |
Status | Status | Text | | Free text on the Details tab, intended to read Open or Completed. Nothing on the shipped screens changes it; type Completed yourself, with the field pencil, when the worksheet is signed off. Completing a worksheet locks nothing and posts nothing. |
UIProps | UI Props | Text | | |
UpdatedDateTime | Updated On | DateAndTime | Yes | |
Actions
| Action | Label | Type | What it does |
|---|
Clone | Clone | ServerAction (Clone) | Create a copy of this record |
ConfirmMatches | Confirm Matches | ServerAction (ConfirmMatches) | Record-less. Records each statement line and journal line pair it is given as a reconciliation match, with the statement line's full amount, and sets the statement line to Matched. It applies no matching rule and no amount or date check. |
GetBankAccounts | Get Bank Accounts | ServerAction (GetBankAccounts) | Record-less. Returns the bank accounts the Bank Reconciliation workspace shows: active bank accounts linked to a GL account of type Bank, for the chosen company and branch or, when neither is chosen, the user's default company and branch. Each comes with a book balance (posted and reversed journal lines on its GL account), a bank balance that adds up the closing balance of every statement on the account, and a count of its statement lines by reconciliation status. |
GetMatchSuggestions | Get Match Suggestions | ServerAction (GetMatchSuggestions) | Record-less. For one Unmatched statement line, returns the posted ledger lines on the bank's GL account that pass every active matching rule, best first. If a rule with auto-match on leaves a clear winner, that match is confirmed during the call and the statement line becomes Matched. Fails when the bank account has no linked GL account. |
GetUnmatchedAgeing | Get Unmatched Ageing | ServerAction (GetUnmatchedAgeing) | Has no server implementation and no screen calls it, so it does nothing. |
New | New | New | New |
Lookup filters
| Filter | Lookup field | Notes |
|---|
| Partner Account Filter | PartnerAccountId | |
