web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

D365 advanced bank reconciliation best practices on matching rules

(0) ShareShare
ReportReport
Posted on by 210
Hi all,
 
Hope that your summer is going well.
 
First of all, i am sorry for taking from your time because i am an IT person and not a "Cash and Bank" or "Accounting" specialist.
 
I have been doing some reviews on internal processes, and 1 particular thing got me.
 
"Advanced bank reconciliation".
 
What i have seen is not something i like based on the fact that Microsoft offers so much more in this space.
What we are doing basically is the following - we import the bank statement and match manually like click on the bank statement and afterwards find the corresponding line in d365 books.
No matching rules, no matching sets, no anything.
Of course, for small legal entities this is fine, but for LE with 1k transactions a month this is nightmare.
 
Today i have been reviewing one "Bank Reconciliation" statement and i noticed the following.
Basically, besides amount and date there is nothing else i can create a rule and match automatically on.
All the videos and documentation i have gone through almost every time uses the Reference No. that most of the time = the Payment reference...
 
 
 
My question is.
The payment reference is something that accountants are putting in the journal, correct?
If they leave it blank it will be blank during reconciliation?
 
Can you please advise me on the best basic matching rules we can implement initially?
 
In your experience does a rule based only on amount and date working properly or it opens the door for mistakes ?
 
I will appreciate any advice and proven working practise in this area as it is brand new to me.
 
From configuration perspective i don't have questions right now, because everything else will require the matching rules/sets to be working in the first place.
 
Thank you.
 
 
Categories:
I have the same question (0)

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
11manish Profile Picture

11manish 107

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 59 Super User 2026 Season 1

#3
sannavajjala87 Profile Picture

sannavajjala87 29

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans