Quick Answer
Bank reconciliation in Business Central is the process of making sure the bank balance in your books matches the balance on your actual bank statement. You do it inside the Bank Acc. Reconciliation window – bring in your statement, match the transactions (automatically or manually), fix any differences like bank charges, then post. This guide walks you through it in simple words with a real example.
Bank reconciliation is one of the most important financial tasks for any company. It helps you ensure that the bank balance in your books matches the balance in your actual bank statement. In Microsoft Dynamics 365 Business Central (BC), this process is simple, smart, and designed to save you time.
In this blog, we will walk you through the Bank Reconciliation process in Business Central with clear steps and examples.
Imagine this: you open your bank statement and see ₹1,00,000. But when you check your company books, it shows ₹98,500. Where did that ₹1,500 go? Bank fees? A missed entry? A typo? That is exactly why bank reconciliation matters - it is your way of making sure your books and your bank are on the same page.
Let’s walk through it together, step by step.
Table of Contents
What is Bank Reconciliation (in simple words)?
Think of reconciliation like balancing your wallet with your bank passbook.
- Your company records = What you think you spent or earned.
- Bank statement = What the bank says actually happened.
Reconciliation simply compares these two and finds the differences – like a bank fee, a missed entry, or a cheque that hasn’t cleared yet. Once you sort them out, both balances agree and your books are accurate.
💡 In one line: Bank reconciliation answers the question – “Does the money my books say I have actually match what the bank says I have?” If yes, you are done. If not, you find out why and fix it.
The Bank Acc. Reconciliation Window in Business Central
In Business Central, the reconciliation happens inside the Bank Acc. Reconciliation window.
- The header section is where you enter information such as the bank account and the statement details.
- The lines section is where the actual reconciliation takes place. Here, you match posted transactions from BC with the transactions on the bank statement.
If there are differences, you can enter or adjust transactions (like bank charges or missing entries) right here. Once everything agrees, you finish by posting the reconciliation. This makes your bank balance in Business Central match the real balance reported by the bank.
Before You Start : Quick Checklist
Make sure these basics are ready before your first reconciliation:
- ✅ Bank Account Card is set up : with the correct currency code matching your real bank account
- ✅ Number Series for statements : so each reconciliation gets its own unique statement number
- ✅ Statement file format ready : if you import files, confirm your format (CAMT.053, MT940, or CSV). For CSV, map the columns once using the “Set up a bank statement file format” assisted setup
- ✅ Your latest bank statement : showing the closing balance and all transactions for the period
📌 Good to know: Business Central reads CAMT files natively. For CSV files, you map each column (date, amount, description, reference) just once — after that, every future import for that bank account uses the same format automatically.
Step by Step: How to Reconcile a Bank Account in Business Central
Step 1 : Open the Reconciliation Page
- Press Alt + Q and search for “Bank Account Reconciliations”
- Click New to start a fresh reconciliation
- In the Bank Account No. field, pick the bank account you want to work on
- Enter the Statement Date (the closing date on your bank statement)
- Enter the Statement Ending Balance (the final balance from your bank statement)
Once you enter the statement date, the right side of the window (Bank Account Ledger Entries) fills automatically with your bank entries up to that date. The left side (Bank Statement Lines) stays empty until you fill it in the next step.
💡 Tip: The statement date acts as a filter. Business Central only shows entries on or before this date, and you can only post the reconciliation with entries up to this date. So set it correctly.
Step 2 : Bring In the Bank Statement
You have three easy ways to fill the left side with your bank transactions. Pick the one that fits you:
| Method | When to Use It |
|---|---|
| Import Bank Statement | When you have a file from your bank (CAMT, MT940, or CSV). The most common method. |
| Bank Feed | When your bank is linked online (via Envestnet Yodlee or a connector). Transactions pull in automatically. Yodlee is US-focused; UK/EU often use connectors like Yavrio. |
| Suggest Lines | When you have no file. BC fills the left side with its own entries that have outstanding payments, so it proposes what the statement should contain. |
💡 Don’t worry: Bank statement lines do not affect your General Ledger when they are created, imported, suggested, or deleted. Nothing posts until the final step — so you can safely experiment.
Step 3 : Match the Transactions
Now you connect each bank statement line (left) with the matching Business Central entry (right). Two ways:
Match Automatically (the time saver): Click Match Automatically. Business Central compares entries by date, amount, and description, then links the ones that match. Matched lines turn green. Anything it can’t match stays black for you to review.
⚙️ Pro tip: Use the Transaction Date Tolerance (Days) field to allow a small gap (say ±2 days) between your BC posting date and the bank’s cleared date. This handles weekends and holidays so more lines match automatically.
Match Manually (for the rest): Select an unmatched line on the left, then select one or more matching entries on the right (hold Ctrl to pick several), and click Match Manually. This is handy when one bank deposit covers several payments. You can combine both methods — manual matches you make first are kept when you run Match Automatically afterwards.
Step 4 : Fix Any Differences
Found a mismatch? Don’t panic. Most differences are bank charges, interest, or timing issues. The next section shows exactly how to handle each type.
Step 5 : Test, Post, and Relax
- Go to the Home tab and select Post → Test Report, then Preview
- The Test Report highlights any warnings or differences before you post – always run it
- Make sure the Total Difference field shows zero (or within your approved tolerance)
- If everything agrees, hit Post. Done!
Your books now reflect the exact bank balance, with a clean audit trail.
⚠️ Common error: If you see “Statement Ending Balance is not equal to Total Balance,” your numbers don’t add up yet. Check that the Statement Ending Balance matches your bank and that the Total Difference field is zero before posting.
Fixing Differences : Bank Charges, Timing, and More
After matching, a few lines may still be unmatched. Here is how to deal with the most common ones:
| Difference Type | How to Fix It |
|---|---|
| Bank fees or interest | Use Text-to-Account Mapping so recurring fees post to the right account automatically, or add a simple General Journal entry |
| Payment not yet posted in BC | Post it through the Payment Reconciliation Journal first, then come back and re-match the line |
| Timing difference (uncleared cheque) | A payment recorded in BC but not yet cleared at the bank — leave it as an outstanding item with a clear note; it clears next period |
| Small penny differences | Use Match Manually and post the tiny difference to a payment tolerance account (only if your company policy allows) |
| Duplicate statement line | Mark it as Rejected and confirm the bank exported the transaction only once |
| Currency rounding | Confirm the currency and exchange rate on the bank account, and post rounding to a dedicated Exchange Gain/Loss account |
Quick Example
Let’s make this real with a simple example.
📄 Your bank statement says:
| Opening Balance | ₹50,000 |
| Deposits | + ₹20,000 |
| Bank Charges | – ₹500 |
| Closing Balance | ₹69,500 |
In Business Central:
- The ₹20,000 deposit matches automatically with your posted entry.
- The ₹500 bank charge isn’t in your books yet, so you add it as a bank charge.
- The final balance now matches ₹69,500 → fully reconciled! ✅
Copilot AI Bank Reconciliation (Newer Versions)
The latest versions of Business Central include Copilot, an AI feature that makes reconciliation even faster. It runs after the automatic match and looks at the transactions that auto-match couldn’t handle, then suggests more matches based on dates, amounts, and descriptions.
Copilot is especially helpful in two situations:
- One-to-many matches : When a single bank deposit covers several invoices you recorded separately, Copilot matches the one statement line to the multiple entries for you.
- Unmatched fees and charges : For a line with no matching entry (like “Fuel Stop 24”), Copilot compares the
- description with your G/L account names and suggests the most likely account to post to.
How to Use Copilot
- Open a new or existing reconciliation on the Bank Acc. Reconciliation page
- Make sure your bank account and statement are loaded
- Click Reconcile with Copilot (or Generate)
- Copilot runs the auto-match first, then proposes extra matches
- Review the suggestions – select Keep it to accept, or Discard it to reject
Latest Business Central versions support Copilot (AI) supported Bank Reconciliation as well
💡 Important: Copilot only suggests – it never posts anything without your approval. You always choose whether each recommended match works before it is saved. This feature is currently in preview and works best in supported languages.
Pro Tips & Common Mistakes
Pro Tips to Make Life Easier
- ✅ Do it every month – don’t wait till year-end. Think of reconciliation like brushing your teeth: do it regularly and you avoid big problems later.
- ✅ Use imported bank statements whenever possible – it is much faster than typing lines.
- ✅ Double-check unmatched entries before posting.
- ✅ Always document adjustments for audits – keep the Test Report as your evidence.
- ✅ Split duties – one person prepares, another reviews and posts. It improves quality and keeps auditors happy.
Common Mistakes People Make
- ❌ Ignoring tiny adjustments (a ₹100 bank fee still matters).
- ❌ Reconciling only once a year (big headache later).
- ❌ Skipping manual review just because “auto-match did it.”
- ❌ Forgetting to post after matching.
- ❌ Skipping the Test Report before final posting.
- ❌ Uploading the same statement twice (creates confusing double entries).
✅ Quick Reconciliation Checklist
- Bank account and currency set up correctly
- New reconciliation with correct statement date and ending balance
- Statement lines imported, fed, or suggested
- Transactions matched (automatically and manually)
- Differences handled (fees, timing, duplicates)
- Test Report previewed with zero difference
- Reconciliation posted and archived for audit
FAQs : Bank Reconciliation in Business Central
Yes, but you will need to cancel and redo the reconciliation carefully.
No, each bank account needs to be reconciled separately.
You can always enter transactions manually.
Yes, adjustments like bank charges or interest are posted directly to the GL.
The Bank Account Reconciliation is your month-end proof that your cash book equals the bank statement. The Payment Reconciliation Journal is used during the month to apply incoming and outgoing payments to customer and vendor entries as you process them. Many teams use the journal during the month and the reconciliation at month-end.
It depends on your transaction volume. For most businesses, reconciling weekly keeps things tidy, with a full reconciliation at month-end. High-volume businesses may reconcile daily. The more often you reconcile, the easier month-end becomes.
It compares your bank statement lines with your bank ledger entries using date, amount, and description, then links the ones that match. Matched lines turn green; anything it cannot match stays black for you to review manually.
Copilot is an AI feature that runs after the automatic match. It inspects transactions that auto-match couldn’t handle and suggests more matches, including one-to-many matches, and it can suggest a G/L account for unmatched fees. You always review and approve its suggestions – it never posts on its own.
The most common reasons are bank fees not yet recorded, payments that haven’t cleared (timing differences), duplicate entries, or a missed transaction. Bank reconciliation is exactly the tool that finds and explains these differences so you can fix them.
Key Takeaway
Bank reconciliation in Business Central does not have to be a boring chore. With the Bank Acc. Reconciliation window, you:
- Match transactions easily
- Spot errors quickly
- Post adjustments instantly
Do it regularly, and you’ll always have peace of mind knowing your books and bank balance are perfectly aligned.
Pro tip: Think of reconciliation like brushing your teeth – do it regularly, and you will avoid big problems later. 🪥
Stay tuned to NavisionPlanet for more simple, step-by-step functional guides on Business Central.
📖 Related guides on Navision Planet:
→ Business Central Chart of Accounts Setup
→ General Ledger Setup in Business Central
→ Dimensions in Business Central – Simple Guide
→ Business Central Keyboard Shortcuts
