Portfolio Cash Question

#6 06-23-2008, 05:32 AM

Hi Scott,

The starting balance for cash is zero. I ran the report as you suggested
and it shows the cash balance as of 1/31/04 to be the same as the cash
transactions register - both are correct. It is only the cash amount on the
portfolio screen that is wrong.

Other ideas?

"Scott Tyler" wrote:

- quote -

> Try going to "Change Account Details". Scroll halfway down and check the
> starting balance for the cash portion.
> Try going to "Reports", "Income and Expenses", "Account Transactions".
> Customize the report to include only the investment cash account, include
> all payees and categories, all transaction types and splits, running balance
> using total of prior transactions.
> "flame1" <flame1[at]discussions.microsoft.com> wrote in message
> news:BCCA40D5-1224-48A9-A0A1-F3092A2F7E18[at]microsoft.com...
> > I'm looking at the "running balance" in the cash transactions register.
> > I'm
> > finally forcing myself to clean up my files and get everything balanced
> > against the statement so I'm backing up to 2003 data. If I look at the
> > balance in the far-right column of the cash transactions account as of
> > 12/31/03, it agrees with my statement balance but the "cash ($)" line on
> > the
> > portfolio as of 12/31/03 has the negative number.
> > > Any other ideas?
> > > "Cal Learner-- MVP" wrote:
> > > > See below.
> > > > > In microsoft.public.money, flame1 wrote:
> > > > > > After reading about the standard repair, I tried that too. It did make
> > > > one
> > > > repair ("fixed records in online table"), but the portfolio page still
> > > > shows
> > > > the negative $28k. Any other suggestions?
> > > > > > > "flame1" wrote:
> > > > > > > > Unfortunately, it didn't work. Should I try standard file repair?
> > > > > > > > > "Cal Learner-- MVP" wrote:
> > > > > > > > > > In microsoft.public.money, flame1 wrote:
> > > > > > > > > > > > I have an investment account that I think has a problem. I have
> > > > > > > entered both
> > > > > > > investment transactions and also some cash only transactions (in
> > > > > > > the
> > > > > > > associated cash account.) When I look at the cash account, it
> > > > > > > balances to
> > > > > > > the cash amount on my statement (which is about $1400),
> > > > > Make sure you are looking at the "Ending Balance" rather than the
> > > "Bank Balance" in the cash transactions register.
> > > > > > > > > > > > but when I look at
> > > > > > > the portfolio screen, the "Cash ($)" line shows a value of
> > > > > > > ($28,417.32) - a
> > > > > > > negative number - under the Market Value column.
> > > > > > > > > > > > > I have not been able to figure out where this number is coming
> > > > > > > from. I
> > > > > > > checked my other accounts to see if any were sourcing the cash from
> > > > > > > this
> > > > > > > account in error but found nothing. Then I tried changing the "As
> > > > > > > of" date
> > > > > > > on the portfolio screen to try to narrow down when the problem
> > > > > > > started, but
> > > > > > > the negative number doesn't go away. The account was opened in
> > > > > > > 2003. I put
> > > > > > > in an "as of" date of 1950 just for grins and it still shows the
> > > > > > > negative
> > > > > > > number on the cash line. Any suggestions?
> > > > > > > > > > > Try File-> RepairMoneyFile-> QuickFileRepair.
> > > > > > >

#5 06-23-2008, 05:07 AM

Try going to "Change Account Details". Scroll halfway down and check the
starting balance for the cash portion.

Try going to "Reports", "Income and Expenses", "Account Transactions".
Customize the report to include only the investment cash account, include
all payees and categories, all transaction types and splits, running balance
using total of prior transactions.

"flame1" <flame1[at]discussions.microsoft.com> wrote in message
news:BCCA40D5-1224-48A9-A0A1-F3092A2F7E18[at]microsoft.com...
- quote -

> I'm looking at the "running balance" in the cash transactions register.
> I'm
> finally forcing myself to clean up my files and get everything balanced
> against the statement so I'm backing up to 2003 data. If I look at the
> balance in the far-right column of the cash transactions account as of
> 12/31/03, it agrees with my statement balance but the "cash ($)" line on
> the
> portfolio as of 12/31/03 has the negative number.
> Any other ideas?
> "Cal Learner-- MVP" wrote:
> > See below.
> > > In microsoft.public.money, flame1 wrote:
> > > > After reading about the standard repair, I tried that too. It did make
> > > one
> > > repair ("fixed records in online table"), but the portfolio page still
> > > shows
> > > the negative $28k. Any other suggestions?
> > > > > "flame1" wrote:
> > > > > > Unfortunately, it didn't work. Should I try standard file repair?
> > > > > > > "Cal Learner-- MVP" wrote:
> > > > > > > > In microsoft.public.money, flame1 wrote:
> > > > > > > > > > I have an investment account that I think has a problem. I have
> > > > > > entered both
> > > > > > investment transactions and also some cash only transactions (in
> > > > > > the
> > > > > > associated cash account.) When I look at the cash account, it
> > > > > > balances to
> > > > > > the cash amount on my statement (which is about $1400),
> > > Make sure you are looking at the "Ending Balance" rather than the
> > "Bank Balance" in the cash transactions register.
> > > > > > > but when I look at
> > > > > > the portfolio screen, the "Cash ($)" line shows a value of
> > > > > > ($28,417.32) - a
> > > > > > negative number - under the Market Value column.
> > > > > > > > > > > I have not been able to figure out where this number is coming
> > > > > > from. I
> > > > > > checked my other accounts to see if any were sourcing the cash from
> > > > > > this
> > > > > > account in error but found nothing. Then I tried changing the "As
> > > > > > of" date
> > > > > > on the portfolio screen to try to narrow down when the problem
> > > > > > started, but
> > > > > > the negative number doesn't go away. The account was opened in
> > > > > > 2003. I put
> > > > > > in an "as of" date of 1950 just for grins and it still shows the
> > > > > > negative
> > > > > > number on the cash line. Any suggestions?
> > > > > > > > > Try File-> RepairMoneyFile-> QuickFileRepair.
> > > > >

