balancing cash adjustment
Ó¿Õ¬
Faithful Q user since 1986, with historical data beginning in 1943, programmer, database designer and developer for 42 years, general troublemaker on Community.Quicken.ComComments
-
It sounds like you still have placeholders. Have you deleted all the placeholders?
Quicken user since Q1999. Currently using QW2017.
Questions? Check out the Quicken Windows FAQ list0 -
You don't need to delete all placeholders, just the one for the cash balance.skeleton567 said:No, I delete a placeholder for a single stock, then try to enter the related transaction(s) to reconcile the shares for that stock. I should not have to delete all placeholders to reconcile a single stock. I'm trying to balance to each quarterly statement in succession, and have completed probably a dozen quarters before this started. Unfortunately, the financial institution did a horrible history download and each quarter has placeholders that accumulate buys from purchases and buys from dividends for the several funds that I held. I just want QW to stop the automatic stuff that is WRONG.
BTW, before this problem began, I could enter the individual transactions, and QW would automatically update the remaining shares in the placeholder. That seemed to work fairly well, and then I would delete the placeholder when it reached zero shares.Quicken user since Q1999. Currently using QW2017.
Questions? Check out the Quicken Windows FAQ list0 -
Also, it's been a long long time since I experimented with placeholders. Doesn't deleting the placeholder delete all its associated transactions?skeleton567 said:No, I delete a placeholder for a single stock, then try to enter the related transaction(s) to reconcile the shares for that stock. I should not have to delete all placeholders to reconcile a single stock. I'm trying to balance to each quarterly statement in succession, and have completed probably a dozen quarters before this started. Unfortunately, the financial institution did a horrible history download and each quarter has placeholders that accumulate buys from purchases and buys from dividends for the several funds that I held. I just want QW to stop the automatic stuff that is WRONG.
BTW, before this problem began, I could enter the individual transactions, and QW would automatically update the remaining shares in the placeholder. That seemed to work fairly well, and then I would delete the placeholder when it reached zero shares.Quicken user since Q1999. Currently using QW2017.
Questions? Check out the Quicken Windows FAQ list0 -
If you have a placeholder for the security dated later than the transactions you are entering, you will get a balancing cash adjustment.skeleton567 said:No, I delete a placeholder for a single stock, then try to enter the related transaction(s) to reconcile the shares for that stock. I should not have to delete all placeholders to reconcile a single stock. I'm trying to balance to each quarterly statement in succession, and have completed probably a dozen quarters before this started. Unfortunately, the financial institution did a horrible history download and each quarter has placeholders that accumulate buys from purchases and buys from dividends for the several funds that I held. I just want QW to stop the automatic stuff that is WRONG.
BTW, before this problem began, I could enter the individual transactions, and QW would automatically update the remaining shares in the placeholder. That seemed to work fairly well, and then I would delete the placeholder when it reached zero shares.Quicken user since Q1999. Currently using QW2017.
Questions? Check out the Quicken Windows FAQ list0 -
So the trick is to work backwards in time, resolving the Placeholders as you go.skeleton567 said:No, I delete a placeholder for a single stock, then try to enter the related transaction(s) to reconcile the shares for that stock. I should not have to delete all placeholders to reconcile a single stock. I'm trying to balance to each quarterly statement in succession, and have completed probably a dozen quarters before this started. Unfortunately, the financial institution did a horrible history download and each quarter has placeholders that accumulate buys from purchases and buys from dividends for the several funds that I held. I just want QW to stop the automatic stuff that is WRONG.
BTW, before this problem began, I could enter the individual transactions, and QW would automatically update the remaining shares in the placeholder. That seemed to work fairly well, and then I would delete the placeholder when it reached zero shares.QWin Premier subscription0 -
It appears to work like this in QWin 2019:
When there is a Placeholder in an investing account, Quicken has forced the share balance to match the downloaded data but does not know how much those shares cost or when they were purchased. You are supposed to edit the Placeholder to adjust earlier transactions or add missing ones using the Enter missing Transactions dialog until the "Shares in Placeholder Entry" is zero.
If you enter a missing transaction for an affected security that affects the cash balance (Buy, Sell, or Div for example) for a date prior to the Placeholder, Quicken creates a balancing cash adjustment to compensate for it, because it is trying to keep the cash balance constant. Leave this in place until you are done resolving the shares.
Once the shares in the Placeholder are down to zero, you can delete the Placeholder and then delete the balancing cash adjustment(s) as well, if you want the cash on the Placeholder date to change to match the transactions you have entered.
I find it much easier not to allow Quicken to create the placeholders in the first place.
QWin Premier subscription0 -
To further confuse things, these balancing cash adjustments are also hidden in the transaction list (register) when the Placeholders are hidden, and when un-hidden, they are not displayed with a gray background like the Placeholders.Jim Harman said:It appears to work like this in QWin 2019:
When there is a Placeholder in an investing account, Quicken has forced the share balance to match the downloaded data but does not know how much those shares cost or when they were purchased. You are supposed to edit the Placeholder to adjust earlier transactions or add missing ones using the Enter missing Transactions dialog until the "Shares in Placeholder Entry" is zero.
If you enter a missing transaction for an affected security that affects the cash balance (Buy, Sell, or Div for example) for a date prior to the Placeholder, Quicken creates a balancing cash adjustment to compensate for it, because it is trying to keep the cash balance constant. Leave this in place until you are done resolving the shares.
Once the shares in the Placeholder are down to zero, you can delete the Placeholder and then delete the balancing cash adjustment(s) as well, if you want the cash on the Placeholder date to change to match the transactions you have entered.
I find it much easier not to allow Quicken to create the placeholders in the first place.
If you delete the adjustment transaction before deleting the zero Placeholder, the corresponding Buy, Sell, or Div transaction is also deleted.
None of this is mentioned anywhere in the Help or online support info.
Looking back over previous conversations about Placeholders, I think these may be causing the "my account balance is twice as big as it should be" issues, because many people do not notice the balance adjustments.QWin Premier subscription0 -
As best I can recall and I am not a placeholder expert' the conventional wisdom circa QW2014 was to delete the placeholder and any transactions entered after that placeholder but pre dating the placeholder. Then you had to re-enter those prior dated transactions. Just deleting the 0-share placeholder did not eliminate the effects of that placeholder.
I am open to correction if I am misstating actuality.0