Sweep Account Downloads Zero Amount Q2005P

My main file has several brokerage accounts with linked cash accounts, which are all old accounts that were converted automatically by Quicken when I upgraded to new versions. One brokerage account, UBS, downloads zero dividend each month on the sweep money market fund. The download goes into the linked cash account as it should and is correctly categorized as _DivInc. But the dollar amount is zero each time, and Quicken won't let me revise it. I have to delete the entire zero dollar transaction and manually enter a new one with the correct amount. This problem started several months ago, about the time when I upgraded to Q2005, although I'm not sure it is associated with the upgrade.

As a test I created a new file with only a UBS brokerage and linked checking account. When I asked it to download it pulled in all the transactions that UBS maintains in their history, including the recent sweep dividend transactions. On this test all the dollar amounts came in correctly. UBS suggests that my main file is probably corrupt. I did a validate and no errors were found. Can anyone offer any suggestions for how to fix this problem?

One odd thing I noticed: the main file linked cash account register contains on the second line the memo field followed by the category field. In the new file I created for test purposes these two fields are reversed, so category is followed by memo. So Q2005 has two different formats in use for the linked cash account register. Both formats download the UBS memo and category correctly and allow the downloaded dividends to be included in a dividend report. Could this two format oddity be causing the zero dollar download problem?

Reply to
Don Range
Loading thread data ...

I have Q2004 Dlx instead of Q2005P. When I upgraded to Q2004, I have a similar problem but not exactly the same.

For a different brokerage firm than you, when I download transactions, the monthly interest transaction for the linked checking account has the correct amount of interest. During reconciliation of the account, the amount is still correct and the account is in balance. But immediately after reconciling the account, the interest amount is changed to zero (or blank) in the register. And if I try to change it to the correct amount, it goes back to blank or zero. So, like you, I deleted the transaction and entered a new one with the correct amount. I posted here, and got a reply back that someone else had the same problem as me. I reported it to Intuit with no fix. So, now I always delete the downloaded interest transaction and enter it manually every month. All the other transactions where dividends are generated in the Investment account then get transferred to the linked account work fine. So, for me, it seems there is a bug for downloaded transaction involving only the linked account. Just wondering if the bug in 2004 is just behaving a little differently for 2005P with still no fix

Reply to
Art Matz

Well, if you have not tried a super Validate, you probably should give it a shot. Backup first. But other than that, I have no clue. I do agree that if the download works properly in a New Quicken file, then you probably have corrupted data ... its' just that Quicken can't always find or fix that corrupted data.

I doubt it. It's not really two different formats for the data, it's just two different formats for the display of the data. You can change that in your Quicken Preferences.

Of course, it is possible that in the process of setting up the two different display formats, Intuit introduced a bug that is affecting your data, but I think that is unlikely too. You can test the effect of the display format by changing it to the same as the file that had the successful download.

I have read some posts that suggest to me that Quicken's conversion of files with linked checking accounts may have some flaws, though it is possible that the converted files had some corruption which caused the problem. I think what I am attributing to conversion problems started around the time Quicken began offering check writing capabilty directly from investment accounts, negating the requirement for linked checking accounts for that purpose..

Reply to
John Pollard

Art, thanks for your comments. As you say, my problem is similar but different in the detail. My dollar amount never gets put into the transaction in the register, so it's not there to fail like yours does during reconcile. In my case Q2005 forces my register entry back to blank when I push the Enter button to overwrite it in an edit of the transaction. All the non-monatary fields of the transaction can be edited. Other brokerage accounts download their sweep income without problem. Since Quicken won't let either of us edit the amount, it does sound like it could be related to your Q2004 problem.

D> I have Q2004 Dlx instead of Q2005P. When I upgraded to Q2004, I have a

Reply to
Don Range

John,

Per your advice I did a SuperValidate. No errors were found, and I still can't enter a dollar amount for the downloaded transaction in my main file. Interestingly, if I go to my test file that downloaded the sweep transactions correctly and try to edit the dollar amount to a different value, when I push the Enter button Quicken blanks out the amount and I am not able to enter any number or even reenter the correct number that was originally downloaded. Even if the zero download is a corrupt file problem, the erasure of the amount when you try to edit it shouldn't be a corrupt file problem because this is happening on the brand new file I created just to test this problem.

On the matter of memo and category display field order, you are exactly right. I had overlooked the preference setting that you pointed out, and they were set differently in the two files.

Thanks for your help and advice.

D> D>

Reply to
Don Range

Yep, mine starts with the correct amount but ends up zero.

