Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a simple bank reconciliation form?
Are there any bank reconciliation forms in Excel or Word?
Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a simple bank reconciliation form?
"Cheryl" wrote in message
... Are there any bank reconciliation forms in Excel or Word? Thanks 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro for Bank Reconciliation | Excel Discussion (Misc queries) | |||
matching Check # for Bank Reconciliation through Excel | Excel Worksheet Functions | |||
Bank Reconciliation | Excel Discussion (Misc queries) | |||
A Bank Statement Reconciliation template | Excel Discussion (Misc queries) | |||
How would you do a bank reconciliation in excel. | Excel Worksheet Functions |