Microsoft KB Archive/838713

= The account balance does not match the balance in the register in Money =

Article ID: 838713

Article Last Modified on 10/26/2007

-

APPLIES TO


 * Microsoft Money 2005 Deluxe Edition
 * Microsoft Money 2005 Premium Edition
 * Microsoft Money 2005 Small Business Edition
 * Microsoft Money 2005 Standard Edition
 * Microsoft Money 2004 Deluxe Edition
 * Microsoft Money 2004 Premium Edition
 * Microsoft Money 2004 Small Business Edition
 * Microsoft Money 2004 Standard Edition
 * Microsoft Money 2003 Deluxe Edition
 * Microsoft Money 2003 Deluxe and Business Edition
 * Microsoft Money 2003 Standard Edition
 * Microsoft Money 2002 Standard Edition

-





SYMPTOMS
When you start one of the products that are listed in the &quot;Applies To&quot; section, you experience one or more of the following symptoms:
 * An account balance in the Account list does not match the account balance in the register.
 * The balance in the register changes when you change the view.



CAUSE
This problem may occur if one or more of the following conditions are true:
 * The balance in the Account list has not been updated.
 * The register contains a hidden transaction.

Note The &quot;hidden transaction&quot; issue was fixed in Microsoft Money 2006.



RESOLUTION
If the balance in the Account list has not been updated, update your accounts online to verify that you have the latest balance information. To do this, click Internet Updates on the Tools menu, and then click Update Now.

Note The following steps are for Microsoft Money 2005. These steps may vary if you use another version of Microsoft Money.

To resolve this problem, use the following methods in the order that they appear in.

Method 1: Repair your Money 2005 file
To repair your Money 2005 file, follow these steps:
 * 1) Start Money 2005.
 * 2) On the File menu, point to Repair Money File, and then click Quick File Repair.

For more information about how to repair a file in earlier versions of Money, click the following article number to view the article in the Microsoft Knowledge Base:

182608 You receive error messages or notice unexpected symptoms in Money

Method 2: Compare the Account Transactions report to the account register

 * 1) Start Money 2005.
 * 2) On the Reports menu, click Reports Gallery.
 * 3) Click Income and Expenses.

If you use a business version of Money, click Personal, and then click Income and Expenses.
 * 1) Double-click Account Transactions.
 * 2) In the Accounts box, click the account that you want to troubleshoot.
 * 3) In the Date Range box, click All Dates.

If the problem started recently, click Custom Dates, and then follow the instructions that appear on the screen to create a custom date range.

After you create this report, compare it with your account register to determine the differences. To do this, follow these steps:  Click Account List. Click the account that you want to compare to the Account Transactions report that you created earlier. Compare the report that you created in Method 2 to the account information that appears on the screen. If you find transactions in the Account Transactions reports that are not in the register, follow these steps:  Double-click the transaction in the Account Transactions report. On the Edit Transaction screen in the Amount box, type 0.00, and then click OK.</li> Click Mark the transaction as void, and then click OK.</li></ol> </li> Click Account List, and then click the account that you want to troubleshoot.</li> Find the transaction that you marked as void in step 4, right-click the transaction, and then click Edit.</li> Edit the transaction information, and then click OK.</li></ol>

Method 3: Export the file to Quicken Import File (QIF) format
To export the file to a QIF file, follow these steps: <ol> Make a copy of your Money 2005 file. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> On the File menu, click Backup.</li> Select a location for the backup file, and then click OK.</li></ol> </li> Open the copy of your Money 2005 file that you created in step 1. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> On the File menu, click Open.</li> In the Files of type box, click Money Backup Files (*.mbf).</li> Click the file that you created in step 1, and then click Open.</li> If you are prompted to do this, click Don't Back Up.</li> Click Browse.</li> Type a file name to determine the file as a file that you use to troubleshoot this issue--for example, Troubleshooting File, and then click OK.</li> Click Restore.</li></ol> </li> Click Account List.</li> <li>Click the account that you want to troubleshoot.</li> <li>Delete all transactions in the account that you want to troubleshoot.

To delete a transaction, right-click the transaction, click Delete, and then click Yes.</li> <li>Export the account to a QIF format file. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> <li>On the File menu, click Export.</li> <li>Click Loose QIF, and then click OK.</li> <li>Type a name for the file, and then click OK.</li> <li>Click Regular, and then click OK.</li> <li>Click the account that you want to export, and then click Continue.</li> <li>Click OK.</li></ol> </li> <li>Close Money 2005.</li> <li>Open the QIF file that you created in step 6 in Notepad. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> <li>Right-click the QIF file, point to Open With, and then click Choose Program.</li> <li>Click Notepad, and then click OK.</li></ol> </li> <li> Verify that no transactions exist in the file. If there is an entry for the opening balance, delete this transaction from the file. The entry for the opening balance resembles the following: <pre class="fixed_text">!Type:Bank D3/15'2005 T1,000.00 CX POpening Balance L[My Bank Checking] ^ </li> <li>If there are existing transactions in the file, note the details of those transactions.</li> <li>Save the file in Notepad.

To do this, click File, and then click Save.</li> <li>Close Notepad.</li> <li>Open your original Money 2005 file. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> <li>Start Money 2005.</li> <li>On the File menu, click Open.</li> <li>Click your original Money 2005 file, and then click Open.</li> <li>Click Don't Back Up.</li></ol> </li> <li>On the File menu, click Import.</li> <li>Click the QIF file that you created in step 6, and then click Import.</li> <li>Click As a statement from my bank, and then click OK.</li> <li>In the Money account name box, click the account that you want to troubleshoot, and then click Next.</li> <li>Click OK.</li> <li>Click Account List.</li> <li>Click the account that you want to troubleshoot.</li> <li>Verify the transactions that you noted in step 10 appear in the register.</li> <li>Compare the transactions in the register to the account transaction report.</li></ol>

Additional query words: balance reconcile file management fix

Keywords: kbrepair kbui kbprb KB838713

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.