#4 06-23-2008, 04:22 AM

I'm looking at the "running balance" in the cash transactions register. I'm
finally forcing myself to clean up my files and get everything balanced
against the statement so I'm backing up to 2003 data. If I look at the
balance in the far-right column of the cash transactions account as of
12/31/03, it agrees with my statement balance but the "cash ($)" line on the
portfolio as of 12/31/03 has the negative number.

Any other ideas?

"Cal Learner-- MVP" wrote:

- quote -

> See below.
> In microsoft.public.money, flame1 wrote:
> > After reading about the standard repair, I tried that too. It did make one
> > repair ("fixed records in online table"), but the portfolio page still shows
> > the negative $28k. Any other suggestions?
> > > "flame1" wrote:
> > > > Unfortunately, it didn't work. Should I try standard file repair?
> > > > > "Cal Learner-- MVP" wrote:
> > > > > > In microsoft.public.money, flame1 wrote:
> > > > > > > > I have an investment account that I think has a problem. I have entered both
> > > > > investment transactions and also some cash only transactions (in the
> > > > > associated cash account.) When I look at the cash account, it balances to
> > > > > the cash amount on my statement (which is about $1400),
> Make sure you are looking at the "Ending Balance" rather than the
> "Bank Balance" in the cash transactions register.
> > but when I look at
> > > > > the portfolio screen, the "Cash ($)" line shows a value of ($28,417.32) - a
> > > > > negative number - under the Market Value column.
> > > > > > > > > I have not been able to figure out where this number is coming from. I
> > > > > checked my other accounts to see if any were sourcing the cash from this
> > > > > account in error but found nothing. Then I tried changing the "As of" date
> > > > > on the portfolio screen to try to narrow down when the problem started, but
> > > > > the negative number doesn't go away. The account was opened in 2003. I put
> > > > > in an "as of" date of 1950 just for grins and it still shows the negative
> > > > > number on the cash line. Any suggestions?
> > > > > > > Try File-> RepairMoneyFile-> QuickFileRepair.
> > >

#3 06-23-2008, 03:30 AM

See below.

In microsoft.public.money, flame1 wrote:

- quote -

> After reading about the standard repair, I tried that too. It did make one
> repair ("fixed records in online table"), but the portfolio page still shows
> the negative $28k. Any other suggestions?
> "flame1" wrote:
> > Unfortunately, it didn't work. Should I try standard file repair?
> > > "Cal Learner-- MVP" wrote:
> > > > In microsoft.public.money, flame1 wrote:
> > > > > > I have an investment account that I think has a problem. I have entered both
> > > > investment transactions and also some cash only transactions (in the
> > > > associated cash account.) When I look at the cash account, it balances to
> > > > the cash amount on my statement (which is about $1400),

Make sure you are looking at the "Ending Balance" rather than the
"Bank Balance" in the cash transactions register.

- quote -

> but when I look at
> > > > the portfolio screen, the "Cash ($)" line shows a value of ($28,417.32) - a
> > > > negative number - under the Market Value column.
> > > > > > > I have not been able to figure out where this number is coming from. I
> > > > checked my other accounts to see if any were sourcing the cash from this
> > > > account in error but found nothing. Then I tried changing the "As of" date
> > > > on the portfolio screen to try to narrow down when the problem started, but
> > > > the negative number doesn't go away. The account was opened in 2003. I put
> > > > in an "as of" date of 1950 just for grins and it still shows the negative
> > > > number on the cash line. Any suggestions?
> > > > > Try File-> RepairMoneyFile-> QuickFileRepair.
> >

#2 06-23-2008, 02:29 AM

After reading about the standard repair, I tried that too. It did make one
repair ("fixed records in online table"), but the portfolio page still shows
the negative $28k. Any other suggestions?

"flame1" wrote:

- quote -

