Notifications
Announcements
No record found.
If possible, use the automated bank rec which allows for the importing of the bank statement. Then you can use the Auto Match, leaving only the unmatched for you to have to manually reconcile.
We have the same situation with our main bank account. We are using the Yodlee Bank Feed service, and our accounting staff create the bank recs at the beginning of the month and then each day they open them and import the bank statement transactions from the previous day and match what they can. They use both automatic and manual matching (because some of our matches are many-to-one). By the end of the month most entries have been matched, and then they use the function to send unmatched entries to a General Journal batch for items such as bank fees and interest income. They enter the final ending balance in the bank rec header, make sure everything is balanced, and post the rec.
Rob - great point. The more often you can do your bank rec, the lighter the load. I have had clients asked about auditors not getting a single bank rec. Auditors have unanimously stated that a closer watch of the bank account (reconciling daily or weekly) is always better than once a month.
Hi, I think you can use the following standard feature.
In W1:
To fill bank reconciliation lines by importing a bank statement
https://docs.microsoft.com/en-us/dynamics365/business-central/bank-how-reconcile-bank-accounts-separately#to-fill-bank-reconciliation-lines-by-importing-a-bank-statement
In Netherlands Local Functionality
Import and Reconcile Bank Statements
https://docs.microsoft.com/en-us/dynamics365/business-central/localfunctionality/netherlands/how-to-import-and-reconcile-bank-statements
Hope this will help.
Thanks.
ZHU
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 3,098
Jainam M. Kothari 1,556 Super User 2025 Season 2
YUN ZHU 1,108 Super User 2025 Season 2
