Re: [GNC] Is GnuCash.org down (Monday, 2/13/2023, 7:20PM PST)
Looks like it's down from here https://downforeveryoneorjustme.com/gnucash.org Kind regards, Greg Feneis (Pixel 3) On Mon, Feb 13, 2023, 19:25 Ken Pyzik wrote: > Is GnuCash.org down (Monday, 2/13/2023, 7:20PM PST)? Can't seem to get to > it. - Ken > ___ > 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] Opening Gnucash
Richard, You may want to provide a few more details. Perhaps mention the version of GnuCash you're using, which OS you're using. How do you open GnuCash, by starting the application or by clicking on a saved file? And so on. Kind regards, Greg Feneis On Sat, Sep 10, 2022 at 6:36 AM Richard Barmann wrote: > When IO open Gnucash to make some entries in the checking account It > opens a page from the past. How can I open the latest page with the > entries up to date. > > Richard Barmann > > ___ > 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] Third party OFX/CVS providers
Same. Making FI data available to the user to download without Quicken to hold the user's hand seems like at best an afterthought in the design of most FI websites. I find I really have to dig for it at many sites. Kind regards, Greg Feneis On Sat, Aug 6, 2022 at 7:16 PM Gyle McCollam wrote: > I have a Citibank credit card and I use the online banking tool to > download a QFX file, but I went to their website and to the activity (not > Statements) and selected the activity/statement month. Then I selected the > download icon and it gave me the following: > [cid:dc3e8429-3ab4-4639-9150-ff3c3a03ffd5] > As you can see there are many formats to choose from. I don't know what > type of statement you are downloading, but I would think if they give you > these options on a credit card, they may give you these options on another > type of account. However, it wouldn't be the first time the left hand > didn't know what the right hand was doing. > > I've added an attachment in case the picture doesn't get through. > > > Thank You, > > Gyle McCollam > > Gyle McCollam > > gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email > > > From: gnucash-user on > behalf of flywire > Sent: Saturday, August 6, 2022 9:36 PM > To: Gnucash Users > Subject: [GNC] Third party OFX/CVS providers > > My Citibank statements are only available as pdf and I use > https://github.com/flywire/pdf_statement_reader . It is based on tabula > and > forks another project to make it functional. More config info at > https://github.com/marlanperumal/pdf_statement_reader/issues/34 . > ___ > 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. > ___ 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] Description list
I suspect what collects in the autocomplete list is generated live as you type, and once you've entered the text in that field, the list is essentially discarded. It's probably not presented to you as an excerpt from a preexisting data file of sequential terms that could be presented to a user in a text file. However, it might be a cool feature to have a certain character sequence the user could type that makes the autocomplete function simply list all possible suggestions in alphabetical order for the user to browse instead of listing the most likely suggestions. Kind regards, Greg Feneis (Pixel 3) On Wed, Jun 29, 2022, 17:37 Steve Elstad wrote: > In my simple mind, to do autocomplete you are looking up the entered values > in a list for a closest match. Seems you could export that list? > > Steve > > -Original Message- > From: gnucash-user On Behalf Of Jeff > Sent: Wednesday, June 29, 2022 5:16 PM > To: gnucash-user@gnucash.org > Subject: Re: [GNC] Description list > > Hi Steve, > > That's a great idea, and one that I wish was there, as it's always those > seldom used ones that you can't remember what you typed it as. > > It may not be possible to generate the list from within GnuCash, but you > could always export the register to Excel and remove the duplicate entries > to create your own list. > > Regards, > Jeff. > > On 30/6/22 10:05, Steve Elstad wrote: > > Thanks for that. Is there a way to produce a list of all those > descriptions that I have used before? Autocomplete is great if I am close > to spelling the description I want. Otherwise I am just guessing and would > like to reuse a previously used description. > > > > > > > > Steve > > > > > > > > From: Glenn Fowler > > Sent: Wednesday, June 29, 2022 4:38 PM > > To: Steve Elstad > > Cc: GnuCash users group > > Subject: Re: [GNC] Description list > > > > > > > > Hi Steve, > > > > > > > > Your register *is* your list. Auto-complete just matches previous entries > as type. > > > > > > > > On Wed, Jun 29, 2022 at 7:21 PM Steve Elstad <mailto:st...@ngc7331.com> > wrote: > > > > Hi, is there a way to create a list of all the items I have used in > > the Description field? The autocompletion works if I remember the > > description correctly. Would like to see a list for those rarely used > ones. > > > > > > > > In the Transfer field there is a pull down list of accounts. > > > > > > > > Thanks, > > > > > > > > Steve > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org <mailto: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. > > > > ___ > 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. > ___ 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] Language settings
Roger, Perhaps an update to the OS has caused a change to whatever GnuCash references to detect the OS language setting? If changing the OS language setting is trivial, you might try setting your OS language setting to something other than Spanish, restart, start GnuCash and confirm that GnuCash has followed this language setting. Then, change your OS language setting back to Spanish, restart, start GnuCash and confirm GnuCash has followed this language setting as well. Pure conjecture. Good luck. Kind regards, Greg Feneis On Mon, Jun 13, 2022 at 4:11 PM Liz wrote: > On Mon, 13 Jun 2022 17:36:07 -0500 > wrote: > > > How do I get my GnuCash back to Spanish? Version 4.6 installed Spanish > > automatically but it recently switched to English. > > > > > > > > Third time to ask for help with this question. > > > > > > > > Thanks, > > > > Roger > > Gnucash runs according to your system settings. So if you set your > computer to a language, that is what you should see. > This wiki page gives some information on how to change for Windows users > > https://wiki.gnucash.org/wiki/Locale_Settings#Changing_the_Language_on_Windows > > 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] Import is finding no matching transactions
Another possibility is if you happen to be trying to import transactions that GnuCash thinks have already been imported, the matcher dialogue may appear like there are no transactions being proposed to be imported, essentially there will be nothing displayed in the matcher dialogue. Just in case this is what you're seeing. This according to how GnuCash 3.21 works. Maybe newer GnuCash still works the same? Kind regards, Greg Feneis (Pixel 3) On Sat, May 14, 2022, 14:20 Jean L wrote: > Can you give us more details? Are you saying that GC does not show > matching transactions, but does it at least show the imported > transactions (and fails to find matches)? > > Note that the transaction dates have to match (the imported transactions > and the ones you have in your ledger) for them to be matched (look in > your preferences, the "import" tab, that's where the thresholds are > adjusted for days), they don't have to match exactly depending on the > "likely match day threshold" but they have to be within that. You could > try to debug by lowering the "match display threshold" to see whether > that helps GC find them. But in theory, if the days match and the > amounts match, GC should find the transactions and show them in the > reconcile dialog. > > On 5/14/2022 2:06 PM, Thepwnd via gnucash-user wrote: > > Hi all, > > > > So I am still fairly new to Gnucash (and personal finances for that > matter), but I've been using it the last 2 months and change to track my > family's spending. I primarily use my debit card for daily purchases, but I > have begun keeping receipts for more immediate entry into the ledger and to > more accurately track what categories I spend the most money in. However, > there are still some purchases I make that don't give me a receipt, and in > those cases, the only record I have is on my bank statement. > > > > I would like to be able to import my bank statement occasionally to > catch all those transactions, but not duplicate all the ones I already > entered. My understanding is that when importing transactions from a bank > statement, Gnucash should be able to match any existing transactions on the > ledger and mark those as "Reconcile" on the statement. I swear this was > working when I first started using Gnucash, but now, when I try to import > my bank statement, Gnucash isn't finding any matches on the ledger, even > though the vast majority of the transactions on the statement already exist > in Gnucash. > > > > I can't figure out what happened, and there don't appear to be any > preferences for imports or matching, so I'm not sure what I might have > changed to cause this to stop working. Does anyone here have any ideas? > > > > Thanks in advance! > > -Aaron > > > > Sent with [ProtonMail](https://protonmail.com/) secure email. > > ___ > > 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 seehttps:// > 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. > ___ 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
I thought perhaps Quicken has a dialogue/wizard feature that appears as a paper check and works as an easily filled form that the user may repeatedly fill as if writing a paper check (QuickBooks had this, I imagine Quicken does too). This might be what the OP is asking to find. GnuCash doesn't have this feature. I think the previously mentioned tutorial should get the OP on the right track Kind regards, Greg Feneis (Pixel 3) On Fri, May 13, 2022, 06:02 Derek Atkins wrote: > Michael, > > On Fri, May 13, 2022 8:50 am, Michael or Penny Novack wrote: > >> First, I highly recommend you read the GnuCash documentation. The > >> Tutorial and Guide are very useful in explaining the concepts, and the > >> Help is useful at explaining what the buttons do. > >> > >> Having said that, there are two ways to enter a transaction like a > >> Check. > >> The first is to open the Transfer Dialog (Ctrl-T) and enter the date, > >> amount, source (e.g. Assets:Checking) and destination (e.g. > >> Expenses:Rent). > >> The second is to open the account register of the checking account and > >> from there you can create a transaction for the expense. > > > > OR, in the second case, you could open the account for the expense and > > do it there. With gnucash, entering a transaction affecting just two > > accounts you can do it form the ledger account of either. But please > > note IF AN EXPENSE. When you write a check, this will be a credit to the > > checking account. The debit side of the transaction will usually be an > > account under expense BUT NOT NECESSARILY SO. For some examples: > > Considering the OP said "doesn't know accounting", I chose not to > introduce this because in the majority of cases it will just confuse the > user and they will enter the transaction incorrectly. Also, most humans > intuitively understand transactions from an Asset or Liability, but have a > much harder time "originating" a transaction from an Income or Expense > account. > > Yes, a user CAN enter a transaction from any account, but IMNSHO a newbie > user should be encouraged to enter them from an Asset or Liability account > to reduce the chance of errors and confusion. > > Thanks, > > > 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. > ___ 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] How to handle multiple entries of multiply reconciled entries
Duplicate transactions could happen if the user isn't carefully reviewing what the matcher has cooked up during importing of account data from the FI to GnuCash. EG if I import credit card data, payments to my credit card are automatically attributed to my checking account. Then, If I import data from my checking account data, a failure in matching promotes the same transaction to be added again because the existing transaction isn't matched to the transaction being imported. The matcher's automation is good for the majority of the work, but the user still needs to review its work and occasionally correct things. Anyway, perhaps a scenario like this is causing your duplicates? Kind regards, Greg Feneis On Thu, Feb 3, 2022 at 8:09 AM Alan A Holmes wrote: > Hi Jeff, > > Did you take a copy of the database before you upgraded to version 4.9. If > so you could take a copy of this backup and open that in version 4.9, which > might tell you if the corruption existed before upgrading to version 4.9. > > Do you have anyway of finding out which version you had before version > 4.9? Was it another flatpack version, or was it the version as part of > Ubuntu 20.04 LTS? That version might still be available on your machine, or > you could re-install that version, which would allow you to look at any > backup copy before upgrading to version 4.9 in that version to see if the > corruption existed. > > You could also look at any/all backup copy taken automatically by version > 4.9 to see if the corruption exists. This depends on how many days of > backups/logs you have specified should be kept in the settings. This might > show when the corruption first started. > > If you can find a backup copy that isn't corrupted then you could start > with that copy and then either manually enter all transactions since then, > or use the log files created since then to re-apply a subset of > transactions (I think I remember a thread somewhere that said you can be > selective in which transactions to re-apply). > > > Alan A Holmes > > -Original Message- > From: gnucash-user alanaholmes.me...@gnucash.org> On Behalf Of Jeff > Sent: 03 February 2022 07:43 > To: Gnucash userlist > Subject: [GNC] How to handle multiple entries of multiply reconciled > entries > > How I did this is beyond me, somehow I confused GNC to let it happen or > had a data corruption when the journal was improperly saved (power outage, > GNC lost a poker game, thought it was Quirken, etc). I use uncompressed > XML on Ubuntu 20.04LTS. > > I have discovered multiple (dozens) of transactions that are duplicates in > several registers but; reconciled to the wrong accounts. I am not sure of > the easiest and proper way to correct them. > > Example of the simplest ones are: using Check 101, Cash, salary. > > 01/01/10 chk 101 -> Cash -> chk 101 reconciled > > 01/01/10 chk 101 -> salary -> salary reconciled > > These are posted as 2 entirely separate transactions, in the same > register, but are supposed to be only one transaction: > > 01/01/10 chk 101 -> salary -> both reconciled > > As a result my current balance is now off by off by over $4,000. > > And the real kicker, is that these errors now go back 3 years in this > journal. I know these errors did not exist prior to FlatPak 4.9, not sure > which version I upgraded from to 4.9. Plus they would have shown up when I > did reports for taxes and income expense statements last year. > > Suggestions, besides burning more midnight oil than this old man has left, > other than to delete all of them and enter all of them correctly as I find > them. I'm in tax time crunch here. > > -- > --JEffrey Black M.B.A. > > ___ > 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. > ___ gnucash-user mailing list gnucash-user@gnucash.org To
Re: [GNC] How to get debug to work (saying "uncle")
Also, I'm not sure, but I don't think GnuCash has a facility for QuickBooks' or Quicken's categories Kind regards, Greg Feneis (Pixel 3) On Mon, Jan 17, 2022, 15:04 flywire wrote: > Test one and a few records too. > > Alternatively, you could try csv format. > > On Tue, Jan 18, 2022 at 9:50 AM flywire wrote: > > > Try part of the qif file at a time. > > > ___ > 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] access to Gnucash Nabble
It might be worth mentioning, I think the recommended location for the file (...app data... and files and folders contained), is a hidden folder. IE It may not appear in searches, or by navigating there by clicking icons in Windows explorer. However, a user should be able to formulate the path and type it into the address bar. Once you make it to the app data folder, you're in. Good luck 爛 Kind regards, Greg Feneis (Pixel 3) On Sun, Jan 16, 2022, 19:09 Liz Dodd wrote: > On Sun, 16 Jan 2022 16:28:40 -0500 > Ken Farley wrote: > > > Argh. This makes it incredibly difficult to help someone when they're > > looking at a directory of files and it shows three "setup" files, > > because Windows is saving you the bother of knowing there is a > > setup.bat, setup.exe, and setup.ini file. Unless you turn off that > > particular option, you don't know which file is which. > > I'm not using Windows these days, but I recall a specific gotcha from > Win7 where it cached a copy of a working config file, and you could > change the config file as often or as much as you liked and absolutely > nothing happened. > > I would get the OS to search the hard drives for "gtk-3.0.css* because > there might be another copy stored somewhere. > > 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] Account Name Matching
As I recall, this issue was reported a good while back on a GnuCash version. I don't recall the version or the OS it was on. Or something similar, where a text field couldn't be edited, and cursor couldn't be manipulated. I forgot what the solution was. It seems like the work around was to place the cursor into a different field, edit that, then place the text cursor back into the problem field. Sorry this isn't very helpful, but maybe it will jog the memory of someone more capable? Kind regards, Greg Feneis On Fri, Nov 12, 2021 at 2:25 PM Dale Alspach wrote: > I have encountered what appears to be buggy behavior when entering the > Transfer account for a transaction. If I make a typing error so that no > existing account matches, the Transfer cell does not allow editing, i.e., > backspace doesn't work, arrows don't work, the cursor position can be > changed with the mouse but delete doesn't work. If I can get the "Do you > want to create this account?" popup to appear (answer No), I can sometimes > get something sensible to happen and then fix the name. > This is on linux mint 20 with the 4.8 flatpak. > Has anyone else seen this? > Dale > ___ > 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] Error importing QIF file
As I understand, GnuCash for Android is no longer supported by its creator and is not supported by GnuCash desktop developers. It's a separate project that happens to have GnuCash in its title. My best recommendations include taking over and continuing development of GnuCash for Android. Or, try WINE for Android and see if you can run GnuCash desktop from within WINE. This may also take some work. Perhaps other GnuCash for Android users will be along and offer you more help with continuing to use GnuCash for Android as it is. Good luck! Kind regards, Greg Feneis On Sat, Oct 23, 2021 at 7:39 AM parag puranik via gnucash-user < gnucash-user@gnucash.org> wrote: > I exported a data file from Gnucash Android App version 2.4.0 in QIF > format. While importing this QIF file into Gnucash desktop version 2.6.19 > or even in version 3.10, I get error saying "Share price: Unrecognized or > inconsistent format.", The import process has to be aborted. The QIF data > file is plain and simple accounts-file and does not contain any > Share-Transaction whatsoever. What is the solution ? > ___ > 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] My data files have disappeared???
I was glad to be of help! Kind regards, Greg Feneis On Sat, Oct 16, 2021 at 10:27 AM Neil Campbell wrote: > Hi Greg > > I didn’t believe you because I couldn’t find the right file in my list on > Finder. However, I tried what you said opening all GNUCash accounts even > though they were all called Income Statement May 2021. On the third attempt > I found my file and saved it with a new name. Also backed it up > immediately! Thank you so much Greg for taking the trouble to help me. I > will remember this for the future. > > Best regards. > > *neilneilcam...@gmail.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 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] My data files have disappeared???
Once the program starts with the undesired data file loaded, you can use the program's file menu to select another (more recent) data file or backup file to see if you can find the right one. You can do this successively to try various files until you find the one you want. Once you've established which file is the one you expect, save it as .gnucash using the same file menu. I recommend making sure is unique so you don't risk overwriting other data. Then, I believe if you close the program, the following times you start the program, it should try to load that file you just named/saved. IE, typically GnuCash loads the last file it was made to save, if I understand correctly. Kind regards, Greg Feneis On Sat, Oct 16, 2021 at 4:16 AM Neil Campbell wrote: > I am using GNUCash v4.8.2 which I upgraded to yesterday on a MacBook Pro > (operating system 10.15.7 Catalina). I did a months accounting entries for > the month of September and ran reports such as P - no problem. > > When I come to use GNUCash this morning it automatically loads a data > file, but the last transaction on this data file is 31 May 2021. I seem to > have “lost" the latest backup (and the three previous months) plus > everything that was posted for June, July, August, September each month > having about 200 transactions. I cannot find any trace of any data file > later than 7 June 2021 on my computer. > > Can anyone please tell me what has happened to my data files for the > previous months? > > Neil > neilcam...@gmail.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 > 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] Column widths-- Help!
A user should be able to adjust each column's width by dragging its right side (except description column). Sometimes the result is the total width of all columns becomes wider than the window or dialog they appear in. (When this happens, look for a horizontal scroll bar to appear at the bottom of all columns) This can make things appear as if columns are disappearing or suddenly becoming too narrow. Usually, just double click the description column header and its width will adjust to allow all of the columns to be seen in one window's width (as long as there's enough room). That is to say, manually adjust or auto adjust all columns' widths but description, as necessary, then auto adjust description column width last. Kind regards, Greg Feneis (Pixel 3) On Mon, Oct 4, 2021, 23:16 Gyle McCollam wrote: > Steve, > I had a similar problem in a reconciliation window. It turned out that > there was some bad data in the description column, namely a lot of spaces > and what looked like the enter key symbol at the very end. If this just > happened recently, I would suggest you check each of the description > entries by using your mouse and clicking in the middle of the text. Then > hit the end key, which should take you to the end of the text. I have the > feeling that on one line it will take you way to the right, past where the > text actually ends. That line is most likely so long and that is why > double clicking does solve your problem. You could left click the left > click the right side of the description column, if you can distinguish it > from the right side of the transfer column, and drag it to the left > manually making the description column narrower. > > > Thank You, > Gyle McCollam > > Gyle McCollam > > 609.680.2326 Mobile > > gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email > > > From: gnucash-user on > behalf of Steve Miller > Sent: Saturday, October 2, 2021 1:08 PM > To: gnucash-user@gnucash.org > Subject: [GNC] Column widths-- Help! > > [image: PXL_20211002_170211297.jpg] > Long time user of GnuCash on Windows laptop, using latest version. > > I was trying to widen the transfer column. In fooling around with it, > however, I seem to have gone down a rabbit hole. > > Now, my description column is extremely wide, my transfer column has > basically disappeared (yes, I know it's there, but the vertical edges are > next to the adjoining column and indistinguishable. See the screenshot. > > I understand I can't "move" the description column. But whenever I tried to > move the other columns to the left, it just reduces the width (and like the > transfer column, seemingly disappears). How do i shrink the description > column, double clicking on it does not reset. > ___ > 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] Cash Accounting Method
Hi Steve, I operate a sole proprietorship in the US in cash basis and have been using GnuCash for many years. Perhaps 10 years? Of the few problems I've encountered using GnuCash, its not explicitly supporting cash basis accounting hasn't been one of them. However, my business is small, and I have no employees. It switches from being a main source of income to being a side hustle, depending on my employment status. Welcome to GnuCash. If you have a specific need not being met by GnuCash, perhaps mention that, and the kind folks here may help find a way to get you what's needed. Kind regards, Greg Feneis On Sun, Sep 12, 2021 at 2:54 AM Steve Morrow wrote: > I spent much of today evaluating GnuCash for use with my U.S. based small > business. I found it to be robust in its functions. > > > > Unfortunately, it only supports the accrual accounting method (income and > expense recognized when invoiced or billed). My business uses cash > accounting method (income and expense recognized at time of receipt or > payment). > > > > I highly recommend an enhancement to add an accounting method option for > accrual or cash method. > > > > This makes a big difference in reporting! > > > > Steve Morrow > > > > ___ > 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] Comenity Bank OFX Exports
IIRC, there is a setting in GnuCash that allows the user to compensate for when the FI does this. The setting is likely not in preferences, since it's going to need to be per account. Maybe see if the account has some setting that will help? Kind regards, Greg Feneis (Pixel 3) On Sat, Aug 14, 2021, 18:02 David Carlson wrote: > My wife recently opened a Comenity Bank Petco credit card and their web > presence apparently reverses the values for charges and payments in their > OFX exports, compared to other credit cards. This surprises me since they > must have many other cards that presumably would not be reversed in their > OFX exports, if they offer them. > > 1. I would like suggestions of references to other Comenity cards with > correct OFX exports (if any exist) to mention if I decide to ask them to > correct the problem, or > > 2. Is there an easy way to preprocess OFX transaction import files to > reverse the signs of every transaction? > > 3. Their export files also include references to external corrections not > included in the files so GnuCash has to indicate that the missing external > correction exists. I am not sure if I want to keep those references > either, so is there an easy preporcess way to delete those? If not, can > the OFX generic import show the references during the import process? One > of those references looks like this: > obfuscatedidentifier > REPLACE > > Other information that I found on the internet suggests that one would be > wise to avoid Comenity cards in general, which is probably why this is the > only Comenity card that we have. > -- > 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. > ___ 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] Fwd: Re: Creating a customer report by location
Perhaps use of jobs could help? If jobs were named per location, or included location in the job name or description? A customer could have multiple locations indicated by job. The thing I don't know is whether reports can sort on job names or descriptions 樂 Kind regards, Greg Feneis (Pixel 3) On Fri, Aug 6, 2021, 12:51 Derek Atkins wrote: > David, > > I'm not sure how you would do that. Customers are just a flat database, a > list; there is no Customer Hierarchy. > > -derek > > On Fri, August 6, 2021 3:34 pm, David H wrote: > > Samantha, > > > > Like David Carlson I'm not a business features user so I'm only guessing > > here but can you setup your customers or Sales in a heirarchy - i.e > > Customers, Customers UK, Customers Local, Customers Non UK OR Sales, > Sales > > UK, Sales Local, Sales Non UK and report on them that way ? > > > > Cheers David H. > > > > On Sat, 7 Aug 2021 at 03:36, Samantha Payn > > > > wrote: > > > >>Sorry, I replied to Derek only and I meant to include the list. > >> > >>Here is my response to Derek's question. > >> > >>-- Original Message -- > >> > >>From: Samantha Payn > >> > >>To: Derek Atkins > >> > >>Date: 06/08/2021 16:26 > >> > >>Subject: Re: [GNC] Creating a customer report by location > >> > >> I am a freelance translator in the UK with clients all over the > >> world. In applying for advice and grants from a local > >> government-run > >> business support agency they want to know the proportion of my > >> sales > >> to local (county) customers, to the wider UK and as “exports”. > >> > >>Location by country for me would be sufficient (I don’t yet have any > >>clients in my actual locality). > >> > >>In fact, for my purposes, a custom text field with A, B, C, D or E > >>would be sufficient. > >> > >>I hope this helps and would love it if someone could come up with > >>something. > >> > >>Many thanks for any pointers > >> > >>Samantha > >> > >> On 6 Aug 2021, at 15:25, Derek Atkins wrote: > >> > >>Hi Samantha, > >>As far as I know, there is no report like that. Indeed, I can't even > >>think of a way that you could collate customers by location within > >>GnuCash. Are you thinking by State? By Zip Code? By some other > >>means? > >>Once you figure that out, then one could write a routine that sorted > >>and > >>collated based on that. But to my knowledge, no such thing exists. > >>I'm curious what your actual use-case is here? > >>-derek > >>On Fri, August 6, 2021 9:11 am, David Carlson wrote: > >> > >> No, not unnoticed, but I do not use business features, so I waited > >> to see > >> > >> if a business user would step up. > >> > >> GnuCash has no geographical data feature to use for such a report. > >> You > >> > >> would have to somehow manually add appropriate information in a > >> text > >> > >> field, > >> > >> but reports generally only have rudimentary sorting on text > >> fields, > >> so > >> > >> maybe at best you could come up with a manually implemented zip > >> code > >> > >> scheme. > >> > >> Short answer, no. > >> > >> On Fri, Aug 6, 2021 at 7:43 AM Samantha Payn < > >> > >> saman...@boorertranslations.com> wrote: > >> > >>Is this not possible, or has this request slipped through > >> unnoticed? > >> > >>Cheers > >> > >>On 05/08/2021 14:26 Samantha Payn > >> > >> <[1]saman...@boorertranslations.com> > >> > >>wrote: > >> > >>Can anyone tell me how to set up a report on income by customer > >> > >>location, please? > >> > >>Many thanks > >> > >>Samantha Payn > >> > >>___ > >> > >>gnucash-user mailing list > >> > >>[2]gnucash-user@gnucash.org > >> > >>To updat
Re: [GNC] Simple Update Question
Sharon, The risk of updating GnuCash to the most recent version on a Windows 7 computer is pretty small compared to your continued use of Windows 7. Microsoft stopped supporting Windows 7 about a year and a half ago. You should avoid using Windows 7 for anything of consequence. Perhaps things like offline games and distributed computing roles such as the Folding at Home project would be OK. Kind regards, Greg Feneis (Pixel 3) On Mon, Aug 2, 2021, 20:47 Peter West wrote: > Hi Sharon, > > I’m CC this to the list, as I cannot answer it. > > Peter > — > Peter West > p...@ehealth.id.au > But immediately Jesus spoke to them, saying, “Take heart; it is I. Do not > be afraid.” > > > On 2 Aug 2021, at 3:09 pm, sc wrote: > > > > Many thanks to Peter and Alan and Geoff for your responses to my > question. So I am now persuaded that it would be wise to upgrade my > GnuCash 3.8. > > > > I am using Windows 7 Home Premium on my Toshiba laptop computer. On the > GnuCash website, it says Version 4.6 is for Windows 8/10. Uh oh, I wonder > if this means my Windows 7 is too old. > > For Windows 7 it says Version 3.11. Maybe I'm not all that outdated > after all. > > > > Am I right in thinking Version 3.11 is the best this computer can > handle? > > > > Again, thank you for responding. Sharon > > > > On 7/28/2021 2:27 AM, Peter West wrote: > >> Hi Sharon, > >> > >> Open source software is different from commercial software in that > there is no contract, implied or otherwise, to support your use of one > particular version of the software. Even with commercial software, there > are limits to support, as you would have found if you you were running, say > Microsoft XP, as your operating system. If commercial companies cannot > maintain support for older versions beyond a few years, so much the less > can open source. > >> > >> 3.8 will continue to do what 3.8 does. But if you attempt something new > at some time in the future, and run into a problem, when you report it you > are likely to be told that the problem was fixed in 4.x (or 5.x) and you > should upgrade. The longer you leave it, the more likely you are to have > upgrade problems. If your problem has not been seen before, and if it is > found to exist in the latest version, it is not going to be fixed in 3.8, > and you will have to live with it. > >> > >> All in all, it’s a good idea to keep up to date with updates. If you > are receiving notices of updates, just keep an eye on the list for the > following 3 or 4 weeks. Problems with the update process and with normal > usage will surface in that time frame. After a month or so without reported > problems, you can be confident of the update. > >> > >> Peter > >> — > >> Peter West > >> p...@ehealth.id.au <mailto:p...@ehealth.id.au> > >> “Then the righteous will shine like the sun in the kingdom of their > Father.” > >> > >>> On 28 Jul 2021, at 1:23 am, sc sc...@impulse.net>> wrote: > >>> > >>> Hello. > >>> > >>> I successfully transferred from Quicken to GnuCash years ago, with no > troubles. I'm a home user, nothing complex. > >>> > >>> Is there any reason I should upgrade from Version 3.8? Are the > changes mostly for business folks or are there changes that a home user > would enjoy? > >>> > >>> Sharon > >>> > >>> ___ > >>> gnucash-user mailing list > >>> gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > >>> To update your subscription preferences or to unsubscribe: > >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user < > https://lists.gnucash.org/mailman/listinfo/gnucash-user> > >>> If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists < > 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. > ___ 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] how to search
Another source of imbalance is if the user imports downloaded data from their FI and the matcher hasn't found a match for the transaction and the user accepts all of the new transactions without correcting. Kind regards, Greg Feneis <http://www.linkedin.com/in/electromechanical> On Thu, Jun 3, 2021 at 6:44 AM Glenn Fowler wrote: > To add to this here are the user list archives: > https://lists.gnucash.org/pipermail/gnucash-user/ > > Info on searching the archives: > https://lists.gnucash.org/search/?idxinfo=gnucash-user > > On Thu, Jun 3, 2021 at 9:21 AM David Carlson > wrote: > > > A small addendum to Derek's comments: > > > > When in the GnuCash program hit F1 to see the help manual. > > > > Also, on the website are links to both the help manual < > > https://www.gnucash.org/viewdoc.phtml?rev=4=C=help>l and the > > Tutorial and Concepts Guide < > > https://www.gnucash.org/viewdoc.phtml?rev=4=C=guide> > > > > On Thu, Jun 3, 2021 at 7:27 AM Derek Atkins wrote: > > > > > Hi Billie, > > > > > > On Thu, June 3, 2021 7:50 am, Billie-Internet wrote: > > > > Good Morning, > > > > I have been using gnucash since 1/1/2021 and I am frustrated with > split > > > > transactions and unbalance account. > > > > > > The Imbalance account gets created when you *enter* an imbalanced > > > transaction. This happens when you, um, hit the *enter* key. If > you're > > > creating a split transaction then you should not hit the enter key > until > > > you are absolutely done will all the splits. > > > > > > The GnuCash Guide documentation goes through a very detailed, > > step-by-step > > > instruction on how to enter a split transaction. I highly recommend > you > > > read the docs. > > > > > > > Now, I could rip gnucash out of my computer and stomp it to death > but I > > > > have 6 months worth of data it in. > > > > I have spent 2 days trying to search for answers and I am amazed that > > so > > > > many smart people that can write this program can't do a better job > of > > > > "support" or finding an answer. > > > > > > Maybe the issue is not asking the right question? Even here, in this > > > email, you don't actually say WHAT your issue is, so I'm only guessing. > > > > > > > Could someone please send me a link on how to seach the mail lists. > A > > > > link > > > > that is understandable to the non-computer-geek-normal-user. > > > > > > Go to www.google.com and search for: > > > > > > site:lists.gnucash.org > > > > > > > Better than that, someone share a link on where someone can be hired > to > > > > just fix the problem! > > > > > > You don't actually state what your problem is... > > > > > > > Thanks. > > > > Frustrated,-- > > > > Billie > > > > 706-383-9057 > > > > > > Good Luck, > > > > > > > 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. > > > > > > > > > -- > > 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. > > > ___ > 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] How To Remove All Old Invoices
IIRC, invoices can only be created. Previously, people have requested help with deleting a single invoice that was created by mistake. I think the best advice I saw was to set it aside and use when needed. Doesn't seem very good for your case, you'd have to unpost and edit each invoice and remove all details AMAP. Then you would have a big mess of unused invoices hanging around. You'd probably have to come up with an empty invoice numbering scheme so they're not easily confused with actual invoices. 路 Kind regards, Greg Feneis (Pixel 3) On Sat, Apr 3, 2021, 19:14 Keith Fetterman wrote: > Has anyone found a way to remove old invoices? > > I am using a GnuCash accounting file for a different business, but I want > to retain the same customers. I followed the steps below to remove the old > transactions and use the same chart of accounts. I discovered today that > the old file also retained all of the previous invoices, and I didn’t find > a command to delete them. Is there anyway to remove the old invoices? > > If not, I think I will need to start from scratch and re-import the > customers. Unfortunately, that would mean having to go through each > customer and reestablish the billing terms and sales tax table assignements. > > > > > > On Mar 20, 2021, at 6:30 PM, Geoff wrote: > > > > How about: > > . Export the Accounts > > . Delete each Account (and its transactions) > > . Import the Accounts. > > > > > > Geoff > > = > > > > On 21/03/2021 12:23 pm, Keith Fetterman wrote: > >> I’ve tried that, and you are correct. I creates the same chart of > accounts, but the tax tables, customers/vendors, etc. are missing. > >> I thought a bulk delete of the transactions would work, but I don’t see > a way to bulk delete the transactions. > >>> On Mar 20, 2021, at 6:21 PM, D. wrote: > >>> > >>> That saves accounts, but I believe not any of the business objects, > unfortunately. > >>> > >>> > >>> Original Message > >>> From: "D. via gnucash-user" > >>> Sent: Sat Mar 20 21:18:51 EDT 2021 > >>> To: Keith Fetterman > >>> Cc: GnuCash users group > >>> Subject: Re: [GNC] How To Remove All Transactions > >>> > >>> File->Export Accounts > >>> > >>> > >>> Original Message > >>> From: Keith Fetterman > >>> Sent: Sat Mar 20 21:14:40 EDT 2021 > >>> To: GnuCash users group > >>> Subject: [GNC] How To Remove All Transactions > >>> > >>> I need to create a copy of an existing GnuCash file that does not have > the transactions. I need to keep the same chart of accounts, configuration > and settings, tax tables, customers, vendors and report configurations in > the new GnuCash file, but have all of the transactions removed. What is > the easiest way to do this? > >>> > >>> Is there a way to bulk delete all of the transactions and have an > empty chart of accounts? > >>> > >>> Thanks > >>> Keith > >>> > >>> PS. I checked the mailing list, but I could find any recent posts. > >>> ___ > >>> 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. > >>> > >> ___ > >> gnucash-user mailing list > >> gnucash-user@gnucash.org > >> To update your subscription preferences or to unsubscribe: > >> https://lists.gnucash.org/mailman/listinfo/gnucas
Re: [GNC] Access GNUCash From Different Devices
GnuCash on Android is theoretically possible, but it's probably not going to be simply downloading and installing from Google Play. However, a Windows GnuCash installation should work on Wine, and recent releases of Wine appear to work on Android. 路 I wish I had the time and resources to see if I could make it work. Kind regards, Greg Feneis (Pixel 3) On Fri, Mar 5, 2021, 11:40 David Carlson wrote: > You are making me jealous. I have Android devices. > > On Fri, Mar 5, 2021 at 11:19 AM Kenneth Schneider < > kschnei...@bout-tyme.net> > wrote: > > > This is going to a much welcome addition to the GNUCash family. > > > > Ken Schneider > > > > > On Mar 5, 2021, at 11:52 AM, John Ralls wrote: > > > > > > This just in: A developer just now requested a wiki editing account > > because he's created a simple GnuCash data-entry app for iOS and iPadOS. > > See https://apps.apple.com/us/app/gnucash-mobile/id1556325950 > > > > > > Regards, > > > John Ralls > > > > > >> On Mar 5, 2021, at 4:58 AM, John Donnee wrote: > > >> > > >> Thanks > > >> > > >> John > > >> > > >> On Thu, Mar 4, 2021 at 9:28 PM John Ralls wrote: > > >> Unfortunately no. The GUI framework GnuCash is built on doesn't > support > > iOS. > > >> > > >> Regards, > > >> John Ralls > > >> > > >> > > >>>> On Mar 4, 2021, at 2:27 PM, John Donnee wrote: > > >>> > > >>> Hi, I’ve been using GNYCash for nine years. > > >>> > > >>> Question: I run my GNU system from a iMac. Is there a way to also > > access > > >>> my GNU system from my iPad? > > >>> > > >>> Thanks > > >>> > > >>> John Donnee > > >>> -- > > >>> John J Donnee > > >>> > > >>> 317 Mount Eden Place > > >>> Cary, NC 27518 > > >>> ___ > > >>> 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. > > >> > > >> -- > > >> John J Donnee > > >> > > >> 317 Mount Eden Place > > >> Cary, NC 27518 > > > > > > ___ > > > 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. > > > > > -- > 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. > ___ 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] Single User two Geographically Separate Computers
There is a non-cloud alternative to being able to use GnuCash in multiple locations on multiple devices. It involves keeping both GnuCash and associated files on a removable media, like thumb drive, and transporting/using the thumb drive at each location. I've only read about this, I don't have experience doing it. Kind regards, Greg Feneis (Pixel 3) On Sat, Feb 20, 2021, 22:02 Peter Williamson wrote: > Hi Dean > Thanks very much. I will now look further at cloud storage and > arrangements for AQBanking. > Peter > > > On 21 February 2021 at 17:00 Dean Gibson mailto:gnucash.st...@mailpen.com > wrote: > > > > > > This is what I do, & it works fine. Note that settings, including > > AQBanking info, is stored in folders in your user area on each > machine. > > You can also share those through OneDrive, but that's a bit advanced. > > > > > > On 2021-02-20 19:40, Peter Williamson wrote: > > > > > > Hi > > > > > > I am a new gnucash user and would like operate as a single > user on two geographically separated computers. I would use each computer > on alternate months depending on my location at the time. > > > > > > I am not very computer literate and I am proposing to use > Onedrive to store my gnucash files and then access them from whichever of > the computers is in my current location. > > > > > > Would this work? Is there a better way of achieving this > operating setup? > > > > > > Peter > > > > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org mailto: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. > ___ 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] arrggghhh - happening again!
Happy New Year, All, If an application window is opening out of reach on a Windows machine, the user can right click on its icon in the taskbar and select Move. This attaches the mouse cursor to wherever the window is. The user may manipulate their mouse to try to drag it back into view, or use keyboard arrow keys to bring the window back to view. Might take some experimentation. Kind regards, Greg Feneis On Sun, Jan 3, 2021 at 5:17 PM D. via gnucash-user wrote: > It is more likely that the OP has or had a second monitor upon which > gnucash is placing its window, as the other response mentioned. This has > happened to others in the past. > > David > > > Original Message > From: py...@cox.net > Sent: Sun Jan 03 20:06:11 EST 2021 > To: 'alessandra derniat' <4san...@live.com>, gnucash-user@gnucash.org > Subject: Re: [GNC] arrggghhh - happening again! > > I am assuming you are on Windows 10 (based upon your "sent from mail" > message. If not, ignore my message and let us know what OS you are using. > > If you are Windows 10 - this does not sound like a Gnucash issue - this > sounds like a windows issue in that your program is losing focus or is > never > getting focus. I have seen this with other web-based apps happen -- the > app > is open, it shows on the task bar yet it is unresponsive. The reason for > the unresponsive-ness is because the focus is on another app that is either > running and you don't know -- or is running and you can't see it. > > To determine if this is the case, open TASK Manger and look at the active > tasks running. If you see an active task that you don't know or that you > are positive should not be running, do a right mouse click on it and END > the > task. Now if you are pretty sure all the running tasks are valid, leave > task manager and see (if Gnucash is still open) if when you click on > Gnucash > if it now has focus (i.e., you can work it). If Gnucash is not open, open > and see if it exhibits the same behavior before when the offending task was > open. If all is good -- that task was the offending task that had focus > and was taking it away from Gnucash. If all is still not good -- it is a > different issue. > > If you are still exhibiting issues, try de-installing and re-installing > Gnucash and see if that works. Don't worry, when you de-install, you will > not lose your data files. Hopefully one of these two items will correct > your problem. If neither of these two work -- let us know and maybe > someone > will have another solution. > > Ken > > -Original Message- > From: gnucash-user On > Behalf Of alessandra derniat > Sent: Sunday, January 3, 2021 4:37 PM > To: gnucash-user@gnucash.org > Subject: [GNC] arrggghhh - happening again! > > I go to open GnuCash and it shows as open in my task bar but when clicked > will not expand to allow me to actually work with it. So I see the program > open in my taskbar and when I scroll over it I can see my books but I can't > work on them. This happened a few months ago but before I could implement > any suggested fixes it starting working again without me doing anything. > > What's the problem? What's going on? Am I doing something wrong? All I did > was open the program! > Thanks to anyone who can help me. > Sandy > > Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows > 10 > > ___ > 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. > > ___ > 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
Re: [GNC] GnuCash 4.4 Announcement/GnuCash 4.3 Announcement
I think the GnuCash project is managed or stored SourceForge. I've somehow noodled around on SF and now when there's a release, I get a SF release notification email, FWIW Kind regards, Greg Feneis <http://www.linkedin.com/in/electromechanical> On Mon, Dec 28, 2020 at 8:54 PM D. via gnucash-user < gnucash-user@gnucash.org> wrote: > Frank, > > I didn't receive either boilerplate announcement in my inboxes, either-- a > point that John acknowledged directly. Something clearly went awry with the > mail in these cases. > > > Original Message > From: "Frank H. Ellenberger" > Sent: Mon Dec 28 21:04:06 EST 2020 > To: py...@cox.net, 'John Ralls' , 'GnuCash-User' < > gnucash-user@gnucash.org> > Subject: Re: [GNC] GnuCash 4.4 Announcement/GnuCash 4.3 Announcement > > Hello Ken, > > Am 29.12.20 um 02:54 schrieb py...@cox.net: > > John - Thank you for the announcement - FYI - Received this e-mail - but > > did not receive the regular nor the 4.3 announcement. > > > > Ken > > it is here: > > https://lists.gnucash.org/pipermail/gnucash-announce/2020-December/000333.html > > All in reverse chronological order: > https://www.gnucash.org/news.phtml > > > ~Frank > ___ > 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. > ___ 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] Sales Taxes...
All of these examples appear to be supplies for the business to use (vs items purchased for selling). Why would the cost of the taxes paid need to be account for separately from the cost of the items? Kind regards, Greg Feneis (Pixel 3) On Sat, Dec 26, 2020, 16:52 Eric H. Bowen via gnucash-user < gnucash-user@gnucash.org> wrote: > Okay. With year-end coming up I'm not looking to make major changes in > the past, but I'd like to account for everything properly in the future. > > Say I purchase $100 in printing supplies (paper, ink, etc.) from a local > vendor. The IRS wants me to account for taxes in the value of items > purchased. So I add an entry for $108.25 (8.25% local tax), and the full > value goes into my "Expenses:Business Expenses:Office Supplies" account. > Fine. > > Now, suppose I purchase that $100 in supplies from an out-of-state > vendor who falls under the threshold for reporting sales taxes to Texas > (rhyming couplet there?) and so does not charge me sales tax on the > purchase. The law says that I have to pay a sales/use tax on the > purchase anyhow. Fine, I have a liability account set up for "Sales > Taxes Payable" which I normally use for the sales I make to customers; > once a quarter I total this up and send a check in to the comptroller. > No problem at all to do so with my online purchase, but the $8.25 which > I pay at the end of the quarter doesn't get added to my Office Supplies > purchase, as it should. > > Finally, suppose I purchase the supplies from a local vendor, who > charges tax, but who grants me a "Net 30" for payment and so it goes > into my Accounts Payable as a bill. If I use the "Sales Tax Payable" > account/tax table for the purchase, my payment for the purchase goes in > as a payment on the liability, which is wrong. I can use a separate > sales tax table tied to a different account for purchases, in which case > it will be recorded as "Expenses:Business Expenses:Business Taxes:Sales > Tax Paid", but ideally the $8.25 should have been added to the value of > the purchase in "Office Supplies." > > Is there a quick and elegant solution to this issue which I'm > overlooking, but that I could implement for next year? > > -- > > Eric H. Bowen > e...@ehbowen.net <mailto:e...@ehbowen.net> > ___ > 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] Rounding & formulas
I don't know if the math functions are available, but various languages have rounding functions. If there's a rounding function, perhaps round up and round down can be used? odd_cent_total/2 will have a fractional cent value in the answer, so round up to the nearest cent for you and down to the nearest cent for the consort? Kind regards, Greg Feneis <http://www.linkedin.com/in/electromechanical> On Sun, Dec 20, 2020 at 5:19 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Note, I'm not aware of a 'proper' solution that you are looking for. > > Sounds like a lot of effort to avoid changing a single digit on review > when occasionally the original amount is odd. > > I would expect your try at "total_amount-(total_amount/2)" to only work > half the time, thus a coin flip. Note, that's 29 characters. (not to > count the clicks to get that far setting it up, or other characters > involved) How many did you type asking this question? How much time and > typing will you save, and if you find a solution, how long will it take > to break even? > > I'm not trying to be rude, but this is almost at the level of wanting to > do accounting to the mille. The payoff will never be worth the effort. > > Regards, > Adrien > > On 12/19/20 12:09 PM, Thomas Lenherr wrote: > > Hi, > > > > I've been using gnucash for a few years now, including scheduled > > transactions with variables/formulas, but one thing I never figured out > is > > how to avoid imbalances in them when variables cause "bad" rounding, > > requiring me to fix those manually. > > > > Simple example: > > I use a scheduled transaction for an expense that varies month to month > > (=variable), and I'd like to split it into two (share with another > person, > > i.e. book 50% against their account). Every now and then that amount is > an > > odd number of cents, and so just dividing by two for both the amount > > against my expense account and their debitor-account results in an > > imbalance that I need to fix manually (= I'm fine always being the person > > that pays a cent more than the other one). > > > > I tried to be "clever" by writing one of them as "total_amount/2" and the > > other one as "total_amount-(total_amount/2)" but that didn't work either. > > Is there a way to e.g. force rounding in the formula? E.g. something like > > "round(total_amount/2, 0.01)" and "total_amount - round(total_amount/2, > > 0.01)"? Or is there a different solution I'm not aware of? > > > > If there's no existing option, would it be hard to add support for such a > > function or other solution? > > ___ > 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] How to Select Columns to Display in "Accounts" Tab - I WITHDRAW THE QUESTION
Hi Ben, With the register in view, in the View menu, you'll find 2 line. Select that and additional info is shown per transaction. Kind regards, Greg Feneis On Wed, Dec 2, 2020 at 10:14 AM Benjamin Soffer wrote: > > > Benjamin E. Soffer | THE SOFFER LAW FIRM PC > > > > -Original Message- > From: gnucash-user [mailto:gnucash-user-bounces+bsoffer= > soffer-law@gnucash.org] On Behalf Of Benjamin Soffer > Sent: 12/02/2020 9:28 AM > To: Gnucash Users > Subject: [GNC] How to Select Columns to Display in "Accounts" Tab > > Under the Accounts tab, I can only see the account name, the description, > and the amount. The "notes" that I entered for the various accounts are > not displaying. I'm using GnuCash 3.8 on Windows 10.. > > Thanks > > Benjamin E. Soffer > ___ > 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. > ___ 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] entry point error after recent automatic windows 10 update
Perhaps if GnuCash could be started by navigating to the actual executable file and double clicking on it. This would bypass concerns with failed file associations, broken shortcuts, etc. If successful, at the very worst, it should start and complain that it can't find the working file it used to know. EG: My GnuCash 2.6.21 installation is found by opening windows explorer and typing this into the address bar. C:\Program Files (x86)\gnucash\bin (then press enter) In the list of files that shows up, I can see gnucash.exe If I double click on this file's icon, GnuCash starts and runs. My GnuCash version is several updates old, so Laurel's may be in a slightly different place. If she could find it, she could start the program directly from the executable and let us know what happens. Failing that, Laurel may be able to navigate to the same location via command prompt and start GnuCash with debug logging enabled in some verbose fashion. Someone else will have to chime in with details on whether and how it's possible. Kind regards, Greg Feneis On Thu, Nov 26, 2020 at 9:00 AM Fred Bone wrote: > On 25 November 2020 at 14:59, David Cousens said: > > > Adrien, Laurel > > > > I have just downloaded GnuCash 4.2 and installed it on my wife's Windows > > 10 box and it appears to be working OK. I checked "C:/Program > > Files(X86)/gnucash/bin" and there is no "libgncmod-app-utils.dll" in that > > location. I can open registers and create new transactions without any > > problems, so the problem appears not to be a general problem with GnuCash > > 4.2 on WIndows 10. > > There's one in that location on v2.6.21 though, which suggests perhaps an > issue with a report designed to run under an older version that needs > reconfiguring for 4.2. > > ___ > 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] List Replies
Well, I'm glad this got thoroughly discussed without folks getting thoroughly disgusted. It seems like the boilerplate that appears in every list email could, instead of reminding members to always reply to the list, it could let people know if they need help replying to a list message privately, they can reply to the list asking for help with that. I can't help believing the occurrence of needing to private reply when not knowing how will be exceedingly rare compared to the current frequency of people failing to reply to the list. Kind regards, Greg Feneis On Wed, Nov 18, 2020 at 9:26 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Yes, I'm well aware of what the MacOS client does as I use it daily. I > don't have an *iOS* device though. > > And the question wasn't about the buttons' current behaviors, but rather > how easy it is to send to *any* e-mail address in any part of the > header, or the body of the message. (and not just the list address or > reply-to header) > > Regards, > Adrien > > On 11/18/20 12:17 PM, w...@theprescotts.com wrote: > > Adrien, > > > > For your reference, in the MacOS Mail.app: > > > > clicking Reply: puts the sender in the To: field > > clicking Reply All: puts gnucash-u...@lists.gnucash.org gnucash-u...@lists.gnucash.org> in the To: field, and the sender in the > cc: field. > > > > Usually what I do is hit 'Reply All', delete the sender from the To: > field and drag gnucash from cc: to To:. > > ___ > 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] List Replies
Derek, it's just the default behavior. It doesn't prevent people from making private replies or make it challenging. That seems like a plausible policy from the late 90s. If it's been the way it is for several years, it might be time to try a change. Perhaps people are more email savvy these days? Kind regards, Greg Feneis On Mon, Nov 16, 2020 at 5:47 AM Derek Atkins wrote: > Greg, > > On Mon, November 16, 2020 8:33 am, Greg Feneis wrote: > > That seems like an unnecessary dichotomy. Perhaps it's a limitation of > > mailman, or our ability to administer? On the other list I belong to > that > > server causes either reply type to default to only the list server > without > > obscuring the originator's address. > > You just stated the issue: "that server causes either reply type to > default to ONLY the list server" (emphasis mine). THAT is the issue. We > DO NOT WANT that behavior. We WANT people to be able to reply privately > to people. Making private replies challenging is just a non-starter. > > Please go read the archives for the last dozen threads on this topic. > > Thanks, > > -derek > > > > > > > > > Kind regards, Greg Feneis > > (Pixel 3) > > > > > > On Mon, Nov 16, 2020, 05:20 Derek Atkins wrote: > > > >> Greg, > >> > >> This topic comes up about once a year or so, usually closer to Spring as > >> people start working on their taxes and asking for help. > >> > >> In short, yes, mailman COULD be set up to set the Reply-To the list. > >> The > >> downside of that approach is that it makes it MUCH MUCH harder (nearly > >> impossible) to make an off-list (private) reply. The decision, which > >> has > >> been made over and over again over the past 20 years, is that making it > >> POSSIBLE to make a private reply is more important than making it always > >> reply-to-list. > >> > >> This is why every message has a note to remind people to Reply-All. > >> > >> -derek > >> > >> On Mon, November 16, 2020 8:06 am, Greg Feneis wrote: > >> > Hi friends, > >> > > >> > A frequent encounter on this list is members replying to an email's > >> > originator and not to the list server. > >> > > >> > In the grand scheme, not a big deal. However, other lists I belong to > >> > don't > >> > seem to have this issue. I'm wondering if a list server setting could > >> > help. > >> > > >> > For this other list I belong to, when I receive an email, it appears > >> to > >> > come from the originator's name and email address. But, no matter if > >> I > >> > use > >> > reply, or reply-all, the initial email composition only ever begins > >> with > >> > the list server as the only recipient. > >> > > >> > I imagine this feature has to do with the construction of the email > >> > messages being sent from the server to the list members. > >> > > >> > Could our mailman server be set to do the same thing?樂 > >> > > >> > Kind regards, Greg Feneis > >> > (Pixel 3) > >> > ___ > >> > 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. > >> > > >> > >> > >> -- > >>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. > > > > > -- >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.
Re: [GNC] List Replies
That seems like an unnecessary dichotomy. Perhaps it's a limitation of mailman, or our ability to administer? On the other list I belong to that server causes either reply type to default to only the list server without obscuring the originator's address. Kind regards, Greg Feneis (Pixel 3) On Mon, Nov 16, 2020, 05:20 Derek Atkins wrote: > Greg, > > This topic comes up about once a year or so, usually closer to Spring as > people start working on their taxes and asking for help. > > In short, yes, mailman COULD be set up to set the Reply-To the list. The > downside of that approach is that it makes it MUCH MUCH harder (nearly > impossible) to make an off-list (private) reply. The decision, which has > been made over and over again over the past 20 years, is that making it > POSSIBLE to make a private reply is more important than making it always > reply-to-list. > > This is why every message has a note to remind people to Reply-All. > > -derek > > On Mon, November 16, 2020 8:06 am, Greg Feneis wrote: > > Hi friends, > > > > A frequent encounter on this list is members replying to an email's > > originator and not to the list server. > > > > In the grand scheme, not a big deal. However, other lists I belong to > > don't > > seem to have this issue. I'm wondering if a list server setting could > > help. > > > > For this other list I belong to, when I receive an email, it appears to > > come from the originator's name and email address. But, no matter if I > > use > > reply, or reply-all, the initial email composition only ever begins with > > the list server as the only recipient. > > > > I imagine this feature has to do with the construction of the email > > messages being sent from the server to the list members. > > > > Could our mailman server be set to do the same thing?樂 > > > > Kind regards, Greg Feneis > > (Pixel 3) > > ___ > > 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. > > > > > -- >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] List Replies
Hi friends, A frequent encounter on this list is members replying to an email's originator and not to the list server. In the grand scheme, not a big deal. However, other lists I belong to don't seem to have this issue. I'm wondering if a list server setting could help. For this other list I belong to, when I receive an email, it appears to come from the originator's name and email address. But, no matter if I use reply, or reply-all, the initial email composition only ever begins with the list server as the only recipient. I imagine this feature has to do with the construction of the email messages being sent from the server to the list members. Could our mailman server be set to do the same thing?樂 Kind regards, Greg Feneis (Pixel 3) ___ 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] Annoying Register Issue
The insert key should do something when it's pressed. To save space, it's often combined with other lesser used keys and requires an extra key press (prior or simultaneous) to activate it. Often, simply pressing the key that says ins on it won't do anything. The insert/typeover mode still exists. If a computer's keyboard doesn't control it, that might be a point of concern. To test for control of the insert/typeover status, typically the user can open a text editor or terminal interface and watch the cursor while toggling typeover vs insert modes. EG on Win 10, the cursor in the command prompt changes shape when switching from typeover to insert mode. EG In my Linux VM, when I open LibreOffice Writer and toggle between typeover and insert mode, I see an indication change at the bottom of the Writer window. Kind regards, Greg Feneis On Fri, Nov 13, 2020 at 9:03 AM Les wrote: > Adrien: > > Thanks for the information, but upon a comparison of both Laptops, there > is no difference in keyboard preferences. Both laptops have an insert > key but it doesn't appear to do anything. > > Les > > On 11/13/20 9:41 AM, Adrien Monteleone wrote: > > Les, that tells me it is an input issue on the offending laptop. Check > > your input method is the same on both. > > > > I too thought of the Insert mode toggle but that usually isn't > > available on a laptop with a single key. (therefore difficult to > > toggle it by accident) You may have a key-combo which toggles this on > > and off, check your keyboard preferences. > > > > Regards, > > Adrien > > > > On 11/12/20 8:02 AM, Les wrote: > >> For what its worth, I have two of these laptops, both running the > >> same version of Linux Mint and I just installed GC 4.2 via Flatpak on > >> the 2nd one and I don't have this problem problem. Weird. > > > > ___ > > 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. > ___ 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] Cannot Obtain Lock error?
IIUC, when a user opens a .gnucash file with GnuCash, EG foo.gnucash is opened, GnuCash creates an additional file in the same folder, as a signal that this file is open and being modified. This is the lock file. The lock file will have the same file name plus LCK extension. EG foo.LCK for when foo.gnucash is opened. Before GnuCash opens the file, it looks for a file that starts with the file name you asked it to open and ends with .LCK. If it finds this file, it gives the warning about difficulty obtaining a lock. In this case, GnuCash thinks the file you're trying to open is already open and being edited. Knowing this, a potential work around for Windows users (perhaps others?) until the software is corrected: When the user is finished using GnuCash, save and close per usual. If the file saved correctly and GnuCash closed correctly, the file that ends .LCK should have also been deleted (lock released). Confirm that it was deleted by opening the folder location where the .gnucash file is stored and look for files that end with .LCK. If a .LCK file is found, delete it. With no .LCK file present, the next time GnuCash tries to open the .gnucash file, the user won't get the obtaining lock message. Kind regards, Greg Feneis On Sat, Nov 7, 2020 at 2:10 PM Jack Slater wrote: > 1 - I really appreciate this software. > 2 - I realize that in my haste I may not initially include all > pertinent details with my questions. > 3 - I do appreciate all those that try to help. > 4 - Users don't appreciate comments with this tone: > https://www.merriam-webster.com/dictionary/condescending > > On Sat, Nov 7, 2020 at 10:04 AM Michael or Penny Novack < > stepbystepf...@comcast.net> wrote: > > > On 11/7/2020 9:32 AM, Chris Green wrote: > > > > > Yes, I know (and mainly agree with) all that, I am a fully fledged > > > (well, ancient) chartered software engineer with lots of letters both > > > before and after my name if necessary. > > > > > > I was just trying to aim my comment at non-computer people and, > > > anyway, it is beginning to drift away from the original issue. > > > > > I was just trying to clarify -- non-computer people should not try to > > use an alpha version even if they really really need that new feature. > > It would be asking for trouble. I, or you, would automatically know what > > we would have to do to make it safer. They do not. > > > > Michael D Novack > > > > > > -- > > There is no possibility of social justice on a dead planet except the > > equality of the grave. > > > > ___ > > 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. > ___ 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] Would anyone else like a hacky way to do partial and catch-up reconciliation?
Also not a good bookkeeper similarly and also interested. Kind regards, Greg Feneis On Wed, Nov 4, 2020 at 7:13 AM David Carlson wrote: > I think it is worth putting a procedure to reconcile 'backwards' on the > Gnucash WIKI. Users who want to fill in old history in some accounts would > benefit. I think your method would also be useful any time a historical > transaction has been accidentally unreconciled, perhaps even when > reconciling a different account in a split transaction. > > I know that it is tricky, especially since the GnuCash reconciliation > process has not been designed to lend itself to do that. > > I have personally developed a method to import old transactions into > accounts and reconcile them when having a starting balance as recent as > last year but I want earlier history to be able to produce comparison > reports in a common format. I am confident that this can be done without > needing to repeat every reconcile in chronological order, so I would love > to see your method. > > On Wed, Nov 4, 2020 at 1:21 AM Jim DeLaHunt wrote: > > > Hello, Gnucash users: > > > > Would anyone else like a hacky way to do partial and catch-up > > reconciliation of bank accounts and credit card accounts? > > > > I am a bad bookkeeper. In my personal finances, I have several GnuCash > > accounts with 10-15 years of transaction history, but I did not > > reconcile them properly against my statements for all those years. > > Recently, I have been doing better. I looked for a way to reconcile just > > this year's transactions for now. Then I want to reconcile new > > statements as they arrive, and work on reconciling last year's > > statements as i have time. Gradually I want to work backwards in time to > > reconcile and correct as much of the history as I can. This will let me > > do better budgeting etc. > > > > Unfortunately, reconciliation in GnuCash is set up to start from the > > beginning of a book account, and to work forward. In fact, the GnuCash > > Guide, 2.9.4. *Reconciliation* > > < > > > https://lists.gnucash.org/docs/C/gnucash-guide/chapter_txns.html#txns-reconcile1 > >, > > > > says: "Warning. It is important to understand that reconciliation is > > done for a given date, and when you reconcile an account based on a > > statement from a given date, you are reconciling all transactions prior > > to that date. Therefore, if you add or modify transactions that predate > > your last reconciliation, your reconciled balances will be thrown off." > > > > But I think I have found a way to do catch-up reconciliation, starting > > with the recent past and working backwards. It's a hacky, unconventional > > approach. It involves adding 3 transactions to adjust balances and net > > out errors in the un-reconciled past. I wrote down my procedure, and the > > instructions are about 4,000 words. But it works. > > > > Is there much interest in my sharing this approach? If there is, I > > might put my instructions on to a wiki page. If not, I'll just publish > > it on my blog or something. > > > > For those of you whose books are up-to-date and fully reconciled, I > > admire you. Best regards, > >—Jim DeLaHunt, software engineer, Vancouver, Canada > > > > ___ > > 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. > ___ 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] OXF/QFX import overwrites Description and Notes fields
It does remain entirely possible that I've been doing it wrong ;-) Kind regards, Greg Feneis <http://www.linkedin.com/in/electromechanical> On Mon, Nov 2, 2020 at 5:23 AM David Carlson wrote: > That is indeed strange in release 2.6.21 > In releases 2.6.19 one one of my linux machines and 3.8 on another linux > machine the matcher will only overwrite the description and notes if I > select Update. > > On Mon, Nov 2, 2020 at 6:47 AM Greg Feneis wrote: > >> I've seen this too. >> I'm on GnuCash 2.6.21 (Win7&10), and I believe I get that same behavior. >> Appears the matcher recognizes a matching transaction and "corrects" the >> transaction in GnuCash to conform to the transaction from the FI data >> being >> imported. >> >> Kind regards, Greg Feneis >> (Pixel 3) >> >> >> On Sun, Nov 1, 2020, 18:18 Richard De Vriese >> wrote: >> >> > Hello, >> > >> > When I import transactions from my bank using OXF file format the >> > Description and Notes fields keep getting overwritten. I've verified >> that >> > only the C column is checked in the import window--A and U+C are >> > unchecked--but the fields still get overwritten with the data from my >> bank >> > rather than retaining the values I entered directly into GnuCash. I'm >> using >> > GnuCash 4.2 (build 4.2+ (2020-09-26) on a Windows 10 PC with the latest >> > Windows updates installed. Any help or advice would be appreciated. >> > >> > Many Thanks >> > -- >> > Rick >> > ___ >> > 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. >> > > > -- > 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] OXF/QFX import overwrites Description and Notes fields
I've seen this too. I'm on GnuCash 2.6.21 (Win7&10), and I believe I get that same behavior. Appears the matcher recognizes a matching transaction and "corrects" the transaction in GnuCash to conform to the transaction from the FI data being imported. Kind regards, Greg Feneis (Pixel 3) On Sun, Nov 1, 2020, 18:18 Richard De Vriese wrote: > Hello, > > When I import transactions from my bank using OXF file format the > Description and Notes fields keep getting overwritten. I've verified that > only the C column is checked in the import window--A and U+C are > unchecked--but the fields still get overwritten with the data from my bank > rather than retaining the values I entered directly into GnuCash. I'm using > GnuCash 4.2 (build 4.2+ (2020-09-26) on a Windows 10 PC with the latest > Windows updates installed. Any help or advice would be appreciated. > > Many Thanks > -- > Rick > ___ > 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] Best way to Auto Sync GC Checking Transactions with the Bank?
Regarding loose cannon with debit card, convert them to using a credit card? Essentially free credit so long as you pay it off every month. Then you only have to deal with it once every month. The GnuCash matcher isn't perfect, but it works well. Kind regards, Greg Feneis (Pixel 3) On Sun, Oct 18, 2020, 12:35 Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > On 10/18/20 12:51 PM, Fran_3 via gnucash-user wrote: > > David, thanks for the comments. > > I'm going to experiment more with the import matcher. > > I have discovered this time saving tip... we can... > > > > - Log on to our bank, drag the mouse over the transactions, and copy > into the paste buffer > > - Then paste them directly into a Google Sheet...- Thus avoiding the > downloading and importing a CSV file. > > Why *not* download the CSV? That saves many, many clicks and drags. You > just open it in Google Sheets and the data is all there. > > > Ditto for GnuCash Checking if we bring it up in a Transaction Report > > And, as I mentioned to Adrien, I have created an App Script to help me > compare the Bank Transactions to the GnuCash TransactionsThe process...- > Sort the Bank Transactions by Amount and then by date- Ditto for the > GnuCash Transactions > > - Put both Bank & GnuCash transactions on the same sheet- Drag the > Amount Columns of each so they are side by side- Insert a column between > the two Amount Columns- Create a spreadsheet formula to put an "X" in the > column if the amounts don't match- Copy that formula all the way down to > the last row- Now you can see where inconsistencies occurIt gets tricky now > however so this is where I wrote an App Script to copy either the Bank > Transactions or the GC Transactions starting with the inconsistency... and > move them down a row... and then re-run the matching formula. > > Normally, too much work... but in one case where I just rechecked the > reconciliation of 3-years worth of transactions... it was helpful. > > There are other, maybe easier ways to do this I'm sure. > > You *could* script a comparison with the transactions exported from GC. > I think there is now also a command-line interface that might be able to > grab the data. Look into something called PieCash. (not sure of > spelling) It was created as a Python interface to the GnuCash data file. > (for reading only, always 'edit' or 'create' transactions using GnuCash > itself) > > Also look into OFX from your bank. You can set up GnuCash to connect to > the bank and grab the transactions directly. (But I'd stand by my > recommendation to improve purchasing procedures and if at all possible > get receipts for everything so you can enter them and then the bank > procedure will be for clearing only) > > 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. > ___ 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] Data Entry Overload - Create Bill + Post Bill + Pay Bill vs just Pay Bill?
I don't have this problem, but perhaps Fran might be interested. They're the OP on this thread. Kind regards, Greg Feneis <http://www.linkedin.com/in/electromechanical> On Tue, Oct 13, 2020 at 9:15 AM elvis wrote: > Hello Greg, > > I encountered this exact same problem. > > > The way bills are entered just does not scale for someone doing more > than home entry, or doing it because they love it. 50 mouse clicks to > record buying a Mars bar just isn't viable if you have more than a Mars > bar a week. > > > I have a small program that takes downloaded transactions from the bank, > munges the descriptions so the qif importer recognises the accounts and > also adds gst. Saves hours and hours a month. > > > > > On 10/10/20 9:37 pm, Greg Feneis wrote: > > Yes, but keep in mind that I don't purchase anything for resale. > > > > Kind regards, Greg Feneis > > (Pixel 3) > > > > > > On Fri, Oct 9, 2020, 16:17 Fran_3 wrote: > > > >> So Greg, you don't post any Bills to Accounts Payable? Electric & > Utilityered > >> bills. Rent or whatever? > >> > >> You just post the payments... is that what you are saying? > >> > >> Thanks > >> > >> > >> On Friday, October 9, 2020, 12:15:25 PM EDT, Greg Feneis < > >> mfen...@gmail.com> wrote: > >> > >> > >> I don't use this process at all. Everything my business buys how on a > >> credit card. 路 > >> > >> Kind regards, Greg Feneis > >> (Pixel 3) > >> > >> > >> On Fri, Oct 9, 2020, 08:41 Fran_3 via gnucash-user < > >> gnucash-user@gnucash.org> > >> wrote: > >> > >>> Posting Bills allows you to keep track of AP and provides data to the > >>> Bills Due Reminder... > >>> However some routine expenses may just get paid without going through > the > >>> steps of creating and posting and paying a bill. > >>> For a small venture posting bills can require a lot of keyboard time... > >>> even duplicating a bill requires a number of steps, data entry, and > >> clicks > >>> and can eat up time if you have a bunch of them to do... > >>> Example, we have a couple of vendor from which we get 50+ to 100+ > charges > >>> per year. They each are on auto pay and are mostly for the same amount > >> per > >>> charge... but each charge is for a different thing... so descriptions, > >> due > >>> dates, etc are different for each item. > >>> (You can think of these as if they were an annual listing or service > >>> fee... one for each item.) > >>> I got reminded of this recently when we made an effort to enter/create > >>> Bills for the 100+ charges that were going to occur for Vendor-A over > the > >>> next 12 months... again, the big corporate vendor does not supply a > >> monthly > >>> Bill listing all charges for that month... the item fee comes up and > gets > >>> auto paid... so 100+ transactions per year for that one vendor. > >>> > >>> It is a lot less work to just enter each payment into the system as > >>> opposed to first creating a bill then posting a bill and then paying > the > >>> bill. > >>> How do you all choose which things to create Bills for and which things > >>> just Pay? > >>> Thanks. > >>> > >>> > >>> > >>> ___ > >>> 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
Re: [GNC] Data Entry Overload - Create Bill + Post Bill + Pay Bill vs just Pay Bill?
Yes, but keep in mind that I don't purchase anything for resale. Kind regards, Greg Feneis (Pixel 3) On Fri, Oct 9, 2020, 16:17 Fran_3 wrote: > So Greg, you don't post any Bills to Accounts Payable? Electric & Utility > bills. Rent or whatever? > > You just post the payments... is that what you are saying? > > Thanks > > > On Friday, October 9, 2020, 12:15:25 PM EDT, Greg Feneis < > mfen...@gmail.com> wrote: > > > I don't use this process at all. Everything my business buys how on a > credit card. 路 > > Kind regards, Greg Feneis > (Pixel 3) > > > On Fri, Oct 9, 2020, 08:41 Fran_3 via gnucash-user < > gnucash-user@gnucash.org> > wrote: > > > Posting Bills allows you to keep track of AP and provides data to the > > Bills Due Reminder... > > However some routine expenses may just get paid without going through the > > steps of creating and posting and paying a bill. > > For a small venture posting bills can require a lot of keyboard time... > > even duplicating a bill requires a number of steps, data entry, and > clicks > > and can eat up time if you have a bunch of them to do... > > Example, we have a couple of vendor from which we get 50+ to 100+ charges > > per year. They each are on auto pay and are mostly for the same amount > per > > charge... but each charge is for a different thing... so descriptions, > due > > dates, etc are different for each item. > > (You can think of these as if they were an annual listing or service > > fee... one for each item.) > > I got reminded of this recently when we made an effort to enter/create > > Bills for the 100+ charges that were going to occur for Vendor-A over the > > next 12 months... again, the big corporate vendor does not supply a > monthly > > Bill listing all charges for that month... the item fee comes up and gets > > auto paid... so 100+ transactions per year for that one vendor. > > > > It is a lot less work to just enter each payment into the system as > > opposed to first creating a bill then posting a bill and then paying the > > bill. > > How do you all choose which things to create Bills for and which things > > just Pay? > > Thanks. > > > > > > > > ___ > > 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. > ___ 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] Data Entry Overload - Create Bill + Post Bill + Pay Bill vs just Pay Bill?
I don't use this process at all. Everything my business buys how on a credit card. 路 Kind regards, Greg Feneis (Pixel 3) On Fri, Oct 9, 2020, 08:41 Fran_3 via gnucash-user wrote: > Posting Bills allows you to keep track of AP and provides data to the > Bills Due Reminder... > However some routine expenses may just get paid without going through the > steps of creating and posting and paying a bill. > For a small venture posting bills can require a lot of keyboard time... > even duplicating a bill requires a number of steps, data entry, and clicks > and can eat up time if you have a bunch of them to do... > Example, we have a couple of vendor from which we get 50+ to 100+ charges > per year. They each are on auto pay and are mostly for the same amount per > charge... but each charge is for a different thing... so descriptions, due > dates, etc are different for each item. > (You can think of these as if they were an annual listing or service > fee... one for each item.) > I got reminded of this recently when we made an effort to enter/create > Bills for the 100+ charges that were going to occur for Vendor-A over the > next 12 months... again, the big corporate vendor does not supply a monthly > Bill listing all charges for that month... the item fee comes up and gets > auto paid... so 100+ transactions per year for that one vendor. > > It is a lot less work to just enter each payment into the system as > opposed to first creating a bill then posting a bill and then paying the > bill. > How do you all choose which things to create Bills for and which things > just Pay? > Thanks. > > > > ___ > 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] win10/mysql/error
Hi Kerwin, You may want to reply with details about the previous computer OS, GnuCash version, etc. If you were using a much older version of GnuCash, there's a process to follow to upgrade to the latest version. If your data file was sql type, there are a few more steps. Kind regards, Greg Feneis (Pixel 3) On Sat, Oct 3, 2020, 23:00 xuhengx...@outlook.com wrote: > Dear Sir/Medam , > > > > I change my computer , > > Win10 2004 > > > > Gnucash : the last > > Version: 4.2 > > Build ID: 4.2+(2020-09-26) > > Finance::Quote: - > > > > Mysql : the last mysql Ver 8.0.21 for Win64 on x86_64 (MySQL Community > Server - GPL) > > [cid:image001.png@01D699A1.5EF35CC0] > > > > [cid:image002.png@01D699A2.59C06120] > > Thanks & Best Regards / kerwin > ___ > 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] help with error message
Jane, usually this happens when the user downloads and tries to import transactions that have already been downloaded and imported. Perhaps confirm that the data hasn't already been imported? However, sometimes GnuCash incorrectly treats new transactions as if they've already been imported. If this is the case, I recommend mentioning your OS and GnuCash version, and someone with more expertise will be along shortly Kind regards, Greg Feneis (Pixel 3) On Fri, Aug 28, 2020, 23:30 Jane Knichel-Aldea wrote: > Hello: > > Can anyone provide some troubleshooting advice for this error: > [image: image.png] > I have downloaded transactions from my bank many, many times, but never got > this message that 2 transactions were processed, but no trx to match. There > are definitely transactions in the date range I downloaded, so I do not > understand why i cannot add them, there is nothing to match them to. I am > not aware of making any configuration changes. > > Thank you, > Best Regards, > Jane Knichel Aldea > 201-725-3507 > ___ > 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] Version 4.1 - Check & Repair problem and segfault on close GnuCash
How do I access the web version of the mailing list? Kind regards, Greg Feneis (Pixel 3) On Sun, Aug 9, 2020, 23:37 Michael Hendry wrote: > > >> > PS Found the links to the threads on the Web version of the mailing list, > and have included these in the entries in Bugzilla. > ___ > 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] Latest Update
I'm still on 2.6.21 I had trouble updating to 3.x, so I gave up. I think the big reasons users should keep updated is to clear up a bug they're facing, or if they have a question about how to do something, it's handy to be asking for help with a recent version. So far, I've been pretty lucky with the end of the 2.6 series Kind regards, Greg Feneis (Pixel 3) On Tue, Aug 4, 2020, 06:26 John Donnee wrote: > Any idea as to why there have been two updates in the past month? > > I have an iMac and decided not to do the last update. > > Thanks > > John > -- > John J Donnee > > 317 Mount Eden Place > Cary, NC 27518 > ___ > 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] Installing on Windows 10 (with Defender)
May I suggest the brother-in-law also join us here on the list? If a new user is getting stuck, they're likely to have more than this one issue before they're up and running. Kind regards, Greg Feneis (Pixel 3) On Mon, Aug 3, 2020, 09:14 David Carlson wrote: > The devil is in the details. The .exe in this case function s very > similarly to a .msi, hence my confusion. > Thanks to all for the correction. > > David Carlson > > On Mon, Aug 3, 2020, 10:42 AM GTI .H wrote: > > > Em seg., 3 de ago. de 2020 às 11:24, D. via gnucash-user < > > gnucash-user@gnucash.org> escreveu: > > > > > David, > > > > > > Gnucash doesn't use an MSI file. It's an EXE. > > > > > > Unfortunately for Peter's brother in law, I cannot help, since my > Windows > > > 10 installation was without complication. > > > > > > David T. > > > > > > > I suggest that he execute this command at the command prompt of his W10. > > > > > > sfc /scannow > > > > > > > > Good luck! > > > > -- > > > > Regards > > ___ > > 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. > ___ 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] GnuCash list
Not familiar with Nabble, but what if... ...A user gives over their GnuCash email list credentials to Nabble at some early stage, thinking they're just doing what's required to be on the list (a Nabble-sent email with instructions, like a phishing scheme) and Nabble takes that info and alters the user's list settings and perhaps password, so it eventually seems to the user that the only way the user can access the list is through Nabble? For this to work, the Nabble bot would need its own account on the list and that account would have to get a notification every time a new user joins (don't even know if that's possible), or somehow monitor the list's activity just enough to detect when new users join the list. Something like this might explain why ppl claim various issues with normal list interaction + claim they can only read and work with the list through Nabble. Kind regards, Greg Feneis (Pixel 3) On Tue, Jul 7, 2020, 06:13 Adrien Monteleone wrote: > Nabble is not GnuCash. They are a site that provides access to one or more > mailing lists (of any subject) in a web forum format instead of having to > use regular e-mail that mailing lists use. > > At some point in history ‘Hugo’ linked the gnucash-user list to Nabble. No > one seems to know if permission from the GnuCash team was ever sought or > obtained when this was done. > > Joining Nabble does *not* subscribe you to the mailing list. > > You do not *need* to join Nabble to use the list. You don’t ever need to > use Nabble at all to get help with GnuCash. (I never have and I joined this > list years ago) > > Mailing lists are just e-mail. They have their own Netiquette and some > tips on this can be found in https://wiki.gnucash.org/wiki/Mailing_Lists. > > I hope that clears up some confusion. > > Regards, > Adrien > > > > > On Jul 7, 2020 w28d189, at 6:59 AM, butterandpean...@gmail.com wrote: > > > > *I would have responded earlier, however, I experienced the exact same > > situation as Adrian. I've been a participant on the GnuCash list for > YEARS, > > and all of a sudden through nabble I was/am no longer able to post or > reply > > to the list. I also get NO RESPONSE from the infamous "Hugo" whoever > > s/he/it is... very frustrating. I just joined the list directly, but I > too > > am totally confused.* > > ___ > 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] Accounts List Columns Displayed
I have found that usually, when the width of all the columns exceeds the width of the window, a slightly inconspicuous horizontal scroll bar appears at the bottom of all columns, allowing me to shift columns left and right. Kind regards, Greg Feneis (Pixel 3) On Mon, Jul 6, 2020, 15:28 listsub3 wrote: > Thanks. > > The down arrow at right hand end of columns header was not visible on my > screen - it seems like expanding column size(s) causes it to get pushed > off the screen - which I guess should not happen. > > On 06/07/2020 12:28, Maf. King wrote: > > On Monday, 6 July 2020 12:14:55 BST listsub3 wrote: > >> On Accounts tab (GC 3.5) the only 3 columns I get displayed are Account > >> Name, Description and Total. > >> > >> Is there any way to control/get additional data columns for account > >> fields - example Account Type? I want to be able to sort list by various > >> fields - especially Type. > >> > >> > > Yes, click the little down arrow at the right-hand end of the columns > header > > row. Type is one of the options to display. > > > > HTH, > > Maf. > > > > > > > > > > > > > ___ > 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] Running both Stable and Development Releases
How? Kind regards, Greg Feneis (Pixel 3) On Tue, May 26, 2020, 17:34 jean laroche wrote: > I've been able to install both is two separate directories, and things > work just fine... But that's just 1 data point... > > Jean > > > On 5/26/2020 5:04 PM, flywire wrote: > > GnuCash setup is quick enough but it asks for the existing version to be > > uninstalled. Can both Development and Stable releases be installed at the > > same time under Win10? Installing the Stable release and running a > > PortableApp version of the Development release would be good. > > ___ > > 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. > ___ 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] Data conversion to QuickBooks
If you have an Android phone, it looks like Wine 5.0 can run on Android, and I bet GnuCash can run in Wine 5.0. So, "it's possible", that you could run GnuCash on an Android phone (or tablet?). However, the more time you spend accounting, the more you're going to want a better interface. I have no experience doing this, but if you try it LUK how it works Kind regards, Greg Feneis (Pixel 3) On Sun, May 24, 2020, 07:53 James Cook wrote: > On Sun, 24 May 2020 at 08:33, Jane Knichel-Aldea > wrote: > > Hi: > > Does anyone know if a gnucash file can be converted to QuickBooks online? > > Or if not, is there an online version of Gnucash? I am about to lose my > > laptop so I will need online access to my file. > > If you have an Android phone, you may be able to get some of GnuCash's > functionality from the Android app. However, I have not tried it so I > don't know what you can and can't do with it. Also, according to > https://wiki.gnucash.org/wiki/GnuCash_and_Mobile_Devices it has not > been updated since 2018 (and is a separate project from GnuCash > itself), so I would not rely on it as a long-term solution. > > James > ___ > 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] Trying to set up online banking
Janet, Good luck with online banking. If you are unable to get online banking to work, there's a fairly easy alternative. Most banks allow their customers to log into the bank's web site and download transactions and banking activity in various formats, which you can import into GnuCash. That's what I do. My credit union allows me to download "credit unioning" activity in an OFX file. Some of my credit cards allow OFX, others provide QFX or some proprietary version of OFX. GnuCash can import these fairly easy. If you have a lot of transactions already in an accounting app such as quickbooks or quicken, you can export from those applictions and import to GnuCash similarly as downloading activity from your bank's web site and importing to GnuCash Kind regards, Greg Feneis On Sun, Apr 26, 2020 at 10:29 AM Janet Shelby wrote: > Thank you very much, this gives me a direction to pursue! I have not given > up yet, and really want to avoid the Quicken subscription fees! > > On Sun, Apr 26, 2020, 9:50 AM David Reiser wrote: > > > Some banks have separate login credentials for standard online banking vs > > directconnect transaction retrieval. Chase and Citibank both have > multistep > > processes that require both adequate aqbanking setup and logging back > into > > the standard bank web site, finding the query from the bank regarding the > > attempt to log in via direct connect, and doing something the bank > > considers to be adequate out-of-band confirmation of identity before > > connections from gnucash can work. After getting it to work once, it’ll > > usually work unchanged until the fake quicken version used for > > directconnect emulation ages out of the acceptable range. Now that > quicken > > is subscription-only, the app version field might not matter, but there > is > > no readily available documentation on the subject. > > -- > > Dave Reiser > > dbrei...@icloud.com > > > > > > > > > > > > > On Apr 26, 2020, at 12:26 PM, Janet Shelby > > wrote: > > > > > > Thanks for that info John. My banks are major ones and both in the > setup > > > dropdown list. One of them will not return any accounts, and the other > > says > > > my user name/password is wrong even though it is correct. I hunted on > > > google until I found a comment suggesting changing the setting under > > > special setup from 1.0 to 1.1 but still can get nowhere. > > > > > > On Sat, Apr 25, 2020, 9:00 PM John Ralls wrote: > > > > > >> > > >> > > >>> On Apr 25, 2020, at 6:11 PM, Janet Shelby > > >> wrote: > > >>> > > >>> Hello, I am a new user migrating from many years of Quicken. I would > > like > > >>> to use Gnucash if it will download banking transactions, especially > > >> credit > > >>> card transactions. The tool provided does not get successful results > > >> with > > >>> no instruction on what to do upon failure. I am an accountant but not > > an > > >> IT > > >>> specialist! Can I get assistance here? Thanks. > > >> > > >> Check your bank's online banking setup page and make sure that it > > supports > > >> OFX DirectConnect. The alternative is OFX WebConnect which uses an > > >> Intuit-proprietary authentication mechanism that GnuCash's online > > banking > > >> library is unable to use. > > >> > > >> If it says that it does, go to https://www.ofxhome.com and search for > > the > > >> bank. If it's there just go to the page for it and check that it has > > >> validated recently. If it has then you should be able to use the bank > > >> selection in the AQBanking setup. If not then you'll have to try to > set > > it > > >> up by hand using whatever information you can glean from the bank's > > >> website, which may not be much: It may just say that you need a > certain > > >> version of Quicken and to go to the online banking tab in that program > > and > > >> select the bank. > > >> > > >> Regards, > > >> John Ralls > > >> > > >> > > >> > > > ___ > > > 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://
Re: [GNC] BackupGnuCash updated for Java 11
How does one find out more about BackupGnuCash, what it does and so forth? Kind regards, Greg Feneis (Pixel 3) On Tue, Mar 3, 2020, 22:39 Chris Good wrote: > Hi, > > > > I've updated my BackupGnuCash app for java 11 which is the default version > of java on Ubuntu 18.04 and derivatives like Mint 19. > > As the app is now a modular java app, it is distributed as a runtime image > which includes the required java runtime, so it is not necessary to have > java installed on your system. > > > > The new BackupGnuCash version is 2.0.0. > > > > Please see: > > > > Linux: > > > https://github.com/goodvibes2/BackupGnuCashLinux/tree/master/src/backupgnuca > sh > > Windows: > > > https://github.com/goodvibes2/BackupGnuCashWin/tree/master/src/backupgnucash > > > > Regards, > > Chris Good > > > > ___ > 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] Problems importing American Express QFX files into GNUCash
When I make the mistake of trying toimport transactions that have already been imported, the matcher dialog appears empty. Check the content of the file you're trying to import and see if it's stuff that's already been imported? Kind regards, Greg Feneis (Pixel 3) On Tue, Mar 3, 2020, 15:10 Jonathan Bentz wrote: > Does this also apply to offline importing? > > I'm just downloading the transactions locally then importing them, not > connected directly via the online banking tools.Thanks. > > On Tue, Mar 3, 2020 at 4:47 PM David Reiser wrote: > > > > > > On Mar 3, 2020, at 4:14 PM, Jonathan Bentz wrote: > > > > > > I'm running GNUCash 3.8 and was manually importing my credit card > > > statements yesterday via QFX and when I tried to import a QFX file from > > > AMEX, it was blank. I have successfully imported QFX files from AMEX > > for a > > > few years now and as recently as December of 2019 I have never > > encountered > > > this. > > > > > > I download the QFX file to my local Win10 machine, then "import" it > into > > > GNUCash, and there are no transactions listed. > > > > > > Any idea what's going on, or what I could try? Thanks. > > > > European banking changes forced some changes in aqbanking that adversely > > affected gnucash US ofx/qfx imports. > > > > Try Gnucash version 3.7, or wait for 3.9. > > > > Dave > > -- > > Dave Reiser > > dbrei...@icloud.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 > 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] Transactions association to accounts (automatically)
I'll wager there is documentation on how to import transactions, and use the matcher dialog. Then, perhaps you can apply this info to your specific use case. It seems like you do a lot of manual processing of the data prior to import. This may be defying the ability and intention of the matcher dialog. Kind regards, Greg Feneis (Pixel 3) On Mon, Mar 2, 2020, 10:10 Stelvio Rosset wrote: > Hi, many thanks for so much help and inputs. > > Actually in the CSV import I was setting the column "ACCOUNT TRANSFER" and > "WITHDRAWAL", and then GNUCASH was asking also the ACCOUNT in mandatory > way. > This is way I was specifying UNBALANCE and then doing the account change > later on. > > Probably that was the mistake, I guess I should instead import the sourcing > account as ACCOUNT and not as WITHDRAWAL but as DEPOSIT, specifying the > number in POSITIVE and not as NEGATIVE. > > Sounds correct? > > I will make further tests of import, and dedicating time to read better the > manual / instruction. > > Thanks again > Stelvio > > > > -- > 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. > ___ 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] Recovering deleted transaction from log files
I imagine logging is minimal by default to help keep GnuCash speedy. Unless the user increases verbosity via CLI when launching GnuCash. Just a guess. I'm also curious about controlling logging. I bet it's documented somewhere Kind regards, Greg Feneis (Pixel 3) On Sat, Feb 22, 2020, 15:00 Roland Roberts wrote: > On 2/21/2020 11:54 PM, Roland Roberts wrote: > > [...] > > So... I figured the log file(s) between those two should have the > > missing transactions. But that file is nothing but a sequence of > > > > = START > > = END > > > > after the header. Why wouldn't the log have my deleted transactions > > in it? > > So I was able to track down the missing transaction. What had actually > happened was that I had apparently edited it (obviously in error) and > change the account on a payment to a credit card. That removed it's > reconciled state in the bank account from which the payment had been > made (naturally, it was no longer against that account). I did that the > painful way by unpacking the two gnucash files and doing diff, that > tracking through the diffs. > > I'm still puzzled by the log file. I read through some of the gnucash > docs and realize that scheduled transactions are special beasts and that > those don't show up in the logs, but an edit like this I thought would. > My immediate problem is solved, but...I'd like to know what sort of > things the logs can help me with since it wasn't as useful as I expected > for this case. > > roland > > > ___ > 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] Small bug in the display
Note that in some cases widening a column can put all of the columns on a common page with a scroll bar at the bottom. So it's possible for the left most column's contents (date) to appear off the screen. Kind regards, Greg Feneis (Pixel 3) On Wed, Feb 19, 2020, 07:11 Colin Law wrote: > Does double clicking the date column header fix it? > > What OS are you using and what version of GnuCash? > > Colin > > On Wed, 19 Feb 2020 at 09:05, mhdecoursey . wrote: > > > > The first column of date characters is partially outside the window > frame, > > making some entries difficult to read. snap enclosed. > > > > > > > > > > > > > > > > Mark H. DeCoursey > > ___ > > 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. > ___ 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] How2find 1) Duplicate items imported 2)Un-Posted Bills?
I typically import qif and ofx files into checking or credit card accounts. GC does a pretty good job of matching pending import transactions with transactions that are already present. Also, I have tried to import a file that I previously tried to import, and nothing shows up in the matcher dialog. I don't know how it knows but I'm glad it does Kind regards, Greg Feneis (Pixel 3) On Tue, Feb 18, 2020, 16:07 Fran_3 via gnucash-user < gnucash-user@gnucash.org> wrote: > Thanks Adrian. > I'll try and run a test on importing a duplicate checking transaction.In > this case the transactions description may not match exactly and I assume > that is one of the fields tested by GC to discover that the transaction is > already in the system.The fields being imported are Date, Num, Description, > Deposit, and Withdrawal > Good answer on finding unposted Bills.Thanks again > > On Tuesday, February 18, 2020, 6:45:53 PM EST, Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > > I’m not sure about flagging, but it shouldn’t create a duplicate. > > As for the finding unposted bills, do a Business > Vendors > Find Bill and > set criteria of “Is Posted?” to unchecked. > > Regards, > Adrien > > > > On Feb 18, 2020 w8d49, at 4:05 PM, Fran_3 via gnucash-user < > gnucash-user@gnucash.org> wrote: > > > > 1) When importing or entering checking transactions does gnuCash flag > importing a transaction that is already in the system? > > 2) How do you find Un-Posted bills. > > Thanks for any help. > > ___ > 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. > ___ 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] [GNC-dev] [MAINT] Server Downtime to relocate hardware, Feb 1, 2020
Sounds like a lot of work, Derek. Thank you very much ✌️ Kind regards, Greg Feneis (Pixel 3) On Sat, Feb 1, 2020, 21:05 Derek Atkins wrote: > Hi, > I've got my main servers racked, network transitioned, and VM host > upgraded. > I turned the VM's back on around 23:30 local time. > As you can see from this message, code is now passing mail again. > I know gncbot is also sitting in IRC. > So I'm going to call the server back up and running. > If you see any issues please let me know and I'll check it in the morning. > > I do still have some work to do; the VMs didn't come up on their own and > needed some manual intervention. I know why, but I'm going to have to > track down how to work around the new issue. :( Unfortunately testing > this might require more downtime to ensure it's working. > > I'll try to schedule that when I can. > > For now, I'm going to try to get some rest. > > Happy GnuCashing! > > -derek > > On Sat, February 1, 2020 4:58 pm, Derek Atkins wrote: > > Hi, > > This maintenance is about to begin. > > -derek > > > > On Fri, January 31, 2020 9:52 pm, Derek Atkins wrote: > >> Hi, > >> Just a reminder that this is scheduled for tomorrow. > >> I am expecting the work to start around 4pm US/ET (2100 UTC). > >> I will send one more email before I start to turn down servers, and will > >> be on > >> IRC as much as I can during the work. > >> Thanks, > >> -derek > >> > >> "Derek Atkins" writes: > >> > >>> Hi, > >>> > >>> TL;DR: I plan to move the hardware that runs code.gnucash.org on the > >>> afternoon/evening of February 1, 2020, which will involve some > >>> significant > >>> downtime as the machine is physically moved and then racked. Expect > >>> anywhere from 4-12 hours of downtime for email, wiki, archives, gncbot, > >>> and git master. Exact time TBD; real-time updates will go to #gnucash > >>> on > >>> IRC. > >>> > >>> > >>> Long version: On the afternoon of February 1, 2020 I plan to relocate > >>> my > >>> hardware to its more permanent location. This will involve significant > >>> downtime because I have toL > >>> 1) shut down the systems > >>> 2) reconfigure the local network at the old location > >>> 3) reroute the IPv4 tunnel to the new location (which requires > >>> coordination with another entity) > >>> 4) physically move the machines from the old location to new location > >>> 5) install the new machines in the racks at the new location > >>> 6) reconfigure the local network for the tunnel > >>> 7) turn on an test > >>> > >>> I expect this whole process will take at least 4 hours, but probably > >>> much > >>> longer depending on many variables. However, once it is complete the > >>> system will be (back) on a 1Gb fiber with a good-sized UPS for > >>> short-to-medium length power outages (which we've had none in the past > >>> 2 > >>> years). > >>> > >>> I will send an email about 30 minutes before I begin, and again after > >>> the > >>> project is complete. I'll remain on IRC in the interim for more > >>> real-time > >>> updates. > >>> > >>> During this outage, most gnucash services will be unavailable. This > >>> includes: email lists and archives, wiki, git master, IRC gncbot, > >>> build > >>> services, etc. The web site, www.gnucash.org, will remain available > >>> and > >>> I > >>> will post a news article about the maintenance. > >>> > >>> DEVS: Please let me know ASAP if there are specific time frames that > >>> would adversely affect you. I do have some flexibility in doing this > >>> work. > >>> > >>> Please let me know if you have any questions, comments, or concerns > >>> prior > >>> to this work. > >>> > >>> Thanks, > >>> > >>> -derek > >> > >> -- > >>Derek Atkins 617-623-3745 > >>de...@ihtfp.com www.ihtfp.com > >>Computer and Internet Security Consultant > >> ___ > >> gnucash-devel mailing list > >> gnucash-de...@gnucash.org > >> https://lists.gnucash.org/mailman/listinfo/gn
Re: [GNC] Problem with colons in account names
I think having colons in names of things interferes with GnuCash's auto-fill/lookup scheme when filling certain fields in a transaction. The colon is a special character that accepts an autofill suggestion and lists a sub selection list based on what the user types. EG, account name colon sub account name, and so on. Perhaps the same name suggestion/lookup function is used for security names, so it triggers an error about account names that should now be more generalized? However, I don't know why you still get the error message if you've edited all colons out. Kind regards, Greg Feneis (Pixel 3) On Wed, Jan 15, 2020, 19:15 wrote: > Hi, all. > > First, thanks for the continuing excellent work on Gnucash in the Dec. > release. I know it is a lot of work for the team; it is not thankless work. > > I recently set up some stock stocks in the Security editor and created > corresponding asset accounts as described in the documentation. The symbols > I was given had colons in them, in the form symbol:currency, such as > ABCD:USD, so I added these as the symbol and display symbol in the security > editor. > > When I next started Gnucash I was warned that I had account names with > colons, which is not true, I had securities linked to the accounts, and > they had the symbols I just described. Regardless, I edited each of the > securities to remove the trailing :USD parts, but I still see the warnings > on starting up. > > Any suggestions for the correct fix are appreciated. > > Ron > ___ > 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] how to delete a new file
And, if all columns' widths are adjusted and not all columns are viewable, there should be a scroll bar just below all columns that you can use to shift the columns left and right. Kind regards, Greg Feneis (Pixel 3) On Thu, Jan 9, 2020, 02:18 david whiting wrote: > Hi Harvey, > > When you say " When i get to the point of entering transactions, there is > no space for "balance" at the end of the entry line" does this mean that > the register is not showing all the columns? If so, you might just need to > resize the columns you can see by double-clicking on the dividing lines > between the columns (at the top of the columns in the header), especially > at the end of the description column. > > David > > On Thu, 9 Jan 2020 at 07:44, Harvey Moxness wrote: > > > I hope someone can help I am new to gnu/cash and trying to set up a > > simple bookkeeping file, as a chequebook. When i get to the point of > > entering transactions, there is no space for "balance" at the end of the > > entry line. So I must have started the set-up procedure wrong, as the > > tutorial pictures show a balance at the end of each transaction. I > > would like to delete the whole project that I have started, and start > > again, but I don't see how to do that. I have used Quicken for years, > > but Microsoft is dumping its Windows 7, which is the only version I was > > able to use the Cash Manager 2015 on. Thank you. Harvey Moxness > > > > ___ > > 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 Whiting > ___ > 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] Multiple GnuCash Rev Installations
Hi, Somebody replied to a comment I made about not being able to install an updated GnuCash alongside an older GnuCash, but I lost track of the response. It seemed to relay a variety of ways they were able to achieve multiple installations, but I was unable to discern any information on how that was done. My wish for the ability to have multiple installations was for the installer dialog to allow this as an option, for anyone to use. I haven't installed GnuCash in a while, but the last time I did, the installer uninstalled the previous installation without an option to leave it there. At the time, I enquired about this very thing and was told it's not an option. What's the secret? Kind regards, Greg Feneis (Pixel 3) ___ 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] Non appearing, appearing - disappearing memo detail
In some programs I've used in the past, I've seen a similar behavior, the text appears in the field while editing, but disappears after entering. Sometimes this is due to the string length causing the text to wrap. Since the field is only one line tall, nothing displays. But when you go back to edit it, it appears again. Kind regards, Greg Feneis (Pixel 3) On Wed, Jan 1, 2020, 09:26 Jeff Albrecht via gnucash-user < gnucash-user@gnucash.org> wrote: > Windows 10 > GNUCash 3.7 > > I started in on my year end taxes a couple days ago. I will get them > filed and paid on time this year. > > I import .OFX transaction and be sure the distributions are correct. I > also paste in details of purchases typically from Amazon and Ebay. This > specific incident is from Amazon. It's not an isolated incident but at > the moment I can't specifically say it happens in other transaction > vendors than Amazon. > > After the initial entry, I put GNUCash aside and double check a couple > days later. I see a transaction categorized correctly but it looks like > I haven't pasted in purchase details. I place my cursor in the seemingly > blank line to enter some detail and (abracadabra) the detail I entered a > couple days ago appears - no I don't believe it's auto complete as I > click the enter command and as I move my cursor out of that transaction > it disappears again and no comment from GNUCash to save changes. > Generally I cut and paste the detail info (not available in the .OFX > transaction) from a .CSV import to a spread sheet that makes it easy to > search for amounts and to copy/paste the detail. I can click back and > forth between the line with odd behavior and a line in another > transaction and have the consistent behavior of appearing when clicking > on the line and disappearing when clicking outside of that lines > transaction. Just for grins I prepended a ' ' space at the beginning of > the line trying to rule out invisible specharacters, recorded the > transaction, clicked out of the transaction and experience the same > disappearing behavior. In this same register I can see many of the > transactions that I've entered additional memo, non .OFX content, > information displaying as I would like - not disappearing... > > This is the string; "Creality 3D Upgraded BLTouch V1 Auto Bed Leveling > Sensor Kit Accessories for Creality 3D Ender 3/ Ender 3 Pro/Ender 5/CR > -10/CR-10S/CR-10S4/S5/CR20/20Pro" Could the GNUCash enter or display > routing or associated library used be interpreting '/CR' as a CRLF or > ??? exhibiting this strange behavior? > > > As I say this was not an isolated incident. It's happened a few time > over my couple years use of GNUCash. Maybe happening more often as once > I'm clicking 'enter' I'm not looking at the transaction. > > - Jeff > > ___ > 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] v3.8
Happy New Year, All Perhaps a better strategy is for the ordinary user to do the waiting. As is the case with a variety of software, both FOSS and commercial, you take some risk when immediately installing and running newly released software. It's just too complicated to test for all possible contingencies. Seems like the developers have to make the best compromise between development efforts and checking for every possible issue. Don't forget, everyone working on this project is doing it to benefit everyone for free. They somewhat rely on users to test and report back about their issues. If anyone has resources to donate, please inquire where you may help. Anyone who has time may can get involved with helping to test before release, for example. I imagine there's a way to get access to a regular (perhaps daily?) build. This could be compiled and installed on a spare computer and tested with a copy of your normal working data. Report back what happens. I don't mean to direct this effort, but if anyone wants this process to improve, they should consider donating resources toward that improvement. I wish I had time to help more, but in my case, I'm still on 2.6.21. It serves me well, so I have no need to upgrade other than for a circumstance where I need to ask how to do something, it's better to have a recent version running. My wish is that there was an easy way to install a newer GnuCash release without giving up the previous, that they could run alongside each other for a while. Kind regards, Greg Feneis On Wed, Jan 1, 2020 at 4:15 AM Finbar Mahon wrote: > I very much appreciate, and depend a lot on, Gnucash. But could I make a > small recommendation? > > When a new version is launched would it be possible to announce when It > works for 'ordinary' users? > > I have no trouble waiting until it is 'clean' > > HYN 2020 to all. > > Finbar > > On 01/01/2020 00:34, David Cousens via gnucash-user wrote: > > It should but you will have to install all the dependencies and their > > development headers to build successfully. There is a breakout page from > the > > building instruction which gives you the dependencies to install. (There > are > > occasionally some that are not covered as it depends on what the > particular > > Linux distribution installs as standard and what libraries have been > > installed with other software but it is now pretty complete). > > > > When you run cmake, it will stop with an error if anything is missing. > > Identify the missing dependency or come back to the list, install it and > > rerun cmake until it completes with out error. Library names can > sometimes > > vary slightly between distributions to complicate matters (usually > addition > > of a version number or "lib" in front > > > > apt-cache search is a good way to find libraries with a slightly > > different package name. > > > > > > > > - > > 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. > ___ > 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] Gnucash keeps crashing with Online Banking Setup Wizard
I get my Chase business credit card account's OFX data right from their website, and in the last several years haven't had trouble importing it. I'm still running 2.6.21, though. If you've got development resources available, I'm sure the developers could use the help Kind regards, Greg Feneis (Pixel 3) On Tue, Dec 31, 2019, 15:15 Traveler12 wrote: > Same problem here, and not getting any answers, either. gnucash won't work > with Chase or Amex OFX downloads. > > > > -- > 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. > ___ 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] Chaning left sidebar spacing
I think the items in that list are tabs, with similar operation to modern browsers. There should be a way to set the properties of the tabs list. You should be able to make them display vertically alongside all windows, or horizontally above all windows. I believe when the number of open tabs causes all the tabs to be so small that they cannot be read, there's a widget in the corner of the tabs display you can click on that makes a pop-out menu display the whole list legibly, so you can search for the tab you want. I only recall this being explained on this list perhaps a year ago. Kind regards, Greg Feneis (Pixel 3) On Tue, Dec 31, 2019, 16:55 William Marshall via gnucash-user < gnucash-user@gnucash.org> wrote: > Hi All, > > I don’t know if this is the right pace to ask this or not, and I’m sure > it’s already been asked many times, but Googling for solutions hasn’t > provided me any relief. How do I reduce the spacing on the left sidebar > that lists the accounts and reports that I’ve opened? Right now, they way > spread out vertically, which happened when I switched to GnuCash 3.X. I’m > currently using GnuCash for Mac version 3.7, Build ID: 3.7+(2019-09-07). > > Thank you, > Bill Marshall > ___ > 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] Credits
Find where that credit appears as a transaction in a register. Then try right click on the transaction and select apply as payment. Kind regards, Greg Feneis (Pixel 3) On Sun, Dec 15, 2019, 03:16 Michael Hendry wrote: > > On 14 Dec 2019, at 22:00, Aaron Mina wrote: > > > > Hello, > > > > I would like to know how credits are used in GNUCash. I am running > 2.6.19 on Ubuntu. I have a client that I want to start off with credits. > I put in a credit while opening the new customer dialogs.I just posted > an invoice to the account and when I went to pay it, the credits didn't > show up. > > > > > > What is the proper way to assign credits to an account and use them? > > > > > > Thank you, > > Aaron > > > I don’t use invoicing, but it would seem logical to issue a credit note to > the customer when setting up, if you already owe that customer money. > > https://wiki.gnucash.org/wiki/Credit_Notes > > Michael > ___ > 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] Invoice date field starts too narrow
Axel, When you double clicked the date column header, did you follow that with a double click of the description column header? If the date column is fully in view, but too narrow to display all of the characters in the fields, double clicking its column header might have widened the column, and simultaneously widened the window that holds all of the columns (horizontal scroll bar at the bottom of all the columns appears), causing the left edge of the date column to shift left. This might have given the appearance of the column collapsing, but it really expanded while moving out of view. You would have to follow that with scrolling all columns to view the entire date column, or double click the description column to normalize the columns' window's width. You might consider double clicking the column header for description column, but only after you have double clicked the column header for any of the other columns. Kind regards, Greg Feneis (Pixel 3) On December 12, 2019, at 9:44 PM, Axel Essbaum wrote: > > > Hi Greg, > > Thanks for the suggestion. Double-clicking on the date header collapses > the column even further, so that the entire day part of the date (I use > format day.month.year) on the bottom line disappears off the left side of > the screen. > > :-( > > - Axel > > — > Axel Essbaum > a...@essbaum.com > > > > > On 12 Dec 2019, at 17:05, Greg Feneis wrote: > > > > No attachment here either, and not a final solution, but I think the > > invoice columns auto size if you double click on the column header. > > > > Double click any column header that's over a too narrow column first, > then > > double click the header over the description column and it will give up > > enough of any excess width to normalize the window width, which should > > eliminate the horizontal scroll bar. > > > > Kind regards, Greg Feneis > > (Pixel 3) > > > > > > On Thu, Dec 12, 2019, 06:35 David Carlson > > wrote: > > > >> Axel, > >> > >> Your attachment did not make it as far as my inbox, but your > description is > >> very clear to me. However, I am not a developer, and I do not have any > >> experience to offer suggestions for your issue with GnuCash. I do not > know > >> if it is an issue that is an artifact of the fact that your date format > is > >> not the U.S default, for example. > >> > >> Good luck. > >> David Carlson > >> > >> On Thu, Dec 12, 2019 at 1:46 AM Axel Essbaum wrote: > >> > >>> > >>> Trying again with attachment at the very end. > >>> > >>> GC retains the column width for each invoice over the life of that > >>> invoice. The issue is that new invoices don't inherit any of this - > they > >>> all start with a narrow date field. > >>> > >>> See at the bottom (I hope). I can't tell if the date of the bottom > line > >>> is 01.12.2019 or 11.12 or 21.12, etc. without clicking on the calendar > >>> selector. So I widen the Date field, and then shrink some other field > to > >>> remove the created horizontal scrollbar. For every invoice I create. > >>> > >>> Thanks, > >>> > >>> - Axel > >>> > >>> — > >>> Axel Essbaum > >>> a...@essbaum.com > >>> > >>> > >>> > >>>> On 12 Dec 2019, at 05:17, John Ralls wrote: > >>>> > >>>> Axel, > >>>> > >>>> Also make sure they're on the end of the email after all text > including > >>> signatures. The list server eats inline attachments. > >>>> > >>>> GnuCash is supposed to remember things like column widths so that you > >>> need set them only once. Is that not working for the Invoice date > >>> column--or perhaps any invoice columns? > >>>> > >>>> Regards, > >>>> John Ralls > >>>> > >>>> > >>>>> On Dec 11, 2019, at 3:52 PM, Frank H. Ellenberger < > >>> frank.h.ellenber...@gmail.com> wrote: > >>>>> > >>>>> Hi Axel > >>>>> > >>>>> Am Mi., 11. Dez. 2019 um 08:53 Uhr schrieb Axel Essbaum < > >>> a...@essbaum.com>: > >>>>>> > >>>>>> > >>>>>> Hi All, > >>>>>> > >>>>>> MacOS Mojave, GnuCash 3.6. Pictures say it all (hope this list > >> allows > >>
Re: [GNC] Invoice date field starts too narrow
No attachment here either, and not a final solution, but I think the invoice columns auto size if you double click on the column header. Double click any column header that's over a too narrow column first, then double click the header over the description column and it will give up enough of any excess width to normalize the window width, which should eliminate the horizontal scroll bar. Kind regards, Greg Feneis (Pixel 3) On Thu, Dec 12, 2019, 06:35 David Carlson wrote: > Axel, > > Your attachment did not make it as far as my inbox, but your description is > very clear to me. However, I am not a developer, and I do not have any > experience to offer suggestions for your issue with GnuCash. I do not know > if it is an issue that is an artifact of the fact that your date format is > not the U.S default, for example. > > Good luck. > David Carlson > > On Thu, Dec 12, 2019 at 1:46 AM Axel Essbaum wrote: > > > > > Trying again with attachment at the very end. > > > > GC retains the column width for each invoice over the life of that > > invoice. The issue is that new invoices don't inherit any of this - they > > all start with a narrow date field. > > > > See at the bottom (I hope). I can't tell if the date of the bottom line > > is 01.12.2019 or 11.12 or 21.12, etc. without clicking on the calendar > > selector. So I widen the Date field, and then shrink some other field to > > remove the created horizontal scrollbar. For every invoice I create. > > > > Thanks, > > > > - Axel > > > > — > > Axel Essbaum > > a...@essbaum.com > > > > > > > > > On 12 Dec 2019, at 05:17, John Ralls wrote: > > > > > > Axel, > > > > > > Also make sure they're on the end of the email after all text including > > signatures. The list server eats inline attachments. > > > > > > GnuCash is supposed to remember things like column widths so that you > > need set them only once. Is that not working for the Invoice date > > column--or perhaps any invoice columns? > > > > > > Regards, > > > John Ralls > > > > > > > > >> On Dec 11, 2019, at 3:52 PM, Frank H. Ellenberger < > > frank.h.ellenber...@gmail.com> wrote: > > >> > > >> Hi Axel > > >> > > >> Am Mi., 11. Dez. 2019 um 08:53 Uhr schrieb Axel Essbaum < > > a...@essbaum.com>: > > >>> > > >>> > > >>> Hi All, > > >>> > > >>> MacOS Mojave, GnuCash 3.6. Pictures say it all (hope this list > allows > > attachments!) > > >> : > > >> There was no attachment, neither in the mail nor on the server: > > >> > > > https://lists.gnucash.org/pipermail/gnucash-user/2019-December/088216.html > > >> > > >> That might be caused by sending mails in HTML format. In text format, > > >> attachments should go through. > > >> > > >> Regards > > >> Frank > > >> ___ > > >> 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. > > > > > -- > 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. > ___ 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] automatic reconnaissance of a transaction
Just to be clear, when a user selects a file for import, it's transactions appear in the matcher dialog. This is where the user must correct whatever assignments are not done, or are done incorrectly. The matcher only learns from corrections made from within this dialog. Once the user is past this dialog, and the transactions have been imported and appear in a GnuCash register, if some error is found and gets corrected, the matcher doesn't learn from this correction, so it will likely fail the same way the next time. Kind regards, Greg Feneis (Pixel 3) On Wed, Dec 4, 2019, 07:39 Joffrey Bienvenue wrote: > Thanks for the update! > > Yeah I can understand when description changes but here I'm referring to > transactions that are always the same and never get automatched > > I'll look at the options you gave me. > > Cheers, > Joffrey > > On Tue, 3 Dec 2019 at 22:57, John Ralls wrote: > > > > > > > > On Dec 3, 2019, at 4:16 PM, Joffrey Bienvenue < > > joffrey.bienve...@gmail.com> wrote: > > > > > > Hello > > > > > > When I import transactions from my bank accounts, some transactions, > very > > > few in fact, are recognized by GnuCash. It used to be better at > > recognizing > > > but I find it's less and less. > > > > > > Is there a way to help that "reconnaissance" ? > > > > > > Some transactions I am registering are *always* posted in the same > > category > > > (eg. Expenses->Groceries) but it keeps on not being recognized. > > > > The matcher works mostly from descriptions. Have those changed > > significantly? > > > > There are two things you can do: Always update the matches and from time > > to time use Tools>Import Match Editor to remove obsolete matches that > might > > lead the match algorithm astray. > > > > If nearly all of your transactions will match descriptions exactly with > > their predecessors then the non-Bayesian matcher may work better, but in > > all other cases the Bayesian one will be better in the long run, though > it > > requires more training at the outset to start getting good matches and > > needs to be maintained by reviewing matches and correcting mismatches *in > > the matcher* to keep on track. > > > > Regards, > > John Ralls > > > > > > -- > -- > Je roule pour la santé des hommes. I ride for men's health > https://gentlemansride.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 > 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] gnucash.org is UP
In case anyone was waiting, gnucash.org is available for your Internet browsing convenience. In case anyone remains concerned with the reliability of the site, details about you can help ensure reliability may be found here: https://www.gnucash.org/donate.phtml I'm very grateful for this software and all who make it happen. Kind regards, Greg Feneis (Pixel 3) ___ 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] Smoother register scrolling?
Typical computer mouse settings allow the user to tune the number of lines of text that get scrolled for each click of the mouse wheel. Perhaps set this to a lower number? How well does vertical scrolling via mouse wheel work in other applications? Kind regards, Greg Feneis (Pixel 3) On Fri, Nov 22, 2019, 10:54 boldstripe wrote: > Forgot to say this is on Debian Buster (10) and Gnucash 3.7. > > > > -- > 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. > ___ 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] How to assign a pre-existing payment to a bill?
What about right click transaction and select assign as payment? Kind regards, Greg Feneis (Pixel 3) On Mon, Nov 18, 2019, 06:14 Fran_3 via gnucash-user < gnucash-user@gnucash.org> wrote: > How can I assign a recorded Payment in gnuCash written to a vendor... > As a payment for the Bill that was posted after the payment was made? > Must I delete the deposit/payment and then re-create it as a payment for > that particular Bill or what? > > Also... > How can I assign a pre-existing deposit in gnuCash as a payment for a > specific Invoice for CustomerX? > Must I delete the deposit and re-create it as a payment for that invoice > or what? > Thanks for any help. > Fran3 > > > > > > > > ___ > 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] Archiving transactions
It seems like there used to be an option to encrypt, or zip the working file when it's the default xml type. If that's still an option, and is enabled, it could cause a delay relative to the file size Kind regards, Greg Feneis (Pixel 3) On Sun, Nov 17, 2019, 17:49 M. Rizwan Muzzammil wrote: > Thanks for your replyI am using the default file types. Does it make a > difference if I change? > If so to what other type and how can it be done? > > > > ___ 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] Schedule Transaction Shows Entered but is not?
There are controls in the view menu that limit what transactions are viewable when a particular account is open for view. Perhaps confirm these controls aren't limiting what transactions can appear in the list. Kind regards, Greg Feneis On Thu, Nov 14, 2019 at 9:19 AM Jack Slater wrote: > I can see the transaction listed in Scheduled Transactions - dated 11/08. > But its NOT listed in the Checking Account registry! > How does that happen? > And how to I get it entered - even though it shows as being done? > ___ > 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] How to compare 2 Transaction Reports to find orphan transactions
If the reports you're interested in comparing are text based, and your computer's OS allows you to use Notepad++, you might consider using Notepad++ to compare the two files. Notepad++ is a free open source text editor that has a great file comparison tool. Kind regards, Greg Feneis On Sat, Nov 9, 2019 at 7:41 AM Christopher Lam wrote: > Hi Fran > > You've stumbled upon a limitation SFX of regular expressions on filtering > the transaction report. > > You may be aware that the transaction report was, for many years, the most > versatile report to extract information from a Gnucash data file. It had > severe limitations and bugs and > > On Sat, 9 Nov 2019, 22:55 Fran_3 via gnucash-user, < > gnucash-user@gnucash.org> > wrote: > > > I want to compare Transaction Report A to Transaction Report B > > and find transactions that appear on one report but not on the other... > > aka orphan transactions > > In past I have either... > > - Done a screen capture of each, pasted them side by side in PC Paint and > > marked off matching transactions one by one... > > - Or printed them out and done the same with pen & paper > > - Or exported the reports and then imported them into a spreadsheet and > > marked matching transactions one by one > > All of this is a bunch of work... > > > > Is there an easier way? > > Thanks for any help - Fran3 > > > > ___ > > 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. > ___ 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] Website Down
OK, but don't forget, this is an entirely volunteer operation. If there's a feature you want in the program, you can volunteer to program it. If you would like a more reliable website you're welcome to chip in for more servers, or some other fashion of redundancy. In general, if you've got resources to share to make Gnu Cash better in some way, please feel free to share. Even money. GnuCash.org does take donations of money too. Although, you might have to wait until the website is back up to see how to donate. ;-) Kind regards, Greg Feneis <http://www.linkedin.com/in/electromechanical> On Fri, Nov 8, 2019 at 7:06 PM Dean Bradley wrote: > OK, thanks. Unfortunately, this multi-day outage does not give a warm and > fuzzy to the new potential convert from Quicken to GnuCash (me). > > Regards, > ~dean~ > > > On November 8, 2019 at 8:14 PM Greg Feneis wrote: > > > > > > Yep, still down. See: > > > > https://downforeveryoneorjustme.com/gnucash.org > > > > > > > > Kind regards, Greg Feneis > > (Pixel 3) > > > > > > On Fri, Nov 8, 2019, 16:53 Dean Bradley wrote: > > > > > Is the site still down? I cannot access it, so I'm guessing it is. Is > > > there an updated ETA? > > > > > > Regards, > > > ~dean~ > > > > > > > On November 5, 2019 at 11:53 AM John Ralls > wrote: > > > > > > > > > > > > Linas reports that https://www.gnucash.org is down with a hardware > > > failure. He'll try to get it working on a secondary server today; > failing > > > that the replacement hardware is due in a day or three. > > > > > > > > Regards, > > > > John Ralls > > > > > > > > ___ > > > > 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. > > > > > ___ > > 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] register column sizes
Typically, double click on the header of each column except the description column first, then do the description column. Kind regards, Greg Feneis (Pixel 3) On Sun, Oct 20, 2019, 14:19 David Carlson wrote: > James, > > I would suggest closing that particular account register tab, then > re-opening it, either by starting from another register that has a transfer > to that account or starting from the chart of accounts. That should > restore at least a minimal width for each column. If your display settings > and overall window and font sizes are reasonable, then double click on the > column titles to get reasonable widths. > > It would be useful to know your OS and the specific GnuCash release, in > case it is an issue that may still exist in the current release. > > David Carlson > > On Sun, Oct 20, 2019 at 12:27 PM James Gill via gnucash-user < > gnucash-user@gnucash.org> wrote: > > > I foolishly attempted to adjust the column widths on the right size. They > > kept getting smaller and smaller until they were gone. Now I have R, > > Deposit and Balance. > > How do I get those other columns back? Are there default sizes to return > > to? Perhaps a default register layout? > > > > Any help 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. > > > > > -- > 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. > ___ 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] Applying Pre-Payments to a Bill
I'm not seeing the dashes on blank lines. #FOMO Kind regards, Greg Feneis <http://www.linkedin.com/in/electromechanical> On Tue, Oct 15, 2019 at 5:18 PM Fran_3 via gnucash-user < gnucash-user@gnucash.org> wrote: > For Vendor X the Monthly Bill is $10.00- > But the Monthly Payment has been $13.00- > After 5 months of Bills and 4 months of Payments we go to pay the $10 Bill > #5 and see four PrePayments listed at $3.00 each-We click Bill #5 and > Control Click the four PrePayments in order to apply the $12 worth of > PrePayments to Bill #5.-Now Clicking Business > Vendor > Find Bill for > Vendor X we see all five Bills marked as Paid.-Now we get the next months > Bill and Post it and go to Pay it... expecting to see the $2.00 un-applied > remainder of the PrePayments listed...-But the $2.00 un-applied PrePayment > remainder does not appear as available...-So, how do we apply the $2.00 > PrePayment remainder to the $10.00 Bill number 6?-I would think any > "remainder" of applied PrePayments would still appear as a PrePayment when > you go to pay a Bill.-Thanks for any help.-PS - Pardon all the dashes on > blank lines but I'm trying to find out how to force line breaks so > formatting can be retained. (I wonder if the html line break tag would work? > > > > > ___ > 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] Job and Invoice
Sounds like you're on the right track. For each association member (customer), create an invoice. Let an item on the invoice be some description, like Annual Dues, or Quarterly dues or Monthly dues, assign that item a value and press the enter key. GnuCash will remember the item description and amount and when you begin to type it, it will predictively complete. Whereas if you use a specific item description EG "Douglas Adam's quarterly dues", you wouldn't benefit from the memorized items as much. GnuCash let's you print your invoices to PDF, so you could generate E-invoices that you can email, if that's easier. Once you receive payment, use the Pay Invoice function to record reception of the money. Kind regards, Greg Feneis On Sat, Oct 12, 2019 at 10:40 AM Patrick Walker wrote: > Just installed GNUCash in hopes of managing finances for my Home Owners > Association. We have 218 homes which I set up as customers. we now wish to > issue invoices for a reserve fund we are creating. Total due is $48 per > home, payable at either six, twelve, or a one time intervals, of which each > home has pre-elected their pay terms upon submitting their commitment > letter. My thought is to create a "Job" for the $48 billing, then create > terms of semiannual, annual or one time payment. > First, am I on the right path? Second , do I print each invoice or can I > bulk print all semiannual, then all annual, then all one time payment > invoices? > Thank you in advance! > Patrick > > > Sent from Mail for Windows 10 > > ___ > 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] Using Gnucash for a church; keeping track of contributions
Perhaps you could use GnuCash's business elements, where you can set up customers and jobs, and receive payments for various jobs. I'm thinking for your church, the church would be the customer, and you could set up various church projects as jobs. Church budget could be one job, a particular mission could be another job, a special project could be thought of as another job. When a payment is received, the bookkeeper generates an invoice against what job (church project) the payment is for and be sure to make the line item(s)' descriptions in the invoice "donation", then immediately use GnuCash's pay invoice function to record the receipt of the money. If the church is a non-profit organization, perhaps print the invoice, mark it paid and mail it to the donor in case they track their donations for tax purposes. The issue with this is that it's a little tricky to apply a single check payment to multiple jobs. I've read about this being an issue in the recent past. I'm not an accountant and this is not professional accounting advice. Just an idea of a direction you could take. Kind regards, Greg Feneis On Sun, Sep 29, 2019 at 6:37 AM Eric H. Bowen via gnucash-user < gnucash-user@gnucash.org> wrote: > I've been using Gnucash for my personal books for a year now so I've > started to become somewhat familiar with it; now I'm wanting to > recommend it to our small church (we're still keeping books by hand). > Expenses is not a problem; our manual chart of accounts fits in very > nicely with the structure of Gnucash. My challenge is on the other end: > Contributions. We typically get members who will contribute, say, $100 > to the church budget, $50 to a missions offering, and $10 to some > special project on one $160 check, and these checks are then deposited > as one lump into the bank the next business day. > > I do get the use of split transactions, just not exactly sure as how to > best structure them in order to keep track of each member's individual > contributions, both undesignated and designated, while at the same time > minimizing the workload of the finance committee...for many of whom > "high-tech" means a mechanical pencil! > > Oh, while I'm thinking about it...our church participates in the > "cooperative program", where we pledge a percentage of our undesignated > receipts to denominational causes, which is then paid quarterly or so. > Works similar to the "sales tax payable" liability account I have set up > for my personal video business. I'm asking for suggestions to "automate" > the tracking of these percentage amounts, again in order to minimize > workload. > > -- > > Eric H. Bowen > e...@ehbowen.net <mailto:e...@ehbowen.net> > ___ > 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] Transactions Associations
It's possible that when you first started importing this data, GnuCash didn't initially recognize the source of the data so you needed to tell it which GnuCash account to import the data to. At this point, you may have selected a sub account of the account you actually wanted. Once GnuCash learns what account receives what imported data source, I don't know how that can be changed. I think another member here faces a similar situation, only in their case, Gnucash incorrectly recognized a new account's import data as belonging to an established GnuCash account, so GnuCash denied them the opportunity to steer the new account's data to the new GnuCash account established for it. Kind regards, Greg Feneis <http://www.linkedin.com/in/electromechanical> On Wed, Sep 25, 2019 at 8:30 PM Joseph G. Keithley, III via gnucash-user < gnucash-user@gnucash.org> wrote: > Thanks Dave. > > I tried all the clicking I could think of and the only one that did > anything was when I selected the "R" box on the import screen for an item > and then double clicked on that row. A window titled "Select Matching > Existing Transaction" and the bottom part of that window labeled "Potential > Splits..." was blank. > > I downloaded your guide, I will give it a read. > > > iii > > > > > > > > > On Thursday, September 26, 2019, 2:16:18 AM UTC, David Cousens < > davidcous...@bigpond.com> wrote: > > > > > > Transaction associations are not formed automatically on imported data. > > The purpose of the feature is to associate an external file such as an > image > or pdf file of a receipt or invoice or other documentation to a transaction > entry in GnuCash so that if you need to view it, it can be opened from > within Gnucash. > > If by Transaction Associstaions you are referring to the assignment of a > transfer account in the window called the Generic Import Matcher, this is > not done from the menu. The documentation is in the process of being > rewritten and updated at the moment and the current documentation is not as > clear as I wold like. > > Generally single left clicking on a row in the import matcher will select > it. Ctrl-left click will add to the selection. Double clicking on the row > will either bring up a dialog to examine the match if a row is not to be > imported or if it is marked for import it will bring up the dialog to > assign > the account for a second split. > > The following is a link to the help manual under development in a shared > folder on my dropbox. It is still under development but the section on > importing transactions in the chapter on transactions may help you. It > hasn't been fully reviewedand accepted by the documentation team at this > stage. If you do use it I would certainly appreciate any feedback on > clarity > and anything which doesn't work as described. > > To use it paste the following link into a browser, look for the file > help.html in the folder the webpage opens at and doubleclick on it. This > should give you the help manual index on the page. The importing is > discussed towards the end of chapter 6. > > https://www.dropbox.com/sh/dqvn0owqleud2g3/AACsnyg0W-3Qbb4UcddTP6ATa?dl=0 > > 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. > ___ > 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] Has the Android APP abandoned?
Perhaps there is a FOSS GUI platform similar to GTK that includes all of the usual target OSes plus Android? Kind regards, Greg Feneis <http://www.linkedin.com/in/electromechanical> On Thu, Sep 19, 2019 at 1:08 AM Andrea Briganti wrote: > You hit the main point of my initial post. > > Who visit the website believes that it is the official android application > and that it's maintained currently. > > If the community can't (won't) take the ownership of the app, I think that > we have just to remove the banner in the homepage. > > > > Returning to the bit that said the gnucash website is promoting the > > android > > app - considering the android app seems to be abandoned, should we remove > > the > > reference from our website or at least indicate it's currently > > unmaintained ? > > > > > -- > | / > | \Byte - Andrea Briganti > Blog: http://kbyte.snowpenguin.org > ___ > 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] U.S. Small Biz Question: Keeping Original Printed FI Statements
Hi Folks, I started a sole proprietorship in the US in 1997. Based on my best understanding of advice I got back then, I've always kept/stored paper financial statements, cash receipts, etc. in case a taxing entity audits me. If any of you in the US has been audited recently, and don't mind writing about it, did they require everything be printed on paper for them to look at? Did they require everything be the originally printed paper item issued by the financial institution or actual receipt from the vendor, etc.? I'd really like to switch to digital storage of things (paperless as the FI's like to promote to me, nearly to the point of harassment), and I suppose I could print stored documents, whether PDF from the financial institution's web site or scanned invoice or receipt from a vendor, if required, when and if I ever actually get audited. Digital storage would allow me to reference various items directly from transactions in GnuCash, which would be very handy. You're thoughts are appreciated. Kind regards, Greg Feneis ___ 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] Assign one payment to multiple invoices (from several customers)
On Wed, Sep 11, 2019, 12:39 Derek Atkins wrote: > Hi, > > Bat writes: > > > Hi > > > > this is a subject that appears regularly on the mailing list, but I > > can not find fine answer neither plan to improve the situation. > > Um, no, it does not appear regularly. Indeed, this is the first time in > 19 years that someone has asked about paying invoices for multiple > customers with a single payment. > > > > I've only been on this list a few years, and seems like this has been mentioned before, perhaps not regularly Kind regards, Greg Feneis (Pixel 3) > ___ 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] Newbie Q: match Description to Transfer
Perhaps, before importing, add a "Groceries" sub account to your expenses account. Then, instead of importing the entire checking account from your bank, just import a month's worth of records or so. In the matcher step, assign transfer accounts accordingly. Then import the remaining records for that checking account from your bank. This lets you teach GnuCash how to assign, at first, then on the second import, GnuCash does most of the work on the majority of the records. Kind regards, Greg Feneis (Pixel 3) On Tue, Sep 3, 2019, 18:20 David Carlson wrote: > Welcome to GnuCash and to the GnuCash-User Maillist. > > GnuCash is set by default to "remember" the transfer account assignment and > to attempt to make the same assignment to similar looking transactions in > future imports. It uses a process called Bayesian Matching, which is not > perfect, but it usually makes pretty good guesses after a training process. > > When you import transactions there is a step where you assign a "transfer" > account to each transaction or, after the first time, you approve GnuCash's > guess or override it with your correct information. If you do not make > corrections in that step, GnuCash cannot "learn" the correct assignments, > and it may even make more "misteaks" later. > > David Carlson > > On Tue, Sep 3, 2019 at 5:24 PM Bitmancer > wrote: > > > Just starting out to use GnuCash. Imports fine from my bank to my > Checking > > account. > > Now I have to make sense of it all! > > > > In the Checking ledger, there are many different creditors. For example, > > "Kroger" in the Description field. How can I label all "Kroger" entries > > with > > "Expenses:Groceries" in the Transfer column? If I can make this happen, I > > can do all my repetitive transactions and catch up on 8 months of data > > faster. > > > > > > > > -- > > 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. > > > > > -- > 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. > ___ 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] Bookkeeping for a club's charity account - use business features?
Michael, I use GnuCash for my cash business and don't have any trouble with it. I think the only trouble you may have is with report generation. Kind regards, Greg Feneis (Pixel 3) On Mon, Aug 26, 2019, 01:46 Michael Hendry wrote: > > On 25 Aug 2019, at 15:55, Mike or Penny Novack < > stepbystepf...@comcast.net> wrote: > > > > On 8/25/2019 3:25 AM, Michael Hendry wrote: > > > > First (and an important question) > >Is your organization om the cash or accrual basis? You should always > state that. > > Cash. > > > The business features of gnucash only work for accrual. > > In that case, my question in the subject line is answered, in the > negative! > > > And I see that your organization does pledges. Here in the US, pledges > ARE receivable,but only according to the terms of the pledge << thus if a > person pledged X a year for five years, only the X for the current year due > NOW >> So pledge accounting will require extra work unless all your pledges > are simple, immediate pledges. > > Volunteering to be a paying guest at a “Foundation Dinner” is the only > undertaking that fits into the definition of a pledge, but I can see that > setting up an invoice for it would make it “receivable”, and have a > lifetime that went beyond the financial year’s end. > > But if I avoided setting up invoices for this particular fundraising > activity, could I use the Business Features to record income from a each > member (“Customer”) as it arises? > > > > > But you can easily have a second set of books to keep and report on "by > member" stuff, and if using the business features, can invoice. > > That’s a method I hadn’t thought of, and will look into. There’s the > obvious risk of these two sets of books getting out of step. > > > Note though that at least in the US "membership dies" are not really > receivables < organization at any time -- organizational rules about "demits", etc. apply > only if you want to rejoin>> However many organizations even cash basis > [prefer being able to send out "statements" (invoices to members) > > > > Notice that I misunderstood.What I was suggesting was if you had to > supply to the government the CORRECT member name for the donations, not > just that it had to be SOME member's name. The latter is of course far > simpler in terms of record keeping << I was picturing the former because > possibly there were by person limits >> > > From the point of view of the annual report to OSCR (the charity > regulator) there is no need for detailed reporting of income - see > https://www.oscr.org.uk/media/1800/2015-01-27-example-accounts-scio.pdf - > but the annual claim for Gift Aid requires the total contributed per annum > by each individual member. The 25% boost that Gift Aid covers is the reason > why most Rotary Clubs in the UK set up charities which operate “at > arms-length” from the clubs themselves but whose trustees are club > officers. > > > > > Michael > > > > PS: I do NOT attempt to get gnucash to produce reports in their final > form. Easier to export full reports and then copy into a document that gets > edited to remove extraneous detail, insert annotations, etc. > > > > The way I’ve set up the accounts may need review, as I’m going to require > a lot of individual searches to isolate contributions from individual > members. > > I think I need to remove a tier and identify the intended destination of > the income using a tag in a searchable field. > > Income:Destination1:MemberA … MemberN > Income:Destination2:MemberA … MemberN > … > Income:DestinationX:MemberA … MemberN > > - a total of X * N accounts. > > > Becomes > > Income:Donations:MemberA … MemberN, with Destinations 1…X recorded in the > Description field of each transaction. > > - a total of N accounts. > > Thanks for your continued interest and support, > > Michael > > > ___ > 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] Printer woes
James, the typical flow in GnuCash and similar programs is that the chart of accounts and various account registers and other things aren't considered documents, so you can't directly print them. Instead, you "run a report". That report is more like a document. If a report is satisfactory, you can print it, or save as a .PDF. The icons along the top of the GnuCash window will change depending on what tab is currently selected. They are context specific. When I click on Accounts tab, the toolbar only shows 6 icons (none of them are about printing). When I'm viewing a checking register, a different set of icons appear, 12 in total (still no printer icon). When I view an invoice, or report, a printer icon is shown. I'm pretty sure you'll see that printer icon, you just need to run a report first. Kind regards, Greg Feneis <http://www.linkedin.com/in/electromechanical> On Sun, Aug 18, 2019 at 4:02 AM David Cousens wrote: > James, > > Can't remember ever seeing a print option for the register window.It might > have existed befor the transaction report was created. The best way to > getsuch a report for a specific account is to use the transaction report , > set the account to the account you desire and set the date range for the > dates required.If you require a running balance select the appropriate > options in the Edit->Report Options menu items. If you use it frequently > save a custom copy (Save Config button). It has a print button in the > toolbar to print it out and you can export it as a html file > > Cheers > 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. > ___ 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] Problems moving vertical lines between columns on registers
You can also double click the column headers of all but the description column. Last, double click the header for the description column. This automatically sets the columns' widths to just the minimum needed to display the contents of the fields, except the description column. Description column automatically adjusts to normalize the page width. Kind regards, Greg Feneis (Pixel 3) On Mon, Aug 12, 2019, 18:30 James Fuller wrote: > > David, > thanks very much. after some cut and try I got what I Need. > I appreciate the help. > Regards, > James > > > On 8/12/2019 6:09 PM, David Carlson wrote: > > James, > > > > Keep in mind that in the register view the description column is a > > special case that essentially defaults to use all the space that is > > not explicitly given to other columns. > > > > This means setting the other widths first, then dragging the right > > edge of the description column title box leftward and letting it snap > > back until there is no horizontal scrollbar at the bottom. > > > > Of course, this can get awkward for users that run the program on > > computers with different display and font settings. Since those > > settings are defined as user settings, different computers normally > > each keep their own settings, but if one accesses the program remotely > > via ssh, for example, it can still get very interesting. > > > > David Carlson > > > > On Mon, Aug 12, 2019 at 6:15 PM James Fuller > <mailto:ja...@plateautel.net>> wrote: > > > > > > Hi Guys, > > > > I'm having a problem figuring out how to move the vertical lines > > defining columns on registers. I seem to remember that you place a > > mouse cursor on the vertical line, hold down the right mouse > > button, and > > move left or right to change the width of of the columns. When I do > > that, the vertical line moves with my mouse. When I let go of the > > right > > button the line zips back. > > > > I'm using 3.2 Gnucash on a Windows 7 HP desktop. What am I doing > > wrong? BTW, I have read the Help Manual until I'm blue in the > > face and > > can't find it. > > > > Thank you > > > > James Fuller > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org <mailto: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. > ___ 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] gnucash-user Digest, Vol 197, Issue 15
Bob, Adrien has it right. See below. Just a few notes You can test by saving your GnuCash working file on computer 1 as with some easy to find specific name in that computer's dropbox folder. Before you stop using computer 1, check the Dropbox icon in the notification area (assuming Windows). It should either indicate that syncing is complete, or that it's still trying to sync. Don't shut down computer 1 until sync is finished ;-) To confirm the file was synced on computer 1, the icon in the notification area should also have an option like visit Dropbox.com. Click that (browser opens...) and navigate to the file. If it's not there, then it didn't sync. In the same icon, you can stop synching, then start synching. Dropbox will check the Dropbox folder on the computer and make sure it is synced with the cloud. At computer 2, you can check the Dropbox icon in the tray, if it says synching is complete, the file should be in the Dropbox folder. If not, you can stop synching on computer 2 and then start it synching again. It usually doesn't take this much micromanaging, but this is how you can do it if needed Kind regards, Greg Feneis (Pixel 3) On Thu, Aug 8, 2019, 11:30 Adrien Monteleone wrote: > I haven’t used Dropbox in some time, but as I recall, you could access it > directly or you could sync local folders to it. > > I’d think the local folder sync would be the best route for GnuCash. That > way, each computer is writing to the local file system. This will improve > save speed, remove occasion of network hiccups during the save, and > avoiding any issues with GnuCash accessing remote file paths. > > So re-save the file on computer 1 in a folder on computer 1, then sync > that folder to Dropbox. > > On computer 2, link the synced folder on Dropbox to a similarly named > folder. > > When you save on computer 1, it will save locally, then sync to cloud. > > When you open computer 2, it will sync from cloud and then GnuCash will > open locally. > > When you save on computer 2, the same process will happen in reverse. > > Other still current users of GnuCash and Dropbox might have other/better > recommendations. > > Regards, > Adrien > > p.s. - when replying to a digest, please copy/paste the subject you are > replying to as your subject (rather than gnucash-user Digest, Vol 197, > Issue 15) and trim the quoted material to the relevant discussion, or if > starting a new topic, don’t use the reply button, use the compose/write/new > button and simply send the message to gnucash-user@gnucash.org, your > e-mail client will likely have this saved already for autocompletion. > > > On Aug 8, 2019, at 12:49 PM, Bob Sisk wrote: > > > > I thought I understood how to do this but I am confused - trying to run > Gnucash on second computer and having access to the same data file. I > thought I was keeping my data file on Dropbox - that is the one I open and > enter data. When I go to secondary computer and open Gnucash the file has > not been updated. Should I click “save as” and direct to Dropbox when > closing the program and then navigating to that file in Dropbox and opening > it? Is there a way to auto sync the data file to both computers? Or is > there a totally different and better approach to do this? Help appreciated. > > > > Robert L Sisk > > sisk@gmail.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 > 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] Proposed change of "U+R" and "R" in the Import main matcher.
Not an opinion on the reconciliation controls, but if the matcher module is getting some love, would be neat™ if either the record description, or memo (or both) could be edited while the pending records are displayed on the matcher window. When I get home, I'll search for the appropriate enhancement/bug request to reference. Kind regards, Greg Feneis (Pixel 3) On Tue, Aug 6, 2019, 07:23 Ken Schneider wrote: > On 8/6/19 6:59 AM, Fross, Michael wrote: > > I agree as well. This was confusing to me when I started. > > > > I also think instead of putting a “Y” in the reconciled column in the > > register, I would put a “R”. > > > > Michael > > > > I agree with the 'R' as well. > > Ken Schneider > > ___ > 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] Help with Export
It could be a permissions issue like Christopher Lam wrote. I just played around with the Export dialog on GnuCash 2.6.21 on Win 7 64. It appears GnuCash knows what extension to give the file based on the Data Format selection at the top of the dialog box. Mine was at .xml by default. I just tried to do a test save of my accounts' exports to C:\ (which win 7 doesn't allow), and it failed silently. Tried it again and same result. James Fuller, if you're using Win 10, it's possible that if you're attempting to save to C:\ Windows 10 isn't allowing it, and if you're using GnuCash 3.x, it's based on GTK3 (sp?) so it's not failing silently like my older version did, but it's not really giving you an appropriate error message either. It should be something like "saving in reserved location is forbidden" If so, you're going to want to select a place to store the accounts export file that's not at the very root of the hard drive. That is, not C:\. However, some folder on C:\ is OK. There's usually a folder where Windows computers encourage users to store their files, like C:\Users\James (replace James with whatever the user's name is.) Try saving there. Or, C:\Users\James\Desktop Kind regards, Greg Feneis On Sun, Jul 28, 2019 at 5:06 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > I’m on a Mac, which doesn’t care about file extensions, but perhaps that > is what Windows was complaining about. Despite the fact that the export is > CSV (with custom delimiter) it saved it without an extension. If the > Windows build does the same, this might be the cause of the error. > > Try giving your file a “.csv” extension. > > Regards, > Adrien > > > On Jul 28, 2019, at 6:43 PM, James Fuller wrote: > > > > Hi, > > > > I'm trying to export my chart of accounts so that I can start a new set > of books. After opening Gnucash I move to the File drop down menu. then > choosing Export I get a screen that offers options. I choose export > accounts. A screen pops up that wants ( i think ) the name of the file to > be saved. In this case I'm using the name ' CruzersGnu19 '. I then select > C: for the drive. when I accept Save As, I get an error message that says > > > > " there was an error saving the file" "invalid argument" Obviously I'm > doing something wrong, but I can't see what. Any help would be > appreciated. > > > > James Fuller > > > > ps. I'm accustomed to using apple Ipads. I do a much better job of > communicating on them. Grrr. Microsoft. > > > > ___ > 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] Match transaction accounts better?
While the matcher is displaying your records, click on a record to correct it. This is how the matcher learns how to match better. It's a statistical matching algorithm I believe, so you correcting one incorrectly matched record won't always immediately fix a matching error tendency. Just keep correcting consistently and the matcher should catch on. Kind regards, Greg Feneis <http://www.linkedin.com/in/electromechanical> On Sat, Jul 20, 2019 at 10:08 AM . wrote: >How can I get GC to better recognize which accounts certain >transactions belong too. > >For example; Giant Supermarket should always have the account "Food" >matched to it. However, when importing a QFX file into GC it matches >this to "imbalanced". > >What should I do? > >Thanks > >Carl W. > ___ > 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] Email inbox clutter (was Column Detection when Imp...)
Patrick, all, If you use Gmail and its web interface through a browser, you can make use of Gmail's labels (similar to folders) and Gmail's filtering rules (see settings) to make this list's emails have a label like "GnuCash Users" , and not have the usual inbox label. It has the effect of aggregating this list's emails into a single place and have them not appear to pepper your usual inbox content with sources of distraction. This sorting/labeling paradigm appears and works nicely in the Gmail mobile app too. You only have to use the browser interface to set it up. HTH Kind regards, Greg Feneis (Pixel 3) On Wed, Jul 10, 2019, 07:18 Patrick wrote: > Sorry, I just saw this response. (I had unsubsribed to try to reduce > flow into inbox, and I just saw it when I was going back through the > archives. I will turn digest back on.) > > Thank you for this additional helpful information. > > 73, > Patrick > ag4jq > > On 6/26/19 12:31 PM, Patrick wrote: > >* When importing transactions from a CSV file, is there a way to have > GnuCash > *>* automatically detect the meaning of the columns based on the CSV > headers? > *>* The headers in my CSV file are "Date", "Description", "Account", etc., > so I > *>* was wondering if GnuCash had the ability to determine what the columns > were > *>* from these headers, so that I don't have to select them from the > dropdown > *>* menus every time I do an import. > *>>* Regards, > *>* Patrick > * > > The screen where you pick these has a field at the very top where you > can name this setup and then save it. > > You will have to select this name on the next import but it will remember: > > * The field assignments > > * The account into which you are doing the import > > * The date format > > * How many lines to skip > > It was a big help when I discovered that! > > --Steve > > > -- > Stephen M Butler, PMP, PSMStephen.M.Butler51 at gmail.com > <https://lists.gnucash.org/mailman/listinfo/gnucash-user>kg7je at > arrl.net <https://lists.gnucash.org/mailman/listinfo/gnucash-user> > 253-350-0166 > --- > GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 > ___ > 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] Fwd: how to copy "Customers Overview" table for spreadsheet.
Seems like the following was meant for the OP. Kind regards, Greg Feneis (Pixel 3) -- Forwarded message - From: Date: Mon, Jul 8, 2019, 11:07 Subject: RE: [GNC] how to copy "Customers Overview" table for spreadsheet. To: Greg Feneis Have you tried highlighting the report contents and pasting into a spreadsheet? In Windows, I can run the Customer Summary report, press CTRL-A, CTRL-C , open a spreadsheet, and press CTRL-V. The results are reasonably sane. I haven't tried on a Mac recently, but ISTR that it worked in a similar fashion there. -Original Message- From: gnucash-user On Behalf Of Greg Feneis via gnucash-user Sent: Monday, July 8, 2019 11:22 PM To: Gnucash Users Subject: Re: [GNC] how to copy "Customers Overview" table for spreadsheet. Perhaps you could use the print function to produce a *.PDF of it, then view it in a PDF viewer, and copy the table (use mouse cursor to select text) from the PDF viewer? I've had limited success with copying tables from PDF documents (win 7, Adobe Reader to Word 2010 is typical) and pasting into other documents, but it could work. Perhaps you could even paste it into a spreadsheet app? Kind regards, Greg Feneis (Pixel 3) On Mon, Jul 8, 2019, 10:19 Jonathan Francoeur via gnucash-user < gnucash-user@gnucash.org> wrote: > I'd like to copy and paste the data from the "Customers Overview" > table into a spreadsheet. Any ideas how? > -- > "You are what you eat. Be your Landscape!" > <http://eeLandscaping.blogspot.com> > J <http://www.facebook.com/people/Jonathan-Brian-Francoeur/580595513 > >onathan > Brian Francoeur > <http://www.facebook.com/people/Jonathan-Brian-Francoeur/580595513> > Landscape design, consultations, creation and care < > https://docs.google.com/document/d/1lyjTLI4QVd_z-P6EPfxRqC22f6omfYt_Ye > JmeoJALIQ/edit?hl=en_US > > > Certified Horticultural Landscaper > < > http://www.hcp.bc.ca/index.php?option=com_content=article=53 > temid=60 > >, > Permaculture designer > <http://www.permaculture.org/nm/index.php/site/permaculture_design_cou > rse/ > >, > Sustainable gardener > <http://www.linnaeafarm.org/farm/show2s/Garden_Programme> and Organic > Master Gardener > <http://www.gaiacollege.ca/organic-master-gardener-course.html>. > goedi...@gmail.com tel: (250) 642-0267 eeLandscaping.blogspot.com > <http://eelandscaping.blogspot.com> > 6411 Sooke Rd., Sooke, B.C., Canada, V9Z-0A8 < > https://www.google.ca/maps/place/Everything+Edible+Landscaping,+6411+S > ooke+Rd > .,+Sooke,+BC+V9Z+0A8/@48.3819275,-123.708261,13z/data=!4m2!3m1!1s0x548 > f056f06cbad49:0xddc41f6f5e57feb> > ___ > 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. ___ 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] how to copy "Customers Overview" table for spreadsheet.
Perhaps you could use the print function to produce a *.PDF of it, then view it in a PDF viewer, and copy the table (use mouse cursor to select text) from the PDF viewer? I've had limited success with copying tables from PDF documents (win 7, Adobe Reader to Word 2010 is typical) and pasting into other documents, but it could work. Perhaps you could even paste it into a spreadsheet app? Kind regards, Greg Feneis (Pixel 3) On Mon, Jul 8, 2019, 10:19 Jonathan Francoeur via gnucash-user < gnucash-user@gnucash.org> wrote: > I'd like to copy and paste the data from the "Customers Overview" table > into a spreadsheet. Any ideas how? > -- > "You are what you eat. Be your Landscape!" > <http://eeLandscaping.blogspot.com> > J <http://www.facebook.com/people/Jonathan-Brian-Francoeur/580595513 > >onathan > Brian Francoeur > <http://www.facebook.com/people/Jonathan-Brian-Francoeur/580595513> > Landscape design, consultations, creation and care > < > https://docs.google.com/document/d/1lyjTLI4QVd_z-P6EPfxRqC22f6omfYt_YeJmeoJALIQ/edit?hl=en_US > > > Certified Horticultural Landscaper > < > http://www.hcp.bc.ca/index.php?option=com_content=article=53=60 > >, > Permaculture designer > <http://www.permaculture.org/nm/index.php/site/permaculture_design_course/ > >, > Sustainable gardener > <http://www.linnaeafarm.org/farm/show2s/Garden_Programme> and Organic > Master Gardener > <http://www.gaiacollege.ca/organic-master-gardener-course.html>. > goedi...@gmail.com tel: (250) 642-0267 > eeLandscaping.blogspot.com <http://eelandscaping.blogspot.com> > 6411 Sooke Rd., Sooke, B.C., Canada, V9Z-0A8 > < > https://www.google.ca/maps/place/Everything+Edible+Landscaping,+6411+Sooke+Rd > .,+Sooke,+BC+V9Z+0A8/@48.3819275,-123.708261,13z/data=!4m2!3m1!1s0x548f056f06cbad49:0xddc41f6f5e57feb> > ___ > 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] delete multiple transactions? csv import profiles?
Hi Mark, I think a recent rev of GnuCash does allow the user to save the CSV import settings. To cover yourself for mistakenly importing a large number of transactions, consider practicing checkpointing for your working file. Or, at the least, save before import, and don't save if the import goes wrong. Perhaps a nice future feature would be some sort of undo import feature. Kind regards, Greg Feneis (Pixel 3) On Mon, Jul 1, 2019, 04:01 Mark Van den Borre wrote: > Hello list! > > Here's two questions that have come up when trying to somewhat > automate processing my bank transactions using gnucash. I had a look > for the answers online, but couldn't really find any recent ones. > > * Can I delete multiple transactions at once? I messed up an import > and painstakingly removed 100 transactions by hand... > * Can I save a csv import profile including the csv column to gnucash > field mappings? Right now, it seems like I have to set these > parameters every time I import a csv exported from my bank. > > Thank you for your work on gnucash! Much appreciated! > > Kind regards, > > Mark > ___ > 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] GnuCash and OSX.15
On Wed, Jun 26, 2019, 07:06 Alan Magnus via gnucash-user < gnucash-user@gnucash.org> wrote: > I am running the new beta version of OSX v15 on a Mac. Since installation, > Gnucash will not run saying my file cannot be found. Seems more likely that GnuCash is running, but cannot find your working file. I have tried selecting files directly and trying to open them. No luck. There is a known issue on Macs, where GnuCash always tries to open the last file that it worked with. Often, Mac users report clicking on a working file, and GnuCash starts and opens a different file, or GnuCash starts and cannot find the file, even though the user just clicked on it. > Any ideas of what the problem is? > After GnuCash starts clear/acknowledge any error messages, and from the main menu, select file>open, and then navigate to the file you want to open. When you do this, GnuCash will ask you if you want to save the current file (a default file it opens when it cannot find the file it wanted to). You shouldn't need to bother saving it. Good luck! > > Alan Magnus > Kingston, Jamaica > Caribbean > alanmag...@flowja.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 > 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] CSV to QIF for Citibank
No need to edit OFX, or QFX files. GnuCash's import facility already knows how to interpret the files. Kind regards, Greg Feneis (Pixel 3) On Mon, Jun 17, 2019, 11:12 Michael DeBusk wrote: > On Mon, Jun 17, 2019 at 1:55 PM Greg Feneis wrote: > >> With no rational explanation, over the years I have tended to favor OFX >> (perhaps because it's an open standard), and QFX (I think QuickBooks' >> proprietary variation on OFX, because I used to use QuickBooks?) Anyway, >> QFX and OFX is what I've been importing into GnuCash for the last several >> years. >> > > I've tried to figure out OFX and found it too complicated. I don't know > how to edit it. > > -- > Home: http://nlphilia.com * Blog: http://nlphilia.net > Registered Linux User #450983 * Ubuntu Counter Project #10548 > ___ 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] CSV to QIF for Citibank
With no rational explanation, over the years I have tended to favor OFX (perhaps because it's an open standard), and QFX (I think QuickBooks' proprietary variation on OFX, because I used to use QuickBooks?) Anyway, QFX and OFX is what I've been importing into GnuCash for the last several years. But I do enjoy a good challenge now and then, so I can also understand the desire to write a file conversion script. Kind regards, Greg Feneis (Pixel 3) On Mon, Jun 17, 2019, 10:13 Michael DeBusk wrote: > On Mon, Jun 17, 2019 at 12:49 PM Greg Feneis wrote: > > > Is it too late to download the records of interest in QFX or OFX format? > > GnuCash will import these formats as well. > > > > It's not too late, but I never learned to appreciate QFX or OFX. > -- > Home: http://nlphilia.com * Blog: http://nlphilia.net > Registered Linux User #450983 * Ubuntu Counter Project #10548 > ___ > 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.
