Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Bank reconsolidation/Transaction Matching/OS List

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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 74
Default Bank reconsolidation/Transaction Matching/OS List

Hi Sam,

Although I don't know of any ~free~ "general ledger" templates or macros
that addresses your needs, I did find some other solutions when I used "bank
ledger download excel" (without the quotes) as a search in Google and got a
few hits. Here are a couple:

http://www.ozgrid.com/Services/accou...ibution-sb.htm
http://www.popularshareware.com/Chec...hot-10512.html

However, you might find more specialized software to be better suited to
your needs:

Microsoft Money: http://www.microsoft.com/money/default.asp
Intuit Quicken: http://www.intuit.com/

Both of these packages retail for less than $100. You can go nuts
downloading information from banks and categorizing as you see fit. I
believe both packages can export data to Excel. But you have to check and
verify that assumption.

Hope my answer provides some food for thought.

Regards,
Kevin


<Sam Grunstien; "Cpa" wrote in message
...
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.


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Bank reconsolidation/Transaction Matching/OS List

Thank you for your reply. I checked these out the problem they don't compare lists you have to do that manually. In Excel it should be easy to compare two lists that are in Excel format to do a bank Rec.

----- Kevin Stecyk wrote: -----

Hi Sam,

Although I don't know of any ~free~ "general ledger" templates or macros
that addresses your needs, I did find some other solutions when I used "bank
ledger download excel" (without the quotes) as a search in Google and got a
few hits. Here are a couple:

http://www.ozgrid.com/Services/accou...ibution-sb.htm
http://www.popularshareware.com/Chec...hot-10512.html

However, you might find more specialized software to be better suited to
your needs:

Microsoft Money: http://www.microsoft.com/money/default.asp
Intuit Quicken: http://www.intuit.com/

Both of these packages retail for less than $100. You can go nuts
downloading information from banks and categorizing as you see fit. I
believe both packages can export data to Excel. But you have to check and
verify that assumption.

Hope my answer provides some food for thought.

Regards,
Kevin


<Sam Grunstien; "Cpa" wrote in message
...
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.



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,824
Default Bank reconsolidation/Transaction Matching/OS List

Chip Pearson has a bunch of techniques (both helpful worksheet formulas and
macros) at:

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

I'd use the worksheet formulas in helper columns and then Data|Filter|autofilter
by that helper column (to find the differences).


Sam Grunstien, Cpa wrote:

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.


--

Dave Peterson

  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default http://www.cpearson.com/excel/duplicat.htm

Thank you it was helpful I see the site has a lot of tips
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Matching items in 2 list to consolidate to one list hot dogs Excel Discussion (Misc queries) 2 April 25th 07 04:01 PM
matching Check # for Bank Reconciliation through Excel kanamohyd Excel Worksheet Functions 1 December 31st 06 03:21 PM
Pulling weekly data out of transaction list? GeorgeM Excel Worksheet Functions 2 December 16th 06 12:41 AM
Transaction type/ Transaction amount in two separate columns Mike New Users to Excel 5 November 9th 06 02:38 PM
Copy # fm one list to matching id in list 2? Curalice Excel Worksheet Functions 3 February 10th 06 09:33 PM


All times are GMT +1. The time now is 11:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"