Reconciling macro

Hello talented gurus,

While I have searched the internet, this forum and made various attempts to piece together a macro, I have failed (over and over) and resorted to writing in formulas... which aren't quite doing the job either. I'm hoping with your assistance I can get this file working much better with macros and without or with few formulas.

Objective - reconcile a single worksheet of transactions, mark as reconciled, then move reconciled items to new worksheet

Issues I have encountered
- The Location, Type and $ are conditions for each line when reconciling (hence the "My attempt" tab where I used unique values), so that only items for those locations and payments types are clearing against each other.
- The file I am working with has over 30,000 lines, so duplicate values often occur

Writing it out like this, it seems fairly simple, and I feel like I should be able to accomplish it on my own, but sadly I have not.

Many thanks in advance.
Recon with formulas v1.2.xlsx

Originally Posted by Kaper

At the moment it's not marking, but moving matching data - of course one can easily either adopt current code, or just after the process mark all in output sheet as reconciled, and copy back to data sheet.

What a brilliant way to display how each set of items is clearing. This feature I really like.

I applied the code, and I have encountered an issue...
It appears items clear as absolute values, rather than + clearing against - (as with debit/credit). I neglected to clarify that Source "GL" should clear against "Report". The prior comments are more or less 1 in the same, as the GL is all the deposits.
For reference, I added a "Proof" column to the "Reconciled". (Sorry!)

Thank you for the help!

Recon with macro v1.4.xlsm

Works beautifully! Thank you again for the help, especially the thoughtful code for the Reconciliation tab. Super, super helpful.
Hope you have a Happy New Year.

Hi there,

I need to do the same kind of reconciliation without taking into account posting date etc. just the amount. i tried to modify the code to do this but I have been unsuccessful. Any help would be greatly appreciated.