statement reconciliation

Hello,

Pls find sample of my data attached...the main statement is dumped in the 'statement' sheet. The statement contains credit and corresponding debit entries later...

I would like a macro which will reconcile the statement based on the amount, narrative and date. The amount, narrative of credit entry should match with the debit amount with same narrative. In addition to that, the debit entry date should be either equal or later than the credit date. If the entries are reconciled, the reconciled items should be copied and reflected in 'reconciled' sheet with reconciled entries adjacent to each other and all unreconciled items should be in 'unreconciled' sheet...

Any help with this will be appreciated...

The data changes so I need a macro for this..

Thank you....its working fine when I have 3 columns....where are changes needed if I have 12 columns?? comparing 3 columns is ok but if there are 12 columns of data that are to be extracted, where are changes needed???

Uploading the sample

Change to

Please Login or Register  to view this content.

Explain what you mean by 'not working' - you need to be precise.

Removed by JT

Thank you...


but the file is not showing all the data of the 'working' sheet...

uploading the result.....it is showing only 29 records in 2 sheets....however there are 44 records in the 'working' sheet

The issue is (I believe) because there are multiple entries of a given "Narrative 2" e,g. 01781830 occurs 10 times 01781829 occurs 6 times and I do not think the code allows for this.

Here I am uploading the file....you can see that primary key is 'Narrative 2' ....................'Amount' and 'Narrative 2' of credit and debit entries should match....also the date of debit should be later than the date of credit, otherwise it should go to 'unreconciled' sheet..
....

I have highlighted the data in the attached file...thank you...

Please Login or Register  to view this content.

I have modified Jindon's code (hopefully correctly as I am a code amateur!) and it delivers the same results as my earlier code EXCEPT for a DUPLICATE transaction (deliberate or error?) : see attached image.

Please Login or Register  to view this content.

the buttons run my code (RUN) and jindon's code (TEST)