Create Macro for Bank Recon

[imniinaaa]

Hi everyone,

I am a newbie. I know there are many of topics out there already with this question. But, I am still a little unclear and confused. Could someone please help me understand and create macro to use for bank rec?

[Mumps1]

See if the attached file helps.

[imniinaaa]

Thank you for your help. I was trying to follow this and hope to create something similar this topic: excel-programming-vba-macros/1031811-vba-macro-to-simplify-large-bank-reconciliation

Instead of check date, I would have "Date" and "Amount" from Bank Statement and General Ledger. I was hoping to create a Macro that would generate O/S from G/L and Bank. I am trying to learn and understand VBA/Macro and I am really lost.

[Mumps1]

Could you attach a copy of your file. Explain in detail what you want to do referring to specific cells, rows, columns and sheets.

[imniinaaa]

Hi, I am sorry about the late reply. I cant attach a file for some reason.

I attached an image would that work? Screen Shot 2018-12-12 at 10.50.51 PM.png

[Mumps1]

I would need to know what calculations are involved in generating O/S from G/L and Bank. Perhaps you could use a few examples from your data and explain referring to specific cells explaining how they are used in the calculation.

[imniinaaa]

The number/data from GL and Statement would already be given. Basically I just need to match data from Statement and GL and highlight those that dont have a match. The problem is that sometimes 2 amounts from Statement would = to 1 amount from GL. I have been trying to find a way that would help cut down the time since I have been matching them manually.

[Mumps1]

Please explain using a few example from your data referring to specific cells and also what the expected results would look like in the two section on the right.

[imniinaaa]

Thank you for being patient and trying to help me! I really am appreciated your help.

So,I would have data from Statement and GL with date and amount.

Statement

1/01/2018--$33,852.41 cr
1/25/2018-- $40,000 cr
1/27/2018-- $45,000 cr
1/29/2018-- ($65,000)dr


GL
1/1/2018-- $33,852.41 dr
1/15/2018--$26,000 dr
1/29/2018-- $95,000 dr
1/30/2018-- ($100,000) cr


I was hoping the result from Macro would show only what is outstanding.

Statement
1/29/2018-- ($65,000)dr


GL
1/15/2018--$26,000 dr
1/30/2018-- ($100,000) cr

[Mumps1]

So you want all the values in brackets form column B to go to column L and those from column E go to column O as well as the corresponding dates. Is this correct?

[imniinaaa]

For the outstanding items, yes!

[Mumps1]

For some reason the screenshot you posted in Post #5 is no longer visible. Perhaps you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Include a detailed explanation of what you would like to do using a few examples from your data and referring to specific cells, rows, columns and worksheets. If the workbook contains confidential information, you could replace it with generic data.