Microsoft VBA using the MS Excel®
EzyRecon is a bank reconciliation program written in Microsoft VBA using the Microsoft Excel® as its user interface. Since the interface is in Microsoft Excel, users can quickly check and modify the result, (i.e. two column AICPA bank reconciliation format), if needed. Not even Microsoft Great Plains® Bank Reconciliation program comes close to it . See how we compare against others (see comparison chart).
Behind the program buttons are complex visual basic programs doing the calculation of outstanding checks, deposit-in-transit and uncleared others.
The resulting reconciliation is a two column bank reconciliation from unadjusted book and bank balances to adjusted book and bank balances.
The system works like this, you download the book and bank file in a csv or MS Excel format, then you tell the computer to do the bank reconciliation. It is a simple 3 step reconciliation process.
Behind the program buttons are complex visual basic programs doing the calculation of outstanding checks, deposit-in-transit and uncleared others.
The resulting reconciliation is a two column bank reconciliation from unadjusted book and bank balances to adjusted book and bank balances.
The system works like this, you download the book and bank file in a csv or MS Excel format, then you tell the computer to do the bank reconciliation. It is a simple 3 step reconciliation process.
 Steps to do Bank reconciliation using EzyRecon 1) Download the bank statement into an Excel or csv file format- no bank format is required. 2) Download the book file as is from your accounting system into an Excel or csv file format(.e.g. SAP, Great Plains, Oracle, Navision, etc.). If your books do not show the check number, you need to download the check register that shows the check number. Make sure that the total of the check register agrees with your total disbursements. If you are reconciling a payroll account your check register will come from a different system (e.g. ADP and others). The total of the check register should agree with your total disbursements. The same is true for deposits. If you are recording the deposits in total, you need to have a deposit breakdown of how the deposits hit the bank. 3) Hit the reconcile button, wait for 3 minutes,review AICPA format 2 column reconciliation from unadjusted to adjusted book and bank balances. The final reconciliation report has adequate audit trail and complies with the Sarbanes-Oxley Act. If needed, the system can prepare the necessary journal entries on the fly to record each reconciling items based on your own chart of aacounts complete with audit trails and explanation. If the above instruction is too complex, send us your book and bank files, we will do the initial set-up and recon for you free of charge-no pressure to buy. The best way to test the program is to actually use your own actual data. |
){kind=link}
){kind=link}
){kind=link}
){kind=link}