[GNC] Reconcile multiple child accounts
Hello GNUCash subscribers - I have a brokerage account which is set up as an ASSET account. The brokerage account holds MUTUAL FUNDS so for each MUTUAL FUND, a sub account underneath the brokerage account is created. All the MUTUAL FUND sub accounts matched the quantity with the statement as transactions were added via OFX import. Now I want to reconcile all those MUTUAL FUND sub accounts. What is the best way to go about "bulk" reconciling all those MUTUAL FUND sub accounts? I am hoping that there is better way than one MUTUAL FUND sub account at a time. Looking forward to suggestions. Kalpesh. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Frustration (recently used files)
Hi Team Theses questions are probably best directed to John Ralls the mac expert. I am running macOS Mojave Version 10.14.6 and I have just downloaded Gnucash 4.5. I am sorry to keep repeating myself with these issues and I appreciate your input so far I just don’t seem to be getting the opening and saving of multiple accounts at all, making using Gnucash for my application un useable. I have historical data that I am not sure where it is, in current accounts. I have backed up but struggling to integrate that, but that’s another issue but would try to get this sorted first. I hope I can explain my problem so you can understand and offer practical solutions. I have historically had 4 sets of accounts based on 4 different bank accounts for 4 individual rental properties. I have only been opening from the file drop down menu as I have been unable to figure another way of doing it. I have come unstuck a few times with other headings coming in to this 1-4 menu but have managed to retrieve main accounts more by good luck than good management. Now I have 5 accounts I am completely lost. I have tried saving main accounts on desk top and in different files with appropriate headings and all I get is the copy of the last account I was in when I open, either by double clicking or right click “open with” gnucash So all I can open at the moment is one of the 4 accounts below, if I go into any of the accounts I have saved with different headings all I get is the last account I had been working on. So I understand there are only the last 4 historical accounts I have been working on as above. All I want to be able to do is save accounts in appropriately named files on my computer outside of gnucash and be able to open to have the correct data specific to that account and be able to add data and run reports etc. Very much appreciate your input and happy to look into any practical solutions. Regards Andrew > On 6/04/2021, at 9:01 AM, Michael or Penny Novack > wrote: > > On 4/5/2021 1:03 PM, D. via gnucash-user wrote: >> Stan, >> >> I'm going to wager that Andrew is on a Mac, because he said that when he >> clicked one account, another opened. This strongly implies the oddity that >> Mac users cannot double click on a GnuCash file in Finder and have that file >> open. It will always trigger Gnucash for the last file opened. >> >> This is a known issue for Mac users of Gnucash, and John Ralls (the Mac >> expert on the development team) has in the past explained exactly why this >> problem exists on the Mac. The workaround on this is to use File->Open in >> GnuCash to open your files. You can create Automator scripts as well, but >> that seems a little like overkill. >> >> David T. > > That is why I was asking for clarity about which OS and exactly what > procedure. Because what was written was described AS IF experiencing this > from file => open as opposed to clicking on an object. > > In my own case, there was so little predictability as to which gnucash books > I wanted to open (relative to the last opened) I use the -nofile option so am > always selecting. The situation has gotten better (fewer sets of books) now > that I have replacements* as treasurer for all of the organizations I was > doing, but I still might open more than four. > > Michael > > * It is considered bad practice not to have periodic replacement of > treasurer. Nor should organizations have to repeatedly override their bylaws > to allow a treasurer to remain beyond set term. Something the accountant > doing a financial review would flag as bad/unsafe practice. > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Reconcile multiple child accounts
Kalpesh, The reconciliation process has an option to include sub accounts. When the dialog first comes up there is a checkbox underneath which you can check to include sub accounts in the reconciliation. David -- 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] [MAINT] Unplanned network outage. yet again. (Upstream ISP failure)
Hi again, You may have noticed that code went offline yesterday -- there was a coolant failure at my ISP which caused the colo room temperature to raise to 122F (50C). Obvoiusly computers don't like to be at that temp. Water was restored earlier today and the ISP services were restored. The equipment at my premises were online the whole time, and indeed I was even able to reach my gateway through another address. Sorry for any inconvenience. Alas, there is very little I could do about *this* particular outage. -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] Reconcile multiple child accounts
Reconciliation only works with one currency or security at a time. As you discovered, security subaccounts must be reconciled separately. I have set up a monthly transaction in my data file to show every active security account in each brokerage account. Those serve to point to all the security accounts that I want to reconcile for that month. -- 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] Frustration (recently used files)
Andrew, You need to realise that on the mac opening GnuCash or double clicking a GnuCash file only ever opens the last file you were working with. Not sure about the behaviour from the recent files list as I don't use that either. I'm fortunate that I only have 1 Gnucash data file so this behaviour doesn't cause any issues for me :-) You should probably setup each of your GnuCash data files in a separate folder - I keep mine in Documents >> Gnucash >> Data but you can easily setup other sub-folders within Documents >> GnuCash. Doing this should keep all your logfiles and backups that Gnucash creates along the way with the relevant GnuCash data file. Make sure that you give each file a meaningful name so that when you open GnuCash you can check the file name in the title bar - if it's not the file you want to work with just use File >> Open to navigate to the sub folder you want and select the GnuCash data file you need. Hope this helps somewhat. Cheers David H. On Mon, 7 Jun 2021 at 10:36, Andrew Ralph via gnucash-user < gnucash-user@gnucash.org> wrote: > Hi Team > > Theses questions are probably best directed to John Ralls the mac expert. > I am running macOS Mojave Version 10.14.6 and I have just downloaded > Gnucash 4.5. > > I am sorry to keep repeating myself with these issues and I appreciate > your input so far I just don’t seem to be getting the opening and saving of > multiple accounts at all, making using Gnucash for my application un > useable. I have historical data that I am not sure where it is, in current > accounts. I have backed up but struggling to integrate that, but that’s > another issue but would try to get this sorted first. > > I hope I can explain my problem so you can understand and offer practical > solutions. > > I have historically had 4 sets of accounts based on 4 different bank > accounts for 4 individual rental properties. I have only been opening from > the file drop down menu as I have been unable to figure another way of > doing it. I have come unstuck a few times with other headings coming in to > this 1-4 menu but have managed to retrieve main accounts more by good luck > than good management. Now I have 5 accounts I am completely lost. > > I have tried saving main accounts on desk top and in different files with > appropriate headings and all I get is the copy of the last account I was in > when I open, either by double clicking or right click “open with” gnucash > > > > > > > > > So all I can open at the moment is one of the 4 accounts below, > > > > > > > > > > > if I go into any of the accounts I have saved with different headings all > I get is the last account I had been working on. > > > > > > > So I understand there are only the last 4 historical accounts I have been > working on as above. All I want to be able to do is save accounts in > appropriately named files on my computer outside of gnucash and be able to > open to have the correct data specific to that account and be able to add > data and run reports etc. > > > > Very much appreciate your input and happy to look into any practical > solutions. > > Regards > > Andrew > > > > > > > On 6/04/2021, at 9:01 AM, Michael or Penny Novack < > stepbystepf...@comcast.net> wrote: > > > > On 4/5/2021 1:03 PM, D. via gnucash-user wrote: > >> Stan, > >> > >> I'm going to wager that Andrew is on a Mac, because he said that when > he clicked one account, another opened. This strongly implies the oddity > that Mac users cannot double click on a GnuCash file in Finder and have > that file open. It will always trigger Gnucash for the last file opened. > >> > >> This is a known issue for Mac users of Gnucash, and John Ralls (the Mac > expert on the development team) has in the past explained exactly why this > problem exists on the Mac. The workaround on this is to use File->Open in > GnuCash to open your files. You can create Automator scripts as well, but > that seems a little like overkill. > >> > >> David T. > > > > That is why I was asking for clarity about which OS and exactly what > procedure. Because what was written was described AS IF experiencing this > from file => open as opposed to clicking on an object. > > > > In my own case, there was so little predictability as to which gnucash > books I wanted to open (relative to the last opened) I use the -nofile > option so am always selecting. The situation has gotten better (fewer sets > of books) now that I have replacements* as treasurer for all of the > organizations I was doing, but I still might open more than four. > > > > Michael > > > > * It is considered bad practice not to have periodic replacement of > treasurer. Nor should organizations have to repeatedly override their > bylaws to allow a treasurer to remain beyond set term. Something the > accountant doing a financial review would flag as bad/unsafe practice. > > > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your s
Re: [GNC] Frustration (recently used files)
Andrew, Are these rental properties are all part of a single business owned by a single legal entity? If so do you really need to maintain 4 sets of books? It is possible within Gnucash to set up an accounting structure in which the four properties would be separate with their on income,expense,asset accounts. There might be some complications around accounts payable/receivable as the business features are based around a single account of each type though. You could have under each of the top level accounts a sub-account for each property with the account substructure you currently have in multiple books/datafiles under the property subaccount in each of the top level account types. This would avoid having to open and close multiple sets of books. You could still create individual reports for each property by restricting the accounts a report includes It also simplifies your backup- only one file -- 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] Frustration
What you want is very simple, just not in GnuCash which is possibly the only package without it. The workaround changing accounts is just not worth the grief. Other software allows a category or class[ification] field on each transaction. Normally the field is even auto-populated based on say a payment by a tenant. One field is still not ideal because you might want multiple classifications on one transaction like bigger accounting packages offer (location, manager, supplier, owner, enterprise etc). The feature's been requested fairly frequently for ages: https://bugs.gnucash.org/show_bug.cgi?id=113772 Best thing you can do is change to different software. I use an old quickbooks version for my business to get that feature but you miss out on the open access to the database and potential reporting that brings. Say rental statements, performance per unit or property manager. Maybe look at https://kmymoney.org/ -- 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] Frustration
> On 7 Jun 2021, at 06:57, flywire wrote: > > What you want is very simple, just not in GnuCash which is possibly the only > package without it. The workaround changing accounts is just not worth the > grief. > > Other software allows a category or class[ification] field on each > transaction. Normally the field is even auto-populated based on say a > payment by a tenant. One field is still not ideal because you might want > multiple classifications on one transaction like bigger accounting packages > offer (location, manager, supplier, owner, enterprise etc). The feature's > been requested fairly frequently for ages: > https://bugs.gnucash.org/show_bug.cgi?id=113772 > > Best thing you can do is change to different software. I use an old > quickbooks version for my business to get that feature but you miss out on > the open access to the database and potential reporting that brings. Say > rental statements, performance per unit or property manager. > > Maybe look at https://kmymoney.org/ I’m using GnuCash 4.4 on iMac with Catalina, and have 6 files in my Most-Recently-Used (MRU) list. Some time ago I reported a bug in the updating of the MRU which was fixed in the next release, and it was about this time that the 6-item MRU became available on my system. I can’t find a Preferences setting for the number of files in the MRU, but I’m sure John Ralls could point a finger in the right direction. Regards, 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.
