Money: How to Create a Bank Statement Report (176329)


The information in this article applies to:

  • Microsoft Money 2004 Deluxe
  • Microsoft Money 2003 Deluxe
  • Microsoft Money 2003 Deluxe and Business
  • Microsoft Money 2003 Standard
  • Microsoft Money 2002
  • Microsoft Money 2001
  • Microsoft Money 2000
  • Microsoft Money 99
  • Microsoft Money 98
  • Microsoft Money 97
  • Microsoft Money 2000 Business and Personal
  • Microsoft Money 98 Deluxe Edition
  • Microsoft Money 98 Financial Suite
This article was previously published under Q176329

SUMMARY

Money does not have an option to print out a report after balancing your account. You can customize an Account Transaction report, and then export the report into a spreedsheet program to work with the information.

MORE INFORMATION

To customize your Account Transaction report to look more like a bank statement, use the appropriate method for your version of Money.

Money 2003, Money 2002, Money 2001, and Money 2000

  1. On the Money navigation bar, click Reports.

    In Money 2001, click Reports, and then click Reports Gallery.
  2. In the left pane, click Spending Habits.
  3. In the list of reports, double-click Account Transactions.
  4. After the report opens, click Customize at the bottom of the screen.
  5. Click the Rows & Columns tab, and then click to select the Cleared status check box and the Category check box.
  6. In the Subtotal by list, click None.

    Note Subtotal by months is easier to read on your screen and makes for a nicer printed report, but it also makes it more difficult to sort after the file has been exported.
  7. Click the Date tab, and then select the date range you want.
  8. Click the Account tab, click Clear All, and then select each account you want to include in the report.
  9. Click the Text tab and make sure that the Find transactions with this text box is empty.
  10. Click the Category tab and make sure that all categories are selected.
  11. Click the Payee tab and make sure that all payees are selected.
  12. Click the Details tab and make sure that All Types is selected in the Type list, and that Reconciled & Unreconciled is selected in the Status list, and then click OK.

    Note You can customize this report in three different ways; Both Reconciled & Unreconciled, only Reconciled Transactions, or only Unreconciled Transactions.

Microsoft Money 99

  1. On the navigation bar, click Reports.
  2. In the left pane, click Spending Habits.
  3. In the list of reports, double-click Account Transactions.
  4. After the report opens, click Customize at the bottom of the screen.
  5. Click the Rows & Columns tab, and then click to select the Cleared status check box and the Category check box.
  6. In the Subtotal by list, click None.

    Note Subtotal by months is easier to read on your screen and makes for a nicer printed report, but it also makes it more difficult to sort after the file has been exported.
  7. Click the Date tab, and then select the date range you want.
  8. Click the Account tab, click Clear All, and then select each account you want to include in the report.
  9. Click the Text tab and make sure that the Find transactions with this text box is empty.
  10. Click the Category tab and make sure that all categories are selected.
  11. Click the Payee tab and make sure that all payees are selected.
  12. Click the Details tab and make sure that All Types is selected in the Type list, and that Reconciled & Unreconciled is selected in the Status list, and then click OK.

    Note You can customize this report in three different ways; Both Reconciled & Unreconciled, only Reconciled Transactions, or only Unreconciled Transactions.
  13. Click Apply, and then click OK to see your report.

Microsoft Money 98 and Earlier

  1. On the navigation bar in Money 98, click Reports.

    In Money 4.0 and 5.0, click Go To, and then click Report and Chart Gallery.
  2. In the list of reports for Spending Habits, double-click Account Transactions, and click Customize.
  3. Under Include Fields, click to select Cleared Flag and Category.
  4. In the Subtotal by list, click None.

    Note Subtotal by months is easier to read on your screen and makes for a nicer printed report, but it also makes it more difficult to sort after the file has been exported.
  5. Select the date range that you want.
  6. Under Include Transactions From Account, click to select your account from the list.
  7. Click Select Transactions, click the Text tab, and then make sure the Find Transactions With This Text box is empty.
  8. Click the Categories tab and make sure that All Categories is selected.
  9. Click the Payee tab, and then make sure that All Payees is selected.
  10. Click the Details tab.
  11. Make sure that Transaction Type is set to All Types and that Status is set to Reconciled & Unreconciled, and then click OK.

    Note You can customize this report in three different ways; Both Reconciled & Unreconciled, only Reconciled Transactions, or only Unreconciled Transactions.
  12. Click View to see the results.
To further sort your information, you can export the report as a text file, and then open the file in a spreadsheet program, such as Microsoft Excel.

Import into Excel

To import the text file into Excel, use the appropriate method for your version of Money.

Money 2000 and Money 99

  1. After you create the custom report with the steps described earlier, right-click the report, and then click Export.
  2. In the Save In list, click to select a location to which you want to save the file. The default location is the My Documents folder.

    Note The file is saved as a Text File (.txt) in the Save as Type.
  3. Start Excel.
  4. On the File menu, click Open, and then locate the folder where you saved the report.
  5. In the Files of type list, click to select Text Files.
  6. In the Text Import wizard, click Finish.
  7. Click to select a cell in the Num column, on the Data menu, and then click Sort.

    Sort by should say Num (Ascending). This will sort the column that contains the check numbers.

    Note Sorting by the Num column is more useful when you have other items typed in that column such as: ATM, Debit, or Deposit; as well as the check numbers.
  8. You can choose to do a secondary sort by any of the other columns.

    Click the arrow under Then By, click Date or any column you want, and then click OK.

Money 98 and Money 5.0

  1. After you create the custom report with the steps described earlier, click Export.
  2. In the Save In list, click to select a location to which you want to save the file. The default location is the Program Files\Microsoft Money folder.

    Note that the file is saved as Text File (.txt) in Save File as Type.
  3. Start Excel.
  4. On the File menu, click Open, and then locate the folder where you saved the report.
  5. In the Files Of Type list, click to select Text Files.
  6. In the Text Import wizard, click Finish.
  7. Click to select a cell in the Num column on the Data menu, and then click Sort.

    Sort by should say Num (Ascending). This will sort the column that contains the check numbers.

    Note Sorting by the Num column is more useful when you have other items typed in that column such as: ATM, Debit, or Deposit; as well as the check numbers.
  8. You can choose to do a secondary sort by any of the other columns. Click the arrow under Then By, click Date or any column that you want, and then click OK.
Modification Type:MajorLast Reviewed:1/5/2005
Keywords:kbhowto KB176329
©2004 Microsoft Corporation. All rights reserved.