Macro for Bank Reconciliation

J

Jai

Hi,
I need help to write a macro or formulas to do reconcile two sheets.
Sheet "A" has list of all the issued cheques for the month and outstanding
cheque list from prior months. In Sheet A : column A - Cheque number, Column
B - Amount. Sheet "B" has list of cashed cheques for month given by bank. In
sheet "B" Column A - Cheque Number and Column B - Amount.
I am trying to come up with macro or formula so that cheque numbers can be
matched and column C shows the matched cheque number from Sheet A and column
D shows the amount, Column E shows the difference in amount i.e. column
b-column d. All the matched cheques should get deleted from sheet "A" so that
sheet A is outstanding list for the cheques.

Please help. Thanks in advance
 
F

Farhad

Hi,

You can do matching cheques and amounts by formula but for deleting them you
need macro. My sugestion is don't delete them and leave them for your backup
just copy outstanding cheques to another sheet anyways there are another
things like deposits and bankfees and also credit cards transaction what do
you want to do for them? because you just asked for matching cheques, well I
can do it for you just send to me your file my email is (e-mail address removed)

Thanks,

Farhad
 
J

Jai

Hi Farhad,
Thanks for your reply, We have 4 different bank accounts, One account is for
all general transactions like bank fees, credit cards etc. Three Bank
accounts are only for cheque clearing. I need to reconcile three cheque
clearing bank accounts which is to compare issued cheques and cashed cheques
then prepare a outstanding cheques list.
I will e-mail you my file soon. Please help me with formula or macro
Thanks
Jai
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top