Investing Center and Net Worth tallies are off (Q2007)

Not a lot of information there. How did you determine that they are off? Are all accounts being included in the total? Are all accounts correct? did it just change from a different figure?

Thanks for helping out Jim!

"How did you determine that they are off? "

The problem is in the Investing Center I have seven accounts there.

If I take the totals displayed on my Home page summary (left side of screen) for each account and add them up, I get a total that is about $50,000 LESS than the total that is displayed just below these seven accounts.

Further, the Net Worth at the bottom of the left summary also is about $50,000 more than it should be.

"Are all accounts being included in the total?"

I believe they are. I have no idea of finding out if they are or are not.

"Are all accounts correct?" Yes, that's the strange part. The total for each account is correct in the accounts summary, as mentioned above.

I have just 'improved' the inaccuracy by doing a few 'updating placeholder values'.

But after doing this I still have the same basic problem.

In my problem account, the total Securities Value at the bottom is correct. Same for the total Cash Balance. The Total Market Value also shows correctly.

That same number is copied to the summary column at the left of the screen.

BUT... when the seven accounts are added together they are inflated now by about $30,000 !!!

Have you tried re-open &/or reboot? On very rare occassions, I "think" I recall issues that I attributed to memory problems & a reboot (or just a re-open) would cure it.

The algorithm to show the final balances for each account may be different for the Accounts Bar vs. the Investment Summary. Try checking to make sure Q hasn't grabbed some bogus $/share value in the future. One might grab the current price & the other the latest date it finds (which could be in the future).

Thanks for helping out Bartt! Yes I tried to re-open and re-boot. That didn't change anything.

I checked the $/share values in the future etc. Nothing shows up. I'm still out more than $30,000 now.

It's quite frustrating.

Have you validated the file?

I'm in Q2011, so the path may not be exactly the same, but File>>File Operations>>Validate and Repair...

Thx, Bartt

Yes I did validate the file but it didn't help. I'm running out of options now.

I contacted Intuit by phone but they weren't any help. The fellow I spoke with said he wasn't familiar with 2007.

I'm going to try to delete practically everything from the account that I believe is the problem one and see if it makes any difference.

You could also try recalculating the register(s).

Open the investment account "register" (or "Transaction List"); put your cursor in the list of transactions, hold down CTRL while pressing the character "Z".

This may be a bit more work that necessary, though deleting and re-entering investment transactions can sometimes correct a problem.

You might try walking the Portfolio view back in time (changing the "As of" date) until you find a time when things are in sync. Then look at the transactions that occurred around that time; consider deleting and re-entering those transactions.

Thanks for helping out John!

By this time I had already deleted pretty much all the transactions in the account (I have a backup), but it didn't help.

I believe I might have made a breakthrough here, but don't know how to close the deal.

I don't know how I got to this screen but it showed my accounts and revealed that I had 26,273.00 as Unclassified (Asset class).

I don't know how to get to that unclassified class and deal with it. (Remove it).

TIA.

snipped-for-privacy@yahoo.com; wrote

By this time I had already deleted pretty much all the transactions in the account (I have a backup), but it didn't help.

I believe I might have made a breakthrough here, but don't know how to close the deal.

I don't know how I got to this screen but it showed my accounts and revealed that I had 26,273.00 as Unclassified (Asset class).

I don't know how to get to that unclassified class and deal with it. (Remove it).

------------------------------------------

I confess to being confused about exactly what you're seeing, so I haven't tried to offer any specifics before. But your reply opens a small door.

Asset classes are controlled at the security level; you can change asset class breakdowns by Editing a security in the Security List and clicking the Define button.

Normally, you get asset classes downloaded when you do a One Step Update; the same part of the OSU process that gets quotes, gets asset classes for your securities. If you don't agree with the downloaded asset class breakdown, or you don't get any breakdown, you can set it manually in the Security List. If you want the manually set breakdown to stick, you should uncheck the box to "Download asset class info".

You can see asset class breakdowns with values computed in: Reports > Investment Asset Allocation. You can customize the report to display a single account, or a single security, if you are trying to narrow down a problem.

Having said that, I don't see how re-allocating asset classes can change the total market value. In the end, 100% must be allocated to some asset class ... "unclassified" is just a catch-all.

My original inclination was to think you were looking at values from different dates; either different report/display "as of" dates, or that a future dated price/share was affecting some of the values. But you seem to have refuted that notion.

The only other thought I have is to try walking back something like the Investing > Portfolio display, changing the "as of" date until you find a date where values look correct. Then look at (and consider deleting and re-entering) transactions on, or soon after, the last date when values were correct.

Thanks John. I just don't know what to say anymore, this is so frustrating.

You were right about defining an asset class. It didn't help at all. It just shifted the amount to a different category.

I can pull up a whole bunch of different views now and in each one the subtotal for this group of accounts is whacky!

If I go to Financial Overview/ Net Worth

It shows a year by year breakdown, from 2008-to 2011

In the Financial Overview/ Net Worth view it shows the correct totals for all accounts except the screwed up one.

It then gives the false Net Worth total for 2011.

BUT.... when you look at the summary of accounts on the left side of the main screen, the 'screwed up account' shows the correct total!

The subtotal however for all of the Investing center accounts is off , as is the Net Worth total.

:(

Well I figured out the problem just now and am quite surprised that no one suggested I try this.

The problem account was in U.S. dollars. I live in Canada and so all of my other accounts are in $Can. The exchange rate that Quicken was using was way out of date (around .