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

56,000 checks to reconcile

This customer, type an amount on the date column on the book data. This error created an overflow error. She requested help from us. She reconciles about 56,000 checks. After a careful review we noted that the error was on her book data. An amount was entered on a date column. We pointed the error to her and ask her to re-run the program. We checked with her to make sure it is ok. This is her reply To: "Conrad Natac" Date: Friday, August 21, 2009, 10:04 AM It worked!! Thanks and don’t work too much. Accounting Manager Stream Energy
Read more