One reconciling item on a bank reconciliation worksheet: a bank statement line, a ledger journal line, or a hand-typed item such as an outstanding cheque, a deposit in transit or a bank charge, with an amount and a matched flag. Lines are added by hand from the Line tab of a bank reconciliation record and are numbered automatically from the BRL series. Nothing in the platform creates, matches or updates them: the Bank Reconciliation workspace, its match suggestions and its confirmed matches work on bank statement lines and never read or write these rows. They are a manual worksheet that sits alongside the automated matching, not a record of it.
Fields
| Field | Label | Type | Required | What it does |
|---|
Amount | Amount | Currency | | The amount of the reconciling item, typed in by hand. It is not copied from, or checked against, the linked statement line or journal line, so enter it with the sign convention your team uses for the worksheet. |
BankReconciliationId | Bank Reconciliation | Lookup → BankReconciliation | | The reconciliation worksheet the line belongs to. It is filled in automatically when the line is added from the worksheet's Line tab. |
BankStatementLineId | Bank Statement Line | Lookup → BankStatementLine | | Optional link to the bank side of the item. The picker is not limited to the worksheet's statement or bank account, so check you pick a line from the right statement. The link is for reference only: it does not change the statement line's reconciliation status and is not read by matching. |
CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created On | DateAndTime | Yes | |
Id | Id | Guid | Yes | |
IsMatched | Is Matched | Boolean | | Tick when the item is agreed on both sides; leave it clear for an item that is still outstanding. Only the person editing the line sets it: confirming or auto-matching in the Bank Reconciliation workspace never ticks it. |
JournalLineId | Journal Line | Lookup → JournalLine | | Optional link to the ledger side of the item. The picker is not limited to the bank's GL account or to posted journals. The link is for reference only and is separate from the journal line recorded when a match is confirmed in the Bank Reconciliation workspace. |
LineNumber | Line Number | Number | | A display sequence number. It is on no seeded form or view and is not assigned automatically, so it stays empty unless an administrator adds it to the line layout. |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
Name | Name | Text | Yes | The line's reference. It is filled in automatically when the line is saved, from the BRL series followed by the date and a six-digit sequence, so it does not appear on the New form. |
Narration | Narration | Text | | Free-text explanation of the item, for example the cheque number and payee of an unpresented cheque. |
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 forms or in the Line tab. |
RecordTypeId | Record Type | Guid, hidden | | |
Type | Type | Text | | Free text describing the kind of item. The vocabulary the worksheet is designed around is Matched, OutstandingCheque, DepositInTransit, BankCharge and Other, but there is no picklist and no rule depends on it. It appears only on the line's own record page, not on the New form or in the Line tab. |
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 |
NewInline | New | NewInline | New |
