[GNC] Profit/Loss report

[Adrien Monteleone]

Dan,

There have been some previous discussions on the list about how top-level accounts work. (and do not work) I seem to recall that for what you want to accomplish, (essentially a separate account tree) top-level accounts aren’t the solution. The issue is that top-level accounts don’t have a type ‘entity’ to facilitate this use and the other types cause issues as you have discovered.

You can either create sub-accounts for each entity under the main accounts, or use sub-accounts under the subs of the main accounts.

For example:

Expenses
Expenses:Personal
Expenses:Personal:expense 1
Expenses:Personal:expense 2
Expenses:Personal:expense 3
Expenses:Personal:expense ...
Expenses:Business
Expenses:Business:expense 1
Expenses:Business:expense 2
Expenses:Business:expense 3
Expenses:Business:expense ...

(same for Income/Revenue)

or

Expenses:expense 1:Personal
Expenses:expense 1:Business
Expenses:expense 2:Personal
Expenses:expense 2:Business
Expenses:expense 3:Personal
Expenses:expense 3:Business
Expenses:expense ...:Personal
Expenses:expense ...:Business

You’ll probably prefer the first option as this makes it easy to select child accounts in report configurations for either entity all at once instead of individually clicking each one. They’ll also show up in the CoA tab together that way. (though each main type, asset, expense, income, et cetera are still divided up under those main accounts) The first option also makes for quick work entering transactions as you can shortcut the typing to something like “ex:p:...” or “ex:b:...” or simply “ex:p” or “ex:b” and then end up in the area of the list that has the intended entity’s accounts.

Regards,
Adrien


> On Sep 28, 2018, at 8:44 AM, Dan Kalagher <dan.kalagher at gmail.com> wrote:
> 
> I should start by saying I'm new to gnucash.
> 
> I'm trying to use a single set of accounts for both household and small
> business. I added the small business account using the "new top level
> account" when I created it. I now want to run a Profit/Loss report for just
> the business accounts. When I select the top level business account and
> it's children, the report is empty. However if I run the P&L report without
> selecting, I get a full report with all accounts.
> 
> BTW, I'm coming from MoneyDance which allows this type of sub reporting.
> 
> Regards,
> 
> Dan Kalagher
> www.ixploreYellowstone.com
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at 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.
>