Re: [GNC] Report Options - Closing Entries Pattern
Derek and Liz give the correct advice to keep separate books, but to your particular question of getting a filtered P&L—"you can't." You can however, get really close to one using the Transaction Report and its more robust filtering abilities. Then export that to a spreadsheet and fill in your formulas for totaling the various sections. Regards, Adrien On 1/22/22 12:34 PM, Louise wrote: I'm trying to set up a sort of classes in Gnucash like Quickbooks. I like to keep one file with multiple bank accounts and businesses together. So, I wanted to use @bookkeeping, @rental and @personal etc in the description field to be able to pull a P&L and filter only to show transactions with @bookkeeping or @rental in the description. Then I would be able to separate a P&L for each rental or business. My issue is that I'm trying to use Options > Entries > Closing Entries Pattern to filter a P&L. When I put @bookeeping in the field it is showing me exactly the opposite. I get totals of everything that does NOT have @bookeeping in the description field. I'm having a hard time finding any documentation on how to use the closing entries pattern to help filter a report. Maybe I'm going about this the wrong way? Any help is appreciated! ___ 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] Report Options - Closing Entries Pattern
On Sat, 22 Jan 2022 13:34:10 -0500 Louise wrote: > I like > to keep one file with multiple bank accounts and businesses together. > So, I wanted to use @bookkeeping, @rental and @personal etc in the > description field to be able to pull a P&L and filter only to show > transactions with @bookkeeping or @rental in the description. Then I > would be able to separate a P&L for each rental or business. I keep several sets of books. It makes it much easier for my accountant. I have to pay for their services by the hour, so having my information close to what they want to see helps with that. Think about selling one of the rental properties. You want to be able to produce accounts showing what you really paid on upkeep and the true income. A P&L report is just a summary and your purchaser might want more details. You would not want them to know how much cash you had in the bank, nor what other businesses you operate. Such information could change the price offered. Your tax rules may be clear on separate accounts. I need to show separate bank accounts and separate accounting. 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.
Re: [GNC] Report Options - Closing Entries Pattern
HI, On Sat, January 22, 2022 1:34 pm, Louise wrote: > I'm trying to set up a sort of classes in Gnucash like Quickbooks. I like > to keep one file with multiple bank accounts and businesses together. So, > I wanted to use @bookkeeping, @rental and @personal etc in the description > field to be able to pull a P&L and filter only to show transactions > with @bookkeeping or @rental in the description. Then I would be able to > separate a P&L for each rental or business. > > My issue is that I'm trying to use Options > Entries > Closing Entries > Pattern to filter a P&L. When I put @bookeeping in the field it is > showing > me exactly the opposite. I get totals of everything that does NOT > have @bookeeping in the description field. I'm having a hard time finding > any documentation on how to use the closing entries pattern to help filter > a report. Maybe I'm going about this the wrong way? Any help is > appreciated! Yes, I think you are going about this the wrong way. The "Closing Pattern" option is how you tell GnuCash what to look for in the Close Book transactions. When you run Tools -> Close Books, it creates a closing transaction to move all your value from Income/Expense to Equity. However, when you run a report, you need to "ignore" those transactions. Hense, you use the option to tell GnuCash how to find those transactions to ignore... And this is why you're seeing the "opposite" of what you want. GnuCash does not have Classes, and really there is no good way to replicate that behavior. However, I question why you are including Business and Personal transactions in one set of books? Note that there are SOME filtering options you can use within, e.g., the transaction report.. But the MAIN reports (P&L, BS, etc) do not have those same features. Good Luck, > Thanks, > > Louise > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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] Report Options - Closing Entries Pattern
I'm trying to set up a sort of classes in Gnucash like Quickbooks. I like to keep one file with multiple bank accounts and businesses together. So, I wanted to use @bookkeeping, @rental and @personal etc in the description field to be able to pull a P&L and filter only to show transactions with @bookkeeping or @rental in the description. Then I would be able to separate a P&L for each rental or business. My issue is that I'm trying to use Options > Entries > Closing Entries Pattern to filter a P&L. When I put @bookeeping in the field it is showing me exactly the opposite. I get totals of everything that does NOT have @bookeeping in the description field. I'm having a hard time finding any documentation on how to use the closing entries pattern to help filter a report. Maybe I'm going about this the wrong way? Any help is appreciated! Thanks, Louise ___ 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.
