Reconcile bank accounts

Path: Business functionality > Finance > Reconcile bank accounts · tier official · system finance · narrative reviewed (checked by Opus)

Overview

This section covers keeping cash records accurate. Reconciliation matches bank statement transactions with bank account ledger entries, using automatic and manual matching, so missing payments and errors show up. Statements can come from imports or bank feeds, and payments can be applied to open invoices through the Payment Reconciliation Journal.

The pages split by task. “Manage bank accounts” gives the general picture, “Reconcile bank accounts” explains the matching process, and “Reconcile bank accounts and apply payments” covers setup of bank feeds, statement import and payment matching rules. A preview page describes Copilot assistance for matching and suggesting G/L accounts. Two further pages cover creating bank deposits and transferring funds between bank accounts.

Start with “Manage bank accounts” or “Reconcile bank accounts” for the basics, then move to the payment application page if you need to apply payments to invoices automatically.

Key points

• Reconciliation matches bank statement lines to bank account ledger entries using automatic and manual matching, and shows outstanding transactions.
• Statements can be imported or fed through bank feeds; the Payment Reconciliation Journal applies payments to open invoices automatically.
• Payment matching rules control how payments are matched to invoices.
• Copilot assistance (preview, 2025 release waves 1 and 2) improves transaction matching and suggests G/L accounts for unmatched transactions, supplementing auto-match.
• Copilot has a ‘Post if fully applied’ option, and match proposals can be reviewed and saved.
• Bank deposits (2022 release wave 1) register cash deposits as one document posting to bank, customer and vendor ledgers, as a lump sum or by individual line.
• Bank deposits handle multiple deposit sources and dimensions.
• Transfers between bank accounts use the General Journals page, with same or different currency codes and exchange rate adjustments.

Learn pages

• Create bank deposits: You can make deposits to maintain a transaction record that contains information that can be applied to outstanding invoices and credit memos.
• Manage bank accounts: You must regularly reconcile bank ledger entries with the related bank transactions in your bank accounts.
• Reconcile bank accounts: Learn how to reconcile transactions in Business Central with transactions in statements from your bank.
• Reconcile bank accounts and apply payments: Outlines tasks to reconcile your bank, receivables, and payables accounts, post cash receipts or expenses, and apply payments automatically.
• Reconcile bank accounts with Copilot (preview): Learn how to use Copilot to reconcile bank accounts in Business Central.
• Transfer bank funds: You can transfer amounts from one bank account to another, including different currencies, by posting the transaction in the general journal.

Videos, posts and code changes

Linked by a Haiku matcher with a grounding quote from the item’s summary (link/topics.ts); machine-generated.

• #10630 Extend OnBeforeCheckBankAcc to skip specific bank reversal checks (code change): “skip specific bank reversal checks when reversing bank account ledger entries”
• #11055 Allow bank rec. duplicated transactions surfaced in UI (code change): “Bank reconciliation now exposes UI controls to allow users to process duplicate transactions”
• #11056 29.x: Allow bank rec. duplicated transactions surfaced in UI (code change): “Bank Acc. Reconciliation and Payment Reconciliation Journal pages now expose an existing option to allow duplicated transactions”

Business Central pages and reports

The pages, reports and queries this hub’s Learn pages name (ms.search.form, API reference), joined to the code by exact object id (data/index/docs-objects.json); a page shows the table it runs on.

• Page 39 “General Journal” · captioned “General Journals” · on Table 81 “Gen. Journal Line”
• Page 165 “Bank Acc. Ledg. Entr. Preview” · on Table 271 “Bank Account Ledger Entry”
• Page 377 “Bank Account Balance” · on Table 270 “Bank Account”
• Page 378 “Bank Account Balance Lines” · captioned “Lines” · on Table 929 “Bank Account Balance Buffer”
• Page 1284 “Outstanding Bank Transactions” · on Table 1284 “Outstanding Bank Transaction”
• Page 1290 “Payment Reconciliation Journal” · on Table 274 “Bank Acc. Reconciliation Line”
• Page 1291 “Pmt. Recon. Journal Overview” · captioned “Payment Reconciliation Journal Overview” · on Table 274 “Bank Acc. Reconciliation Line”
• Page 1293 “Pmt. Rec. Journals Overview” · captioned “Unprocessed Payments” · on Table 273 “Bank Acc. Reconciliation”
• Page 1294 “Pmt. Reconciliation Journals” · captioned “Payment Reconciliation Journals” · on Table 273 “Bank Acc. Reconciliation”
• Page 1690 “Bank Deposit” · on Table 1690 “Bank Deposit Header”

Learn also names 8 objects with no object page: page/10140, page/10141, page/10143, page/10144, page/10146, page/10147, page/10148, page/36646.

Source: Microsoft Learn (CC BY 4.0). Descriptions are Learn’s own.