Fampowder Docs

Bank Account

Estimated reading: 3 minutes 24 views

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

  1. Open Microsoft Dynamics 365 Business Central

  2. Use the search icon (magnifying glass)

  3. Search for:

Bank Accounts
  1. Select Bank Accounts from the results


Main Bank Account Information

Each bank account contains important company banking details.

Typical information includes:

FieldDescription
No.Bank account number in Business Central
NameBank account name
Currency CodeCurrency used by the account
BalanceCurrent account balance
Last Statement No.Last imported or reconciled statement
Bank Branch No.Bank branch information
Bank Account No.Actual bank account number
IBANInternational bank number
SWIFT CodeInternational bank identifier

Opening the Bank Account Card

To view or edit bank account details:

  1. Open the Bank Accounts page

  2. Select the desired account

  3. 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

  1. Select the bank account

  2. 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:

MethodExample
Cash Receipt JournalsCustomer payments
Payment JournalsVendor payments
General JournalsManual adjustments
Bank ReconciliationMatching statement transactions

Using Payment Journals

Payment Journals are used to pay vendors or other expenses.

Steps

  1. Search:

Payment Journals
  1. Select the journal batch

  2. Enter:

FieldExample
Posting DateCurrent date
Document TypePayment
Account TypeVendor
Account No.Vendor number
AmountPayment amount
Bal. Account TypeBank Account
Bal. Account No.Company bank account
  1. Review the journal

  2. Click:

Post

Using Cash Receipt Journals

Cash Receipt Journals are used to record incoming customer payments.

Steps

  1. Search:

Cash Receipt Journals
  1. Enter the customer payment information

  2. Select the correct bank account

  3. 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

  1. Search:

Bank Account Reconciliations
  1. Click:

+ New
  1. Select the bank account

  2. Enter:

FieldDescription
Statement DateBank statement date
Statement Ending BalanceEnding 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

  1. Open Bank Reconciliation

  2. Click:

Import Bank Statement
  1. Select the bank file

  2. Review imported transactions


Transferring Between Bank Accounts

Business Central supports transfers between company bank accounts.

Steps

  1. Search:

Bank Account Transfers
  1. Create a new transfer

  2. Select:

FieldExample
Transfer-from AccountCAD Account
Transfer-to AccountUSD Account
AmountTransfer amount
  1. Post the transfer


Creating a New Bank Account

Only authorized accounting personnel should create new bank accounts.

Steps

  1. Open Bank Accounts

  2. Click:

+ New
  1. Enter required information:

FieldExample
No.BMO-CAD
NameBMO CAD Account
Currency CodeCAD
Bank Account No.Actual bank account number
  1. Configure posting groups if required

  2. Save the record


Blocking a Bank Account

Unused bank accounts can be blocked.

Steps

  1. Open the Bank Account Card

  2. 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

AreaExample
Customer PaymentsIncoming EFT or cheque payments
Vendor PaymentsSupplier wire transfers
PayrollPayroll bank processing
Currency ManagementCAD and USD accounts
Expense PaymentsUtilities, 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

PagePurpose
Payment JournalsVendor payments
Cash Receipt JournalsCustomer receipts
Bank ReconciliationStatement matching
Bank Ledger EntriesTransaction history
General JournalsManual 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.

Antimanual

Ask our AI support assistant your questions about our platform, features, and services.

You are offline
Chatbot Avatar
What can I help you with?