I have to define the workflow for reconciliation please help me in this.
1. We cant use Multi-row formula.
2. First it will check for same check number in the same column (Check Number1), if it is found then it will search for same amount present in same column(Amount1) with opposite sign then it is reconciled and deleted from the data.
the above data is reconciled.
3. Then, it will check for same check number in the same column, if it is found then it will search for same amount present in another column(amount2) with same sign then it is reconciled and deleted from the data.
Sometimes when things are complicated with a MultiRow formula, they can be done simply with a few joins. This is good when the datasets are variable or just writing the formula would be a nightmare. I usually put a RecordId on the records before I start this stuff to make it clear what is going where. Join the data back to itself on CheckNumber and possibly EmpNo (depending on your rules) You will get a RECORD and a TEST record and I sometimes rename the records so I can tell them apart. You can then test using simple IF statements. Flag the records and use a FILTER to remove or keep what you want.
Not the most elegant solution but I think this works. It doesn't give exactly your output but I think you might have missed something, e.g. as far as I can see all entries for A102 cancel out, but one is left in your output.