Re: [GNC] Managing Profit Centers, Enterprises, Projects

2020-05-13 Thread Adrien Monteleone


> On May 13, 2020 w20d134, at 5:10 AM, flywire  wrote:
> 
>> There is also a Jobs structure which can be used with specific projects
> and
>> allows invoices/bills to be grouped for a specific job for a single
>> customer/vendor. It is discussed in the help manual
> 
> I've reviewed that but I understand (??) it's not applicable. I'm a big fan
> of the Tutorial and Concepts Guide where the examples teach you what the
> terminology means and how to apply it.

The ‘Jobs’ feature as I understand it is a bit misnamed. It is more like a 
‘purchase order’. (there’s a filed RFE on renaming it)

There is the limitation that a Job can only have *one* customer, or *one* 
vendor. And while a Customer Job and a Vendor Job can have the same name, they 
won’t be the same Job. Additionally a bill or invoice can have only one Job.

see: https://lists.gnucash.org/pipermail/gnucash-user/2018-August/079310.html 
(Derek wrote the feature, he’s explaining it to me in that thread)

It is not really a means to track revenue and expenses for a ‘project’ or 
client except within those very limiting circumstances. (I have a client that 
issues POs to Vendors but they always cover multiple orders for customers as 
well as for their own stock, so they can’t use the feature.)

It also doesn’t help for anything outside of issuing bills and invoices. 
There’s no way to manually associate transactions with Jobs as best I can tell.

> 
> Back to the camel farm. Just say you sell a sheep in Oz. If you have a road
> train full (
> https://img.izismile.com/img/img3/20100721/640/road_trains_640_26.jpg )
> then no worries, but if it's one you had better eat it because the proceeds
> wouldn't cover the bookkeeping cost. With fees, levies, industry funds,
> different tax treatments, various parties - there's 20 splits for that
> transaction (could be more if it has a lamb) so when you multiply it by the
> subaccounts, well, it's a suicide risk.
> 
> https://bugs.gnucash.org/show_bug.cgi?id=113772#c6

Yes, sub-accounts (or separate trees even) can get very unwieldy very quickly 
even with the simplest cases. A Category/Tag feature is really the only 
solution that covers most if not all cases. (that legitimately belong in one 
book)

I’m not sure how much work it would be, but I suggested in Comment 22 on that 
bug to first expand the filtering option to all cells for every report. (and 
add the option where it doesn’t yet exist for a report, making it standard) 
This way, without even adding another table or tables, users can tag in any 
manner they wish, with as many tags as they like for even the same transaction 
(multi-dimensions) and be able to run reports to analyze their activity. Since 
this type of accounting is really about crafting reports, I figured that’s 
probably where the focus should be. And since Regex is already built in to the 
option, that is quite powerful indeed.

Later, when GnuCash becomes a proper database app, table or tables can be added 
to allow the user to name those other dimensions they need, and maybe even name 
the dimension itself and use that name in the UI where appropriate. (So that 
one could have a list of ‘projects’, ‘jobs’, ‘properties’, ‘relatives’, etc.)

Regards,
Adrien
___
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: [GNC] Managing Profit Centers, Enterprises, Projects

2020-05-13 Thread flywire
As always, thanks for your considered advice David.

It's a single entity where everything is shared except for specific income
and expenses. Separate books are not-on. I'm understanding you are
suggesting a separate subaccount for each Enterprise/Project under the
existing CoAs (eg Expenses:Maintenance:Camel farm). Every report would be
customised for each Enterprise/Project.

> What you are required to do...

I'm not an accountant so in Oz I assume it's:
... provide evidence for amounts in any tax returns if requested (ie give
them the shoebox).

> There is also a Jobs structure which can be used with specific projects
and
> allows invoices/bills to be grouped for a specific job for a single
> customer/vendor. It is discussed in the help manual

I've reviewed that but I understand (??) it's not applicable. I'm a big fan
of the Tutorial and Concepts Guide where the examples teach you what the
terminology means and how to apply it.

Back to the camel farm. Just say you sell a sheep in Oz. If you have a road
train full (
https://img.izismile.com/img/img3/20100721/640/road_trains_640_26.jpg )
then no worries, but if it's one you had better eat it because the proceeds
wouldn't cover the bookkeeping cost. With fees, levies, industry funds,
different tax treatments, various parties - there's 20 splits for that
transaction (could be more if it has a lamb) so when you multiply it by the
subaccounts, well, it's a suicide risk.

https://bugs.gnucash.org/show_bug.cgi?id=113772#c6

>
___
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: [GNC] Managing Profit Centers, Enterprises, Projects

2020-05-12 Thread David Cousens
If these businesses are operated as separate entities in the legal sense,
(i.e. one business activity is not legally liable for the debts of another
activity - this depends on the business structures employed), then they
should have separate books and hence separate reports.

If they are activities of a single entity who is reponsible for the debts
incurred by all the activities, then you could have subaccounts under each
of the top level accounts (Assets, Liabilities, Equity, Income, Expenses)
for each activity. The reports options allows you to specify which accounts
are included in the report and 

for each of the top level accounts you would select the relevant subaccounts
for the specific activity for which you wish to generate reports.  Some
Assets and some Expenses may be shared between all activities for eaxmple. 

In this case you could still run separate books for each activities and
consolidate the reports into a single set of reports in accordance with the
applicable accounting/business recording/taxation requirements.

What you are required to do will be determined by the business legislation
and taxation legislation  and applicable accounting standards in your
jurisdiction. This is where you need to consult a practising accountant in
your area familiar with the applicable legislative and legal requirements.

There is also a Jobs structure which can be used with specific projects and
allows invoices/bills to be grouped for a specific job for a single
customer/vendor. It is discussed in the help manual under the business
features
(https://www.gnucash.org/docs/v3/C/gnucash-help/chapter_busnss.html).


David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.


[GNC] Managing Profit Centers, Enterprises, Projects

2020-05-12 Thread flywire
I don't know the proper accounting term for this, the intent is to use
reports to compare finances between the different parts of the entity. I'm
asking how people do it.

https://wiki.gnucash.org/wiki/GnuCash_Quick_Start_Guide_For_Business_Users uses
a simple rental business as an example. Assume house, unit and short-stay
groups. They each have the same income and expense accounts and
the customers (tenants) come and go but the finances are very different for
each group. How are specific reports generated (either individual or
combined) to compare the three groups?

The question in another context. How is the landscaping enterprise
performing compared to the camel farm dairy, tourist rides, and shed
building?

I'm aware of the jobs business feature and reported bugs.
___
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.