Bank reconsolidation/Transaction Matching/OS 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.
 
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/accounting-distribution-sb.htm
http://www.popularshareware.com/Checkbook-for-Excel-screenshot-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


Is there a template or macro that can match downloaded bank information
Click to expand...
with general ledger information exported to excel. Then create an
outstanding list and list of discrepancies. Thank you.
 
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/accounting-distribution-sb.htm
http://www.popularshareware.com/Checkbook-for-Excel-screenshot-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


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