---
id: object/table/275
type: object
title: Table 275 "Bank Account Statement"
summary: Table 275 "Bank Account Statement" in Base Application (Microsoft.Bank.Statement). 11 fields. Present since at least BC23, still in BC30, changed in BC24, BC28.
tier: official
language: en
tags:
  - table
  - base application
versions:
  introduced: null
  last_changed: "28"
  deprecated: null
review:
  state: derived
  by: null
  at: null
  flags: []
generated:
  at: "2026-10-11T00:31:51.816Z"
  pipeline: 0.2.0
  prompts: {}
  input_hash: 4f4080c946413f5c95e730826a7e3f541bbd5c88a6ae0471e3aebefa6bfa72d8
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Bank/Statement/BankAccountStatement.Table.al
    title: src/Layers/W1/BaseApp/Bank/Statement/BankAccountStatement.Table.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn:
    - https://learn.microsoft.com/dynamics365/business-central/LocalFunctionality/UnitedStates/how-to-reconcile-bank-accounts
    - https://learn.microsoft.com/dynamics365/business-central/receivables-how-reconcile-payments-auto-application
  objects: []
  features: []
  topics:
    - topic/business-central/business-functionality/finance/manage-payables/apply-payments-automatically-and-reconci
    - topic/business-central/business-functionality/finance/manage-receivables/apply-payments-automatically-and-reconci
    - topic/business-central/business-functionality/local-functionality/united-states/banking-and-payments
  localizations: []
  videos: []
  posts: []
  guidelines: []
object_type: table
object_id: 275
name: Bank Account Statement
namespace: Microsoft.Bank.Statement
app: Base Application
extends: null
first_version: "23"
last_version: "30"
present_in:
  - "23"
  - "24"
  - "25"
  - "26"
  - "27"
  - "28"
  - "29"
  - "30"
changed_in:
  - "24"
  - "28"
source_major: "29"
obsolete: null
countries: []
ms_search_form_ids: []
counts:
  fields: 11
  procedures: 1
  events: 0
  subscribers: 0
relations:
  out: 3
  referenced_by: 2
  pages: 3
  extended_by: 0
  event_subscribers: 0
  calls: 1
  called_by: 0
  implements: 0
---

# Table 275 "Bank Account Statement"

> Table 275 "Bank Account Statement" in Base Application (Microsoft.Bank.Statement). 11 fields. Present since at least BC23, still in BC30, changed in BC24, BC28.

Base Application · Microsoft.Bank.Statement · BC23-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Bank/Statement/BankAccountStatement.Table.al) · facts from BC29

Learn documents this table through its pages: [Page 389 "Bank Account Statement List"](../page/389.md) (2 Learn pages).

## Properties

| Property | Value |
|---|---|
| Caption | Bank Account Statement |
| DataClassification | CustomerContent |

## Fields

Explanation: the field's ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Bank Account No. | Code[20] | Specifies the number of the bank account that has been reconciled with this Bank Account Statement. | TableRelation [Table 270 "Bank Account"](../table/270.md) (Bank Account); NotBlank |
| 2 | Statement No. | Code[20] | Specifies the number of the bank's statement that has been reconciled with the bank account. | NotBlank |
| 3 | Statement Ending Balance | Decimal | Specifies the ending balance on the bank's statement that has been reconciled with the bank account. |  |
| 4 | Statement Date | Date | Specifies the date on the bank's statement that has been reconciled with the bank account. |  |
| 5 | Balance Last Statement | Decimal | Specifies the ending balance on the bank account statement from the last posted bank account reconciliation. | not editable |
| 50 | Bank Account Name | Text[100] | Specifies the name of the bank account that has been reconciled. | FlowField: lookup("Bank Account".Name where("No." = field("Bank Account No."))) |
| 100 | G/L Balance at Posting Date | Decimal | — | not editable |
| 101 | Outstd. Payments at Posting | Decimal | Outstanding Payments at Posting Date <small>caption</small> | not editable |
| 102 | Outstd. Transact. at Posting | Decimal | Outstading Bank Transactions at Posting Date <small>caption</small> | not editable |
| 103 | Total Pos. Diff. at Posting | Decimal | Total Positive Difference at Posting Date <small>caption</small> | not editable |
| 104 | Total Neg. Diff. at Posting | Decimal | Total Negative Difference at Posting Date <small>caption</small> | not editable |

## Keys

- Key1: Bank Account No., Statement No. (clustered)

## Procedures

1 local procedures, no public ones.

## Triggers

OnDelete, OnRename

## Relations

- lookup page [Page 389 "Bank Account Statement List"](../page/389.md)
- Bank Account Name: CalcFormula [Table 270 "Bank Account"](../table/270.md)
- Bank Account No.: TableRelation [Table 270 "Bank Account"](../table/270.md)

## Referenced by

2 fields in 2 objects relate to this table (TableRelation or CalcFormula).

- [Table 1693 "Bank Acc. Comment Line"](../table/1693.md): No.
- [Table 276 "Bank Account Statement Line"](../table/276.md): Statement No.

## Pages and codeunits on this table

- [Page 1300 "Pmt. Rec. Undo Statement"](../page/1300.md) (source table)
- [Page 383 "Bank Account Statement"](../page/383.md) (source table)
- [Page 389 "Bank Account Statement List"](../page/389.md) (source table)
- [Codeunit 1340 "Undo Bank Statement (Yes/No)"](../codeunit/1340.md) (codeunit runs on it)
- [Codeunit 382 "BankAccStmtLines-Delete"](../codeunit/382.md) (codeunit runs on it)

## Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an `Object::"Name"` argument. Interface dispatch and calls through events are not counted, so the list is not complete.

- [Codeunit 382 "BankAccStmtLines-Delete"](../codeunit/382.md) (1 call: `OnDelete → (object)`)

## Across versions

- Present in: BC23-30
- Changed (declaration) in: BC24, BC28

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

## Ask your agent

Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: `bcatlas_resolve_node(object_type: "table", object_name: "Bank Account Statement")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.