Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Acct Rep
 
Posts: n/a
Default Is there an Excel template to reconcile business bank statments?

I am looking for a template that will simplify the bank reconciliation process?
  #2   Report Post  
Gordon
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel template to mimic PowerPoint Julian Excel Discussion (Misc queries) 0 February 3rd 05 03:01 PM
Is there a template for rapid debt repayment in Excel? fofanna Excel Worksheet Functions 0 January 26th 05 04:07 PM
Does anyone have a good template for business valuation they can . Sonny R. Moyers Excel Discussion (Misc queries) 1 December 12th 04 06:17 PM
How do I save a record from an excel template to a database in a . Fred Smith Excel Discussion (Misc queries) 1 November 30th 04 02:49 PM
How do I use Template wizard add in for 2002 Excel in 2003 excel?. TCIrish Excel Worksheet Functions 0 November 23rd 04 05:43 PM


All times are GMT +1. The time now is 01:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"