The similarities I noticed were:

  1. Account was a linked checking.
  2. Transaction affected involved only the linked account and not the investment account. (looked like your case too).
  3. My transaction ended up with zero after reconcile, yours started out with zero, but neither could update the amount to a non zero amount.
  4. We both had to delete the downloaded transaction and enter it manually.

Here is a link to the thread I started a year ago:

formatting link

One note to point out was the other person who had the same problem as me had it with a UBS account like you. Mine was with Schwab.

Hopefully, a Super Validate will fix yours as John Pollard suggests. If you do find a solution, I would appreciate it if you would post it. I've been just deleting it after download and entering the amount during the renconcile.

Reply to
Art Matz

Don,

Just curious on your test file, if after you download the trans with the correct amount, if you try reconciling it, if the amount gets blanked immediately after the reconcile. Then your situation would be exactly like mine for 2004.

Reply to
Art Matz

Art,

Bingo! Yes, on my test file which downloads the correct income on the sweep fund, when I reconcile Quicken blanks out the amount in the register as I exit the reconcile process. Thereafter it is uneditable in the register and the only way to get it right is to delete the whole transaction and manually enter a new one with the correct amount. If I create the replacement transaction by using Copy/Paste of the blank amount transaction and entering just the amount manually, the register accepts the amount I enter but then it is blanked upon reconcile. However, if I create the replacement from scratch its amount remains editable in the register and it is not blanked out when doing a reconcile. So there is something about these particular downloaded sweep fund income transactions, going into the linked checking account, that is bad. Since both you with Schwab and Claude Rains with UBS in the 2004 thread you cited have the same problem as me, it sure looks like a bug. Then I have the additional problem of a zero amount downloaded. BTW, I also have a Schwab account with a linked checking account and it does not have a problem with either downloading or reconciling the sweep fund income.

D> Don,

Reply to
Don Range

Just to make sure not to rule out the UBS / Schwab possibility. Have you reconciled your Schwab linked checking account, to be sure that account works OK? And also other non UBS / Schwab accounts. I have one other linked checking account with Morgan Stanley but I don't download transactions for that account.

Maybe we can narrow this down so Intuit can fix this bug.

Reply to
Art Matz

Art,

I download transactions from three accounts with sweep funds. The downloads put the sweep income into the appropriate linked checking accounts. I reconcile all three each month. Only the UBS account has the problem, and it was fine until a few months ago, about the time I upgraded from Q2002 to Q2005. However I can't be sure the problem started exactly at the time of the upgrade.

D> Just to make sure not to rule out the UBS / Schwab possibility. Have you

Reply to
Don Range

Don,

Thanks for the feedback. It's a mystery why it works for some accounts but not others. I'll just continue deleting and re-adding the interest for that account every month.

Reply to
Art Matz

You can set up your sweep account way JP Morgan Tech support had me set it up. I will explain how they told me to set it up.

JP Morgan offers 2 logins 1 is for investment download and other is for banking downloads including bill pay via quicken.

So on the investment side I have a brokerage account with a hidden cash checking account with a sweep feature. So in the investment account all I see are equities. All the cash redemtions and transactions are handled in the hidden account which I never see. Only reason they download the cash transactions from the investment side they told me is so your investment center will reflect a correct cash balance in thoses reports.

Then they had me open a normal checking account which uses my SSN for a login. In this checking account they download all normal banking transactions like deposits/withdrawls/checks/bill payments and the equities purchases. Then they had me create a cash account with same name as the checking account except called it equities purchases at the end. Then when it downloads all equities purchases are linked to this hidden account. They told reason they do that is so you compare transactions with your statement quickly.

And all reports are correct because 2 hidden account balances are not pulled or drawn into any of the reports. There balance in the 2 hidden account is not shown anywhere. Both the normal checking and linked checking account will match in balance and both hidden equitiy purchase account and investment account will match in balance. So they told me just to reconsile the investment account. They said as long as both investment and hidden equity account match in balance and both linked checking and checking balance match there would be no reason to reconsile both as info is the same.

Not sure if any other brokerage houses have there quicken direct access set up this way but it sure makes it much cleaner without having to see tons of purchases and redemtions in your registery zeroing each other out. Plus in the 3 months I have been downloading with quicken from them I have yet to find 1 mistake at all. Everything downloads correct and works very well how the tech had me set it up.

Reply to
ob

OB,

Thanks for posting your method.

D> You can set up your sweep account way JP Morgan Tech support had me set

Reply to
Don Range

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.