S
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.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
W
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
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
N
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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
create an outstanding list and list of discrepancies. Thank you.
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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
information with general ledger information exported to excel. ThenSam Grunstein said:Is there a template or macro that can match downloaded bank
create an outstanding list and list of discrepancies. Thank you.
S
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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
create an outstanding list and list of discrepancies. Thank you.
----- 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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
information with general ledger information exported to excel. ThenSam Grunstein said:Is there a template or macro that can match downloaded bank
create an outstanding list and list of discrepancies. Thank you.
N
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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
P
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
[email protected]
www.pcdatasheet.com
and list of discrepancies. Thank you.
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
[email protected]
www.pcdatasheet.com
general ledger information exported to excel. Then create an outstanding listSam Grunstein said:Is there a template or macro that can match downloaded bank information with
and list of discrepancies. Thank you.