Acct said:
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.
