reconcilation of debit and credit

[rohithverma]

on day one i have data like as below

sno debit credit chequeid vdate
1 200 0 1234 01-jan-2020
2 200 0 1234 01-jan-2020
3 400 0 4567 01-jan-2020
4 400 0 4567 01-jan-2020
5 400 0 4567 01-jan-2020
6 600 0 6789 01-jan-2020

and on day 2 i have data like this as appended to day 1 data the final input as

sno debit credit chequeid vdate
1 200 0 1234 01-jan-2020
2 200 0 1234 01-jan-2020
3 0 200 1234 02-jan-2020
4 400 0 4567 01-jan-2020
5 400 0 4567 01-jan-2020
6 400 0 4567 01-jan-2020
7 0 400 4567 02-jan-2020
4 600 0 6789 01-jan-2020

So the final output i required is

dataset1

sno debit credit chequeid vdate flag
1 200 0 1234 01-jan-2020 matched
2 0 200 1234 02-jan-2020 matched
3 400 0 4567 01-jan-2020 matched
4 0 400 4567 02-jan-2020 matched

dataset2

sno debit credit chequeid vdate flag
1 200 0 1234 01-jan-2020 open
2 400 0 4567 01-jan-2020 open
3 400 0 4567 01-jan-2020 open

Please do the needfull

Thanks in advance

ance

[PaigeMiller]

Please don't make us guess. Please tell us the logic that takes the raw data and produces output data set 1 and ouptut data set 2.