Hi,
Does anyone know, auto bank reconciliation matching criteria/rules in business central?
Thanks in advance!
Hi,
Does anyone know, auto bank reconciliation matching criteria/rules in business central?
Thanks in advance!
The matching algorithm basically checks these parameters: Amount, Transaction Date, Related Party Match, Document Number Match, External Document Match, Description Match
Amount: The algorithm looks if the amount on the left matches the right, exactly (sometimes it may accept differences in pennies)
Transaction/Posting Date: When you try to auto-match, a tolerance input is expected. Based on the tolerance input, the dates on either (left & right) pages are matched with each other
Document No Match & External Document No Match: Checks if the imported document number matches (by how much % in nearness) with the existing ledger
Description Match: Checks how "near" the existing description is with the imported description
In a nutshell, all that matters is your Transaction Date & Amount to match, other parameters have a high chance of not being similar/near to each other.
*Please mark this answer as YES if it helped you answer your question*
André Arnaud de Cal...
292,516
Super User 2025 Season 1
Martin Dráb
231,409
Most Valuable Professional
nmaenpaa
101,156