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.
<tbody>
</tbody>And the ledger extract
<tbody>
</tbody>
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!
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.
| Date | ID | Value |
| 2014-10-07 | 1254 | $458.55 |
| 2014-10-01 | 12448 | $8004.88 |
<tbody>
</tbody>
| Date | Value | Matching ID |
| 2014-10-07 | $458.55 | 1254 |
| 2014-08-01 | $8004.88 | 12448 |
<tbody>
</tbody>
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!
