Cash flow report

[mkappa74]

I've got a strange behaviour when reporting transaction on cash account filtered by "include only external transaction" to see external cash flow.
The problem is that when "VIEW-exchange rate adjusted" is on I see some sell-transaction (but not necessarily in other currencies) that are not correct because they have a correspondent buy transaction.
If I turn OFF the view option, I see correct cash flow.

If you want I can privately send .pdf report file or .dat file.

[Mark]

Hi mkappa74,

Thanks, I see this same problem here. It is a bug. We'll get this fixed for the next release.

[mkappa74]

Hi,
I've tried some other test.
It seems that Cash flow report doesn't work very well. Despite off the bug above, I've some other strange behaviour:

Context: report on cash account including only eternal transaction
- there are several transaction reported that are related to buy-sell transaction. For example, I have a -100 € redemption form fund A and a + 100 € redemption to fund be (same day): in report I see the redemption as external cash flow
- I have a +100 new cash (so, this is a real external transaction) and a -100 purchase to buy fund C. In report I don't see any of this transaction, while I'd to see the first one ...
In this second case, I've noticed that report became correct (ie: it reports the externale 100 cash flow) if I modify the date: for example if I set the purchase the day later.

[Mark]

Hi mkappa74,

Fund Manager relies on finding equal/opposite transactions for finding external cash flow items. For example, if you have a buy and sell for equal amounts on the same date, these cancel out, and are not considered external. However, if you have 2 sells, one for +100 and one for -100 those would not cancel. If you change the -100 sell to a +100 buy, then they will cancel, and not be reported as external. The idea is that typically you would sell something and the money would be deposited into cash, so the sell will match and cancel out the buy of cash.

For purposes of determining portfolio internal/external transactions it is not necessary that one side of the transaction come from a default cash account. This is usually the case, but as long as there is a corresponding entry with the same value and same date anywhere within the same sub-portfolio, the transaction will be considered internal.

Are you using a default cash account? In your second example, if you deposit $100 and then buy fund C for $100 you should have 3 total transactions: $100 buy of cash, $100 sell of cash, and a $100 buy of fund c. The sell of cash and buy of fund c will cancel, so the only external transaction that would show up is the $100 buy of cash. It sounds like maybe you have the 3 transactions, but instead of the $100 sell of cash you have recorded a -$100 purchase of cash? Is there some reason you don't record this as a $100 sell, instead of a -$100 purchase? Fund Manager won't cancel out a purchase/purchase or sell/sell, it has to be opposite, like a buy/sell.

[mkappa74]

Are you using a default cash account? In your second example, if you deposit $100 and then buy fund C for $100 you should have 3 total transactions: $100 buy of cash, $100 sell of cash, and a $100 buy of fund c. The sell of cash and buy of fund c will cancel, so the only external transaction that would show up is the $100 buy of cash. It sounds like maybe you have the 3 transactions, but instead of the $100 sell of cash you have recorded a -$100 purchase of cash? Is there some reason you don't record this as a $100 sell, instead of a -$100 purchase? Fund Manager won't cancel out a purchase/purchase or sell/sell, it has to be opposite, like a buy/sell.

I've got a PORTFOLIO which contain only one investment called @CASH (cash investment type). PORTFOLIO has not default cash account.

Then I've 4 sub portfolio (Bond, Equity, Mixed asset, Total Return): each of them has @CASH as default cash account and contains several investment.

Suppose my portfolio value is 1000, 1000 in @CASH, 0 in other investment.
1. I add 1000€ to @CASH : I register a buy transaction of 1000 on @CASH. I can see a +1000 "Purchase" in data list.
My portfolio value is 2000, 2000 in @CASH, 0 in other investment

2. I go to subportfolio BOND, open an Investment (suppose BONDINV) and add a 1000€ purchase: I register another buy transaction. My portfolio value is still 2000, 1000 in @CASH, 1000 in BONDINV.
In @CASH I can see a -1000 redemption; comment reports: Bought XXX BONDINV

I think it's correct.

3. I select Report-Investment Transaction, choose PORTFOLIO, choose @CASH as investment and select "include only portfolio external transaction" in filtering.

Result: my +1000€ add to @CASH is not reported.
If I change the date of purchase on BONDINV a day later, it's reported ...

Where I'm wrong?

[Mark]

Hi mkappa74,

I entered this situation, and it correctly reported the $1000 deposit into cash as an external cash flow. Are you sure you have it recorded exactly as you've described? You could try creating a new portfolio with this example, and see if you can reproduce this problem. If so, you can create a backup, and email that to us, so we can take a look. Alternatively, you can make a backup of your actual portfolio where you see this problem, and email that to us.

Also, are you using version 11.8?

[mkappa74]

Yes, I'm using last version.

If simulated a new portfolio and I've found no errorSo, the problem is related with 2 of my 5 portfolio.

I'm not able to find where the error is. I will send it to: <deleted> for a review, if you can.

Many thanks, Marcello

[Mark]

Hi Marcello,

Yes, please email us this backup, I'll take a look. I edited your posting to remove our email address. You had the correct address. With all the spam problems, it is best to not post an email address...

[mkappa74]

Hi,
I'm having some problem with email transmission: I've received this error message:

***
This is an automatically generated Delivery Status Notification
THIS IS A WARNING MESSAGE ONLY.
YOU DO NOT NEED TO RESEND YOUR MESSAGE.
Delivery to the following recipient has been delayed:
<deleted by moderator...>
Message will be retried for 2 more day(s)
Technical details of temporary failure:
The recipient server did not accept our requests to connect.
***

[Mark]

Hi mkappa74,

The email address you sent to is wrong. The domain is fundmanagersoftware.com not fundmanager.com.

[Mark]

Hi mkappa74,

We received your email and attachments. I sent some of the specific reasons why transactions weren't being matched by email. For transactions to match up, and be considered internal they both must be in the same sub-portfolio you're reporting on, and the amounts must match exactly, and in the opposite directions, like a buy matched up with a sell.