Fwd: portfolio accounting and budget report

[Robert Hoogendoorn]

Hi,

Is there someone who can help me with the below?


Kind regards,
Robert


---------- Forwarded message ----------
From: Robert Hoogendoorn <robertmbh at gmail.com>
Date: Tue, May 16, 2017 at 12:52 AM
Subject: portfolio accounting and budget report
To: gnucash-user at gnucash.org


Hi,

I am using version 2.6.16 and I have a couple of questions:

1. I am playing around with GNU and although I have not used the multi
currency feature yet, I was wondering why my cash balance is reflected in
the Profit and Loss under the header Trading currency (see report Profit
and Loss 05_03_2017).
2. As well in the same report under the header Trading AMEX the market
value appears in stead of the unrealized gain/loss. Why is this?
3. Also in the same report, should there not be a an account with the
realized gains and losses?
4. Same report. It appears that a negative total in the Profit and Loss is
perceived as a "Net Loss for the Period" as mentioned on the last line of
this report, while it should be a Profit. Please advice?
5. As you can see on the Transaction report 05_01_2017 to 05_04_2017 I have
made a Lots Sell1 of R$1 on 05_03_2017, however the advanced portfolio
report only takes the sale into account on 05_04_2017 and does not reflect
this sale on 05_03_2017. See reports Advanced Portfolio 05_03_2017 and
05_04_2017. On these report the holding is 1010 shares on 05_04_2017 and
1260 on 05_03_2017. So the sale of 250 shares on 05_03_2017 is not taken
into account. I believe the sell of 250 shares should be taken into account
on the report of 05_03_2017. Please advice? The balance sheet as in report
Multi column view 05_03_2017 and 05_04_2017 shows the correct number of
shares.

Some reporting suggestions outstanding:

The report named Budget report:
1. As this is a multi currency system normally a budget is made before an
accounting period with an estimated currency rate. It appears that the
current report is not multi currency and only shows it in one currency. Can
this be changed so a currency rate specifically for the budget can be used
while the realized number uses the actual currency rate?
2. The (sub)totals appear above the amounts while it would be great if we
can have the option to reflect them below the summarized numbers. The
Balance sheet report has such a feature and that seems to work.

Kind regards,
Robert
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Multicolumn View--05_03_2017 and 05_04_2017.pdf
Type: application/pdf
Size: 60517 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20170517/cf94e0b6/attachment-0006.pdf>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Profit & Loss--05_04_2017.pdf
Type: application/pdf
Size: 49422 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20170517/cf94e0b6/attachment-0007.pdf>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Profit & Loss--05_03_2017.pdf
Type: application/pdf
Size: 49558 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20170517/cf94e0b6/attachment-0008.pdf>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Advanced Portfolio--05_04_2017.pdf
Type: application/pdf
Size: 49445 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20170517/cf94e0b6/attachment-0009.pdf>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Advanced Portfolio--05_03_2017.pdf
Type: application/pdf
Size: 48962 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20170517/cf94e0b6/attachment-0010.pdf>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Transaction Report--05_01_2017 to 05_04_2017.pdf
Type: application/pdf
Size: 85090 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20170517/cf94e0b6/attachment-0011.pdf>