Re: [GNC] Revising an old Gnucash file
If you set an account to Hidden, it will be... hidden in the chart of accounts. Assuming that your messed up account is a catch-all account from which you hope to move transactions, I'd actually keep that account visible, and change the messed up transactions to reflect my current intention-- for example, changing the destination accounts to follow my new plan. As you change a transaction to use, say, Expenses:Auto instead of Expenses:Catch-all, the transactions will "disappear" from the Catch-all account (not really; they actually just get moved to the proper register). You'll know you're finished when the register is empty. Just my opinion. David T. On July 20, 2022 1:18:26 AM GMT+03:00, Tom Browder wrote: >On Tue, Jul 19, 2022 at 16:57 wrote: > >> Tom, >> >> You can make accounts hidden. Edit the account in the Account tab and >> select the >> hidden button in the dialogue. You can always then use the right click in >> the >> Accounts tab, select Find Account and unhide them in future. If you delete >> an >> account you can choose another account for any splits to the deleted >> account to >> be redirected to. > > >That sounds like the way to go! I saw in the docs one can hide an account, >but I could not find in the docs what the effect of a “hidden” file is. > >Thanks, David! > >-Tom >___ >gnucash-user mailing list >gnucash-user@gnucash.org >To update your subscription preferences or to unsubscribe: >https://lists.gnucash.org/mailman/listinfo/gnucash-user >If you are using Nabble or Gmane, please see >https://wiki.gnucash.org/wiki/Mailing_Lists for 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] GC4.10 on Win10 Crashing
I apologize if my response seemed testy. It's extremely frustrating to be working on a large data set with lots of complex transactions ("How exactly should the capital gains for a stock position with multiple purchase lots and an intervening split be tracked?"), finally work out how those complex transactions get recorded, enter them, go to save the result, only to have the program crash out. I will certainly try closing at least the one report I have open, as your idea that the report derives information from that reconciled account seems a reasonable possibility. On July 20, 2022 12:42:42 AM GMT+03:00, Adrien Monteleone wrote: >I wasn't trying to cause you work, just offering ideas on tracking down the >cause. Eliminating variables is part of that process. Lots of tabs and >especially reports open = variables. > >I'm going to hazard there is a report that feeds off one of those registers >(likely the one you are reconciling) that is a good candidate, thus closing >everything but that register should reveal if that is the case. > >But perhaps an upgrade to 4.11 would suit you better. You'll end up there most >likely anyway. > >Regards, >Adrien > >On 7/19/22 1:41 PM, David T. via gnucash-user wrote: >> Adrien, >> >> Thanks for the suggestions. >> >> It would seem to me that Finish/Ctrl-S is pretty reduced. >> >> I currently have about 12 tabs open. 10 registers, the CoA, and one report >> (granted, it's a multicolumn report). >> >> Saving after every edit is a remarkably annoying idea, especially given how >> long each save takes. I won't be doing that. >> >> As for a backup, I'm not sure why I'd go to a backup. The problem doesn't >> always happen, so I don't believe it's a problem with data corruption. I'm >> trying to move forward with my books, not backward. >> >> Nothing is holding me back from 4.11. > > >___ >gnucash-user mailing list >gnucash-user@gnucash.org >To update your subscription preferences or to unsubscribe: >https://lists.gnucash.org/mailman/listinfo/gnucash-user >If you are using Nabble or Gmane, please see >https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Setting up online banking finishes without success or error...
> On Jul 19, 2022, at 10:57 PM, Jeffrey Bush wrote: > > I am setting up OFX-DirectConnect backend in GnuCash and I enter all of the > information for the user and when I get to the end it asks you to request > the account list. I do that and the resulting output says: > > 22:34:28 Sending request... > 22:34:28 Using GnuTLS default ciphers. > 22:34:28 TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-128-GCM:AEAD > 22:34:28 Waiting for response... > 22:34:28 Operation finished, you can now close this window. > > All examples I can see online have something between "Waiting for > response..." and "Operation finished". An error, a success message, > something. But I get nothing at all. > > I have double-checked all of the settings and they are correct. I have used > the Python library ofxtools to connect with the settings and they work and > I am able to get a list of accounts and transactions with that tool. The > settings are: > > FID = '94089' > ORG = 'starone.org' > URL = 'https://fs-services.1fsapi.com/eftxweb/tyfone.ofx' > Client ID = 'F878CCBF-0AB5-4C61-A8DD-DD77275B4558' > The username and password don't have anything besides letters and numbers > in them (the wiki mentioned that that could sometimes be a problem). If I > do give a username/password combo that is bad I do get an error during the > account list retrieval, so it is at least getting that far. > > Is there any way to get more logs of why this might be going wrong? I was > thinking of submitting this to the aq mailing list, but I don't know > German... > > Another solution that I would actually prefer is to be able to run OFX > import from the command line or API. I know that it would have to make > assumptions about which accounts to make expenses go into since that is > normally done interactively, but I am actually completely fine with that. > What I want is to get the bayesian matching predictions that I can correct > later. > > Thanks! > ___ Well, you don’t have an error message, so that suggests you completed the request. That window that you can close is the comm status window, not the aqbanking setup window. If you look in the aqbanking setup dialog, there is a Users tab and an Accounts tab. Have you looked to see if anything has shown up in the Accounts tab? Martin (author of aqbanking) does just fine with English queries on the aqbanking mailing list. And he’s the best authority on aqbanking operation. Occasionally the gnucash interface with aqbanking throws in a couple curve balls, but he’d probably still know how to proceed. -- 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.
Re: [GNC] Revising an old Gnucash file
Tom, forgive me if I'm misunderstanding what you're trying to accomplish. (based on the initial direction of some of the replies, perhaps I am not grasping the original question properly.) But what do you mean by "ignore accounts"? If you have any data in GnuCash, it *is* double entry. (GnuCash won't let you do anything else) The Chart of Accounts you are using might well need some tweaking, (known as 'refactoring' in some software circles) but that can be accomplished with an existing book, without having to start over. (in most cases, even the worst case I can think of and have encountered, I still managed it, and I've 'refactored' my accounts several times and probably will again, I'm certain.) Could you be more specific, maybe with an example, as to what you'd like to 'ignore' and why? (that is, how you think 'ignoring' an account will help you tidy things up.) The situation may very well prove to not require 'ignoring' any account. Regards, Adrien On 7/19/22 3:27 PM, Tom Browder wrote: I have my original Gnucase file which has been continually used (for about 15 years) mainly as a simple check book app to replace Quicken. I am motivated now to (1) improve the account structure and (2) start moving toward a properly used double-entry system so I can use the full power of Gnucash. Is there any way to ignore accounts while incrementally working on tidying up my mess? Or should I just give up and start afresh (ugh)? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Setting up online banking finishes without success or error...
I am setting up OFX-DirectConnect backend in GnuCash and I enter all of the information for the user and when I get to the end it asks you to request the account list. I do that and the resulting output says: 22:34:28 Sending request... 22:34:28 Using GnuTLS default ciphers. 22:34:28 TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-128-GCM:AEAD 22:34:28 Waiting for response... 22:34:28 Operation finished, you can now close this window. All examples I can see online have something between "Waiting for response..." and "Operation finished". An error, a success message, something. But I get nothing at all. I have double-checked all of the settings and they are correct. I have used the Python library ofxtools to connect with the settings and they work and I am able to get a list of accounts and transactions with that tool. The settings are: FID = '94089' ORG = 'starone.org' URL = 'https://fs-services.1fsapi.com/eftxweb/tyfone.ofx' Client ID = 'F878CCBF-0AB5-4C61-A8DD-DD77275B4558' The username and password don't have anything besides letters and numbers in them (the wiki mentioned that that could sometimes be a problem). If I do give a username/password combo that is bad I do get an error during the account list retrieval, so it is at least getting that far. Is there any way to get more logs of why this might be going wrong? I was thinking of submitting this to the aq mailing list, but I don't know German... Another solution that I would actually prefer is to be able to run OFX import from the command line or API. I know that it would have to make assumptions about which accounts to make expenses go into since that is normally done interactively, but I am actually completely fine with that. What I want is to get the bayesian matching predictions that I can correct later. 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.
Re: [GNC] GC4.10 on Win10 Crashing
[Apologies to David T for diverting this thread.] FYI my main data file is 36MB on disc (XML format) and GnuCash has 85MB of RAM allocated when I open it. It typically takes about 15 seconds to start up and open, and about 3 seconds to save to disc (SATA SSD). Windows 10, 8GB RAM, Intel i7-3770 CPU, 10+ years old hardware. GnuCash 4.8, not crashing. Geoff = On 20/07/2022 6:27 am, David Carlson wrote: My data file is so big that it seems to tie up 1.5 gigs of Ram or more when open, so most of my computers cannot run a web browser simultaneously with GnuCash without using swap space and grinding down to a crawl. Even on my highest performance machines it takes several seconds to save but I usually do it before starting any activity that will take more than a few minutes. On Tue, Jul 19, 2022 at 1:43 PM David T. via gnucash-user < gnucash-user@gnucash.org> wrote: Adrien, Thanks for the suggestions. It would seem to me that Finish/Ctrl-S is pretty reduced. I currently have about 12 tabs open. 10 registers, the CoA, and one report (granted, it's a multicolumn report). Saving after every edit is a remarkably annoying idea, especially given how long each save takes. I won't be doing that. As for a backup, I'm not sure why I'd go to a backup. The problem doesn't always happen, so I don't believe it's a problem with data corruption. I'm trying to move forward with my books, not backward. Nothing is holding me back from 4.11. David On July 19, 2022 3:57:55 PM GMT+03:00, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: First, I'd reduce the steps before trying to save as a way of narrowing down the trigger of the crash. If you normally have many tabs open, particularly reports, perhaps consider closing everything but the CoA, and then keep only the register you need at one time. Since it is so easy to do, perhaps saving after each new transaction or edit? Then try reconciling. Then save. (does that reconcile still take longer than usual?) Do you have a backup, or recall at what point your file didn't crash? Anything holding you back from 4.11? I don't see anything particularly noted for solving a crash of this type in the release notes, but perhaps programming fixes were made that *might* avoid this issue. Regards, Adrien On 7/19/22 7:21 AM, David T. via gnucash-user wrote: Hello, I'm running GC4.10 on Win10, and I've been running into numerous crashes in the last few days while trying to catch up on my finances. Ironically, many of these crashes happen when I attempt to save my file. My usual workflow when catching up is to open the pdf bank statement and work through it to catch any omitted transactions, which I then enter into GC. After entering the transactions, I will then perform a reconcile for the account. Upon completing the reconciliation, I save my file. Over the last two days, GnuCash has crashed several times when I Ctrl-S at this point to save the file. (When I say crashed, I mean GnuCash simply disappears from the task bar, and a restart gives the usual file lock errors). This is, to say the least, frustrating. I have checked the trace files for the days in question, but there is nothing that seemingly refers to the crash. The trace mostly contains thousands of iterations of: * 13:32:51 WARN [gnc_numeric_to_decimal()] Rounding required when 'never round' specified. As for what I might be doing to cause the crashes, I really can't say, but I wonder if there is a conflict that happens when I click "Finish" in the reconciliation and then click Ctrl-S shortly after. I have noticed on my machine that there is a noticeable delay in the program between when I finish the reconciliation and when the program returns control to my input. (There's actually noticeable delays in *everything* I do in GnuCash on my machine, which is another issue that may or may not be related to my machine). I wonder if the software crashes because Ctrl-S interrupts the reconcile closing process, and leaves something corrupted. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for 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
Re: [GNC] Revising an old Gnucash file
Tom, I only have personal accounts and have several download options at most of them. Your idea of keeping a copy 0 safe and editing copy 1 seems reasonable but with 15 years of data do you have an effective way to get rid of unwanted transactions? How many years do you want to reformat and why? I’m asking because I often get ideas about what I’d like to do before thinking through the ramifications. Just spent several hundred $$$ trying to save my unstable Money database. Finally found a good backup that only lost 2021. I’ll keep that one for legacy and move forward with GnuCash. Best of luck to you! Po > On Jul 19, 2022, at 4:41 PM, Tom Browder wrote: > > On Tue, Jul 19, 2022 at 15:52 Phyllis Bruce wrote: >> >> Tom, best wishes! I had to abandon Microsoft Money after 30 years. I >> suggest you do as I did, even though you've been using GC. > > Thanks, Po. I'm too lazy to start over again, but I'm sure your method > is probably the best (and maybe less work in the long run!). One > problem is that I don't think my banks support either QIF or OFX for > personal accounts, but I'll check it out. > > I may also change my mind a bit and do a combo: (1) save a copy of the > existing file, (2) delete obsolete accounts, and (3) reorg/update the > leftover accounts. > > -Tom > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Revising an old Gnucash file
Being able to transfer bank transaction data is a godsend. I've found QIF file format more reliable to transfer transaction data from financial institutions - except for from PayPal. The Gnucash process isn't super obvious but works well. The auto recognition of same transactions is excellent. An improvement for repeated transactions that vary because the bank adds a different number to each would be good. For example, the ability to select part of the transaction text as the identifier for automated repeat transaction allocation. -Original Message- From: gnucash-user On Behalf Of David Carlson Sent: Wednesday, 20 July 2022 5:26 AM To: Phyllis Bruce Cc: Gnucash Users Subject: Re: [GNC] Revising an old Gnucash file Yes, when OFX or QFX works it is a lot easier. Alas, some financial institutions do not offer either of those formats and there are a small number of institutions that do not follow the format rigorously enough to be useful without some or a lot of pre or post processing during the import. Also, when keeping old files that modern programs cannot open, it is helpful to keep some old programs around that can open them. I am stuck with a lot of spreadsheets that I cannot open any more as well as some data files from other financial management programs that are no longer around. Sometimes it might make sense to copy the old files and save them in a newer format that is more likely to be around ten years from now.. On Tue, Jul 19, 2022 at 3:54 PM Phyllis Bruce wrote: > Tom, best wishes! I had to abandon Microsoft Money after 30 years. I > suggest you do as I did, even though you've been using GC. > > Create a new file and start with 2022. Keep your old file for > historical data. Import data from banks and savings accounts and > create your account structure as you go. Have you been importing all > along? I found that using the CSV file was too cumbersome. Choosing > QFX from your banking institutions might be a better idea. > > Someone way more knowledgeable will come along and tell you the easy > way to make the switch but after a brief learning curve I'm finding it > easy, if time consuming. > > One of our fellow users gave me this link that is proving very helpful. > https://gnucash-docs-rst.readthedocs.io/en/latest/index.html > > Good luck! > Po > > On Tue, Jul 19, 2022 at 3:28 PM Tom Browder wrote: > > > I have my original Gnucase file which has been continually used (for > about > > 15 years) mainly as a simple check book app to replace Quicken. I > > am motivated now to (1) improve the account structure and (2) start > > moving toward a properly used double-entry system so I can use the > > full power of Gnucash. > > > > Is there any way to ignore accounts while incrementally working on > tidying > > up my mess? Or should I just give up and start afresh (ugh)? > > > > Thanks. > > > > Cheers! > > > > -Tom > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > If you are using Nabble or Gmane, please see > > https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Revising an old Gnucash file
On Tue, Jul 19, 2022 at 16:57 wrote: > Tom, > > You can make accounts hidden. Edit the account in the Account tab and > select the > hidden button in the dialogue. You can always then use the right click in > the > Accounts tab, select Find Account and unhide them in future. If you delete > an > account you can choose another account for any splits to the deleted > account to > be redirected to. That sounds like the way to go! I saw in the docs one can hide an account, but I could not find in the docs what the effect of a “hidden” file is. Thanks, David! -Tom ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Revising an old Gnucash file
Tom, You can make accounts hidden. Edit the account in the Account tab and select the hidden button in the dialogue. You can always then use the right click in the Accounts tab, select Find Account and unhide them in future. If you delete an account you can choose another account for any splits to the deleted account to be redirected to. David Cousens On Tue, 2022-07-19 at 15:27 -0500, Tom Browder wrote: > I have my original Gnucase file which has been continually used (for about > 15 years) mainly as a simple check book app to replace Quicken. I am > motivated now to (1) improve the account structure and (2) start moving > toward a properly used double-entry system so I can use the full power of > Gnucash. > > Is there any way to ignore accounts while incrementally working on tidying > up my mess? Or should I just give up and start afresh (ugh)? > > Thanks. > > Cheers! > > -Tom > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for 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] GC4.10 on Win10 Crashing
I wasn't trying to cause you work, just offering ideas on tracking down the cause. Eliminating variables is part of that process. Lots of tabs and especially reports open = variables. I'm going to hazard there is a report that feeds off one of those registers (likely the one you are reconciling) that is a good candidate, thus closing everything but that register should reveal if that is the case. But perhaps an upgrade to 4.11 would suit you better. You'll end up there most likely anyway. Regards, Adrien On 7/19/22 1:41 PM, David T. via gnucash-user wrote: Adrien, Thanks for the suggestions. It would seem to me that Finish/Ctrl-S is pretty reduced. I currently have about 12 tabs open. 10 registers, the CoA, and one report (granted, it's a multicolumn report). Saving after every edit is a remarkably annoying idea, especially given how long each save takes. I won't be doing that. As for a backup, I'm not sure why I'd go to a backup. The problem doesn't always happen, so I don't believe it's a problem with data corruption. I'm trying to move forward with my books, not backward. Nothing is holding me back from 4.11. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Revising an old Gnucash file
On Tue, Jul 19, 2022 at 15:52 Phyllis Bruce wrote: > > Tom, best wishes! I had to abandon Microsoft Money after 30 years. I > suggest you do as I did, even though you've been using GC. Thanks, Po. I'm too lazy to start over again, but I'm sure your method is probably the best (and maybe less work in the long run!). One problem is that I don't think my banks support either QIF or OFX for personal accounts, but I'll check it out. I may also change my mind a bit and do a combo: (1) save a copy of the existing file, (2) delete obsolete accounts, and (3) reorg/update the leftover accounts. -Tom ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Revising an old Gnucash file
Yes, when OFX or QFX works it is a lot easier. Alas, some financial institutions do not offer either of those formats and there are a small number of institutions that do not follow the format rigorously enough to be useful without some or a lot of pre or post processing during the import. Also, when keeping old files that modern programs cannot open, it is helpful to keep some old programs around that can open them. I am stuck with a lot of spreadsheets that I cannot open any more as well as some data files from other financial management programs that are no longer around. Sometimes it might make sense to copy the old files and save them in a newer format that is more likely to be around ten years from now.. On Tue, Jul 19, 2022 at 3:54 PM Phyllis Bruce wrote: > Tom, best wishes! I had to abandon Microsoft Money after 30 years. I > suggest you do as I did, even though you've been using GC. > > Create a new file and start with 2022. Keep your old file for historical > data. Import data from banks and savings accounts and create your account > structure as you go. Have you been importing all along? I found that > using the CSV file was too cumbersome. Choosing QFX from your banking > institutions might be a better idea. > > Someone way more knowledgeable will come along and tell you the easy way to > make the switch but after a brief learning curve I'm finding it easy, if > time consuming. > > One of our fellow users gave me this link that is proving very helpful. > https://gnucash-docs-rst.readthedocs.io/en/latest/index.html > > Good luck! > Po > > On Tue, Jul 19, 2022 at 3:28 PM Tom Browder wrote: > > > I have my original Gnucase file which has been continually used (for > about > > 15 years) mainly as a simple check book app to replace Quicken. I am > > motivated now to (1) improve the account structure and (2) start moving > > toward a properly used double-entry system so I can use the full power of > > Gnucash. > > > > Is there any way to ignore accounts while incrementally working on > tidying > > up my mess? Or should I just give up and start afresh (ugh)? > > > > Thanks. > > > > Cheers! > > > > -Tom > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > If you are using Nabble or Gmane, please see > > https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Revising an old Gnucash file
On Tue, Jul 19, 2022 at 15:51 David Carlson wrote: > I would develop a plan that would probably include some limited steps of > improvement with backups between steps. Now that there is a way to export > and import transactions via CSV between files if there is enough > commonality to make it worthwhile for a few dozen transactions or so, at > least, that might fit in your plan. > > I would not ignore accounts, especially asset and liability accounts, but > try to redefine the income and expense accounts to make more sense. > Thanks, David. Is there any way to "turn off" an account while doing my clean-up? I do have many financial accounts that I would like to keep (at least for now) but have them not participating the book in the meantime. -Tom ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Revising an old Gnucash file
Tom, best wishes! I had to abandon Microsoft Money after 30 years. I suggest you do as I did, even though you've been using GC. Create a new file and start with 2022. Keep your old file for historical data. Import data from banks and savings accounts and create your account structure as you go. Have you been importing all along? I found that using the CSV file was too cumbersome. Choosing QFX from your banking institutions might be a better idea. Someone way more knowledgeable will come along and tell you the easy way to make the switch but after a brief learning curve I'm finding it easy, if time consuming. One of our fellow users gave me this link that is proving very helpful. https://gnucash-docs-rst.readthedocs.io/en/latest/index.html Good luck! Po On Tue, Jul 19, 2022 at 3:28 PM Tom Browder wrote: > I have my original Gnucase file which has been continually used (for about > 15 years) mainly as a simple check book app to replace Quicken. I am > motivated now to (1) improve the account structure and (2) start moving > toward a properly used double-entry system so I can use the full power of > Gnucash. > > Is there any way to ignore accounts while incrementally working on tidying > up my mess? Or should I just give up and start afresh (ugh)? > > Thanks. > > Cheers! > > -Tom > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Revising an old Gnucash file
I would develop a plan that would probably include some limited steps of improvement with backups between steps. Now that there is a way to export and import transactions via CSV between files if there is enough commonality to make it worthwhile for a few dozen transactions or so, at least, that might fit in your plan. I would not ignore accounts, especially asset and liability accounts, but try to redefine the income and expense accounts to make more sense. On Tue, Jul 19, 2022 at 3:28 PM Tom Browder wrote: > I have my original Gnucase file which has been continually used (for about > 15 years) mainly as a simple check book app to replace Quicken. I am > motivated now to (1) improve the account structure and (2) start moving > toward a properly used double-entry system so I can use the full power of > Gnucash. > > Is there any way to ignore accounts while incrementally working on tidying > up my mess? Or should I just give up and start afresh (ugh)? > > Thanks. > > Cheers! > > -Tom > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for 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] GC4.10 on Win10 Crashing
My data file is so big that it seems to tie up 1.5 gigs of Ram or more when open, so most of my computers cannot run a web browser simultaneously with GnuCash without using swap space and grinding down to a crawl. Even on my highest performance machines it takes several seconds to save but I usually do it before starting any activity that will take more than a few minutes. On Tue, Jul 19, 2022 at 1:43 PM David T. via gnucash-user < gnucash-user@gnucash.org> wrote: > Adrien, > > Thanks for the suggestions. > > It would seem to me that Finish/Ctrl-S is pretty reduced. > > I currently have about 12 tabs open. 10 registers, the CoA, and one report > (granted, it's a multicolumn report). > > Saving after every edit is a remarkably annoying idea, especially given > how long each save takes. I won't be doing that. > > As for a backup, I'm not sure why I'd go to a backup. The problem doesn't > always happen, so I don't believe it's a problem with data corruption. I'm > trying to move forward with my books, not backward. > > Nothing is holding me back from 4.11. > > David > > On July 19, 2022 3:57:55 PM GMT+03:00, Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > >First, I'd reduce the steps before trying to save as a way of narrowing > down the trigger of the crash. > > > >If you normally have many tabs open, particularly reports, perhaps > consider closing everything but the CoA, and then keep only the register > you need at one time. > > > >Since it is so easy to do, perhaps saving after each new transaction or > edit? > > > >Then try reconciling. Then save. (does that reconcile still take longer > than usual?) > > > >Do you have a backup, or recall at what point your file didn't crash? > > > >Anything holding you back from 4.11? I don't see anything particularly > noted for solving a crash of this type in the release notes, but perhaps > programming fixes were made that *might* avoid this issue. > > > >Regards, > >Adrien > > > >On 7/19/22 7:21 AM, David T. via gnucash-user wrote: > >> Hello, > >> > >> I'm running GC4.10 on Win10, and I've been running into numerous > crashes in the last few days while trying to catch up on my finances. > Ironically, many of these crashes happen when I attempt to save my file. > >> > >> My usual workflow when catching up is to open the pdf bank statement > and work through it to catch any omitted transactions, which I then enter > into GC. After entering the transactions, I will then perform a reconcile > for the account. Upon completing the reconciliation, I save my file. Over > the last two days, GnuCash has crashed several times when I Ctrl-S at this > point to save the file. (When I say crashed, I mean GnuCash simply > disappears from the task bar, and a restart gives the usual file lock > errors). This is, to say the least, frustrating. > >> > >> I have checked the trace files for the days in question, but there is > nothing that seemingly refers to the crash. The trace mostly contains > thousands of iterations of: > >> > >> * 13:32:51 WARN [gnc_numeric_to_decimal()] Rounding required > when 'never round' specified. > >> > >> As for what I might be doing to cause the crashes, I really can't say, > but I wonder if there is a conflict that happens when I click "Finish" in > the reconciliation and then click Ctrl-S shortly after. I have noticed on > my machine that there is a noticeable delay in the program between when I > finish the reconciliation and when the program returns control to my input. > (There's actually noticeable delays in *everything* I do in GnuCash on my > machine, which is another issue that may or may not be related to my > machine). I wonder if the software crashes because Ctrl-S interrupts the > reconcile closing process, and leaves something corrupted. > > > > > >___ > >gnucash-user mailing list > >gnucash-user@gnucash.org > >To update your subscription preferences or to unsubscribe: > >https://lists.gnucash.org/mailman/listinfo/gnucash-user > >If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for 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, pleas
[GNC] Revising an old Gnucash file
I have my original Gnucase file which has been continually used (for about 15 years) mainly as a simple check book app to replace Quicken. I am motivated now to (1) improve the account structure and (2) start moving toward a properly used double-entry system so I can use the full power of Gnucash. Is there any way to ignore accounts while incrementally working on tidying up my mess? Or should I just give up and start afresh (ugh)? Thanks. Cheers! -Tom ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for 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] New User Oh boy I need an accountant
Second thoughts. I decided to go with QFX files and they are much easier to deal with. Thanks again for your help. On Jul 19, 2022, at 5:11 AM, Phyllis Bruce wrote: Thank you all for your quick responses. Viewing the splits in the bank ledger is very helpful too. I'm going to start over at the CSV level. It will go quickly now. I also see I had a transfer to cash that I entered improperly. FYI, I've used Microsoft Money for 30 years so I have some "un-learning" to do. On Tue, Jul 19, 2022 at 1:24 AM Fred Bone wrote: > On 18 July 2022 at 17:32, Phyllis Bruce said: > > > I am getting too many unanticipated results. Watched many YouTube videos > > since I cannot make sense of the Help manual. I have added accounts > where > > they appear to belong, added my opening balances, and imported a couple > > CSV files from a bank account. > > > > Here is the CSV: Note columns for Withdrawal and Deposit > > [image: 0fb3e81e-c69c-40b2-b876-6cd92092afe4.png] > > > > [image: image.png] > > > > Here is the bank journal showing the transactions and transfer accounts: > > Everything a deposit?! [image: image.png] > > Of course. Your bank has put minus signs on the withdrawals. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for 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] GC4.10 on Win10 Crashing
Adrien, Thanks for the suggestions. It would seem to me that Finish/Ctrl-S is pretty reduced. I currently have about 12 tabs open. 10 registers, the CoA, and one report (granted, it's a multicolumn report). Saving after every edit is a remarkably annoying idea, especially given how long each save takes. I won't be doing that. As for a backup, I'm not sure why I'd go to a backup. The problem doesn't always happen, so I don't believe it's a problem with data corruption. I'm trying to move forward with my books, not backward. Nothing is holding me back from 4.11. David On July 19, 2022 3:57:55 PM GMT+03:00, Adrien Monteleone wrote: >First, I'd reduce the steps before trying to save as a way of narrowing down >the trigger of the crash. > >If you normally have many tabs open, particularly reports, perhaps consider >closing everything but the CoA, and then keep only the register you need at >one time. > >Since it is so easy to do, perhaps saving after each new transaction or edit? > >Then try reconciling. Then save. (does that reconcile still take longer than >usual?) > >Do you have a backup, or recall at what point your file didn't crash? > >Anything holding you back from 4.11? I don't see anything particularly noted >for solving a crash of this type in the release notes, but perhaps programming >fixes were made that *might* avoid this issue. > >Regards, >Adrien > >On 7/19/22 7:21 AM, David T. via gnucash-user wrote: >> Hello, >> >> I'm running GC4.10 on Win10, and I've been running into numerous crashes in >> the last few days while trying to catch up on my finances. Ironically, many >> of these crashes happen when I attempt to save my file. >> >> My usual workflow when catching up is to open the pdf bank statement and >> work through it to catch any omitted transactions, which I then enter into >> GC. After entering the transactions, I will then perform a reconcile for the >> account. Upon completing the reconciliation, I save my file. Over the last >> two days, GnuCash has crashed several times when I Ctrl-S at this point to >> save the file. (When I say crashed, I mean GnuCash simply disappears from >> the task bar, and a restart gives the usual file lock errors). This is, to >> say the least, frustrating. >> >> I have checked the trace files for the days in question, but there is >> nothing that seemingly refers to the crash. The trace mostly contains >> thousands of iterations of: >> >> * 13:32:51 WARN [gnc_numeric_to_decimal()] Rounding required when >> 'never round' specified. >> >> As for what I might be doing to cause the crashes, I really can't say, but I >> wonder if there is a conflict that happens when I click "Finish" in the >> reconciliation and then click Ctrl-S shortly after. I have noticed on my >> machine that there is a noticeable delay in the program between when I >> finish the reconciliation and when the program returns control to my input. >> (There's actually noticeable delays in *everything* I do in GnuCash on my >> machine, which is another issue that may or may not be related to my >> machine). I wonder if the software crashes because Ctrl-S interrupts the >> reconcile closing process, and leaves something corrupted. > > >___ >gnucash-user mailing list >gnucash-user@gnucash.org >To update your subscription preferences or to unsubscribe: >https://lists.gnucash.org/mailman/listinfo/gnucash-user >If you are using Nabble or Gmane, please see >https://wiki.gnucash.org/wiki/Mailing_Lists for 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] GC4.10 on Win10 Crashing
I didn't notice that spellchecker changed "wrt" to with, so insert the words "respect to". On Tue, Jul 19, 2022, 9:58 AM David Carlson wrote: > I do not use ctrl-s. Where does that shortcut fall with the bug in > release 4.10? > > On Tue, Jul 19, 2022, 8:16 AM Glenn Fowler wrote: > >> I'm not sure if it applies to this issue but there were issues fixed in >> 4.11 for crashes on Windows when closing without saving first. >> >> On Tue, Jul 19, 2022 at 8:57 AM Adrien Monteleone < >> adrien.montele...@lusfiber.net> wrote: >> >> > First, I'd reduce the steps before trying to save as a way of narrowing >> > down the trigger of the crash. >> > >> > If you normally have many tabs open, particularly reports, perhaps >> > consider closing everything but the CoA, and then keep only the register >> > you need at one time. >> > >> > Since it is so easy to do, perhaps saving after each new transaction or >> > edit? >> > >> > Then try reconciling. Then save. (does that reconcile still take longer >> > than usual?) >> > >> > Do you have a backup, or recall at what point your file didn't crash? >> > >> > Anything holding you back from 4.11? I don't see anything particularly >> > noted for solving a crash of this type in the release notes, but perhaps >> > programming fixes were made that *might* avoid this issue. >> > >> > Regards, >> > Adrien >> > >> > On 7/19/22 7:21 AM, David T. via gnucash-user wrote: >> > > Hello, >> > > >> > > I'm running GC4.10 on Win10, and I've been running into numerous >> crashes >> > > in the last few days while trying to catch up on my finances. >> > > Ironically, many of these crashes happen when I attempt to save my >> file. >> > > >> > > My usual workflow when catching up is to open the pdf bank statement >> and >> > > work through it to catch any omitted transactions, which I then enter >> > > into GC. After entering the transactions, I will then perform a >> > > reconcile for the account. Upon completing the reconciliation, I save >> my >> > > file. Over the last two days, GnuCash has crashed several times when I >> > > Ctrl-S at this point to save the file. (When I say crashed, I mean >> > > GnuCash simply disappears from the task bar, and a restart gives the >> > > usual file lock errors). This is, to say the least, frustrating. >> > > >> > > I have checked the trace files for the days in question, but there is >> > > nothing that seemingly refers to the crash. The trace mostly contains >> > > thousands of iterations of: >> > > >> > > * 13:32:51 WARN [gnc_numeric_to_decimal()] Rounding required >> when >> > > 'never round' specified. >> > > >> > > As for what I might be doing to cause the crashes, I really can't say, >> > > but I wonder if there is a conflict that happens when I click "Finish" >> > > in the reconciliation and then click Ctrl-S shortly after. I have >> > > noticed on my machine that there is a noticeable delay in the program >> > > between when I finish the reconciliation and when the program returns >> > > control to my input. (There's actually noticeable delays in >> *everything* >> > > I do in GnuCash on my machine, which is another issue that may or may >> > > not be related to my machine). I wonder if the software crashes >> because >> > > Ctrl-S interrupts the reconcile closing process, and leaves something >> > > corrupted. >> > >> > >> > ___ >> > gnucash-user mailing list >> > gnucash-user@gnucash.org >> > To update your subscription preferences or to unsubscribe: >> > https://lists.gnucash.org/mailman/listinfo/gnucash-user >> > If you are using Nabble or Gmane, please see >> > https://wiki.gnucash.org/wiki/Mailing_Lists for 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] GC4.10 on Win10 Crashing
The bug was if you closed the window with X or made selections on the popup window for auto-save. If you manually saved or let auto-save run, it worked as expected. On Tue, Jul 19, 2022 at 10:58 AM David Carlson wrote: > I do not use ctrl-s. Where does that shortcut fall with the bug in > release 4.10? > > On Tue, Jul 19, 2022, 8:16 AM Glenn Fowler wrote: > >> I'm not sure if it applies to this issue but there were issues fixed in >> 4.11 for crashes on Windows when closing without saving first. >> >> On Tue, Jul 19, 2022 at 8:57 AM Adrien Monteleone < >> adrien.montele...@lusfiber.net> wrote: >> >> > First, I'd reduce the steps before trying to save as a way of narrowing >> > down the trigger of the crash. >> > >> > If you normally have many tabs open, particularly reports, perhaps >> > consider closing everything but the CoA, and then keep only the register >> > you need at one time. >> > >> > Since it is so easy to do, perhaps saving after each new transaction or >> > edit? >> > >> > Then try reconciling. Then save. (does that reconcile still take longer >> > than usual?) >> > >> > Do you have a backup, or recall at what point your file didn't crash? >> > >> > Anything holding you back from 4.11? I don't see anything particularly >> > noted for solving a crash of this type in the release notes, but perhaps >> > programming fixes were made that *might* avoid this issue. >> > >> > Regards, >> > Adrien >> > >> > On 7/19/22 7:21 AM, David T. via gnucash-user wrote: >> > > Hello, >> > > >> > > I'm running GC4.10 on Win10, and I've been running into numerous >> crashes >> > > in the last few days while trying to catch up on my finances. >> > > Ironically, many of these crashes happen when I attempt to save my >> file. >> > > >> > > My usual workflow when catching up is to open the pdf bank statement >> and >> > > work through it to catch any omitted transactions, which I then enter >> > > into GC. After entering the transactions, I will then perform a >> > > reconcile for the account. Upon completing the reconciliation, I save >> my >> > > file. Over the last two days, GnuCash has crashed several times when I >> > > Ctrl-S at this point to save the file. (When I say crashed, I mean >> > > GnuCash simply disappears from the task bar, and a restart gives the >> > > usual file lock errors). This is, to say the least, frustrating. >> > > >> > > I have checked the trace files for the days in question, but there is >> > > nothing that seemingly refers to the crash. The trace mostly contains >> > > thousands of iterations of: >> > > >> > > * 13:32:51 WARN [gnc_numeric_to_decimal()] Rounding required >> when >> > > 'never round' specified. >> > > >> > > As for what I might be doing to cause the crashes, I really can't say, >> > > but I wonder if there is a conflict that happens when I click "Finish" >> > > in the reconciliation and then click Ctrl-S shortly after. I have >> > > noticed on my machine that there is a noticeable delay in the program >> > > between when I finish the reconciliation and when the program returns >> > > control to my input. (There's actually noticeable delays in >> *everything* >> > > I do in GnuCash on my machine, which is another issue that may or may >> > > not be related to my machine). I wonder if the software crashes >> because >> > > Ctrl-S interrupts the reconcile closing process, and leaves something >> > > corrupted. >> > >> > >> > ___ >> > gnucash-user mailing list >> > gnucash-user@gnucash.org >> > To update your subscription preferences or to unsubscribe: >> > https://lists.gnucash.org/mailman/listinfo/gnucash-user >> > If you are using Nabble or Gmane, please see >> > https://wiki.gnucash.org/wiki/Mailing_Lists for 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] GC4.10 on Win10 Crashing
I do not use ctrl-s. Where does that shortcut fall with the bug in release 4.10? On Tue, Jul 19, 2022, 8:16 AM Glenn Fowler wrote: > I'm not sure if it applies to this issue but there were issues fixed in > 4.11 for crashes on Windows when closing without saving first. > > On Tue, Jul 19, 2022 at 8:57 AM Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > > > First, I'd reduce the steps before trying to save as a way of narrowing > > down the trigger of the crash. > > > > If you normally have many tabs open, particularly reports, perhaps > > consider closing everything but the CoA, and then keep only the register > > you need at one time. > > > > Since it is so easy to do, perhaps saving after each new transaction or > > edit? > > > > Then try reconciling. Then save. (does that reconcile still take longer > > than usual?) > > > > Do you have a backup, or recall at what point your file didn't crash? > > > > Anything holding you back from 4.11? I don't see anything particularly > > noted for solving a crash of this type in the release notes, but perhaps > > programming fixes were made that *might* avoid this issue. > > > > Regards, > > Adrien > > > > On 7/19/22 7:21 AM, David T. via gnucash-user wrote: > > > Hello, > > > > > > I'm running GC4.10 on Win10, and I've been running into numerous > crashes > > > in the last few days while trying to catch up on my finances. > > > Ironically, many of these crashes happen when I attempt to save my > file. > > > > > > My usual workflow when catching up is to open the pdf bank statement > and > > > work through it to catch any omitted transactions, which I then enter > > > into GC. After entering the transactions, I will then perform a > > > reconcile for the account. Upon completing the reconciliation, I save > my > > > file. Over the last two days, GnuCash has crashed several times when I > > > Ctrl-S at this point to save the file. (When I say crashed, I mean > > > GnuCash simply disappears from the task bar, and a restart gives the > > > usual file lock errors). This is, to say the least, frustrating. > > > > > > I have checked the trace files for the days in question, but there is > > > nothing that seemingly refers to the crash. The trace mostly contains > > > thousands of iterations of: > > > > > > * 13:32:51 WARN [gnc_numeric_to_decimal()] Rounding required > when > > > 'never round' specified. > > > > > > As for what I might be doing to cause the crashes, I really can't say, > > > but I wonder if there is a conflict that happens when I click "Finish" > > > in the reconciliation and then click Ctrl-S shortly after. I have > > > noticed on my machine that there is a noticeable delay in the program > > > between when I finish the reconciliation and when the program returns > > > control to my input. (There's actually noticeable delays in > *everything* > > > I do in GnuCash on my machine, which is another issue that may or may > > > not be related to my machine). I wonder if the software crashes because > > > Ctrl-S interrupts the reconcile closing process, and leaves something > > > corrupted. > > > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > If you are using Nabble or Gmane, please see > > https://wiki.gnucash.org/wiki/Mailing_Lists for 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] GC4.10 on Win10 Crashing
I'm not sure if it applies to this issue but there were issues fixed in 4.11 for crashes on Windows when closing without saving first. On Tue, Jul 19, 2022 at 8:57 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > First, I'd reduce the steps before trying to save as a way of narrowing > down the trigger of the crash. > > If you normally have many tabs open, particularly reports, perhaps > consider closing everything but the CoA, and then keep only the register > you need at one time. > > Since it is so easy to do, perhaps saving after each new transaction or > edit? > > Then try reconciling. Then save. (does that reconcile still take longer > than usual?) > > Do you have a backup, or recall at what point your file didn't crash? > > Anything holding you back from 4.11? I don't see anything particularly > noted for solving a crash of this type in the release notes, but perhaps > programming fixes were made that *might* avoid this issue. > > Regards, > Adrien > > On 7/19/22 7:21 AM, David T. via gnucash-user wrote: > > Hello, > > > > I'm running GC4.10 on Win10, and I've been running into numerous crashes > > in the last few days while trying to catch up on my finances. > > Ironically, many of these crashes happen when I attempt to save my file. > > > > My usual workflow when catching up is to open the pdf bank statement and > > work through it to catch any omitted transactions, which I then enter > > into GC. After entering the transactions, I will then perform a > > reconcile for the account. Upon completing the reconciliation, I save my > > file. Over the last two days, GnuCash has crashed several times when I > > Ctrl-S at this point to save the file. (When I say crashed, I mean > > GnuCash simply disappears from the task bar, and a restart gives the > > usual file lock errors). This is, to say the least, frustrating. > > > > I have checked the trace files for the days in question, but there is > > nothing that seemingly refers to the crash. The trace mostly contains > > thousands of iterations of: > > > > * 13:32:51 WARN [gnc_numeric_to_decimal()] Rounding required when > > 'never round' specified. > > > > As for what I might be doing to cause the crashes, I really can't say, > > but I wonder if there is a conflict that happens when I click "Finish" > > in the reconciliation and then click Ctrl-S shortly after. I have > > noticed on my machine that there is a noticeable delay in the program > > between when I finish the reconciliation and when the program returns > > control to my input. (There's actually noticeable delays in *everything* > > I do in GnuCash on my machine, which is another issue that may or may > > not be related to my machine). I wonder if the software crashes because > > Ctrl-S interrupts the reconcile closing process, and leaves something > > corrupted. > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for 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] GC4.10 on Win10 Crashing
First, I'd reduce the steps before trying to save as a way of narrowing down the trigger of the crash. If you normally have many tabs open, particularly reports, perhaps consider closing everything but the CoA, and then keep only the register you need at one time. Since it is so easy to do, perhaps saving after each new transaction or edit? Then try reconciling. Then save. (does that reconcile still take longer than usual?) Do you have a backup, or recall at what point your file didn't crash? Anything holding you back from 4.11? I don't see anything particularly noted for solving a crash of this type in the release notes, but perhaps programming fixes were made that *might* avoid this issue. Regards, Adrien On 7/19/22 7:21 AM, David T. via gnucash-user wrote: Hello, I'm running GC4.10 on Win10, and I've been running into numerous crashes in the last few days while trying to catch up on my finances. Ironically, many of these crashes happen when I attempt to save my file. My usual workflow when catching up is to open the pdf bank statement and work through it to catch any omitted transactions, which I then enter into GC. After entering the transactions, I will then perform a reconcile for the account. Upon completing the reconciliation, I save my file. Over the last two days, GnuCash has crashed several times when I Ctrl-S at this point to save the file. (When I say crashed, I mean GnuCash simply disappears from the task bar, and a restart gives the usual file lock errors). This is, to say the least, frustrating. I have checked the trace files for the days in question, but there is nothing that seemingly refers to the crash. The trace mostly contains thousands of iterations of: * 13:32:51 WARN [gnc_numeric_to_decimal()] Rounding required when 'never round' specified. As for what I might be doing to cause the crashes, I really can't say, but I wonder if there is a conflict that happens when I click "Finish" in the reconciliation and then click Ctrl-S shortly after. I have noticed on my machine that there is a noticeable delay in the program between when I finish the reconciliation and when the program returns control to my input. (There's actually noticeable delays in *everything* I do in GnuCash on my machine, which is another issue that may or may not be related to my machine). I wonder if the software crashes because Ctrl-S interrupts the reconcile closing process, and leaves something corrupted. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for 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] GC4.10 on Win10 Crashing
Hello, I'm running GC4.10 on Win10, and I've been running into numerous crashes in the last few days while trying to catch up on my finances. Ironically, many of these crashes happen when I attempt to save my file. My usual workflow when catching up is to open the pdf bank statement and work through it to catch any omitted transactions, which I then enter into GC. After entering the transactions, I will then perform a reconcile for the account. Upon completing the reconciliation, I save my file. Over the last two days, GnuCash has crashed several times when I Ctrl-S at this point to save the file. (When I say crashed, I mean GnuCash simply disappears from the task bar, and a restart gives the usual file lock errors). This is, to say the least, frustrating. I have checked the trace files for the days in question, but there is nothing that seemingly refers to the crash. The trace mostly contains thousands of iterations of: * 13:32:51 WARN [gnc_numeric_to_decimal()] Rounding required when 'never round' specified. As for what I might be doing to cause the crashes, I really can't say, but I wonder if there is a conflict that happens when I click "Finish" in the reconciliation and then click Ctrl-S shortly after. I have noticed on my machine that there is a noticeable delay in the program between when I finish the reconciliation and when the program returns control to my input. (There's actually noticeable delays in *everything* I do in GnuCash on my machine, which is another issue that may or may not be related to my machine). I wonder if the software crashes because Ctrl-S interrupts the reconcile closing process, and leaves something corrupted. Suggestions are welcome. David T. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for 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] New User Oh boy I need an accountant
Thank you. I will take your advice and try again to make sense of the help manual On Mon, Jul 18, 2022 at 8:10 PM flywire wrote: > Firstly, an accountant won't know how to use GnuCash unless they are a > user. > > Have you done the GnuCash Tutorial and Concepts Guide as an introduction > for Getting Started and Managing Personal Finances? Put it in a window on > one side of your screen and start a new GnuCash file in a window on > the other side and work through the exercises. I find this old version much > easier to follow: > https://gnucash-docs-rst.readthedocs.io/en/latest/index.html By the end of > it you will have a good working knowledge of GnuCash and should understand > how to do that split. > > Importing csv is a bit daunting, click the transaction line and follow the > Help Manual section 6. > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for 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] New User Oh boy I need an accountant
Thank you all for your quick responses. Viewing the splits in the bank ledger is very helpful too. I'm going to start over at the CSV level. It will go quickly now. I also see I had a transfer to cash that I entered improperly. FYI, I've used Microsoft Money for 30 years so I have some "un-learning" to do. On Tue, Jul 19, 2022 at 1:24 AM Fred Bone wrote: > On 18 July 2022 at 17:32, Phyllis Bruce said: > > > I am getting too many unanticipated results. Watched many YouTube videos > > since I cannot make sense of the Help manual. I have added accounts > where > > they appear to belong, added my opening balances, and imported a couple > > CSV files from a bank account. > > > > Here is the CSV: Note columns for Withdrawal and Deposit > > [image: 0fb3e81e-c69c-40b2-b876-6cd92092afe4.png] > > > > [image: image.png] > > > > Here is the bank journal showing the transactions and transfer accounts: > > Everything a deposit?! [image: image.png] > > Of course. Your bank has put minus signs on the withdrawals. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for 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.