Zentriq Agent is live on Microsoft AppSourceInstall it free →Microsoft AppSourceInstall it free →

How to Reconcile a Bank Account in Business Central

Open Bank Acc. Reconciliations, create one for your bank account, import the bank statement, then match statement lines against ledger entries and post once the difference is zero. Business Central's Copilot can suggest matches natively. Or ask the Zentriq Agent for your cash position and unmatched entries in plain language.

Step-by-step guide

1

Open Bank Acc. Reconciliations

In Business Central, use the search bar (Alt+Q) and type 'Bank Acc. Reconciliations'. Click 'New' and select your bank account in the Bank Account No. field. Enter the Statement Date and the Statement Ending Balance from your bank statement.

2

Import the bank statement

Click 'Import Bank Statement' and select the file from your bank (for example camt.053 or a CSV format). The import format is defined on the bank account card in the Bank Statement Import Format field. Statement lines appear on the left, open bank account ledger entries on the right.

3

Match the lines

Click 'Match Automatically' to let BC pair statement lines with ledger entries by amount, date, and text. Business Central also includes a native Copilot assist ('Reconcile with Copilot') that proposes additional matches for you to review. For the rest, select a line on each side and match them manually.

4

Handle entries missing in BC

Bank charges or interest that only exist on the statement need to be posted first. Use 'Transfer to General Journal' to create the missing entries, post the journal, then return to the reconciliation and match them.

5

Verify and post

The Total Balance must equal the Statement Ending Balance, so the difference shows zero. Click 'Post'. Matched ledger entries are closed and the reconciliation is saved as a Bank Account Statement.

The faster way with Zentriq

Instead of opening the reconciliation page to check where you stand, ask the Zentriq Agent 'What is my cash position?' or 'Which bank ledger entries are still open this month?': it reads the data and answers in plain language, and it never posts anything without your approval.

Related Zentriq products: Zentriq Agent

Try Zentriq free →

More guides

Related resources

GlossaryBank ReconciliationUse CaseAI Assistant for Business CentralHow-toHow to Create a Purchase Order in Business CentralHow-toHow to Process a Purchase Invoice in Business Central