Revised 03/16/2026
The following videos cover topics included in the Bank Account Reconciliation portion of the Business Central - Month End Processes Training Session offered on our Training Menu.
This is part one of a three part Month End Processes series. For part two, please see Fund Fees Assessment - Suggested Learning Course. For part three, please see Joint Investment Allocation - Suggested Learning Course.
Using the Bank Account Reconciliation Knowledge Article as a guide, this suggested learning course walks through the full bank reconciliation process in Business Central, including starting a Bank Account Reconciliation, importing and matching bank statement lines using CSV files, reviewing totals, posting, and viewing posted Bank Reconciliations.
While we suggest watching all videos in order, you may click on a Title below to jump to a topic:
- Starting a New Bank Account Reconciliation
- Understanding the Bank Reconciliation Form
- Preparing a CSV File for Import
- Setting Up an Import Format for a Bank Account
- Importing Your Bank Statement
- Matching
- Posting a Bank Account Reconciliation
- Viewing Clear Dates & Posted Bank Reconciliation
- Undoing a Bank Reconciliation
Starting a New Bank Account Reconciliation
This video walks through how to start a new Bank Account Reconciliation in Business Central, including selecting the Bank Account and entering the statement date, statement ending balance, and prior statement balance to ensure accuracy before reconciling.
Understanding the Bank Reconciliation Form
This video explains the layout of the Bank Reconciliation form in Business Central, including how posted transactions and bank statement lines are displayed and how key totals, such as Total Difference and Total Balance, are used to confirm a reconciliation is complete and accurate.
Preparing a CSV File for Import
This video explains how to format a CSV file for import into Business Central, including required columns, correct sign conventions for amounts, and tips for combining and preserving data so future bank reconciliations are faster and more consistent.
Setting Up an Import Format for a Bank Account
This video explains how to create and assign a Bank Statement Import Format in Business Central, including using the Import Wizard to map CSV columns so bank statement lines can be imported accurately and reused for future reconciliations.
Importing Your Bank Statement
This video shows how to import a bank statement into Business Central using a predefined Import Format, bringing all statement lines into the reconciliation so they’re ready for matching and review.
Matching
This video explains how to automatically and manually match imported Bank Statement Lines to ledger entries in Business Central, including setting a Tolerance Window and reviewing matched and unmatched transactions to complete your Bank Reconciliation accurately.
Posting a Bank Account Reconciliation
This video explains how to confirm a completed Bank Reconciliation by reviewing matched items and totals and post the reconciliation in Business Central.
Viewing Clear Dates & Posted Bank Reconciliations
This video highlights how cleared payments are reflected back in akoyaGO CRM for visibility across teams, as well as viewing posted Bank Reconciliations in Business Central.
Undoing a Bank Reconciliation
This video covering undoing a Bank Reconciliation if a mistake was made.