Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Bank Reconciliation
Small and medium business | Business Central, N...
Suggested answer

Bank Reconciliation

(1) ShareShare
ReportReport
Posted on by AR-13061958-0 2
Hi, 
 
I'm having an issue with completing the bank reconciliation within business central. Our payments have loaded, but how do you add the bank deposits and fee amounts to business central in order to balance? 
 
Thank you, 
Ashley 
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 26,793 Super User 2025 Season 1 on at
    Bank Reconciliation
    The suggest lines will pull all unreconciled bank transactions posted to your bank account. Are the outstanding checks posted and is the date filter you are using for suggest lines include the date of the checks?
     
    Also, I would not recommend using suggest lines, but rather importing a bank statement from a csv file into Business Central. I wrote a blog post how to do this - https://valentincastravet.com/create-a-bank-statement-import-format/
     
  • Suggested answer
    Jun Wang Profile Picture
    Jun Wang 7,624 Super User 2025 Season 1 on at
    Bank Reconciliation
    you need to sign up with your bank to get a bank statement export. then set up bank statement file import. 
    then you will be able to import it and auto populate the bank reconcile lines
     
    Jun Wang
     
  • AR-13061958-0 Profile Picture
    AR-13061958-0 2 on at
    Bank Reconciliation
    Thank you for your replies, I am still working through the info, but have a follow up question. The outstanding checks are not loading when i choose the suggest lines option. how can I get this information to populate? 
  • Valentin Castravet Profile Picture
    Valentin Castravet 26,793 Super User 2025 Season 1 on at
    Bank Reconciliation
    The bank deposits are typically added throughout the month when you register customer payments. This is done using either the cash receipt journal, register customer payments, etc. The bank fees you can add during the bank reconciliation, more info on that - Reconcile Bank Accounts - Business Central | Microsoft Learn
     
  • gdrenteria Profile Picture
    gdrenteria 15,338 Most Valuable Professional on at
    Bank Reconciliation

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,884 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,760 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans