Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Is there an Excel template to reconcile business bank statments?
I am looking for a template that will simplify the bank reconciliation process?
|
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel template to mimic PowerPoint | Excel Discussion (Misc queries) | |||
Is there a template for rapid debt repayment in Excel? | Excel Worksheet Functions | |||
Does anyone have a good template for business valuation they can . | Excel Discussion (Misc queries) | |||
How do I save a record from an excel template to a database in a . | Excel Discussion (Misc queries) | |||
How do I use Template wizard add in for 2002 Excel in 2003 excel?. | Excel Worksheet Functions |