Auto Recon match Bank items

Hi Jasper

Let's see if the Code in the attached gets you started. If so, we can build on it. CTRL + x will fire the Code.

Hi Jaslake

I have opened the file and it seems to be working as required. It has already got info in Column J as Reconciled and I did not activate Ctrl + x.(Downloaded file again and allows for fuction Ctrl + x). Sorry. I have highlighted some that shows no reconciliation such as credit cards. I don't know if we can address them. The other seems to be fine and when difference reason is given. How do I get the macro when used in another month. I would like to test one full month on my side and would like to provide you with feedback. Can you also tell me what Sheet Report means as it displays only heading.

Many thanx again.

Hi Jasper

There are MANY highlighted Cells in your most recent attachment. Please highlight ONLY those items that are Credit Card items in one color. If there are other items you believe SHOULD have been matched, highlight them in a DIFFERENT distinct color. Keep in mind, I'm color blind.

Regarding this

How do I get the macro when used in another month

Will your Month Data File ALWAYS be of the SAME Structure as your Sample File? ALWAYS same number of Columns in the SAME sequence? ALWAYS same Column Headers and ALWAYS in Row 1? ALWAYS the same Sheet Names?

Ignore this for the moment...we'll deal with that as you define what reports you'll like to see.

Can you also tell me what Sheet Report means as it displays only heading

Hi Jaslake

I have highlighted the once that I found not reconciled with green and blue. The Green refers to Credit Card payments while the blue is Cashier Totals as well. I don't know if it is because we don't have a reference on either side that could impact it, but the values should be the same. If that is the case I am trying to see if there is any reference from both sides I can use to do the recon. That is also why I indicated that I would like to perform one month to see if any other problems are experienced, but for now all seems fine, except for the once mentioned. I don't know where the sheet report comes from as it was not part of my original file.

Going forward, I will provide you with sample of the full recon file as I have only supplied minimum information on the file to you. There is additional sheets but the main once will be the once provided with the same names every month.

Thanx again for your assistance. It is highly appreciated.
Jasper

Hi Jasper

The Code assumes YES to this (you can have extra sheets, not an issue).

Will your Month Data File ALWAYS be of the SAME Structure as your Sample File? ALWAYS same number of Columns in the SAME sequence? ALWAYS same Column Headers and ALWAYS in Row 1? ALWAYS the same Sheet Names?

Place the two attached Files in the SAME Folder. Open the Macro Book, click the Button. You'll get a Dialog to select a Data File to Open. Select a Data File. The Code will do the rest.

You're getting a couple of apparent miss matches on Credit Cards simply because the Amounts are the same.

Let me know of issues.