How does match personal expenses with the bank statement (reconciliation) ?

[Jeferson11]

Every week I input my personal expenses from different channels (credit card, debit transaction,...) into a excel data base. This process results in a large database (2018, 2019,..). At the end of the each month I would like to have a way to match these excel database with the original statements from the bank/credit card to check if deviation for corrections (reconciliation). So, if the data matches...... the contents from "Account" and "Sub-Account" should be copied to the Statement. I started to work on but I can't get progress because of is not easy to connect/find the similar data. (I was thinking a way should be create a unique ID for both database...but it is just a idea)
I've added a attachment with more details (tab Flow & Explanation) about the request.
Thanks in advance for any support !
Jeferson

[Bo_Ry]

Please try at

L9:M9
=IFERROR(INDEX(F:F,AGGREGATE(15,6,ROW($B$8:$B$23)/($I9>=$B$8:$B$23)/($K9=$C$8:$C$23),COUNTIFS($I$9:$I9,$I9,$K$9:$K9,$K9))),"")

N9
=LOOKUP(SUMPRODUCT(($I9>=$B$8:$B$23)*($K9=$C$8:$C$23)),{0,1,2},{"NOK","OK","check"})

Copy L9:N9 down

[Jeferson11]

Hello Bo_Ry
First of all many thanks for your repply !

In general looks the solution works ! I will test during this week with the original file (that it's much larger) to check it.
Instead of use a fixed range ($B$8:$B$23 / C$8:$C$23) I've replace by the entire column ($B$:$B$ / C$:$C$)...but it takes long time for calculation...so I will back to original one.
So,...I will continue making some tests and I will forward you the results soon.

Once again, thanks for the support,
Jeferson