Thursday, 28 November 2013

Microsoft Excel Macro for Automatic Bank Reconciliation Statement

Dear Friends,

I'm sharing Microsoft Excel Macro for Bank Reconciliation Statement developed by me

Download the Macro Enabled Excel file from below link

Open the “Book Sheet” and copy paste the Bank Ledger in your Books in the necessary fields

Open the “Bank Sheet” and copy paste the Bank statements in the necessary fields

Then Go to “Reconcilation Sheet” and Click “Generate Reco” Button

It will process and give the reconciliation output

You can Drill down the details by Selecting the Cell and using “Ctrl + [“

Please Do not delete any sheet , It will corrupt the programme


Binu Kochupurackal

Download Link

No comments:

Post a Comment