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

Regards

Binu Kochupurackal
binu.yahoo.rediff@gmail.com

Download Link

No comments:

Post a Comment