Re: Account Report/Register Report

[Mike or Penny Novack]

On 3/8/2018 5:40 PM, Robin Chattopadhyay wrote:

I've tested the report several times under varying use cases and
cross-checked against both pen & paper and a spreadsheet, so I'm fairly
confident that it's reporting what I want it to report.

David C. suggested saving the register report and I certainly could do
that. Honestly, it hadn't occurred to me to save the report. The catch is
that this report doesn't currently allow you to select/change the account
at runtime, so I would have to create a separate, saved report for each
account I wanted to report on.

Well, after running the report could export it.

That's what I do. I have a folder into which reports are exported and 
then suitably renamed. Then I can refer back to them at any time in the 
future without gnuscash itself being cluttered. It just needs one 
"skeleton" for each report I run.


For example, take an organization for which I am treasurer and the board 
of directors meets quarterly. So each quarter I would be running an 
Income Statement report retitled "Statement of Revenues and Expenses" 
and a Balance Sheet for the end of that quarter and export them. 
(already have the Balance Sheet for the beginning of the quarter run as 
Balance Sheet of the previous quarter) Then I would rename them (in that 
folder) to something like "Revenues-and-Expenses-q1-2018" and 
"Balance-Sheet-20180331". << those are the RAW reports -- I use the 
contents of those to produce the pretty print, excess detail removed 
reports that the board gets >>


Michael D Novack
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Account Report/Register Report

[David Carlson]

When I suggested that perhaps the report could be reconfigured I intended
to suggest that the report could be redesigned by a developer to expose
additional settings as required to enable saving it to be open-able without
first opening the desired register.

David C

On Thu, Mar 8, 2018 at 4:40 PM, Robin Chattopadhyay 
wrote:

> I've tested the report several times under varying use cases and
> cross-checked against both pen & paper and a spreadsheet, so I'm fairly
> confident that it's reporting what I want it to report.
>
> David C. suggested saving the register report and I certainly could do
> that. Honestly, it hadn't occurred to me to save the report. The catch is
> that this report doesn't currently allow you to select/change the account
> at runtime, so I would have to create a separate, saved report for each
> account I wanted to report on.
>
> That could get unwieldy as there are some 40 different accounts that need
> reported on (multiple commodities across a range of accounts: retirement,
> college savings, health savings, regular brokerage, etc.)
>
> As for your question, "Why?" I want my balance sheet to mirror the cost
> basis that my 401k provider comes up with. (Before anyone says it, this is
> for my own performance tracking, not tax reporting).
>
>
>
>
> On Wed, Mar 7, 2018 at 7:56 AM, Wm via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
> > On 06/03/2018 01:25, Robin Chattopadhyay wrote:
> >
> >> Hi-
> >>
> >> Using Linux Mint 18.3, Gnucash 2.6.19...
> >>
> >> There's a report I like to use called Account Report. You can get to it
> >> after opening a register. I use this report to see what gnc has as the
> >> cost
> >> basis for an investment.
> >>
> >
> > I'm not sure that was how it was meant to be used so it may be that it is
> > occasional that it is producing the number you expect or want :)
> >
> > Because of the way my 401(k) provider calculates cost basis, I have found
> >> that the only way to properly track realized gains/losses in gnc is to
> >> manually make the entries myself. So I use this report and set the
> options
> >> to Amount = SINGLE and tick the 'Value' option. The net Value Change
> >> neatly
> >> reflects my cost basis (assuming there are no filters and all
> transactions
> >> in the account are visible).
> >>
> >
> > That sounds good.
> >
> > My question is: Can I go somewhere and change the defaults for this
> report
> >> so that I don't have to select them every time? For any other report, I
> >> would save the report to ~/.gnucash/saved-reports-2.4 and just select
> the
> >> account I wanted to report on.
> >>
> >
> > I can save a register report on windows, I haven't tried on another OS to
> > see if it is different there.
> >
> >
> >> But this report doesn't have an option to select the account so my next
> >> thought was to change the defaults.
> >>
> >
> > Are you, perhaps, trying to make a report do something it wasn't intended
> > to do ?  If so why ?
> >
> > Is there anything unusual that you think might be preventing you from
> > saving it for reuse other than not understanding what is being reported?
> >
> > --
> > Wm
> >
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Account Report/Register Report

[Robin Chattopadhyay]

I've tested the report several times under varying use cases and
cross-checked against both pen & paper and a spreadsheet, so I'm fairly
confident that it's reporting what I want it to report.

David C. suggested saving the register report and I certainly could do
that. Honestly, it hadn't occurred to me to save the report. The catch is
that this report doesn't currently allow you to select/change the account
at runtime, so I would have to create a separate, saved report for each
account I wanted to report on.

That could get unwieldy as there are some 40 different accounts that need
reported on (multiple commodities across a range of accounts: retirement,
college savings, health savings, regular brokerage, etc.)

As for your question, "Why?" I want my balance sheet to mirror the cost
basis that my 401k provider comes up with. (Before anyone says it, this is
for my own performance tracking, not tax reporting).




