Home Page link  

Cash Balance in Investment Account

 

Quicken Personal Finance Discussions - Quicken - personal finance software discussions

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Cash Balance in Investment Account Jim T. 08-07-2008
Posted by Jim T. on August 7, 2008, 5:33 pm
Please log in for more thread options


I closed out an account with a broker, all stock was sold and proceeds
transferred to another account. There remains a small cash balance in
the investment account (not the linked cash account.) Quicken seems to
have no way for me to adjust this. All potential transactions are Xs
(transfers.)
Can anyone help, this is annoying?

Posted by Carl on August 7, 2008, 9:17 pm
Please log in for more thread options


> I closed out an account with a broker, all stock was sold and proceeds
> transferred to another account. There remains a small cash balance in
> the investment account (not the linked cash account.) Quicken seems to
> have no way for me to adjust this. All potential transactions are Xs
> (transfers.)
> Can anyone help, this is annoying?

If no one posts a better answer you could do what I did in a previous
version. Create an account, maybe call it Rounding Errors, make it hidden
if you want, transfer out the remaining balance to that account. It is
for this reason that nowadays I take the trouble to force those rounding
errors back to the price so the pennies in the totals match the statements.



Posted by John Pollard on August 8, 2008, 9:56 am
Please log in for more thread options


Jim T. wrote:
> I closed out an account with a broker, all stock was sold and
> proceeds
> transferred to another account. There remains a small cash
> balance in
> the investment account (not the linked cash account.) Quicken
> seems to
> have no way for me to adjust this. All potential transactions
> are Xs
> (transfers.)

As suggested by the other poster, it's possible there is some
small rounding error involved. Or it's possible there is a
small error in one or more of the old transactions in the
account (if true, such problems can sometimes be "fixed" by
deleting and re-entering old transactions ... especially Buy and
Reinvest transactions ... but there is no guarantee).

You can also try the other poster's suggestion, in a more formal
way: enter a cash adjustment in the account. In essence, you
tell Quicken what the cash balance in the account was on a
certain date, and Quicken tries to make that be true. Also no
guarantee this will work.

With the account open to its "register": Investing > Investing
Activities > Update Cash Balance.

--

John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup



Posted by Jim T. on August 9, 2008, 9:16 am
Please log in for more thread options


On Fri, 8 Aug 2008 08:56:53 -0500, "John Pollard"

>Jim T. wrote:
>> I closed out an account with a broker, all stock was sold and
>> proceeds
>> transferred to another account. There remains a small cash
>> balance in
>> the investment account (not the linked cash account.) Quicken
>> seems to
>> have no way for me to adjust this. All potential transactions
>> are Xs
>> (transfers.)
>
>As suggested by the other poster, it's possible there is some
>small rounding error involved. Or it's possible there is a
>small error in one or more of the old transactions in the
>account (if true, such problems can sometimes be "fixed" by
>deleting and re-entering old transactions ... especially Buy and
>Reinvest transactions ... but there is no guarantee).
>
>You can also try the other poster's suggestion, in a more formal
>way: enter a cash adjustment in the account. In essence, you
>tell Quicken what the cash balance in the account was on a
>certain date, and Quicken tries to make that be true. Also no
>guarantee this will work.
>
>With the account open to its "register": Investing > Investing
>Activities > Update Cash Balance.
You aren't allowed to do that if there is a linked cash account.

Posted by Jim Jensen on August 9, 2008, 10:58 am
Please log in for more thread options





> On Fri, 8 Aug 2008 08:56:53 -0500, "John Pollard"
>
>>Jim T. wrote:
>>> I closed out an account with a broker, all stock was sold and
>>> proceeds
>>> transferred to another account. There remains a small cash
>>> balance in
>>> the investment account (not the linked cash account.) Quicken
>>> seems to
>>> have no way for me to adjust this. All potential transactions
>>> are Xs
>>> (transfers.)
>>
>>As suggested by the other poster, it's possible there is some
>>small rounding error involved. Or it's possible there is a
>>small error in one or more of the old transactions in the
>>account (if true, such problems can sometimes be "fixed" by
>>deleting and re-entering old transactions ... especially Buy and
>>Reinvest transactions ... but there is no guarantee).
>>
>>You can also try the other poster's suggestion, in a more formal
>>way: enter a cash adjustment in the account. In essence, you
>>tell Quicken what the cash balance in the account was on a
>>certain date, and Quicken tries to make that be true. Also no
>>guarantee this will work.
>>
>>With the account open to its "register": Investing > Investing
>>Activities > Update Cash Balance.
> You aren't allowed to do that if there is a linked cash account.

Can you lower the share price until the cash balance disappears? For
example, if you sold at 19.58/sh, edit the transaction to a lower price,
say 19.5775/sh, and see what happens to the cash balance. Adjust the
price as necessary to eliminate the cash balance.



Similar ThreadsPosted
Adjust cash balance in investment account. October 12, 2008, 1:46 pm
How to change Cash Amount and Cash Balance in Q2008 Investment Acct? January 1, 2008, 9:34 pm
Account Cash Balance January 21, 2007, 5:25 pm
Investments Account Cash Balance July 16, 2007, 9:38 am
How can I display a cash balance column in a brokerage account? September 13, 2008, 12:46 pm
Adjusting an Investment Account Balance April 25, 2008, 10:53 am
Investment account shows wrong balance November 16, 2006, 10:59 pm
Cannot accept downloaded transactions into Ameritrade-Cash account "You should make this change from the investment account" message July 8, 2006, 9:15 am
Deposit in Investment Account doesn't show up in Balance Sheet? July 4, 2008, 11:34 pm
Online Banking - Cash Balance August 17, 2006, 4:53 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap