balancing cash adjustment

skeleton567

How can I stop QW2014 Premier from automatically entering a balancing cash adjustment?  I'm working through an investment account that was messed up by attempted download of transactions back in 2004.  I'm deleting the placeholder and trying to enter a straight cash dividend, and a buy of corresponding shares with the correct cost.  I tried Reinvest Div and that didn't work either. QW2014 is behind the scene taking my DIV entry and changing it to an adjustment.  Getting tired of QW thinking it is smarter than I am.  This should be a simple entry of data without being adjusted for me

mshiggins

It sounds like you still have placeholders. Have you deleted all the placeholders?

Unknown

This content has been removed.

mshiggins

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.  

You don't need to delete all placeholders, just the one for the cash balance.

mshiggins

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.  

Also, it's been a long long time since I experimented with placeholders. Doesn't deleting the placeholder delete all its associated transactions?

Unknown

This content has been removed.

mshiggins

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.  

If you have a placeholder for the security dated later than the transactions you are entering, you will get a balancing cash adjustment.

Jim_Harman

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.  

So the trick is to work backwards in time, resolving the Placeholders as you go.

Unknown

This content has been removed.

Jim_Harman

Jim_Harman

q_lurker

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.