On Wed, Mar 7, 2018 at 7:56 AM, Wm via gnucash-user <
gnucash-user@gnucash.org> wrote:

> On 06/03/2018 01:25, Robin Chattopadhyay wrote:
>
>> Hi-
>>
>> Using Linux Mint 18.3, Gnucash 2.6.19...
>>
>> There's a report I like to use called Account Report. You can get to it
>> after opening a register. I use this report to see what gnc has as the
>> cost
>> basis for an investment.
>>
>
> I'm not sure that was how it was meant to be used so it may be that it is
> occasional that it is producing the number you expect or want :)
>
> Because of the way my 401(k) provider calculates cost basis, I have found
>> that the only way to properly track realized gains/losses in gnc is to
>> manually make the entries myself. So I use this report and set the options
>> to Amount = SINGLE and tick the 'Value' option. The net Value Change
>> neatly
>> reflects my cost basis (assuming there are no filters and all transactions
>> in the account are visible).
>>
>
> That sounds good.
>
> My question is: Can I go somewhere and change the defaults for this report
>> so that I don't have to select them every time? For any other report, I
>> would save the report to ~/.gnucash/saved-reports-2.4 and just select the
>> account I wanted to report on.
>>
>
> I can save a register report on windows, I haven't tried on another OS to
> see if it is different there.
>
>
>> But this report doesn't have an option to select the account so my next
>> thought was to change the defaults.
>>
>
> Are you, perhaps, trying to make a report do something it wasn't intended
> to do ?  If so why ?
>
> Is there anything unusual that you think might be preventing you from
> saving it for reuse other than not understanding what is being reported?
>
> --
> Wm
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Account Report/Register Report

[Wm via gnucash-user]

On 06/03/2018 01:25, Robin Chattopadhyay wrote:

Hi-

Using Linux Mint 18.3, Gnucash 2.6.19...

There's a report I like to use called Account Report. You can get to it
after opening a register. I use this report to see what gnc has as the cost
basis for an investment.


I'm not sure that was how it was meant to be used so it may be that it 
is occasional that it is producing the number you expect or want :)



Because of the way my 401(k) provider calculates cost basis, I have found
that the only way to properly track realized gains/losses in gnc is to
manually make the entries myself. So I use this report and set the options
to Amount = SINGLE and tick the 'Value' option. The net Value Change neatly
reflects my cost basis (assuming there are no filters and all transactions
in the account are visible).


That sounds good.


My question is: Can I go somewhere and change the defaults for this report
so that I don't have to select them every time? For any other report, I
would save the report to ~/.gnucash/saved-reports-2.4 and just select the
account I wanted to report on.


I can save a register report on windows, I haven't tried on another OS 
to see if it is different there.




But this report doesn't have an option to select the account so my next
thought was to change the defaults.


Are you, perhaps, trying to make a report do something it wasn't 
intended to do ?  If so why ?


Is there anything unusual that you think might be preventing you from 
saving it for reuse other than not understanding what is being reported?


--
Wm

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Account Report/Register Report

[David Carlson]

That is a clever trick.  You could create a separate report for each
security, but I suspect that could easily get out of hand.  Perhaps someone
else has a better suggestion, or perhaps the report could be re-configured
to allow selecting the source account.

David C

On Mon, Mar 5, 2018 at 7:25 PM, Robin Chattopadhyay 
wrote:

> Hi-
>
> Using Linux Mint 18.3, Gnucash 2.6.19...
>
> There's a report I like to use called Account Report. You can get to it
> after opening a register. I use this report to see what gnc has as the cost
> basis for an investment.
>
> Because of the way my 401(k) provider calculates cost basis, I have found
> that the only way to properly track realized gains/losses in gnc is to
> manually make the entries myself. So I use this report and set the options
> to Amount = SINGLE and tick the 'Value' option. The net Value Change neatly
> reflects my cost basis (assuming there are no filters and all transactions
> in the account are visible).
>
> My question is: Can I go somewhere and change the defaults for this report
> so that I don't have to select them every time? For any other report, I
> would save the report to ~/.gnucash/saved-reports-2.4 and just select the
> account I wanted to report on.
>
> But this report doesn't have an option to select the account so my next
> thought was to change the defaults.
>
> Thanks,
> Robin
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Account Report/Register Report

[Robin Chattopadhyay]

Hi-

Using Linux Mint 18.3, Gnucash 2.6.19...

There's a report I like to use called Account Report. You can get to it
after opening a register. I use this report to see what gnc has as the cost
basis for an investment.

Because of the way my 401(k) provider calculates cost basis, I have found
that the only way to properly track realized gains/losses in gnc is to
manually make the entries myself. So I use this report and set the options
to Amount = SINGLE and tick the 'Value' option. The net Value Change neatly
reflects my cost basis (assuming there are no filters and all transactions
in the account are visible).

My question is: Can I go somewhere and change the defaults for this report
so that I don't have to select them every time? For any other report, I
would save the report to ~/.gnucash/saved-reports-2.4 and just select the
account I wanted to report on.

But this report doesn't have an option to select the account so my next
thought was to change the defaults.

Thanks,
Robin
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.