Bank Account
Using Bank Accounts in Microsoft Dynamics 365 Business Central
Overview
Bank Accounts in Microsoft Dynamics 365 Business Central are used to manage company banking activities, including:
Receiving customer payments
Paying vendors
Recording bank transactions
Performing bank reconciliations
Managing multiple company bank accounts
At FAM Powder Coating, Bank Accounts are used to track daily financial activity and maintain accurate cash balances.
Accessing Bank Accounts
How to Open Bank Accounts
Open Microsoft Dynamics 365 Business Central
Use the search icon (magnifying glass)
Search for:
Bank Accounts
Select Bank Accounts from the results
Main Bank Account Information
Each bank account contains important company banking details.
Typical information includes:
| Field | Description |
|---|---|
| No. | Bank account number in Business Central |
| Name | Bank account name |
| Currency Code | Currency used by the account |
| Balance | Current account balance |
| Last Statement No. | Last imported or reconciled statement |
| Bank Branch No. | Bank branch information |
| Bank Account No. | Actual bank account number |
| IBAN | International bank number |
| SWIFT Code | International bank identifier |
Opening the Bank Account Card
To view or edit bank account details:
Open the Bank Accounts page
Select the desired account
Click the account name or choose:
Edit
The Bank Account Card contains:
General information
Posting setup
Transfer settings
Payment details
Reconciliation settings
Viewing Bank Ledger Entries
Bank Ledger Entries show all transactions posted to a bank account.
Steps
Select the bank account
Click:
Related → Bank Account → Ledger Entries
This page shows:
Posting Date
Document Number
Description
Amount
Remaining Balance
Recording Bank Transactions
Bank transactions are commonly recorded through:
| Method | Example |
|---|---|
| Cash Receipt Journals | Customer payments |
| Payment Journals | Vendor payments |
| General Journals | Manual adjustments |
| Bank Reconciliation | Matching statement transactions |
Using Payment Journals
Payment Journals are used to pay vendors or other expenses.
Steps
Search:
Payment Journals
Select the journal batch
Enter:
| Field | Example |
|---|---|
| Posting Date | Current date |
| Document Type | Payment |
| Account Type | Vendor |
| Account No. | Vendor number |
| Amount | Payment amount |
| Bal. Account Type | Bank Account |
| Bal. Account No. | Company bank account |
Review the journal
Click:
Post
Using Cash Receipt Journals
Cash Receipt Journals are used to record incoming customer payments.
Steps
Search:
Cash Receipt Journals
Enter the customer payment information
Select the correct bank account
Post the journal
Bank Reconciliation
Bank Reconciliation compares Business Central transactions against the bank statement.
This helps ensure:
Accurate balances
Missing transaction detection
Duplicate transaction prevention
Financial accuracy
Opening Bank Reconciliation
Steps
Search:
Bank Account Reconciliations
Click:
+ New
Select the bank account
Enter:
| Field | Description |
|---|---|
| Statement Date | Bank statement date |
| Statement Ending Balance | Ending bank balance |
| Statement No. | Bank statement number |
Matching Transactions
During reconciliation:
Imported bank transactions are matched against Business Central entries
Matching can be automatic or manual
Matched entries help confirm:
Payments
Deposits
Transfers
Fees
Importing Bank Statements
Some bank accounts support importing statement files.
Typical formats:
CSV
CAMT
MT940
Import Steps
Open Bank Reconciliation
Click:
Import Bank Statement
Select the bank file
Review imported transactions
Transferring Between Bank Accounts
Business Central supports transfers between company bank accounts.
Steps
Search:
Bank Account Transfers
Create a new transfer
Select:
| Field | Example |
|---|---|
| Transfer-from Account | CAD Account |
| Transfer-to Account | USD Account |
| Amount | Transfer amount |
Post the transfer
Creating a New Bank Account
Only authorized accounting personnel should create new bank accounts.
Steps
Open Bank Accounts
Click:
+ New
Enter required information:
| Field | Example |
|---|---|
| No. | BMO-CAD |
| Name | BMO CAD Account |
| Currency Code | CAD |
| Bank Account No. | Actual bank account number |
Configure posting groups if required
Save the record
Blocking a Bank Account
Unused bank accounts can be blocked.
Steps
Open the Bank Account Card
Enable:
Blocked
This prevents future postings while preserving historical data.
Best Practices
Do
Reconcile bank accounts regularly
Verify payment amounts before posting
Use correct posting dates
Review unmatched transactions carefully
Maintain proper approval processes
Do Not
Post directly without review
Modify reconciled entries improperly
Use incorrect bank accounts
Ignore reconciliation differences
Common Business Use Cases at FAM Powder Coating
| Area | Example |
|---|---|
| Customer Payments | Incoming EFT or cheque payments |
| Vendor Payments | Supplier wire transfers |
| Payroll | Payroll bank processing |
| Currency Management | CAD and USD accounts |
| Expense Payments | Utilities, freight, office expenses |
Troubleshooting
Bank Balance Does Not Match
Check:
Unposted journals
Missing transactions
Duplicate entries
Incorrect statement balance
Date filters
Unable to Post Journal
Possible reasons:
Missing balancing account
Incorrect posting setup
User permissions
Blocked bank account
Related Pages in Business Central
| Page | Purpose |
|---|---|
| Payment Journals | Vendor payments |
| Cash Receipt Journals | Customer receipts |
| Bank Reconciliation | Statement matching |
| Bank Ledger Entries | Transaction history |
| General Journals | Manual postings |
Summary
Bank Accounts in Business Central are essential for managing company cash flow, payments, deposits, and reconciliations. Proper use of bank account functionality helps maintain financial accuracy, improves transaction tracking, and supports daily accounting operations.
Users should follow company financial procedures and ensure all banking activities are properly reviewed and reconciled.

