1. Required Software
You will need either Microsoft Excel or Open Office Calc (free, reads Excel data) and Microsoft Money installed on your computer to create a bank statement report.2. Customize the Account Transaction Report in Money
Use How to Create a Bank Statement Report from the Microsoft Help and Support knowledge base for a work-around to printing a bank statement or reconciliation report directly from Money.This tutorial covers Microsoft Money 5.0 and Microsoft Money 98 - 2003, but the directions can be used for Money 2004 and later. If you use a later version of Microsoft Money, the difference will be in how you access the Account Transactions report.
To get to the Account Transaction report in more recent versions of Microsoft Money, like Money Plus:
- Click on the Reports tab at the of the screen.
- Under Income and expenses, click on Account transactions.
- Follow the steps in How to Create a Bank Statement Report.
3. Options for Importing Money Data to Excel
Use one of these options to import data from Microsoft Money to Excel.
- Use the free Excel add-in, MoneyLink, to import your data to Excel.
- Directions from Microsoft for importing data into Excel 2003.
- Directions from Microsoft for importing data into Excel 2007.
4. Customize the Account Transaction Report in Money
Use How to Create a Bank Statement Report from the Microsoft Help and Support knowledge base for a work-around to printing a bank statement or reconciliation report directly from Money.This tutorial covers Microsoft Money 5.0 and Microsoft Money 98 - 2003, but the directions can be used for Money 2004 and later. If you use a later version of Microsoft Money, the difference will be in how you access the Account Transactions report.
To get to the Account Transaction report in more recent versions of Microsoft Money, like Money Plus:
- Click on the Reports tab at the of the screen.
- Under Income and expenses, click on Account transactions.
- Follow the steps in How to Create a Bank Statement Report.
5. Customize the Account Transaction Report in Money
Use How to Create a Bank Statement Report from the Microsoft Help and Support knowledge base for a work-around to printing a bank statement or reconciliation report directly from Money.This tutorial covers Microsoft Money 5.0 and Microsoft Money 98 - 2003, but the directions can be used for Money 2004 and later. If you use a later version of Microsoft Money, the difference will be in how you access the Account Transactions report.
To get to the Account Transaction report in more recent versions of Microsoft Money, like Money Plus:
- Click on the Reports tab at the of the screen.
- Under Income and expenses, click on Account transactions.
- Follow the steps in How to Create a Bank Statement Report.
