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) |
Comments
Post a Comment