Doing Bank Reconciliation in a Breeze

I used to do bank reconciliation manually. We have about 1,200 checks to reconcile in a month. Sometimes, it will take me an hour to reconcile, if I lost continuity of thought in the process. Then, I decided to do a bank reconciliation program. I said to myself that there should be a software out there that can do the process by just giving the book and bank files to use. Unfortunately, I did not find any- most of them requires you to do data entry

So, I did one and called it EzyRecon ( www.ezyrecon.com). It took me a year to perfect the program for commercial use. The process to reconcile is made up of three (3) steps, as follows:

1) dowload the book file ( book transactions) in a csv or MS Excel file
2) dowload the bank file ( bank transactions) in a csv or MS Excel file.
3) hit the reconcile button, review the 2 column AICPA format bank reconciliation.

As you can see from these steps, you did not do anything except to dowload the files.

The EzyRecon software is witten in Visual Basic, with MS Excel as the interface. I chose the MS Excel as the user interface for ease of use. But behind the program is a complex Visual Basic modules, doing the data manipulation. Since, it is in Excel, the user can do their own corrections and data manipulations as needed.

With 2,000 checks you can finish your reconciliation in less than 2 minutes, with virtually nothing to do-except to give the files to use. There is no reconciliation in the market that is program to process this way- simply define or give the files to use.

You can download the program and use it for free for 2 months at www.EzyRecon.com

What do you have to loose, test drive the EzyRecon reconciliation today.

Should you have any questions, please write to me at sales@ezyrecom.com


Conrad

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