balancing cash adjustment

skeleton567
skeleton567 Quicken Windows Other Member ✭✭✭✭
edited December 2018 in Investing (Windows)
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

Ó¿Õ¬

Faithful Q user since 1986, with historical data beginning in 1943, programmer, database designer and developer for 42 years, general troublemaker on Community.Quicken.Com

Comments

  • mshiggins
    mshiggins Quicken Windows 2017 SuperUser ✭✭✭✭✭
    edited December 2018
    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 list

  • Unknown
    edited December 2018
    This content has been removed.
  • mshiggins
    mshiggins Quicken Windows 2017 SuperUser ✭✭✭✭✭
    edited December 2018

    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.

    Quicken user since Q1999. Currently using QW2017.
    Questions? Check out the Quicken Windows FAQ list

  • mshiggins
    mshiggins Quicken Windows 2017 SuperUser ✭✭✭✭✭
    edited December 2018

    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?

    Quicken user since Q1999. Currently using QW2017.
    Questions? Check out the Quicken Windows FAQ list

  • Unknown
    edited December 2018
    This content has been removed.
  • mshiggins
    mshiggins Quicken Windows 2017 SuperUser ✭✭✭✭✭
    edited December 2018

    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.

    Quicken user since Q1999. Currently using QW2017.
    Questions? Check out the Quicken Windows FAQ list

  • Jim_Harman
    Jim_Harman Quicken Windows Subscription SuperUser ✭✭✭✭✭
    edited December 2018

    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.
    QWin Premier subscription
  • Unknown
    edited December 2018
    This content has been removed.
  • Jim_Harman
    Jim_Harman Quicken Windows Subscription SuperUser ✭✭✭✭✭
    edited December 2018
    QWin Premier subscription
  • Jim_Harman
    Jim_Harman Quicken Windows Subscription SuperUser ✭✭✭✭✭
    edited December 2018
    QWin Premier subscription
  • q_lurker
    q_lurker Quicken Windows Subscription SuperUser ✭✭✭✭✭
    edited December 2018
    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.
This discussion has been closed.