Bank Reconciliation

that includes collecting 6 months of pertinent data to start the bank rec process. hey it takes about 20 minutes to finish a chilled san miguel, right? (who says you can't enjoy a li'l brewsky with EZY RECON?) - just kidding. one hour compared to over 85 hours is awesome. salamat gary

Conrad, Thanks for your email. I haven't forgotten about you either. It sounds like your proposed upgrade would be able to handle the situation whereby there is a batch code for A/P checks and a different batch code for payroll checks. I have another thought, I don't know if you may have considered this yet...it involves using the Solver Add-on in Excel. Let's say after running the reconciliation, there are a hundred and fifty reconciling items originating from the books and forty from the bank (just for sake of example) and lets say that you know that most of these book items represent sales (checks and cash) on the books which have been grouped together to make one daily deposit per day to the bank. And let's say that you know that the person compiling the deposits is very accurate but very busy and sometimes she only makes two or three deposits per week and sometimes up to a week late...would it be possible to incorporate the Excel Solver into your program such that...

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...

Paul Gardner wrote: Conrad, thanks so much for your help. I have reviewed your mapping and understand it correctly. The column you set up for book debits makes sense. I have copied the control total pages and will use them going forward. I deleted the old system and used your new version. It runs much faster, saves faster, and I like it. The one question I have, is now that we have a good run on May, can I just keep the system in the Excel folder I am running off without having to change the name of the system each month? I assume that I can keep it as BankReconSD and just name the input files with the correct names and then change the control portion to agee to the new monthly names for that period. So for June, I would use JuneBank2006.xls and Junechecks2006.xls but keep the system as BankReconSD. I hope I don't have to call you too many more times, but thank you for your patience and help. You provided great service!!!Thanks, Steve.

Hi Conrad! Thanks for sending the latest version... I certainly appreciate it! My day has turned into a very hectic one...by chance, would you available to speak on Sunday, May 21st? I'm coming into the office then, and would have more time available to speak... If you're not available on Sunday, I certainly understand, and I'll just call you on Monday ... In the meantime, I have a couple questions ... My company has a very unique and complex bank reconciliation process...due to sweep accounts (all our accounts, except for our operating and line of credit account, are $0.00 balance accounts)...our operating account funds 2 separate disbursement accounts, and we have a daily sweep to our line of credit account from our operating account ... we also have inter-company accounts and a main lockbox account, along with 4 subsidiary lockboxes (our incoming deposits post to these)... so, setting up a bank reconciliation process using your program would take a great deal of analy...

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.

We have a customer who did not do their bank reconciliation for a year. At year end, they were cramming to produce their bank reconciliation for the external auditors. The external auditor will not sign on the audit report, unless the Company can reconcile the general account. The Finance Manager was looking for some easy and quick way to reconcile their general account. So, we recommended to him the following: 1) to download from their general ledger the whole year transactions of the bank account to be reconciled. 2) Next, they dowloaded from their bank the last six months of bank transactions, the other six months they copied to Excel from the actual bank statements. 3) Using EzyRecon, we processed and reconciled the whole year of transactions- the whole processing took less than two minutes. Actually, the Finance Officer gave the two files to us to use and took a coffee break. When he returned, he was amazed that it was done. You are done?, is the first question that ca...

How to do 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 B...

If you are having a hard time doing your bank reconciliation, let me help you for free. All you need to do is send me your book and bank file in a csv or Excel format. You can delete some information like payee and payor, if you want. Normally, you can download from your accounting software the general ledger for the bank account you are reconciling. Also, you can download from your bank the bank transaction for the period in a csv or MS Excel format. If you can download these two files, your reconcilation is practically done- I guarantee you. I am in the process of thoroughly testing my software called EzyRecon. In the process, I want to get all kinds of book data from all software out there. You can write to me at sales@ezyrecon.com Conrad