Share
Report
10Hi all,
I am hoping someone can help me design a bank matching rule.
I found some examples online, but our scenario is slightly more complicated.
We receive one daily settlement on the bank statement but we post transactions as and when they happen.
Below i/ve mocked up an example of what we try to do using matching rules. So a one to many match, where the bank statement date is ahead 1 day from postings. The below example shows all of the info we have available to make this work.
Bank statement transactions Bank transactions
Booking date Debit Credit Bank transaction type Reference No. Date Debit Credit Bank transaction type Description
07/11/2019 228.7 200 RS1500 06/11/2019 100.00 200 RS1500
06/11/2109 128.7 200 RS1500
All responses (
Answers (
