Is there an Excel template to reconcile business bank statments?
 

I am looking for a template that will simplify the bank reconciliation process?

Acct Rep wrote:
I am looking for a template that will simplify the bank reconciliation process?

How do you mean "simplify"? You will still need to manually tick off the
bank statements against the cashbook entries. If you're looking for an
AUTOMATED bank rec, then you're looking at comparisons of lists, and
that gets complicated if (say) the bank has entered a cheque number
correctly but with the wrong amount or vice-versa. It DOES happen - I've
seen it. Also that assumes you can download bank statements into Excel
and that your cashbook is either already in Excel, or can be exported to it.

--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk