Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 24,824 Super User 2024 Season 2 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,443 Super User 2024 Season 2 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 24,824 Super User 2024 Season 2 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 12,183 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans