Simple Bank Recon

[djmurray]

Hey guys,

I am looking for a way to easily recon my bank statment by value.

At the moment I generate a statment in CSV from the bank and compare it to transactions in my export.

The layout is simple, the bank statment shows.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Date
[/TD]
[TD]ID
[/TD]
[TD]Value
[/TD]
[/TR]
[TR]
[TD]2014-10-07
[/TD]
[TD]1254
[/TD]
[TD]$458.55
[/TD]
[/TR]
[TR]
[TD]2014-10-01
[/TD]
[TD]12448
[/TD]
[TD]$8004.88
[/TD]
[/TR]
</tbody>[/TABLE]
And the ledger extract
[TABLE="width: 500"]
<tbody>[TR]
[TD]Date
[/TD]
[TD]Value
[/TD]
[TD]Matching ID
[/TD]
[/TR]
[TR]
[TD]2014-10-07
[/TD]
[TD]$458.55
[/TD]
[TD]1254
[/TD]
[/TR]
[TR]
[TD]2014-08-01
[/TD]
[TD]$8004.88
[/TD]
[TD]12448
[/TD]
[/TR]
</tbody>[/TABLE]

I would like the script to match to the value and put the matching transaction on the ledger extract.

Any unmatched transcation can move to a new sheet.

Look forward to your reply!