Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Dividends double-posting to cash account

Questions about updating prices or transactions in Fund Manager

Postby f3red » Mon Jun 16, 2014 5:39 am

It looks like any transaction that results in a deposit to my default cash account is double-posting - one entry with no memo, and one with the tag "[Imported]". I know I resolved this issue on another account, but this is my wife's account and apparently I didn't set it up right. I have a vague recollection of needing to clear a checkbox ... somewhere ...
f3red
 
Posts: 4
Joined: Tue Apr 28, 2009 6:05 pm

Postby Mark » Mon Jun 16, 2014 8:41 am

Hi f3red,

Is it only happening for the dividends? If so, maybe it is because you retrieved transactions and also retrieved dividend data from Yahoo (Historical) when you retrieved prices? In the Professional/Advisor versions, when you retrieve pricing using "Yahoo (Historical)" you can request it to retrieve splits and dividends. If you're also retrieving from your broker, you would not typically also want to retrieve this same data from Yahoo (Historical). Just un-check this option on the price retrieve dialog box if this is the case.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby f3red » Mon Jun 16, 2014 8:47 am

Mark,

I'm using FM Personal. This appears to happen on any transaction that results in a deposit to the default cash account, dividends and sale of assets included.
f3red
 
Posts: 4
Joined: Tue Apr 28, 2009 6:05 pm

Postby f3red » Mon Jun 16, 2014 8:52 am

I have also confirmed that the difference computed in the "Reconcile" operation is precisely the sum of the aforementioned "[Imported]" transactions, so I assume :wink: that I can just delete them to complete the reconcile. I mean, once I find the elusive checkbox with your help...
f3red
 
Posts: 4
Joined: Tue Apr 28, 2009 6:05 pm

Postby Mark » Mon Jun 16, 2014 9:09 am

Hi f3red,

Maybe then your cash transactions are being retrieved/imported, so you don't need to use a default cash account? How are you getting transactions into Fund Manager? Retrieving from a broker, importing, manually entering?

If you are retrieving/importing, and you see both halves of a transaction listed, then you don't need to use the default cash account feature. For example, if you buy a stock for $1,000 and you see both the buy of stock for $1,000 and a sell of cash listed for $1,000 on the same date, then you don't need to use the default cash account option, as your cash side of the transactions are already there. You would only use the default cash account option if you only see the $1,000 stock purchase listed.

There are 2 ways you can not use the default cash account feature:

1) Under "Portfolio Properties..." set your sub-portfolio's default cash account to "(none)".
2) In the Preview Importing Transactions dialog, un-check the "Automatically Record Corresponding Default Cash Account Entry" option.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby f3red » Mon Jun 16, 2014 9:21 am

That's it! The default cash account setting in Properties. So then I went thru the other sub-portfolios and made certain that they were all set the same way.

Thanks, Mark.
f3red
 
Posts: 4
Joined: Tue Apr 28, 2009 6:05 pm


Return to Prices and Transactions

Who is online

Users browsing this forum: No registered users and 6 guests

FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy
Copyright © 1993-2024 Beiley Software, Inc. All rights reserved.
cron