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

Bank Account Reconciliation

(1) Share

Report

Posted on by KA-18031449-0

Hi, I am a bit new to BC, and is right now looking at my first Bank Account Reconciliation. We have a sweeping arrange with our bank, which every day clears the balance of our income account and automatically transfers the balance to our Payments account. When reconciling the two bank accounts in BC, it seem the sweeping transaction is only displayed in the GL of the account the amount is transferred FROM, and not the receiving account. Is that correct? Or is there something I have over looked?

Kind regards

Kent Andersen

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

Moved from Integration, Dataverse, and general topics forum to Small and medium business | Business Central, NAV, RMS forum.

Was this reply helpful? Yes No
Jainam M. Kothari 15,631 Super User 2025 Season 2 on at

Like (1)

Report

Hello,

May this can help : https://technologyblog.rsmus.com/technologies/microsoft/dynamics-365-business-central/make-reconciling-credit-card-statements-and-sweep-accounts-easy-in-business-central/

https://www.accountingtools.com/articles/cash-sweeping

Was this reply helpful? Yes No
KA-18031449-0 8 on at

Like (0)

Report

Hi Jainam,

Thanks for your reply. As I understand it, the Payment Reconciliation Journal, is more of an easy way to import and journal bank statements. I an looking at the Bank Account Reconciliation beyond that. I.e. using the Bank Account Reconciliation function, import the statement one more time, and tick off all the entries in the GL. In the llist og GL entries to the left, it seem when you reconcile the account that receives the sweep, the sweeping GL entry does not appear in the list, which makes it impossible to tick off all the entries in the statement, as you can't reconcile with the closing balance in the bank account. Any ideas?

Kind regards

Kent

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,157 Most Valuable Professional on at

Like (1)

Report

Hi, good day
I hope this can help you, and give you some hints.

Reconcile bank accounts - Business Central | Microsoft Learn

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,275 Super User 2025 Season 2 on at

Like (1)

Report

Hope this helps as well: https://www.youtube.com/watch?v=BTgB2WtQKyM

Was this reply helpful? Yes No
KA-18031449-0 8 on at

Like (0)

Report

Hi All,

Just in case it might be of help to someone else, I have now figured it out. The reason the entry did not appear in the Bank Account Ledger when processing the Bank Account reconciliation, was that when posting the entry using the Payment Reconciliation Journal, the balancing account was posted as a GL account which is the default. The balancing account has to be changed to a "Bank Account".

Many thanks for helping.

Kind regards

Kent Andersen

Was this reply helpful? Yes No