Bank reconsolidation/Create Outstanding list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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.
Sam Grunstein said:
Is there a template or macro that can match downloaded bank
Click to expand...
information with general ledger information exported to excel. Then
create an outstanding list and list of discrepancies. Thank you.
 
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.
Sam Grunstein said:
Is there a template or macro that can match downloaded bank
Click to expand...
information with general ledger information exported to excel. Then
create an outstanding list and list of discrepancies. Thank you.
 
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


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Bank reconsolidation/Transaction Matching/OS List 4
Bank reconsolidation/Transaction Matching/OS List 1
Help to create a macro 2
Macro for Bank Reconciliation 2
Print a Statement from a list 1
Alert messages, running totals, connecting spreadsheets or cells 1
Calculations based on cell colour 6
Using Sumproduct with Headers 5

Back
Top