Dynamics GP to Business Central - Bank Rec Tables

 

Bank Reconciliation is the process of matching your company's internal bank records (cash ledger) with the bank statement provided by your financial institution. It helps ensure accuracy in cash reporting, detect discrepancies like missing entries or fraud, and maintain up-to-date balances in your ERP system.

Both Dynamics GP and Dynamics 365 Business Central support bank reconciliation, but they handle it differently in terms of process and data structure.

BANK RECONCILIATION TABLES

GP Table	Description	BC Table	Business Central Equivalent
CM00100	Checkbook Master	270	Bank Account
CM10100	Deposit Work (unposted)	1690 81	Bank Deposit Header Gen. Journal Line
CM20100	Bank Rec Journal	271 17	Bank Account Ledger Entry (Posted) General Ledger Entry
CM20200	Transactions	271	Bank Account Ledger Entry
CM20201	Transaction Totals	271	Aggregated Bank Account Ledger Entries (via reports)
CM20300	Receipts	271	Bank Account Ledger Entry (Deposit = TRUE or via Type)
CM20400	Distributions	17	G/L Entry
CM20500	Reconciliation Headers	273 274	Bank Acc. Reconciliation Header Bank Acc. Reconciliation Line
CM20501	Reconcile Adjustments	273	Bank Acc. Reconciliation Line (Adjustment Type)
CM20502	Outstanding Transactions History	271	Bank Account Ledger Entry (click on Total Outstanding Checks)
CM20600	Transfers	274	General Journal Line (Bank Transfer Template)
CM30200	Transaction History	271	Bank Account Ledger Entry (historical view)
CM30300	Receipt History	271	Bank Account Ledger Entry (Deposit Receipt filter)