Bank Reconciliation demo with City of Hawthorne

Nov 9, 2006 – I met with the accountants from City of Hawthorne, I demonstrated to them that with EzyRecon, they will be able to do their bank reconciliation in minutes. One of their big problem in doing their manual bank reconciliation, is how to find out the other book entries that needs to be adjusted. I showed them during the demo that the system can easily segregate those book entries that are incorrect. I showed them how the system can reconcile using raw data of book and bank files. During the presentation the system was able to reconcile the sample data of 2,000 checks in less than 5 minutes. The system is able to detect those bank checks showing as zero check numbers and misposted check numbers.

Their bank files can be downloaded directly from the bank . However, their general ledger is not yet ready to be downloaded. We are still awaiting from their IT department to make the general ledger as a txt file. I emphasized to them that once their general ledger is downloaded as text file then their reconciliation is done.

Comments

Post a Comment

Popular posts from this blog

Comments from users of Ezyrecon bank reconcilation (www.ezyrecon.com)

Conrad, this note is from Steve at the Village Sports Den in Salt Lake. I want to thank you for the assistance and patience you have provided in helping us set up the EZYRECON bank reconciliation program. It is exactly what we needed to match our bank activity to our book activity and create an accurate listing of outstanding items. A job which formerly required a good portion of a day now takes only a few minutes. If I have any problems with sending the praises for your product to your website blog, I will let you know. Thanks again for your help. Please provide us with the new serial number for our product and we look forward to your support in the future. We will mail your payment tomorrow.
Read more

Ezyrecon Bank Reconciliation Overview

Ezyrecon can 1a). Reconcile from the general ledger or control account. The system can accept additional file to support some of the lump sum entries in the ledger for deposits and disbursements. For example, in the payroll account, the entry may be for the total net payroll only. This entry is supported by another spreadsheet coming from the payroll provider. So, the disbursement in the book is supported by a check register coming from another source (e.g. ADP Payroll register). This is acceptable for Ezyrecon. You can have support files that are outside of your accounting system. 1b. Prepare the final report, the AICPA suggested two column bank reconciliation, from unadjusted to reconciled book and bank balances. This report is on the tab called "Main". All supporting working papers for the reconciliation can be printed on the fly. 1c. Comply to Sarbanes-Oxley Act, which is mandatory for publicly listed companies. There is an adequate audit trail to support all the reconcil
Read more

Wish List for a Bank Reconciliation Software

1) I prefer an Excel based stand alone bank reconciliation software. In this way, I can easily modify the report. 2) I need one where I don't have to do anything except download the book and bank file into either an Excel or CSV file. 3) It should be able to do the bank reconciliation without too much effort on the part of the user. 4) It should be able to take any bank and book file as its data source. 5) The initial set up to get it running should take less than 30 minutes. In other words, it should be easy to install. It should be maintenance-free – there is no need for a tech support every now and then. 6) I should be able to install the software at my laptop to run it at home, if needed, without additional fee or whatever. 7) There should be no lengthy instruction to run the software. It should be intuitive or logic driven. 8) The process to reconcile should not be complex, but rather confined to a few simple steps, preferably three steps. 9) The final report should
Read more