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