Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Bank Reconciliation

Posted on by 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 7,109 Super User 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 5,519 Super User 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 7,109 Super User 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 5,036 Super User on at
    Bank Reconciliation

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,914 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,549 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans