Email this post as a PDFTips and tricks · 21 October 2026 · 1 min read

Tip 30: Bank reconciliation with automatic and Copilot matching

Reconciling the bank is import, match, post. Most of the matching is automatic now.

Bank Account Reconciliations → new → Import Bank Statement (from a bank feed if set up, or a file). Match Automatically matches on amount, date and text. Then Reconcile with Copilot (version 24 onwards, online) proposes matches for what is left using the descriptions, and suggests G/L accounts for bank charges and interest that have no document. Review, accept, post the reconciliation; the statement balance and the book balance agree, or the difference is listed.

Set up the bank feed (Bank Account → Link to Online Bank Account) and statements import themselves daily. Reconcile weekly, not monthly, and month-end's bank step is ten minutes.

Email this post as a PDF
A branded PDF of this post, sent to your inbox to keep, print or share. Copy in colleagues if you like.
We only use these addresses to send this PDF. Nobody is added to a mailing list. Mike at Business Boxed receives a copy. See our privacy notice.
Email this post
Talk to us
Want this done in your Business Central?
Book a 30 minute callGet the monthly newsletter

Related posts