Is there a simple bank reconciliation form?

  • Thread starter Thread starter Guest
  • Start date Start date
Cheryl said:
Are there any bank reconciliation forms in Excel or Word?

Thanks
Click to expand...

The method I use is-
Column X next to the account which, by default has a -

Column Y (at the extreme rh side) with the formula
=IF(AND(A1<>"-",B1="-"),A1,"-") (where A1 is the amount and B1 is a record
of the statement page number). A - is returned if a - is detected in A1 and
B1 or a statement page number is detected in B1. Otherwise the value of the
outstanding cheque is returned..

At the bottom of column Y there are 3 cells
Y555 =SUM(Y1:Y999) A total of non cleared cheques
Y556 =M5988-AL5988 The difference between the total of the cheque account
column and the non cleared cheques

On receiving a statement, enter the statement page number against each entry
Confirm the balance on the statement is the same as Y556

It works for me!

Bill Ridgeway
 
Back
Top