Re: [GNC] Account Hierarchy
Thank you for the reply, Frank. To take the second half of your reply first, there won’t be many products. I used the word ‘product’ for illustration; in actual fact, these are product groups or types. That said, your other suggestion, to treat shops as assets, is something I will look into. My accountancy knowledge is basic to say the least. I will attempt to find some reading material about this. Thank you for the suggestion. Kind wishes - Patrick On Fri, 3 May 2024 at 21:56, Frank Ciani wrote: > This is where Tags would be great. There are some work arounds to 'fake ' > tags into existence, but they are cumbersome to use - my opinion. > > Shop A and Shop B aren't income/expense accounts. They're locations > comparable to assets. > > Why not setup asset accounts for Shop A and B. Then sales by product and > expenses would be debited/credited to the appropriate Shop account. Then > it would be easy to generate Shop A reports vs. Shop B. > > Your proposed hierarchies would necessitate a lot of duplicate > income/expense accounts which would become a nightmare to maintain. > > Another question is how many products do you plan to have? If it's only a > few, I think you'll be OK. If it's a lot, perhaps you need a product that > has an inventory capability. > > > On Fri, May 3, 2024, 7:57 AM Patrick Skelton > wrote: > >> Hi, >> >> I am about to structure a new set of accounts for a business. GnuCash uses >> a hierarchy, which I am currently trying to decide upon. Two >> part-hierarchies come to mind: >> >> *FIRST* >> >> Sales >> >> Shop A >> >> Product 1 >> >> Product 2 >> >> Shop B >> >> Product 1 >> >> Product 2 >> >> >> *SECOND* >> >> Sales >> >> Product 1 >> >> Shop A >> >> Shop B >> >> Product 2 >> >> Shop A >> >> Shop B >> >> >> The first would make it easy to see sales for each shop but harder to find >> out the sales for each product. The second would make it easy to see sales >> for each product but harder to find out the sales for each shop. >> >> Both of these seem like reasonable questions to be able to ask of the >> accounts. How do I choose which hierarchy to go with and is there any way >> I >> can answer both of these questions? >> >> Any advice would be most welcome as I am no accounting expert and have >> only >> basic knowledge of GnuCash. >> >> Kind wishes - Patrick >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> - >> 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Account Hierarchy
Thanks Stan, I've bookmarked for future reference. Regards, Adrien On 5/3/24 9:50 PM, Stan Brown (using GC 4.14) wrote: https://github.com/dawansv/gnucash-custom-reports?tab=readme-ov-file#tag-prefix ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Account Hierarchy
On 2024-05-03 14:36, Adrien Monteleone wrote: > There is also a custom 'Tag' version of that report floating around on > this list. Look for the user 'flywire' to find posts linking to it. > (it's on Github I think) Posted 2024-04-28 by flywire with subject "The equivalent for Quicken Tag": > Use the custom transaction report at > https://github.com/dawansv/gnucash-custom-reports?tab=readme-ov-file#tag-prefix Stan Brown Tehachapi, CA, USA https://BrownMath.com ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Account Hierarchy
There is another, simpler, option, such as: Sales and that's it. If you're using the Business Features and will be creating Invoices for your sales, then the invoice line items will contain the individual product sales data. (you also might have separate sub-accounts under Assets:Inventory for each item) By default, this is not exposed for reporting, but if you unset the preference to 'consolidate splits on posting' then each line item will appear in affected registers. From there, you can craft Transaction Reports that filter based on say, the name of the product allowing you to create an aggregate sales report. (you can do this per invoice, or set a global preference) I'm not sure what your use of 'Shop A' and 'Shop B' is in the real world. Are these just separate physical locations of the same business? If not, and these are distinct business entities, the usual recommendation is they should have their own individual books. If they are just different sales locations, you can put that info in the Invoice line items as noted, and use the Transaction Report filter tab on that text as well. Or, you can go so far as to create: Sales: Shop A Shop B The line items will contain the product data, and the posting account will segregate the sales locations. These can be selected per invoice. There is also a custom 'Tag' version of that report floating around on this list. Look for the user 'flywire' to find posts linking to it. (it's on Github I think) If you aren't going to use the business features and will simply be doing manual sales transactions (imported, or created individually), then you can use a similar approach with filtering and/or tagging and put the 'shop' location either in the Description, Notes, or Action field. (use Double Line view mode to see Notes) Or as above, create sub-accounts under Sales. The only report that can't filter/tag nicely at present is the P/Income Statement, but you could craft something via the Transaction Report to get close. Further possibilities open up if you export said reports to a spreadsheet app for further manipulation if you can't get exactly what you want within GnuCash. Any of the above approaches would remove the either/or situation you're contemplating and open up more flexibility down the road should you need it without having to refactor your historical transactions or account structure as you find your needs change. Regards, Adrien On 5/1/24 3:30 AM, Patrick Skelton wrote: I am about to structure a new set of accounts for a business. GnuCash uses a hierarchy, which I am currently trying to decide upon. Two part-hierarchies come to mind: *FIRST* Sales Shop A Product 1 Product 2 Shop B Product 1 Product 2 *SECOND* Sales Product 1 Shop A Shop B Product 2 Shop A Shop B The first would make it easy to see sales for each shop but harder to find out the sales for each product. The second would make it easy to see sales for each product but harder to find out the sales for each shop. Both of these seem like reasonable questions to be able to ask of the accounts. How do I choose which hierarchy to go with and is there any way I can answer both of these questions? Any advice would be most welcome as I am no accounting expert and have only basic knowledge of GnuCash. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Account Hierarchy
Hi, I am about to structure a new set of accounts for a business. GnuCash uses a hierarchy, which I am currently trying to decide upon. Two part-hierarchies come to mind: *FIRST* Sales Shop A Product 1 Product 2 Shop B Product 1 Product 2 *SECOND* Sales Product 1 Shop A Shop B Product 2 Shop A Shop B The first would make it easy to see sales for each shop but harder to find out the sales for each product. The second would make it easy to see sales for each product but harder to find out the sales for each shop. Both of these seem like reasonable questions to be able to ask of the accounts. How do I choose which hierarchy to go with and is there any way I can answer both of these questions? Any advice would be most welcome as I am no accounting expert and have only basic knowledge of GnuCash. Kind wishes - Patrick ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Account Hierarchy Meesed Up
AAK, When I want to make a massive change to something like my account tree, I make a map of where I want to go first. Often it is just with pencil and paper, but sometime I can print something and mark it up. David Carlson On Tue, Mar 12, 2019 at 12:58 AM Liz wrote: > On Sat, 9 Mar 2019 10:25:07 -0600 (CST) > AAK wrote: > > > I imported a QIF file into Gnucash and started editing the account > > hierarchy. I inadvertently created a mess. I now have a checking > > account berried under the Expenses account, which in turn, is berried > > under the Automobile Expenses category. I can't figure out how to > > reverse this mess. How can I make hidden accounts show up again? Is > > there a way to edit the entire tree structure at once? > > Take a deep breath, and relax. > > Go to the Accounts tab. > Choose an account to move, right click and select Edit Account. > This opens a box. In mine, at the bottom right, is a box with a name > like "parent". > Find where the account should be in the account tree, and move it. > For example, you might put the Cheque account under "Assets". > > Make sure its right, and save. > > If you still get it wrong, you can move things again. > > Liz > ___ > 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. > -- David Carlson ___ 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] Account Hierarchy Meesed Up
On Sat, 9 Mar 2019 10:25:07 -0600 (CST) AAK wrote: > I imported a QIF file into Gnucash and started editing the account > hierarchy. I inadvertently created a mess. I now have a checking > account berried under the Expenses account, which in turn, is berried > under the Automobile Expenses category. I can't figure out how to > reverse this mess. How can I make hidden accounts show up again? Is > there a way to edit the entire tree structure at once? Take a deep breath, and relax. Go to the Accounts tab. Choose an account to move, right click and select Edit Account. This opens a box. In mine, at the bottom right, is a box with a name like "parent". Find where the account should be in the account tree, and move it. For example, you might put the Cheque account under "Assets". Make sure its right, and save. If you still get it wrong, you can move things again. Liz ___ 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.