Posts

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

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

A comment from an accountant consultant

This is a new customer, a consultant, just signed in for a test a few weeks ago, please read his comment Thanks. I have our biggest recon almost done, same issue only one check that lists as OS and should be an adjustment. I did have to tag quite a few ACH’s re on book we use several dummy checks to match one bank ACH. Also, when I tagged mismatched totals on purpose to force a diff, it seemed to throw the whole thing out of balance so I started over a few times. Have it down pretty well now and love it- you’ve done an amazing job of trying to cover all the different variables and I know it’s next to impossible. I’m looking forward to talking to Agustin and will email and/or call you later. I’ll show the big recon to our GM when I’ve tested it and know it will recomputed in a couple minutes. What I might do is figure out a way to buy it directly from you (for my consulting business), then have (my client) buy it from me as my first customer under our new agreement ( when we have it in

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

Goodwill Industries comment

FYI Conrad I forwarded your contact information to our auditors and highly recommended you for their clients. Constandinos Saketos Accounting Manager, A.V.P. Goodwill Industries of Greater NY and Northern NJ, Inc.

Rolling the August to November

This customer was behind on his reconciliation. His last recon was in June. So, using EzyRecon we started his July- we helped him set up all the parameters in July. Then, we left him to do the August on his own. Later, we asked him, if he was able to do the September too. Apparently, he did not only do, September on his own but rolled it to November too. Down below is his reply. One note, the EzyRecon will work in Vista, you just need to change the security settings in Office 2007. Conrad, Hope you are having a nice day. Yes, I was able to do it; in fact right thru November. In working with the program( I was at home) it does not function on Vista; no problem, I put it on my Laptop ( XP) and rolled along. When you finish a month and initialize for the subsequent month it retains the old bank and book files which was problematic at first until I remembered your instructions on removing them. I didn’t see anything in the instructions on this. Absolutely a great program!!! Let me know

City of Hawthorne

I called the accountant of City of Hawthorne yesterday 02/21/2007. She said that their general ledger is not yet ready for uploading. I told her that once her gl can be downloaded, her bank reconciliation is done in just a few minutes.