Re: [GNC] QUESTION: transaction classes (tags) like QuickBooks?
Thanks Liz.. Very valid point... I don't have much problems with GNUcash... On Tue, Jun 23, 2020 at 4:33 PM Liz Dodd wrote: > On Mon, 22 Jun 2020 20:06:05 +0800 > Adrian Yong wrote: > > > As Gnucash is still under development, > > This is a place to point out a difference in view points. > > Lots of software is still under development. Most commercial software > is, so that they can sell you a new version, rather than just an offer > to give you new features. > > Gnucash for Android is not under development, and that's not a good > thing, as it appears to be abandoned, and no updates will come. > > Every time there are updates, some users have some problems. For many > that marks the first time they come to this mailing list for advice. > You already know about us, and can ask what you need to know. > > 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. > ___ 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] QUESTION: transaction classes (tags) like QuickBooks?
On Mon, 22 Jun 2020 20:06:05 +0800 Adrian Yong wrote: > As Gnucash is still under development, This is a place to point out a difference in view points. Lots of software is still under development. Most commercial software is, so that they can sell you a new version, rather than just an offer to give you new features. Gnucash for Android is not under development, and that's not a good thing, as it appears to be abandoned, and no updates will come. Every time there are updates, some users have some problems. For many that marks the first time they come to this mailing list for advice. You already know about us, and can ask what you need to know. 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] QUESTION: transaction classes (tags) like QuickBooks?
Zi, Welcome to GnuCash! The answer is ‘yes, sort of’. While it doesn’t have an explicit class facility, you can make up your own tagging and filtering system. Specific to your example, each transaction can have multiple splits, that isn’t an issue at all. Each split has a ‘memo’ line where you can describe the split. Additionally, each transaction has a Description (payee if you like) *and* a Notes field right under the Description. You have to turn on View > Double Line to see it and use it. My personal preference is to use Description for payee, Notes for a general transaction description or info, and the Memos as descriptions specific to each split. You also have a NUM field, which may or may not be useful with text for you. The ‘official’ purpose for it is something like Check#, so consider that accordingly if you record check or bank transaction#s. For each split, there is also an Action field that can be used. By default it is a physically small column, but can hold more than one word. So you can have a single Utility transaction with splits for each property. Read the earlier reply I sent in response to Adrian. I outline a basic method for tagging info and how to filter or search for it with reports. You could use Unit#s or street names, etc. as your tags. Note, this won’t give you a P with breakouts as-is. It will allow you to run a P for each property separately. If you want a combination or break-out style report, you’ll need to run the reports that get you the data, then export to a spreadsheet app and re-combine them from there. (or code the reports from scratch) What you are looking for is possible, just not obvious. (even from the docs) Regards, Adrien > On Jun 21, 2020 w26d173, at 2:18 PM, Zi via gnucash-user > wrote: > > Hi > > I've used QuickBooks for years and am seriously considering finding a > (*non*web based) alternative. GnuCash looks very promising, but here's the > million-dollar question (and yes, I browsed the whole site, the manual, the > FAQ, etc. trying to find an answer to this question!) > > In addition to the accounts and sub-accounts that inform reconciliation and > P type reporting, is there a way to *class* transactions the way QuickBooks > does? In other words, can one, while entering a transaction, enter something > like the following: > > (vendor) Local Electricity Provider > (amount) $ total amount of bill > (split line one account) "utilities" AND THEN > (*class*) address of investment property and unit # > (split $ amount for this property) > (split line two account) "utilities" > (*class*) address of *other* investment property and unit # > (split $ amount for *that* property) > etc. > thus allowing a property manager to show expenditures around *each > particular* property. > > OR for instance one travels sometimes, and needs to record the expenses. > Like, the appropriate transaction accounts for such would include "meals", > "lodging", etc. and the CLASS for each could be "Las Vegas 2020", or "Phoenix > 2019" thus giving one a way to show the expenditures for a *particular* trip. > > If GnuCash provides this functionality, I will likely switch over to it! If, > however, it does not, Intuit must, sadly, still win. ___ 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] QUESTION: transaction classes (tags) like QuickBooks?
While there is no official ‘class’ or ’tag’ facility, you can still accomplish this somewhat. You can do searches on any text located in any text field, Description, Memo, Notes, Action, Num, etc. Thus you can create your own tagging system using # or @ if you like. (or any other symbol or even emoji as those are now supported) Most reports have a Filter option where you can only report transactions that match (or exclude) the Filter text. Unfortunately, the report filtering only works for Description, Notes, and Memo fields. Both Edit > Find & (report) Options > Filter allow regular expressions. -- Concerning the ‘finding files’ threads, those all have been user issues. GnuCash hasn’t been eating data. (though you should always have a backup available for *any* important data for *any* app.) I’ve been stepping through 3.0-3.10 and with the exception of a display discrepancy back at 3.1, I haven’t had any major issues. (plenty of small, minor bugs, but that is to be expected, and most of them were quickly fixed after reporting) Of course, upgrade at your own pace. I believe the official policy is to support the current and most recent major version. So after 4.0 is out only the 3.x series will continue to be ’supported’ but I don’t think you’ll see any additional 3.x releases to fix bugs. The wiki has more info on this. Regards, Adrien > On Jun 22, 2020 w26d174, at 7:06 AM, Adrian Yong > wrote: > > Hi Zi, > > I was a QB user as well and have recently switched to Gnucash... > > I have tried splitting expenses claims like Quit Rent & Assessment as an > expense claim but split into Quit Rent and Assessment as separate Expenses > in P & L... > > The one thing which I have trouble with is the General Ledger which QB > lists the opening and closing balances and all the transactions in between > for individual ledger accounts... In Gnucash, you won't get that but the > argument is we enter data using a double entry procedure, so *assuming that > the transactions are entered correctly,* the opening and closing balance > should be reflected in the Account Tree or Balance Sheet... > > As I am not super confident that the transactions are entered correctly, I > do have a problem with this... > > As Gnucash is still under development, there are a lot of updates and I am > hearing of people having difficulties in locating their files after > updating... I think the current version is 3.10 and I am on 3.x... I have > this fear of updating to 3.10... Maybe I will do it after my auditors > confirmed that they have got everything they need... ___ 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] QUESTION: transaction classes (tags) like QuickBooks?
Zi, Welcome to the world of GnuCash. As a user of GnuCash for nearly 15 years, I can tell you that it's a feature-rich application with a great user community. Unfortunately, "classes" is not one of those features. It has been discussed for as long as I can remember (e.g., https://lists.gnucash.org/pipermail/gnucash-user/2001-October/002612.html, https://lists.gnucash.org/pipermail/gnucash-user/2007-July/020856.html, https://lists.gnucash.org/pipermail/gnucash-user/2010-December/037498.html), and users have an established request for it to be added (see https://gnucash.uservoice.com/forums/101223-feature-request/suggestions/1543027-transaction-classifications). The developers are aware of these requests and discussions, but have not to date found time to implement the feature. Since this is a volunteer-run open source project, we accept both the limitations of the program and the input of interested parties who may be able to add a given feature such as this to the program. Examining the threads through the years will yield a number of workarounds that users have cobbled together. Despite its limitations, GnuCash remains for me a powerful and useful program. I heartily recommend it. David T. Original Message From: Zi via gnucash-user Sent: Sun Jun 21 15:18:25 EDT 2020 To: gnucash-user@gnucash.org Subject: [GNC] QUESTION: transaction classes (tags) like QuickBooks? Hi I've used QuickBooks for years and am seriously considering finding a (*non*web based) alternative. GnuCash looks very promising, but here's the million-dollar question (and yes, I browsed the whole site, the manual, the FAQ, etc. trying to find an answer to this question!) In addition to the accounts and sub-accounts that inform reconciliation and P type reporting, is there a way to *class* transactions the way QuickBooks does? In other words, can one, while entering a transaction, enter something like the following: (vendor) Local Electricity Provider (amount) $ total amount of bill (split line one account) "utilities" AND THEN (*class*) address of investment property and unit # (split $ amount for this property) (split line two account) "utilities" (*class*) address of *other* investment property and unit # (split $ amount for *that* property) etc. thus allowing a property manager to show expenditures around *each particular* property. OR for instance one travels sometimes, and needs to record the expenses. Like, the appropriate transaction accounts for such would include "meals", "lodging", etc. and the CLASS for each could be "Las Vegas 2020", or "Phoenix 2019" thus giving one a way to show the expenditures for a *particular* trip. If GnuCash provides this functionality, I will likely switch over to it! If, however, it does not, Intuit must, sadly, still win. Thanks so much! Sent from ProtonMail mobile ___ 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. ___ 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] QUESTION: transaction classes (tags) like QuickBooks?
Hi Zi, I was a QB user as well and have recently switched to Gnucash... I have tried splitting expenses claims like Quit Rent & Assessment as an expense claim but split into Quit Rent and Assessment as separate Expenses in P & L... The one thing which I have trouble with is the General Ledger which QB lists the opening and closing balances and all the transactions in between for individual ledger accounts... In Gnucash, you won't get that but the argument is we enter data using a double entry procedure, so *assuming that the transactions are entered correctly,* the opening and closing balance should be reflected in the Account Tree or Balance Sheet... As I am not super confident that the transactions are entered correctly, I do have a problem with this... As Gnucash is still under development, there are a lot of updates and I am hearing of people having difficulties in locating their files after updating... I think the current version is 3.10 and I am on 3.x... I have this fear of updating to 3.10... Maybe I will do it after my auditors confirmed that they have got everything they need... Regards, Adrian On Mon, 22 Jun. 2020, 17:52 Zi via gnucash-user, wrote: > Hi > > I've used QuickBooks for years and am seriously considering finding a > (*non*web based) alternative. GnuCash looks very promising, but here's the > million-dollar question (and yes, I browsed the whole site, the manual, the > FAQ, etc. trying to find an answer to this question!) > > In addition to the accounts and sub-accounts that inform reconciliation > and P type reporting, is there a way to *class* transactions the way > QuickBooks does? In other words, can one, while entering a transaction, > enter something like the following: > > (vendor) Local Electricity Provider > (amount) $ total amount of bill > (split line one account) "utilities" AND THEN > (*class*) address of investment property and unit # > (split $ amount for this property) > (split line two account) "utilities" > (*class*) address of *other* investment property and unit # > (split $ amount for *that* property) > etc. > thus allowing a property manager to show expenditures around *each > particular* property. > > OR for instance one travels sometimes, and needs to record the expenses. > Like, the appropriate transaction accounts for such would include "meals", > "lodging", etc. and the CLASS for each could be "Las Vegas 2020", or > "Phoenix 2019" thus giving one a way to show the expenditures for a > *particular* trip. > > If GnuCash provides this functionality, I will likely switch over to it! > If, however, it does not, Intuit must, sadly, still win. > > Thanks so much! > > Sent from ProtonMail mobile > ___ > 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. > ___ 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] QUESTION: transaction classes (tags) like QuickBooks?
Hi I've used QuickBooks for years and am seriously considering finding a (*non*web based) alternative. GnuCash looks very promising, but here's the million-dollar question (and yes, I browsed the whole site, the manual, the FAQ, etc. trying to find an answer to this question!) In addition to the accounts and sub-accounts that inform reconciliation and P type reporting, is there a way to *class* transactions the way QuickBooks does? In other words, can one, while entering a transaction, enter something like the following: (vendor) Local Electricity Provider (amount) $ total amount of bill (split line one account) "utilities" AND THEN (*class*) address of investment property and unit # (split $ amount for this property) (split line two account) "utilities" (*class*) address of *other* investment property and unit # (split $ amount for *that* property) etc. thus allowing a property manager to show expenditures around *each particular* property. OR for instance one travels sometimes, and needs to record the expenses. Like, the appropriate transaction accounts for such would include "meals", "lodging", etc. and the CLASS for each could be "Las Vegas 2020", or "Phoenix 2019" thus giving one a way to show the expenditures for a *particular* trip. If GnuCash provides this functionality, I will likely switch over to it! If, however, it does not, Intuit must, sadly, still win. Thanks so much! Sent from ProtonMail mobile ___ 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.