> Unfortunately, it didn't work. Should I try standard file repair?
> "Cal Learner-- MVP" wrote:
> > In microsoft.public.money, flame1 wrote:
> > > > I have an investment account that I think has a problem. I have entered both
> > > investment transactions and also some cash only transactions (in the
> > > associated cash account.) When I look at the cash account, it balances to
> > > the cash amount on my statement (which is about $1400), but when I look at
> > > the portfolio screen, the "Cash ($)" line shows a value of ($28,417.32) - a
> > > negative number - under the Market Value column.
> > > > > I have not been able to figure out where this number is coming from. I
> > > checked my other accounts to see if any were sourcing the cash from this
> > > account in error but found nothing. Then I tried changing the "As of" date
> > > on the portfolio screen to try to narrow down when the problem started, but
> > > the negative number doesn't go away. The account was opened in 2003. I put
> > > in an "as of" date of 1950 just for grins and it still shows the negative
> > > number on the cash line. Any suggestions?
> > > Try File-> RepairMoneyFile-> QuickFileRepair.
>

#1 06-23-2008, 02:05 AM

Unfortunately, it didn't work. Should I try standard file repair?

"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, flame1 wrote:
> > I have an investment account that I think has a problem. I have entered both
> > investment transactions and also some cash only transactions (in the
> > associated cash account.) When I look at the cash account, it balances to
> > the cash amount on my statement (which is about $1400), but when I look at
> > the portfolio screen, the "Cash ($)" line shows a value of ($28,417.32) - a
> > negative number - under the Market Value column.
> > > I have not been able to figure out where this number is coming from. I
> > checked my other accounts to see if any were sourcing the cash from this
> > account in error but found nothing. Then I tried changing the "As of" date
> > on the portfolio screen to try to narrow down when the problem started, but
> > the negative number doesn't go away. The account was opened in 2003. I put
> > in an "as of" date of 1950 just for grins and it still shows the negative
> > number on the cash line. Any suggestions?
> Try File-> RepairMoneyFile-> QuickFileRepair.

06-23-2008, 01:49 AM

In microsoft.public.money, flame1 wrote:

- quote -

> I have an investment account that I think has a problem. I have entered both
> investment transactions and also some cash only transactions (in the
> associated cash account.) When I look at the cash account, it balances to
> the cash amount on my statement (which is about $1400), but when I look at
> the portfolio screen, the "Cash ($)" line shows a value of ($28,417.32) - a
> negative number - under the Market Value column.
> I have not been able to figure out where this number is coming from. I
> checked my other accounts to see if any were sourcing the cash from this
> account in error but found nothing. Then I tried changing the "As of" date
> on the portfolio screen to try to narrow down when the problem started, but
> the negative number doesn't go away. The account was opened in 2003. I put
> in an "as of" date of 1950 just for grins and it still shows the negative
> number on the cash line. Any suggestions?

Try File-> RepairMoneyFile-> QuickFileRepair.

#-1 06-23-2008, 01:45 AM

I have an investment account that I think has a problem. I have entered both
investment transactions and also some cash only transactions (in the
associated cash account.) When I look at the cash account, it balances to
the cash amount on my statement (which is about $1400), but when I look at
the portfolio screen, the "Cash ($)" line shows a value of ($28,417.32) - a
negative number - under the Market Value column.

I have not been able to figure out where this number is coming from. I
checked my other accounts to see if any were sourcing the cash from this
account in error but found nothing. Then I tried changing the "As of" date
on the portfolio screen to try to narrow down when the problem started, but
the negative number doesn't go away. The account was opened in 2003. I put
in an "as of" date of 1950 just for grins and it still shows the negative
number on the cash line. Any suggestions?

Similar Threads
Thread	Forum	Replies	Last Post
Customizing Portfolio Manager question John: Hello! In MS Money 2006 Portfolio Manager (PM), one of my column headers is "Last tran.". The tooltip for this says "Date of the last...	Microsoft Money	1	10-08-2006 08:47 PM
Question about (gains/losses) in the Portfolio Manager DL Browne: On July 17, I bought 0.3808 shares of Vanguard Viper at 120.79. As of today, the stock prices is 122.01 yet under the gain column it lists (3.54)....	Microsoft Money	2	07-29-2005 01:45 AM
Money 2004 shows more cash in Portfolio and Acocunt Views than in the Cash Account Itself Ted Kulinski: I transferred some money to my brokerage account from checking. Everything was OK initially, but since I downloaded from the broker: the cash...	Microsoft Money	2	12-07-2004 12:37 AM
Portfolio in M05 question. *****noone*******: OK, I don't make a ton of money. At this point I can barely afford to contribute anything to my 401k. But I have a problem that I can't seem to...*	Microsoft Money	1	10-15-2004 04:05 PM
Money 2003 - Portfolio Question bob bad: I seem to be stuck in Portfolio nightmare. I have created 4 seperate portfolio accounts as IRA Roth - B, IRA Roth - J, IRA - B and IRA - J. When...	Microsoft Money	4	07-22-2003 01:33 PM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode