1. You update security prices on May 3.
2. You receive your brokerage statement on May 10.
3. The statement includes a April 21 security sale that is not entered in FN yet.
4. You enter the transaction in FN.
5. The system recognizes that the account’s ending balance does not match its balance in the month you are selling it.

quote:

---

Balance for this Account:
[xyz]
differs in a later month.

---

To find the problem:

1. Select Reports | Report Selection.
2. Select the Transactions by Account report group.
3. Select the Transactions by Account report.
4. Select the Unrealized Gains or Losses account.
5. Set the range of dates to be the month in which the problem occurred. If you are not sure of the month, select January through December.
6. Select Screen to generate the report and display it on-screen.

To correct the problem:

1. Select Transactions | Enter Transactions.
   • Month: Select the month of the security valuation
   • Category: Unrealized Gains or Losses
   • Account: Unrealized Gains or Losses
2. Select Apply to display the Unrealized Gains or Losses journal.
3. An Unrealized Gains or Losses entry appears as a normal transaction entry with the exception of the Payee field. The Payee field displays:
   • Security symbol (if applicable)
   • Revalued price per share
   • Quantity affected
4. Find the correct transaction. Select Edit | Find. Search for the security account name. Check the date, price per share, and quantity to ensure that it is the correct entry.
5. Select Edit | Delete Transaction. The security account should now have the appropriate balance.
6. Select Tools | Asset and Liability Info. The Account Selection screen appears.
7. Select the security account. Select OK to display the account’s information.
8. Select the Balances command button. The Balances for Accounts screen appears.
9. Review the account’s monthly balances to ensure they are correct.

------------------
Renée Trudeau
Financial Navigator Service Provider

1. As month-end approaches, make sure that you've entered everything and reconciled all the brokerage statements from the previous month. For example, if it's May 20th, make certain that all of your April 30th statements are reconciled and all transactions are entered up to that date.
2. Before the first trading day of the next month, access Stock Web and download and update your stock prices. In this example, you'd need to get your prices no later than May 31st. Do not wait until June to get your prices!
   
   • NOTE:If you're using Navigator Access, you can perform this download at any time. Navigator Access supports historical prices, so you can select any date. Just make sure that you select a date in the month you've yet to enter prices for. In this example, you could wait until any day before the end of June. Just make sure you specify that you want prices for May 31, and use Access Prices to Update Securities as of May 31.
   • If you're inputting prices manually, you can also gather (i.e. from the brokerage statement or the newspaper) your prices at any time -- just make sure that the prices you obtain are for May 31, and use Enter Prices to Update Securities as of May 31.
     
3. When the statement arrives, go back to the previous month and enter whatever transactions you need to enter. In this example, the statement will arrive on about June 10th. Go back to May activity and enter your transactions. Here's the key: since you updated in May, and the purchase and sale transactions are entered in May, the system won't give you that "Balance differs in later month" message.