Hi All
I have a bank statement in PDF and can download in CSV from my bank. Parents pay their child fees into the bank account. I have a workbook in excel from Grade 1 to Grade 5 (different worksheet for each grade). The information in the worksheet are : Name and Surname, Months of the year...
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>
Date
ID
Value
2014-10-07
1254
$458.55...
cheque book Bank Data
Date cheque no amount matching cheque in bank date cheque no amount
01/10/2009 692201 40000 no match 01/10/2009 692203 23000
02/10/2009 692202 50000 no match 05/10/2009 692201 40000
03/10/2009 692203 23000 no match 06/10/2009 692205 51000
04/10/2009 692204 29000 no...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.