Re: [GNC] Backup recovery
Yes, I appreciate the comment. In my original post I mentioned that I was testing out an app called backblaze, an automatic backup to the the cloud. I asked where and how I would find the GNU backups, since the folder where GNU stuff is saved is full of files, and would have been backed up by backblaze it its entirity.. I got the answer(s) and the link to the manual. It was only then that I discovered, after I asked another question about the file name, that I was working on another backup. I don't recall making one specifically but it was probably part of a 'general' HD backup. However, I have no idea how or when I restored it, if I ever did, I have not had any reason to restore any files. As you so rightly pointed out I may have fd up, thanks. I asked, in effect if the version that is in the backblaze app backup folder is a complete backup up to the 8 Feb, or is it just an update of the March 5 2018 file? If it is a 'catch-up' then is that ok? Sorry for any confusion, it is not deliberate. Thanks again, Finbar On 10/02/2019 16:23, David T. wrote: I don’t know. What is backblaze? Based on the info in the FAQ to which I referred, it appears that on Feb 8, 2019, you opened a backup copy of “GNU 5 Feb 2018”, which itself was made on March 5, 2018, made some changes, and saved from that backup. I don’t know your workflow or immediate purpose for doing that; in my situation, if I had opened a backup file from 11 months ago and made changes to that file which I then saved, I would most likely have f**ked up. YMMV. David On Feb 10, 2019, at 8:00 PM, Finbar Mahon wrote: Thanks for that, I probably did, but not (yet) in backblaze, does that matter? Finbar On 09/02/2019 12:59, D wrote: That file name indicates that you opened, and saved, a backup of your main data file. You might not have intended to do this. See https://wiki.gnucash.org/wiki/FAQ#Q:_Why_is_my_file_name_getting_longer_and_longer.3F David On February 9, 2019, at 5:15 PM, Finbar Mahon wrote: Thanks, I read the guide and was a bit confused when backblaze showed the most recent save was yesterday at 3.55pm but with two dates/times of - GNU 5 Feb 2018 .gnucash.20180305171639.gnucash.20190208155508.gnucash<< Is the second date from the left [20180305171639] the date the file was created originally, and the first one [GNU 5 Feb 2018] the file name ? Not critical as the backblaze file is the last save before I closed gnucash. Finbar On 08/02/2019 22:56, David Cousens wrote: Finbar, The directory with your data file will also contain log files and backup files. See https://www.gnucash.org/docs/v3/C/gnucash-guide/basics-backup1.html for details 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] Backup recovery
On Monday, 11 February 2019 09:10:30 GMT Finbar Mahon wrote: > that I was working on another backup. I don't recall making one > specifically but it was probably part of a 'general' HD backup. However, > I have no idea how or when I restored it, if I ever did, Finbar, re-read the GC info about backups & filenames. GC normally makes a backup each time you save the data file - and puts the timestamp numbers on the end of the "working" filename. It is one of these auto-backups that you opened (actually, a backup-of-a-backup, hence the 2x digit strings) not anything that you backed-up/restored external to GC. 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.
Re: [GNC] Backup recovery
OK, thanks. So, it is 'normal' to be using it? Finbar On 11/02/2019 10:28, Maf. King wrote: On Monday, 11 February 2019 09:10:30 GMT Finbar Mahon wrote: that I was working on another backup. I don't recall making one specifically but it was probably part of a 'general' HD backup. However, I have no idea how or when I restored it, if I ever did, Finbar, re-read the GC info about backups & filenames. GC normally makes a backup each time you save the data file - and puts the timestamp numbers on the end of the "working" filename. It is one of these auto-backups that you opened (actually, a backup-of-a-backup, hence the 2x digit strings) not anything that you backed-up/restored external to GC. 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.
Re: [GNC] Backup recovery
On Monday, 11 February 2019 10:35:30 GMT you wrote: > OK, thanks. So, it is 'normal' to be using it? > No, you risk data loss at the point of opening the backup. let me clarify. Your data file is called (for example) "mybooks.gnucash" All timestamps are made up (but plausible) you enter a transaction and save and quit. GC renames the old "mybooks.gnucash" to "mybooks.gnucsh.201901022345.gnucash" and saves the changes into a new file on disk called "mybooks.gnucash" you later open the backup (by mistake) and enter another transaction, save and quit again. GC creates the backup mybooks.gnucash.201901022345.gnucash. 201901081256.gnucash GC now has 3 files in the folder: mybooks.gnucash<-- has the 1st edit in it mybooks.gnucash.201901022345.gnucash <-- has the 2nd edit in it mybooks.gnucash.201901022345.gnucash.201901081256.gnucash <--no edits in it as you can see, by using a backup, you loose the previous edit session - go a few edits down the road and you can be in proper mess with transactions seeming to go missing from months ago! When Gnucash starts, it *normally* opens the file that was open when you shut down last time around, so it is fairly easy to get the wrong one by mistake if you've been digging in the folder. On Windows & Linux, you can make GC open with a different file by clicking... but not so on mac. No matter what file you try to open GC with, it WILL use the previous one. So if you've been looking at backups, on a Mac you NEED to File->Open once GC is running. 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.
[GNC] Version 3.4 Mac OS - intermittent fault with transaction editing popup
This came to my notice when trying to examine a number of Split Transactions. I selected the first transaction and right-clicked to bring up the menu, but when I clicked Split Transaction nothing happened. I tried one or two other transactions, and sometimes the popup menu options work and sometimes not. After trying other transactions the first one sometimes works, sometimes not. I haven’t been able to work out a way of producing this consistently. Is this a known issue? 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.
Re: [GNC] Backup recovery
Wow, this is getting (more) complicated - You said - [When Gnucash starts, it *normally* opens the file that was open when you shutdown last time around, so it is fairly easy to get the wrong one by mistake if you've been digging in the folder.] I just booted up GNUcash without any 'digging' and got - On the bottom of the screen. which follows your information, as the 'second' file? right ? so, I go to file>open and I get - etc., etc. None of which have the date that is on the open GNUcash file. Maybe it is one of the files marked 'wed'? but the dates don't match. So I look further down the list of files under file > open and I finally come to - The only file on these two grabs which fits your name criteria is the very first one above but the date is almost a year ago, and none of the others in the second grab seem to fit the criteria. :-( I am truly sorry for the long sequence of q&a but I am accustomed to assuming the file I last used opens again after I 'save' and 'quit' Thank you very much for your patience. Finbar On 11/02/2019 12:08, Maf. King wrote: On Monday, 11 February 2019 10:35:30 GMT you wrote: OK, thanks. So, it is 'normal' to be using it? No, you risk data loss at the point of opening the backup. let me clarify. Your data file is called (for example) "mybooks.gnucash" All timestamps are made up (but plausible) you enter a transaction and save and quit. GC renames the old "mybooks.gnucash" to "mybooks.gnucsh.201901022345.gnucash" and saves the changes into a new file on disk called "mybooks.gnucash" you later open the backup (by mistake) and enter another transaction, save and quit again. GC creates the backup mybooks.gnucash.201901022345.gnucash. 201901081256.gnucash GC now has 3 files in the folder: mybooks.gnucash<-- has the 1st edit in it mybooks.gnucash.201901022345.gnucash <-- has the 2nd edit in it mybooks.gnucash.201901022345.gnucash.201901081256.gnucash <--no edits in it as you can see, by using a backup, you loose the previous edit session - go a few edits down the road and you can be in proper mess with transactions seeming to go missing from months ago! When Gnucash starts, it *normally* opens the file that was open when you shut down last time around, so it is fairly easy to get the wrong one by mistake if you've been digging in the folder. On Windows & Linux, you can make GC open with a different file by clicking... but not so on mac. No matter what file you try to open GC with, it WILL use the previous one. So if you've been looking at backups, on a Mac you NEED to File->Open once GC is running. 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.
Re: [GNC] Backup recovery
I can't see the images you presumable posted for some reason, but I suspect what happened was that some time ago you, for some reason, opened one of the backup files (so whatever.gnucash.longdatestring.gnucash) and didn't then re-open or save as the original file name. Ever since then you have bee using that file as your working file so it has been making backup files with the the second timestamp added too. Thus it may well be that the file with the latest single date string is actually your latest data. As for your comment that you are used to applications opening the last used file, that is exactly what Gnucash has been doing. Colin On Mon, 11 Feb 2019 at 13:28, Finbar Mahon wrote: > > Wow, this is getting (more) complicated - > > You said - > > [When Gnucash starts, it *normally* opens the file that was open when > you shutdown last time around, > > so it is fairly easy to get the wrong one by mistake if you've been > digging in the folder.] > > I just booted up GNUcash without any 'digging' and got - > > On the bottom of the screen. > > which follows your information, as the 'second' file? right ? so, I go > to file>open and I get - > > etc., etc. None of which have the date that is on the open GNUcash file. > Maybe it is one of the files marked 'wed'? but the dates don't match. > > So I look further down the list of files under file > open and I finally > come to - > > The only file on these two grabs which fits your name criteria is the > very first one above but the date is almost a year ago, and none of the > others in the second grab seem to fit the criteria. > > :-( I am truly sorry for the long sequence of q&a but I am accustomed to > assuming the file I last used opens again after I 'save' and 'quit' > > Thank you very much for your patience. > > Finbar > > On 11/02/2019 12:08, Maf. King wrote: > > On Monday, 11 February 2019 10:35:30 GMT you wrote: > >> OK, thanks. So, it is 'normal' to be using it? > >> > > No, you risk data loss at the point of opening the backup. > > > > let me clarify. > > > > Your data file is called (for example) "mybooks.gnucash" All timestamps are > > made up (but plausible) > > > > you enter a transaction and save and quit. GC renames the old > > "mybooks.gnucash" to "mybooks.gnucsh.201901022345.gnucash" and saves the > > changes into a new file on disk called "mybooks.gnucash" > > > > you later open the backup (by mistake) and enter another transaction, save > > and > > quit again. GC creates the backup mybooks.gnucash.201901022345.gnucash. > > 201901081256.gnucash > > > > GC now has 3 files in the folder: > > > > mybooks.gnucash<-- has the 1st edit in it > > mybooks.gnucash.201901022345.gnucash <-- has the 2nd edit in it > > mybooks.gnucash.201901022345.gnucash.201901081256.gnucash <--no edits in it > > > > as you can see, by using a backup, you loose the previous edit session - go > > a > > few edits down the road and you can be in proper mess with transactions > > seeming to go missing from months ago! > > > > When Gnucash starts, it *normally* opens the file that was open when you > > shut > > down last time around, so it is fairly easy to get the wrong one by mistake > > if > > you've been digging in the folder. On Windows & Linux, you can make GC open > > with a different file by clicking... but not so on mac. No matter what > > file you > > try to open GC with, it WILL use the previous one. So if you've been looking > > at backups, on a Mac you NEED to File->Open once GC is running. > > > > 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] Backup recovery
Hi Finbar. Comments in-line below... On Monday, 11 February 2019 13:24:32 GMT Finbar Mahon wrote: > Wow, this is getting (more) complicated - > > You said - > > [When Gnucash starts, it *normally* opens the file that was open when > you shutdown last time around, > > so it is fairly easy to get the wrong one by mistake if you've been > digging in the folder.] > > I just booted up GNUcash without any 'digging' and got - > > On the bottom of the screen. > > which follows your information, as the 'second' file? right ? The file you have opened was originally an auto-backup of the file you called "GNU 5 Feb 2018 ", this backup was made after you hit Save on 5th March 2018 at 17.16 > so, I go > to file>open and I get - > > etc., etc. None of which have the date that is on the open GNUcash file. > Maybe it is one of the files marked 'wed'? but the dates don't match. > those 2 *.log files suggest that you were editing a different "auto backup", one taken originally on 1st March 2018 at 12:42. Seems you opened or that file on 6th Feb this year, at around 16.15. But the log files are not your data, so don't worry too much about them. > So I look further down the list of files under file > open and I finally > come to - > > The only file on these two grabs which fits your name criteria is the > very first one above but the date is almost a year ago, and none of the > others in the second grab seem to fit the criteria. Looks like there is a couple of auto-backups in the image 6.png that suggest you had the current file open for editing yesterday at around 14.14 or so. the top entry in that image suggests you also had the current file open on saturday at 12.45 too. the last file in the list shown in 6.png is the "lock" file that GC uses to help prevent openign the data twice - the "can't get lock" message we all see (occasionally) at start up - it should clear away on a clean shutdown. Proves that the current file is in that folder somewhere... > > :-( I am truly sorry for the long sequence of q&a but I am accustomed to > > assuming the file I last used opens again after I 'save' and 'quit' > GC does that by default (and always on a mac). The problem is that at some point after 5th March last year, you told GC to open a different file. And it has been doing so ever since. I suggest that you might like to do a file->save as and use a new name without the datestamps, but it is clear from 5.png that you have worked with 2 files in the last week (possibly more?), so you may well be missing things from the current file that you thought you had done, but are in the "wrong" file. You'll need to look carefully at how the 2 files differ before tiding up. Good luck, 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.
Re: [GNC] Version 3.4 Mac OS - intermittent fault with transaction editing popup
> On Feb 11, 2019, at 3:27 AM, Michael Hendry wrote: > > This came to my notice when trying to examine a number of Split Transactions. > > I selected the first transaction and right-clicked to bring up the menu, but > when I clicked Split Transaction nothing happened. > > I tried one or two other transactions, and sometimes the popup menu options > work and sometimes not. > > After trying other transactions the first one sometimes works, sometimes not. > > I haven’t been able to work out a way of producing this consistently. > > Is this a known issue? Maybe. If it's the one I know about the menu item isn't highlighted and moving the pointer up and down the menu doesn't have any visual effect. Move the pointer out of the menu and back in and the items highlight and everything works as it should. 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.
Re: [GNC] GNUCash fails to start on Windows 10 after windows update
Interesting! I am running GC v3.4 on Window 10 Home and updated to 1809 (Build 17763.292) a couple of days ago. GnuCash continues to run without any problem. Larry > Date: Sun, 10 Feb 2019 08:54:05 -0600 (CST)> From: Robert > > To: gnucash-user@gnucash.org > Subject: Re: [GNC] GNUCash fails to start on Windows 10 after windows > update> Message-ID: <1549810445196-0.p...@n4.nabble.com> > Content-Type: text/plain; charset=us-ascii > > I have the exact same problem. Trace files are empty and compatibility > mode does not help.> This is a real blocker - I don't have access to my > financial data anymore. > I hope there will be a solution for this issue soon!> > Robert * ___ 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 3.4 Mac OS - intermittent fault with transaction editing popup
> On 11 Feb 2019, at 15:07, John Ralls wrote: > > > >> On Feb 11, 2019, at 3:27 AM, Michael Hendry wrote: >> >> This came to my notice when trying to examine a number of Split Transactions. >> >> I selected the first transaction and right-clicked to bring up the menu, but >> when I clicked Split Transaction nothing happened. >> >> I tried one or two other transactions, and sometimes the popup menu options >> work and sometimes not. >> >> After trying other transactions the first one sometimes works, sometimes not. >> >> I haven’t been able to work out a way of producing this consistently. >> >> Is this a known issue? > > Maybe. If it's the one I know about the menu item isn't highlighted and > moving the pointer up and down the menu doesn't have any visual effect. Move > the pointer out of the menu and back in and the items highlight and > everything works as it should. > > Regards, > John Ralls > That’s the one! I’m having great trouble reproducing it this afternoon, and hadn’t discovered the move-the-pointer trick on the inert popup. But I have discovered that moving the cursor just outside the top of an active popup (i.e. one which does highlight the options) may make it inert when the cursor is brought back in. 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.
[GNC] Problem with Splits
From: Gareth Davies [mailto:gareth.davie...@ntlworld.com] Sent: 11 February 2019 11:54 To: 'gnucash-user@gnucash.org' Subject: Problem with Splits Windows 10, GC v 3.2. Help. Hi, I am having a problem trying to get an Account in Assets to automatically decrease or increase when I update and income or expense under a different heading. I have tried setting it up, but it doesn't seem to work. Gareth ___ 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] UK VAT Flat Rate Scheme
I’ll caveat that I’m not in a VAT territory, but this is how I’d approach it: Method 1: = Set your tax rate at 20% linked to a VAT Payable account. Write your invoice as taxable with the appropriate rate just defined. When you remit your payment to the government add a split for your own profit. You can do that manually, or set up a scheduled transaction using variables. You can create the SX template to ask for the current liability amount set to some variable say ‘vat_collected'. (no way yet to query the account unfortunately) Set the payment split amount to: vat_collected * .775 (15.5/20 = .775) Set the profit split amount to: vat_collected * .225 Your SX reminder should be set to fire according to the schedule you make your payments. (monthly, quarterly, etc.) When the SX fires, you’ll be prompted for the vat_collected amount and then it will do the math for the splits and then you can approve the transaction. Method 2: = Alternatively, if you need to recognize this income right away, then simply enter a transaction for .225 of the VAT collected balanced between a debit to the tax liability account and your ‘other revenue' account. Unfortunately, there is not yet a basic ’template transaction’ feature to make this easier and using a SX really won’t work because you can’t get it to fire on command. (only by a particular date with/out recurrence) Method 3: = It *might* be possible to set up two rates, one at 15.5% and another at 0.5% and link the 0.5% to the ‘other revenue’ account, but I have not tested this. Revenue accounts may not be offered as options when setting up tax rates, and the invoice might list both rates separately, which probably isn’t allowed. You’ll have to play around with that to see if it works for you. Doing it this way would eliminate the need for additional transactions moving the vendor compensation amount from liability to revenue and is probably the cleanest option if it works. Regards, Adrien > On Feb 10, 2019, at 12:38 PM, Bumbling Amateur wrote: > > I've read a couple of previously posted topics on this subject stretching > back years but haven't found an explanation of exactly how to successfully > manage the UK's VAT Flat Rate Scheme (FRS) from within gnucash. Here we are > in 2019, can anyone share their method? > > In summary when in the VAT Flat Rate Scheme one adds 20% to sales to create > an invoice. Then one calculates 15.5% of sales which is paid to the > government. The difference between the 20% invoiced and the 15.5% paid out > is profit for the business ie > > Sales: £1000 > VAT added to sales invoice @ 20% = £200 > Invoiced amount: £1200 > VAT @ 15.5% owed to government = £155 > Profit for business = 200-155 = £45 > > Thanks for any help, I'm really looking forward to a neat 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.
[GNC] Problem after upgrade from 2.6.14 to 3.x, bookings of an account are cut off
Hello, does anyone have suggestions how to trace the fault further? even if I launch gnucash with "gnucash --log "=debug" --log "gnc.backend.dbi=debug" --log "qof=debug" --log "gnc=debug", I do not get anything on STDOUT or STDERR.. but first of all the problem: in the account/bookings view gnucash shows me only entries until a specific date. all newer and newly created bookings are not being shown. But there are bookings in the MySQL (respecitvely MariaDB) databases. I see there all corresponding transactions and splits. the corresponding bookings in the other accounts are shown. I migrated to 3.x by exporting the book into xml, but in this file(s) the contents are already missing. I have a backup of the database (which worked fine until gnucash 2.6.14. But if I open that database using gnucash 3.3 or 3.4 those data are not shown. currently: Version: 3.4 Build ID: 3.4+ (2018-12-30) Finance::Quote: 1.47 using the command-line option --debug doesn't show any database related information or exceptions. Thank you Paul Neuwirth -- 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.
Re: [GNC] accrual of property tax payments
You should speak with a local CPA, but I’d posit that if you receive a bill for the full amount, then the taxes are all for one year and belong in that year. You are simply being allowed to pay the bill in installments but it is otherwise fully owed. There might be a hitch if the bill received in 2018 was for 2019 and you were pre-paying half of it. But that is just a posting date adjustment. (which might necessitate the use of a 'pre-paid expenses' asset account as a temporary intermediary) But if your CPA says you need to recognize only the quarterly payments as expenses when they were actually paid then: Method 1: = Creating 4 separate bills with their own future posting dates as Liz suggested. Method 2: = Continue as you are now, but create an adjusting transaction at the end of the year(or even right away) reversing the second half of the expense to an “Accrued Expenses” account. (sits under Liabilities) When you make your future February and May payments, re-expense those amounts. There might be some 3rd method using an intermediate account, but I can’t seem to figure out where it would go in the tree. It isn’t a pre-paid expense, so Assets is out. It isn’t a contra-expense because that would cancel itself out. It isn’t a liability because that would also cancel itself out. It isn’t revenue, so Income is out. It doesn’t belong in Equity, though I suppose you could use that and understand it is a ‘virtual account’. Really, if you need to recognize this on a cash basis, you shouldn’t be using the Business Features for this. Instead use manual transactions or scheduled transactions on the dates you make the payments. The Business Features are for accounting on an accrual basis. Regards, Adrien > On Feb 10, 2019, at 11:49 AM, Keith Bellairs wrote: > > My property tax is payable in 4 installments -- August, November, February, > and May. I have tried to set this up with my town as the vendor and 4 > payments. > > When I ran my income statement for last year, I see that the future > liabilities have been posted with the date that the bill was posted, not > the date that the bill is due. So all of my 2019 payments show as tax > expense in 2018. > > Is there a way to have the vendor bills show up dated with the due date > instead of the date posted? > > Keith ___ 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] Backup recovery
Yes, if you just launch GnuCash from its launcher it will open the last file you had open when you did a ’Save’ and ‘Quit’. But apparently, you intentionally at one point opened a backup file instead of the current working file, twice. (each time a different backup file) You normally do *not* want to see any dates in the name of the currently open file. (unless you intentionally put that in the file name, such as the year if you open new files each year) If you have a file open and there is a GnuCash generated date in the file name (like what you’ve shown previously, I can’t see the attachments either) then you very likely have a mess on your hands. You’ll need to figure out which file is the ‘most correct one’ and contains the *most* transactions that you expect to be there. If you find another file with transactions you thought to be missing, you can open them side-by-side and copy/paste into the ‘most correct’ file. (Business Feature transactions will have to be done manually) Then I’d do a Save As on the ‘most correct’ file to reset the filename to something simple without the date—e.g., ‘mybook.gnucash’ When you are trying to figure this out, be sure to set your file manager to show last access date for each file. That will be eye opening. I’d suspect the last access date of mybook.gnucash to be on or before the last GnuCash generated date in the file name you are working in. When you are confident you have everything straight, then delete ALL other files in the folder leaving only mybook.gnucash. Do a backup to BackBlaze manually and make sure older backups are erased. (so you don’t accidentally restore one of the incomplete ‘messy’ files in the future) Finally, don’t open any files with a GnuCash generated date again, unless you are trying to resolve an issue and don’t enter ANY transactions into that file. Only open such files for inspection and research. Enter transactions only in the ‘mybook.gnucash’ file. Regards, Adrien > On Feb 11, 2019, at 7:24 AM, Finbar Mahon wrote: > > Wow, this is getting (more) complicated - > > You said - > > [When Gnucash starts, it *normally* opens the file that was open when you > shutdown last time around, > > so it is fairly easy to get the wrong one by mistake if you've been digging > in the folder.] > > I just booted up GNUcash without any 'digging' and got - > > On the bottom of the screen. > > which follows your information, as the 'second' file? right ? so, I go to > file>open and I get - > > etc., etc. None of which have the date that is on the open GNUcash file. > Maybe it is one of the files marked 'wed'? but the dates don't match. > > So I look further down the list of files under file > open and I finally come > to - > > The only file on these two grabs which fits your name criteria is the very > first one above but the date is almost a year ago, and none of the others in > the second grab seem to fit the criteria. > > :-( I am truly sorry for the long sequence of q&a but I am accustomed to > assuming the file I last used opens again after I 'save' and 'quit' > > Thank you very much for your patience. > > Finbar ___ 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 3.4 Mac OS - intermittent fault with transaction editing popup
All context menus for me on a Mac have a ‘lag’ or delay on some or all items in the menu. At most this lasts about 2 seconds. In most cases it is only one menu entry (consistently a ‘delete’ variant) that doesn’t seem to want to be highlighted while the others are all responsive right away. I haven’t had to move the mouse off the menu, I just move up and down and it eventually ‘wakes up.’ Not sure if that is related. Regards, Adrien > > That’s the one! > > I’m having great trouble reproducing it this afternoon, and hadn’t discovered > the move-the-pointer trick on the inert popup. > > But I have discovered that moving the cursor just outside the top of an > active popup (i.e. one which does highlight the options) may make it inert > when the cursor is brought back in. > > 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.
Re: [GNC] Problem with Splits
Gareth, Not sure exactly what you mean with respect to "a different heading." As a general rule, I’d enter all transactions in the account the money is coming from. So if you are entering an expense, open your cash or checking account that you are using to pay the expense, and enter it there. If you are entering receipt of money, open the relevant income account and enter the transaction showing where the money went. (cash/checking/undeposited funds, etc.) You can enter a transaction into any account, but by sticking to this workflow you can eliminate lots of confusion. You can also use the General Journal but that too can introduce confusion if you aren’t careful. I’d also highly recommend turning on Double Line mode and Transaction Journal under the View Menu. This will show all information for the transaction at all times and will help you to learn what GnuCash is doing as well as get a handle on double-entry accounting. (it will also help if you use Formal Accounting labels, which will make all accounts show the debit/credit columns rather than various labels which depend on account type) Regards, Adrien > On Feb 11, 2019, at 11:13 AM, Gareth Davies via gnucash-user > wrote: > > > Windows 10, GC v 3.2. > > > > Help. > > > > Hi, I am having a problem trying to get an Account in Assets to > automatically decrease or increase when I update and income or expense under > a different heading. > > > > I have tried setting it up, but it doesn't seem to work. > > > > Gareth ___ 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] Problem with Splits
Hi, my general rule of thumb is to always entering from an asset or liability account. (Which might have something to do with the fact that in the software I use at work one account is autofilled from the last transaction). This way its also easier to keep track of bank accounts balance and you don’t to switch account windows that often. Kind regards Christian Kluge Am 11.02.2019 um 20:07 schrieb Adrien Monteleone: > Gareth, > > Not sure exactly what you mean with respect to "a different heading." > > As a general rule, I’d enter all transactions in the account the money is > coming from. > > So if you are entering an expense, open your cash or checking account that > you are using to pay the expense, and enter it there. > > If you are entering receipt of money, open the relevant income account and > enter the transaction showing where the money went. > (cash/checking/undeposited funds, etc.) > > You can enter a transaction into any account, but by sticking to this > workflow you can eliminate lots of confusion. You can also use the General > Journal but that too can introduce confusion if you aren’t careful. > > I’d also highly recommend turning on Double Line mode and Transaction Journal > under the View Menu. This will show all information for the transaction at > all times and will help you to learn what GnuCash is doing as well as get a > handle on double-entry accounting. (it will also help if you use Formal > Accounting labels, which will make all accounts show the debit/credit columns > rather than various labels which depend on account type) > > Regards, > Adrien > >> On Feb 11, 2019, at 11:13 AM, Gareth Davies via gnucash-user >> wrote: >> >> >> Windows 10, GC v 3.2. >> >> >> >> Help. >> >> >> >> Hi, I am having a problem trying to get an Account in Assets to >> automatically decrease or increase when I update and income or expense under >> a different heading. >> >> >> >> I have tried setting it up, but it doesn't seem to work. >> >> >> >> Gareth > > > ___ > 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] Problem with Splits
On 2/11/2019 2:40 PM, Christian Kluge wrote: Hi, my general rule of thumb is to always entering from an asset or liability account. The proper "general rule" for a (one side) split transaction is to enter it from the side (debit or credit) that is NOT being split. That this is most often either and asset or a liability account just the consequence of that most often the side of the transaction not being split. Starting with an account on the side of the transaction being split will make entry almost as difficult as entering a transaction that is split on both sides. You need an example? Say you are paying for your share of an expense X and the person you are sharing with allows you to pay part in cash and owe the rest. You would begin this split from the expense account (the credit side being split between cash (asset) and loan (liability) Michael D Novack ___ 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 leadership team
"David T. via gnucash-user" writes: > Honestly, the decision is yours. > > I’ve been using GnuCash now for over 13 years. Back then, Derek Atkins > was one of the primary developers, having taken over for another crew > that had carried GnuCash from its early years as xaccountant. He > stepped back, and several others stepped in. So, it’s been through > that process a couple of times anyway already. And I'm still here. Just not as active as before (as you can tell from my 10-day delay in responding ;) > 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.
Re: [GNC] SMTP TLS -- Re: Liabilities and Net Worth in Android app
humming.b...@posteo.net writes: > Dear Derek, > > if this email reaches the list, then TLS is working. Considering you sent it to me *and* the list, I have no way to confirm. My tests seem to imply it is working. ;) > Cheers > Chris -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.
Re: [GNC] accrual of property tax payments
Keith Bellairs writes: > My property tax is payable in 4 installments -- August, November, February, > and May. I have tried to set this up with my town as the vendor and 4 > payments. > > When I ran my income statement for last year, I see that the future > liabilities have been posted with the date that the bill was posted, not > the date that the bill is due. So all of my 2019 payments show as tax > expense in 2018. > > Is there a way to have the vendor bills show up dated with the due date > instead of the date posted? See: https://bugs.gnucash.org/show_bug.cgi?id=95700 This is talking about customer invoices, but vendor bills use the same logic. Note the date of the bug report. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] transaction imported do not show up
Hi: I was taught by a friend and use gnucash for years but am not really knowledgeable. I didn't use and maintain an account with a bank since 2015. Recently I decided to start using it again. I tried to import data from the bank but it didn't show up in the ledger. How can I restore that gnucash account? Thank you. ___ 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] Order of scheduled transaction processing
When GnuCash processes scheduled transactions and there is more than one transaction on a single day, in which order are those transactions created? It looks like it might be alphabetical by name. Is that correct? Peter ___ 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] Problem with Splits
Gareth, There is no way that GnuCash automatically debits or credits an asset account when you enter a transaction from an income or expense account. You have to manually enter the second part of the transaction to create the appropriate debit or credit to the asset account. When you have entered the transaction into say an expense account you enter the first split E.g. if you have the Expense:Clothes Account open and you enter the transaction there Date Description Account Debit Credit 12/12/19 Clothes Expense:Clothes $30 you will have to enter the second split which will credit your bank account. To do this you can use the tab key after entering the $30 in the debit column to open up the second split line.In this line if you tab to the Account field , click on the field to bring up the drop down list and select Asset:Current Assets:Bank (or whatever account you are spending the money from) you will find the $30 appears in the Credit column to balance the transaction. I.e. the account register now looks like: Date Description Account Debit Credit 12/12/19 Clothes Expense:Clothes $30.00 Asset:CurrentAssets:Bank $30.00 If you then hit return and then click anywhere else in the window (a previous transaction or on the date for a new transaction the dialog asking you to either record or cancel the transaction will then come up. Select Record and you are done. See https://www.gnucash.org/docs/v3/C/gnucash-help/ch_Common_Trans_Ops.html for more detail about entering transactions. - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Importing Quicekn Files
I am a new user and just tried to import my Quicken files following the instructions. However, My files are saved as .QDF files, not .QIF and I get a wrong format error message when I try to import them. I would appreciate any suggestions for fixing this. Thank you in advance, David Seltzer ___ 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] installation ..... Mac
Hello, I have a Mac 2009 MacBook Pro running 10.9.5 on a SSD. I also have macOS 10.11.6 El Capitan also an a SSD, but the 10.9.5 is my primary OSX. I download the gnu cash get the .dmg image then drag the gnucash app to my applications folder and then click on the app. A message box appears indication that the gnu cash app is being verified. The message box disappears and then nothing happens. There is no indication that gnucash is running, but if you bring-up “force quit” the application appears in the list. What am I doing wrong? Thanks, JP ___ 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] Problem after upgrade from 2.6.14 to 3.x, bookings of an account are cut off
> On Feb 11, 2019, at 6:13 AM, Paneologist via gnucash-user > wrote: > > Hello, > does anyone have suggestions how to trace the fault further? > even if I launch gnucash with "gnucash --log "=debug" --log > "gnc.backend.dbi=debug" --log "qof=debug" --log "gnc=debug", I do not get > anything on STDOUT or STDERR.. Logs are by default written to https://wiki.gnucash.org/wiki/Tracefile. Use --logto=foo to change that; stdout and stderr are special values of foo that do what you'd expect, otherwise foo is expected to be a file path. > but first of all the problem: > in the account/bookings view gnucash shows me only entries until a specific > date. all newer and newly created bookings are not being shown. > But there are bookings in the MySQL (respecitvely MariaDB) databases. I see > there all corresponding transactions and splits. > the corresponding bookings in the other accounts are shown. > > I migrated to 3.x by exporting the book into xml, but in this file(s) the > contents are already missing. > > I have a backup of the database (which worked fine until gnucash 2.6.14. But > if I open that database using gnucash 3.3 or 3.4 those data are not shown. > > currently: > Version: 3.4 > Build ID: 3.4+ (2018-12-30) > Finance::Quote: 1.47 > > using the command-line option --debug doesn't show any database related > information or exceptions. As a first guess you have a filter set. Select View>Filter By... and make sure that "Show All" is selected on the date tab. 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.
Re: [GNC] Importing Quicekn Files
> On Feb 11, 2019, at 12:28 PM, David Seltzer via gnucash-user > wrote: > > I am a new user and just tried to import my Quicken files following the > instructions. However, My files are saved as .QDF files, not .QIF and I get > a wrong format error message when I try to import them. > > > I would appreciate any suggestions for fixing this. You must export them as QIF or QFX files. GnuCash doesn't know how to read QDF. 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.
Re: [GNC] transaction imported do not show up
Anatoly What version of GNuCash are you using and on what platform (Linux/Windows/MacOS)? How were you trying to import your data from the bank? Directly using an on-line connection or by downloading a datafile and then importing that file into GnuCash? If the latter what was the format of the data file? While there is online support for direct download from a bank from within GnuCash, this is not necessarily available from all banks or in many countries. Other options usually available are to download OFX/QFX files, QIF files, CSV files. Of these the first are generally easiest to import provided the bank has got the OFX format right. Not all do. 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.
Re: [GNC] installation ..... Mac
From within the /Applications folder right-click on Gnucash.app and choose ‘open’. You will be asked if you want to open an app that was downloaded from the internet. You of course want to. GnuCash should launch. From then on, you can keep it in your dock and launch from there. Regards, Adrien > On Feb 11, 2019, at 7:18 PM, John Darwin Powers wrote: > > Hello, I have a Mac 2009 MacBook Pro running 10.9.5 on a SSD. I also have > macOS 10.11.6 El Capitan also an a SSD, but the 10.9.5 is my primary OSX. > > I download the gnu cash get the .dmg image then drag the gnucash app to my > applications folder and then click on the app. > A message box appears indication that the gnu cash app is being verified. > The message box disappears and then nothing happens. > There is no indication that gnucash is running, but if you bring-up “force > quit” the application appears in the list. > > What am I doing wrong? > > Thanks, JP ___ 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.