How to use Excel for Bank Reconciliation.

Posted by AccountingWEB PM | on Sun, 03/12/2006 - 19:40 66198 19 comments | report

Hi,

I am looking for Tips from my senior colleagues, who using Excel for Bank Rec, and would highly appreciate your comments.

I want to speed up Bank Reconciliation process when using Excel. How can we use Excel effeciently when doing Bank Reconciliation jobs to fine out Differences.

I have spent Hours in the Past to find differences .

Kind Regards.
Rehan Arain

Comments

There are 19 comments. Login or register to view them.

Bank Recs in Excel

Oscar Lopez LL | Tue, 24/02/2009 - 11:30

btw, use google translate

mikeopolo | Fri, 25/01/2008 - 22:27

SQL database for reconciliations - Auto Bank Rec

enodatio | Fri, 25/01/2008 - 17:33

Where are you starting from?

Richard Willis | Mon, 04/12/2006 - 10:08

its all about matching?

listerramjet | Mon, 04/12/2006 - 09:10

hi Richard - pivot table tip

listerramjet | Mon, 04/12/2006 - 10:23

Alastair, I agree

Richard Willis | Tue, 05/12/2006 - 09:15

Excel version

yardleystar | Fri, 15/12/2006 - 16:41

Data List feature

jumpalongjim | Sat, 16/12/2006 - 00:03

Thanks Very Much.

Rehan1 | Mon, 04/12/2006 - 22:01

Data 'leakage' from named ranges

yardleystar | Fri, 15/12/2006 - 13:25

Try using bank statement numbers & filters.

Mick Eaton | Thu, 07/12/2006 - 13:25

I'd personally would use the "if" formulae and the "auto filter"

adam.hall | Thu, 07/12/2006 - 14:26

Excel Reconciliation Function

jumpalongjim | Thu, 07/12/2006 - 16:00

Steve

listerramjet | Fri, 15/12/2006 - 15:20

Steve, can you Group dates in a List?

David Carter | Wed, 20/12/2006 - 13:41

Excel for Bank Reconciliation

oliv-33 | Thu, 20/05/2010 - 17:46

Excel Tool to Reconcile Bank to Books

dougschiller | Fri, 30/03/2012 - 17:13

Bank Reconciliation

AlBear | Tue, 19/03/2013 - 14:38