Bank reconsolidation/Create Outstanding list

[Sam Grunstein]

Is there a template or macro that can match downloaded bank information with general ledger information exported to excel. Then create an outstanding list and list of discrepancies. Thank you.

 

[whisperer]

If your downloaded bank information is in the form of a text or csv fil
then both can be imported directly to Excel.

Comparison then is relatively easy if both sets of information star
with a date field for instance

 

[Norman Harker]

Hi Sam!

It's unlikely that there will be such a template because different
banks record the data in different ways.

If you can convert the downloaded data and the general ledger
information to an Excel workbook, then there are formulas that will
allow you to compare. See especially:

Chip Pearson:
http://www.cpearson.com/excel/duplicat.htm

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

Is there a template or macro that can match downloaded bank

information with general ledger information exported to excel. Then
create an outstanding list and list of discrepancies. Thank you.

 

[Sam Grunstein, CPA]

Thank you, this site has a lot of usefull information about excel

----- Norman Harker wrote: -----

Hi Sam!

It's unlikely that there will be such a template because different
banks record the data in different ways.

If you can convert the downloaded data and the general ledger
information to an Excel workbook, then there are formulas that will
allow you to compare. See especially:

Chip Pearson:
http://www.cpearson.com/excel/duplicat.htm

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

Is there a template or macro that can match downloaded bank

information with general ledger information exported to excel. Then
create an outstanding list and list of discrepancies. Thank you.

 

[Norman Harker]

Hi Sam!

Agreed! One of the very best.

You might also like to bookmark:

Dave McRitchie
http://www.mvps.org/dmcritchie/excel/xlindex.htm

John Walkenbach
http://j-walk.com/ss/excel/index.htm

That should keep you busy for a long time over Christmas / New Year!

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[PC Datasheet]

Sam,

Contact me at the email address below if you haven't found a solution.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

Is there a template or macro that can match downloaded bank information with

general ledger information exported to excel. Then create an outstanding list
and list of discrepancies. Thank you.