I have a Roth IRA account with USAA. It consists of the Target Retirement 2040 Fund. Every two weeks, I move $185 from my USAA Savings account to the IRA, and in the IRA the $185 is used to buy shares in the fund.
When I download transactions, in the IRA, my contributions are classified as "Automated Cash Reversal" And in the savings account... they're classified as "Target", as in the store, with a category of "Household". If I make any change to that, it screws everything up. The accounts will never reconcile properly again. The only way I can fix that is to move all of my Quicken files to another location and set Quicken up all over again, which obviously loses all of my history.
Right now, I'm working from a fresh Quicken database. I've set up all of my accounts and downloaded whatever the bank had. All of the balances are correct, but the above behavior is manifesting itself. Since I am NOT paying Target, the store, $185 every two weeks... how do I fix this, and get Quicken to stop doing whatever it's doing to rename that transaction?
Is the IRA account a Quicken "Single Mutual Fund" account (does it have a "Share Bal" column, or a "Cash Bal" column)?
When the IRA account contribution transaction is in the "Accept transactions ..." window, what is its "Action" value? And after you Accept it, what is its "Action" value? Is Quicken adding one, or more, transactions when you Accept the downloaded transactions.
Is it possible you have one, or more, placeholders in the Quicken IRA account? [Make sure Quicken is set to display hidden investment transactions (Edit > Preferences > Quicken Preferences > Investment transactions); look for transactions with an Action value of "Entry".]
The savings account transaction is a mystery to me at this point. A Quicken "transfer" transaction requires the name of the TO account in square brackets in the category field. I can't see how a transaction with "Household" in the category field can be involved in the process.
Have you tried Validating a Quicken Copy of your data and seeing the the Validated Copy exhibits the same behavior?
Also, have you considered making the contribution transaction a Quicken scheduled transaction and having it Entered before you Accept the downloaded transactions ... so the downloaded transactions will "Match" transactions already in your Quicken accounts?
It does have a "Cash balance" column, but it's always zero.
And that's another thing... Quicken puts the share purchases first, so the balance goes from $0 to -$185, then adds the contribution, so the balancce goes up to zero.
Not sure. Since I just re-set this up (I even uninstalled Quicken, deleted all Quicken-related keys from the registry and deleted some Quicken-related files, then reinstalled Quicken and then started *again* with a fresh database), I just set up the account, it connects, and sucks down a bunch of stuff. There was never an option to accept or review anything.
There are a couple of "placeholders" at the beginning, because there isn't info going back to the beginning of the account. I just left them... I have no idea what I'd do with them, and the account is correct now, so if I add any info, it'll throw the account out of whack and I'd have to start over.
It never gave me a chance to say "This is a transfer". It just automatically assumed it was a "Household". Yes, even after uninstalling and reinstalling Quicken. If I change one to a Transfer, it'll break the account balance and I will never be able to fix it again... from then on, any change I make just throws the balance off further and further. I have several copied databases where I tried various things.
Not sure what that means.
I can give that a shot.
I wanted to manually match the transactions, but I can't. Googling about matching transactions led me to
formatting link
refers to "MatchManually". I don't have that option. Googling that led me to
formatting link
which refersto "Account Actions". I don't have that, either. Googling that returns a bunch of results that just assume that everyone has it and knows where it is.
What does the downloaded contribution transaction look like? What "Action" value? Does it specify a transfer account as the source of the $185?
Where does the "Automated Cash Reversal" fit?
I don't think reinstalling Quicken is necessary or useful for your situation. I suspect that deleting the investment account would suffice. [Unless the savings account is also new; then you'd probably want to delete that too.]
Often, on the first download to a *new* investment account, Quicken doesn't put the transactions in the "Accept transactions into register" window. Sometimes, you can fool Quicken into thinking it's not a *new* account by having a transaction in the account before the first download.
You could try creating the account without specifying the financial institution. Enter a transaction - any transaction - in the account; planning to delete it later, if it's not a valid transaction [You could possibly enter the "contribution" transfer for this purpose, and plan to keep it.]
Then tell Quicken the fi name, and setup the account for downloading. Sometimes this will cause Quicken to put the first downloaded transactions into the "Accept transactions" window. [When they are there, you could also try accepting them in the order you want them in the register ... I've never tried it, but it's worth a shot.]
At some point, you may have to decide whether to leave things as they are, or invest the effort to get them as close as you can to the way you'd like them.
One characteristic of placeholders is that they prevent any transaction that they affect from altering the cash balance of the investment account. I'm thinking that the "automatic cash reversal" may be Quicken trying to prevent the cash balance from changing ... because of a placeholder.
But, if the results are correct, perhaps you'll be happier just leaving things as they are.
Look for a memorized transaction for that Target "payee".
File > File operations > Copy File > File operations > Validate (the Copy from the previous step)
Have Quicken open the Validated Copy and see if the behavior changes.
The contribution should be a "transfer" transaction; transferring funds from your savings account to your IRA acccount. It would probably be better if that transfer transaction was already entered in Quicken before you did your download.
I think that's because your initial download didn't put the downloaded transactions in the "Accept transactions" window (which is where a manual match must be initiated). See above for trying to get downloaded transactions for a *new* account to appear in the "Accept transactions" window.
The Account Actions button was first introduced in Q2010; so not applicable to you. But the Account Actions button is not involved in the manual match process, in any event.
The "Automated Cash Reversal" is a "Deposit". Share purchases are "Bought".
That's the Description.
I thought that maybe Quicken was saving an old renaming rule or something.
But I also wanted to demonstrate that I'm starting 100% fresh. There is nearly no possibility of some old remembered setting. Unless Quicken is very carefully hiding it, not uninstalling it, and then digging it back up again when reinstalled.
OK, I deleted both accounts. manually added them without the online thing. Added a scheduled transaction. Edited the accounts to set up the online thing. The savings connected, and all of the transfers are the same jacked up thing (even though I deleted the rename rule). No chance to review or accept anything. Then I got the IRA. It lets me review. All of the transfers show up as "Automated Cash reversal". There is a "Match Manually" option. I try it, and it tells me there are no transactions to match.
There is one. But I don't know where it came from. Quicken just decided to do it, and it keeps doing it even when I delete everything, uninstall/reinstall, etc. There is no option for it to input these transactions correctly... it just insists that "Target 2040 Masviaach ****" absolutely has to be "Target", the department store, with a Category of "Household".
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.