---
title: "Table 273 Bank Acc. Reconciliation"
author: "Jonas Paprotka"
url: https://jonas-paprotka.de/ref/table/273-bank-acc-reconciliation/
type: table
id: 273
name: "Bank Acc. Reconciliation"
app: "Base Application"
namespace: Microsoft.Bank.Reconciliation
versions: "17-28"
build: 28.5.54151.54365
source: "https://jonas-paprotka.de/ref/table/273-bank-acc-reconciliation/source/29/"
checked: 2026-09-20
subject: "Microsoft Dynamics 365 Business Central"
license: "Content © 2026 Jonas Paprotka. Quote freely with attribution and a link."
---

# Table 273 Bank Acc. Reconciliation

Jonas Paprotka, https://jonas-paprotka.de/ref/table/273-bank-acc-reconciliation/

| | |
| --- | --- |
| App | Base Application |
| Namespace | Microsoft.Bank.Reconciliation |
| Versions | 17-28 |
| Source file | Bank/Reconciliation/BankAccReconciliation.Table.al |

## Fields

| Id | Name | Type | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- |
| 1 | Bank Account No. | Code[20] | 17-28 | - | - |
| 2 | Statement No. | Code[20] | 17-28 | - | - |
| 3 | Statement Ending Balance | Decimal | 17-28 | - | - |
| 4 | Statement Date | Date | 17-28 | - | - |
| 5 | Balance Last Statement | Decimal | 17-28 | - | - |
| 6 | Bank Statement | Blob | 17-28 | - | - |
| 7 | Total Balance on Bank Account | Decimal | 17-28 | - | - |
| 8 | Total Applied Amount | Decimal | 17-28 | - | - |
| 9 | Total Transaction Amount | Decimal | 17-28 | - | - |
| 10 | Total Unposted Applied Amount | Decimal | 17-28 | - | - |
| 11 | Total Difference | Decimal | 17-28 | - | - |
| 12 | Total Paid Amount | Decimal | 20-28 | - | - |
| 13 | Total Received Amount | Decimal | 20-28 | - | - |
| 20 | Statement Type | Enum Bank Acc. Rec. Stmt. Type | 17-28 | - | - |
| 21 | Shortcut Dimension 1 Code | Code[20] | 17-28 | - | - |
| 22 | Shortcut Dimension 2 Code | Code[20] | 17-28 | - | - |
| 23 | Post Payments Only | Boolean | 17-28 | - | - |
| 24 | Import Posted Transactions | Option | 17-28 | - | - |
| 25 | Total Outstd Bank Transactions | Decimal | 17-28 | - | - |
| 26 | Total Outstd Payments | Decimal | 17-28 | - | - |
| 27 | Total Applied Amount Payments | Decimal | 17-25 | Removed 24.0 | Type is not used to determine if the bank rec. line is associated to a CLE, instead find explicitly CLEs with their corresponding BLE No. . See BankAccReconTest codeunit TotalOutstandingPayments for an example |
| 28 | Bank Account Balance (LCY) | Decimal | 17-28 | - | - |
| 29 | Total Positive Adjustments | Decimal | 17-28 | - | - |
| 30 | Total Negative Adjustments | Decimal | 17-28 | - | - |
| 31 | Total Positive Difference | Decimal | 17-25 | Removed 24.0 | Difference is now tracked manually instead. Type field was redundant and error prone. |
| 32 | Total Negative Difference | Decimal | 17-25 | Removed 24.0 | Difference is now tracked manually instead. Type field was redundant and error prone. |
| 33 | Copy VAT Setup to Jnl. Line | Boolean | 17-28 | - | - |
| 50 | Bank Account Name | Text[100] | 21-28 | - | - |
| 51 | Allow Duplicated Transactions | Boolean | 21-28 | - | - |
| 480 | Dimension Set ID | Integer | 17-28 | - | - |

## Keys

| Name | Fields | Versions |
| --- | --- | --- |
| Key1, clustered | Statement Type, Bank Account No., Statement No. | 17-28 |

## Procedures

| Name | Parameters | Returns | Access | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- | --- |
| CreateDim | (Integer, Code[20]) | - | public | 17-22 | Pending 20.0 | Replaced by CreateDim(DefaultDimSource: List of [Dictionary of [Integer, Code[20]]]) |
| MatchSingle | (Integer) | - | public | 17-28 | - | - |
| ImportBankStatement | () | - | public | 17-28 | - | - |
| ValidateShortcutDimCode | (Integer, var Code[20]) | - | public | 17-28 | - | - |
| ShowDocDim | () | - | public | 17-28 | - | - |
| OpenNewWorksheet | () | - | public | 17-28 | - | - |
| ImportAndProcessToNewStatement | () | - | public | 17-28 | - | - |
| ImportStatement | (var Record Bank Acc. Reconciliation, Record Data Exch.) | Boolean | public | 17-28 | - | - |
| ProcessStatement | (var Record Bank Acc. Reconciliation) | - | public | 17-28 | - | - |
| CreateNewBankPaymentAppBatch | (Code[20], var Record Bank Acc. Reconciliation) | - | public | 17-28 | - | - |
| SelectBankAccountToUse | (var Record Bank Account, Boolean) | Boolean | public | 17-28 | - | - |
| OpenWorksheet | (Record Bank Acc. Reconciliation) | - | public | 17-28 | - | - |
| OpenList | (Record Bank Acc. Reconciliation) | - | public | 17-28 | - | - |
| SetFiltersOnBankAccReconLineTable | (Record Bank Acc. Reconciliation, var Record Bank Acc. Reconciliation Line) | - | public | 17-28 | - | - |
| DrillDownOnBalanceOnBankAccount | () | - | public | 17-28 | - | - |
| MatchCandidateFilterDate | () | Date | public | 18-28 | - | - |
| CreateDim | (List) | - | public | 20-28 | - | - |
| CreateDimFromDefaultDim | () | - | public | 20-28 | - | - |
| GetPaymentRecJournalTelemetryFeatureName | () | Text | internal | 21-28 | - | - |
| GetBankReconciliationTelemetryFeatureName | () | Text | internal | 21-28 | - | - |
| CreateBankAccountReconcillation | () | - | public | 22-28 | - | - |
| OnInsertValidations | (Enum Bank Acc. Rec. Stmt. Type, Code[20], Code[20]) | - | internal | 25-28 | - | - |

## Events

| Kind | Name | Parameters | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- |
| Integration event | OnAfterCreateDimTableIDs | (var Record Bank Acc. Reconciliation, var Integer, var Integer, var Code[20]) | 17-22 | Pending 20.0 | Temporary event for compatibility |
| Integration event | OnAfterValidateShortcutDimCode | (var Record Bank Acc. Reconciliation, var Record Bank Acc. Reconciliation, Integer, var Code[20]) | 17-28 | - | - |
| Integration event | OnBeforeImportAndProcessToNewStatement | (var Record Bank Acc. Reconciliation, var Record Data Exch., var Record Data Exch. Def, var Boolean) | 17-28 | - | - |
| Integration event | OnBeforeOpenWorksheetFromProcessStatement | (var Record Bank Acc. Reconciliation, var Boolean) | 17-28 | - | - |
| Integration event | OnBeforeValidateShortcutDimCode | (var Record Bank Acc. Reconciliation, var Record Bank Acc. Reconciliation, Integer, var Code[20]) | 17-28 | - | - |
| Integration event | OnBeforeMatchSingle | (var Record Bank Acc. Reconciliation, Integer, var Boolean) | 19-28 | - | - |
| Integration event | OnAfterInitDefaultDimensionSources | (var Record Bank Acc. Reconciliation, var List) | 20-28 | - | - |
| Integration event | OnCreateDimOnAfterSetDimensionSetID | (var Record Bank Acc. Reconciliation, Integer, List) | 20-28 | - | - |
| Integration event | OnUpdateAllLineDimOnAfterUpdateGlobalDimFromDimSetID | (var Record Bank Acc. Reconciliation Line) | 20-28 | - | - |

## Source

Symbols: Microsoft.BaseApplication.symbols.437dbf0e-84ff-417a-965d-ed2bb9650972, https://dynamicssmb2.pkgs.visualstudio.com/DynamicsBCPublicFeeds/_packaging/MSSymbols/nuget/v3/index.json, highest build per major on 2026-09-20.
AL source 29: https://github.com/microsoft/BCApps, MIT, releases/29.x at a66254c3b8b5bb1cea290dc8f9d097aec4381153.

Jonas Paprotka, 2026-09-20.