Bank Acc. Reconciliation #273

Other table in Microsoft Dynamics 365 Business Central. 32 fields, 2 records in Cronus demo.

Bank Acc. Reconciliation is the header table for bank reconciliation documents in Business Central. When you import a bank statement and match it against ledger entries, the reconciliation header lives here, with individual statement lines in the related line table.

COMMON USE CASES

Bank statement import and matching
Bank account reconciliation workflows
Statement balance tracking
Payment matching automation
Cash management and bank audit

Fields

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Bank Account No., Statement No., Statement Type.

All fields (32)

Bank Acc. Reconciliation — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Bank Account No. PK	Code	Normal	→ Bank Account #270
2	Statement No. PK	Code	Normal
3	Statement Ending Balance	Decimal	Normal
4	Statement Date	Date	Normal
5	Balance Last Statement	Decimal	Normal
6	Bank Statement	BLOB	Normal
7	Total Balance on Bank Account ⚡ FLOW	Decimal	FlowField
8	Total Applied Amount ⚡ FLOW	Decimal	FlowField
9	Total Transaction Amount ⚡ FLOW	Decimal	FlowField
10	Total Unposted Applied Amount ⚡ FLOW	Decimal	FlowField
11	Total Difference ⚡ FLOW	Decimal	FlowField
12	Total Paid Amount ⚡ FLOW	Decimal	FlowField
13	Total Received Amount ⚡ FLOW	Decimal	FlowField
20	Statement Type PK	Option	Normal
21	Shortcut Dimension 1 Code	Code	Normal	→ Dimension Value #349
22	Shortcut Dimension 2 Code	Code	Normal	→ Dimension Value #349
23	Post Payments Only	Boolean	Normal
24	Import Posted Transactions	Option	Normal
25	Total Outstd Bank Transactions ⚡ FLOW	Decimal	FlowField
26	Total Outstd Payments ⚡ FLOW	Decimal	FlowField
28	Bank Account Balance (LCY) ⚡ FLOW	Decimal	FlowField
29	Total Positive Adjustments ⚡ FLOW	Decimal	FlowField
30	Total Negative Adjustments ⚡ FLOW	Decimal	FlowField
33	Copy VAT Setup to Jnl. Line	Boolean	Normal
50	Bank Account Name ⚡ FLOW	Text	FlowField
51	Allow Duplicated Transactions	Boolean	Normal
480	Dimension Set ID	Integer	Normal	→ Dimension Set Entry #480
2000000000	System ID	GUID	Normal
2000000001	Created At	DateTime	Normal
2000000002	Created By	GUID	Normal
2000000003	Modified At	DateTime	Normal
2000000004	Modified By	GUID	Normal

Related tables (4)

Tables referenced by fields on the Bank Acc. Reconciliation table through TableRelation properties.

Bank Account

#270 · Other · via Bank Account No.

Dimension Value

#349 · Dimensions · via Shortcut Dimension 1 Code, Shortcut Dimension 2 Code

Dimension Set Entry

#480 · Dimensions · via Dimension Set ID