Small and medium business | Business Central, N...

Bank Reconciliation

(1) Share

Report

Posted on by AR-13061958-0

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

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Gerardo Rentería Ga... 26,091 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi

I hope this can help you: Reconcile Bank Accounts - Business Central | Microsoft Learn

BR

GR

Was this reply helpful? Yes No
Valentin Castravet 32,502 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
AR-13061958-0 2 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Suggested answer

Jun Wang 8,210 Moderator on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 32,502 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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/

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No