Re: [GNC] End of year
On 1/30/2024 4:37 PM, Adrien Monteleone wrote: Michael, if I recall correctly, the OP was bifurcating their checking account *every year*. That is: Checking -2022 -2023 -2024 -etc. I was discussing in general. And in any case, standing accounts (asset, liability,equity) are NOT "closed." And I was certainly not meaning to include something as questionable as doing this for a CHECKING account. Some assets have a defined "statement value" at a point in time so I suppose you COULD do this with them. But a checking account does NOT. I will repeat this. The checking account in your books has an amount as of some date and the bank statement for that checking account will have a value as of some date, but it in the very nature of checks that these need not be the same. You normally would have some checks that have been "constructively delivered" (mailed, for example) but that have not been received by the payee, not been de[posited by the payee, not gotten back to your bank. That is why we reconcile checking. Michael D Novack ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] End of year
On Wednesday, January 31st, 2024 at 01:12, Adrien Monteleone wrote: > > On 1/29/24 8:04 AM, Mahon Finbar via gnucash-user wrote: > > > OK, I want to do it properly, but I had an email crash and . > > > > So, can someone point me or send me the 'how to' for doing an end of > > year process, where I can 'inherit' the names from the autocomplete > > from the previous years? > > You can't. I thought we described that already. Not strictly true. > If you start a new file/account each year, you will lose all > auto-complete from the previous year's entries. > > The auto-complete list is generated on the fly from the other > transactions in the register you have open at that time. If that > register doesn't contain previous transactions because you started > a new year, then you don't get auto-complete suggestions. As Adrien points out, in order to have auto-complete, you need to have some "previous" transactions to auto-complete against However, if you have created a new, empty tree of accounts, and you have also exported a CSV of transactions, then you should be able to import those old transactions, so as to give you something to auto- complete against. Clearly though, you don't need multiple tranaactions that have the same name (Description field) because you only need one to be able to autocomplete against it. So the "trick" would be editing the CSV file so that you only have one transaction per auto-complete target that gets imported, and then deleting "old" entries, once you have your first autocompleted one for the new period, from within GnuCash itself. The amount of work required depends on how many "proto-transactions" you want to be able to autocomplete from, but it should be possible, however, it's not for everyone, and if you don't feel comfortable editing either CSV files, or the GnuCash files, when saved as XML, then make lots of backups as you work out what works best for you. Note that this approach is akin to copying your old GnuCash file to a new one and then deleting all the old tranactions, one at a time, from with the GUI front-end. I could even suggest that, once you have an exported CSV file of transactions, you might be able, simply by changing the dates in it, to re-use the same "common transactions" file every time you start a new GnuCash file. Alternatively, you might even maintain a second Gnucash file, which just has one transaction per auto-complete target, to which you add new ones as you encounter them in your ongoing accounts, and export your proto-transactions to CSV from that. So, make some backups; make one more set of backups, and then start experimenting. The bottom line is, whilst it is true that the vast majority of GnuCash users will only ever see, and operate on, their charts of accounts and transactions through the GUI front-end, underneath it all, it is just editable plain text, and you can use that to your advantage. HTH ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] End of year
Michael, if I recall correctly, the OP was bifurcating their checking account *every year*. That is: Checking -2022 -2023 -2024 -etc. As a result (the same would happen with a new file), they were losing the benefits of auto-complete. The only workaround for that is simply don't start a new account or file each year. It has nothing to do with accounting, but simply how the software works. Of course as you note, 'closing the books' and other year-end procedures can be done in the same book, and in the same account, without losing auto-complete. Regards, Adrien ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] End of year
> On 01/30/2024 9:39 AM PST Michael or Penny Novack > wrote: > > ONE refers to closing all the accounts of type income and expense > (temporary accounts of fundamental type equity) into equity itself or > accounts under equity. You will have to be doing the latter if the > entity type isn't "sole" (personal books or a sole proprietorship) > because need to allocate to the individual partners or shareholders. > Just closing the accounts of type income and expense WILL start the new > year off with these at zero. There are those who love the "Income Summary" account, and then there are those who would rather forget about it. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] End of year
On 1/30/2024 12:12 PM, Adrien Monteleone wrote: You can't. I thought we described that already. If you start a new file/account each year, you will lose all auto-complete from the previous year's entries. The auto-complete list is generated on the fly from the other transactions in the register you have open at that time. If that register doesn't contain previous transactions because you started a new year, then you don't get auto-complete suggestions. If auto-complete is important to you (it does save lots of time!) then don't start a new file/account each year. Let's not confuse two very different things under the name of "year end closing" ONE refers to closing all the accounts of type income and expense (temporary accounts of fundamental type equity) into equity itself or accounts under equity. You will have to be doing the latter if the entity type isn't "sole" (personal books or a sole proprietorship) because need to allocate to the individual partners or shareholders. Just closing the accounts of type income and expense WILL start the new year off with these at zero. Gnucash can produce reports without closing the books, but if you like to see the current income and account balances (just for the current accounting period) you might want to close the books. Making a backup copy of the books is just like making a backup of any other file. Hopefully you are not JUST making a year end backup, but that's the one you might be sending additional copies to safe keeping. While just doing this does not prevent you from altering the past it does make that detectable. The SECOND meaning is to also "start fresh" with just the balances of all "standing accounts". This file would have no past that could be altered. But as noted, you will lose things like autocomplete. It more closely mimics the old days when books were kept in physical volumes, starting in a fresh volume each year. THAT is why we still call these financial records "books" because for many hundreds of years, they were books. Michael D Novack ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] End of year
You can't. I thought we described that already. If you start a new file/account each year, you will lose all auto-complete from the previous year's entries. The auto-complete list is generated on the fly from the other transactions in the register you have open at that time. If that register doesn't contain previous transactions because you started a new year, then you don't get auto-complete suggestions. If auto-complete is important to you (it does save lots of time!) then don't start a new file/account each year. Regards, Adrien On 1/29/24 8:04 AM, Mahon Finbar via gnucash-user wrote: OK, I want to do it properly, but I had an email crash and . So, can someone point me or send me the 'how to' for doing an end of year process, where I can 'inherit' the names from the autocomplete from the previous years? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Balance Sheet fails to run for dates more than 7 month ago.
Following the suggestion of David Cousens I searched for config files both in 2.18 and 3.6 . I used the configuration diagram in https://wiki.gnucash.org/wiki/Configuration_Diagrams_-_Linux to guide me to the correct directory. 2.18 /home//.gnucash I found 8 of the 9 files that diagram suggests. I could not find config.user file . Is it possible that 2.18 would work without the config.user file ? 3.6 /home//.config/gnucash This directory was empty so no config-user.scm file found . Is it possible that 3.6 would work without the config-user.scm file ? I cannot find any config files , what should I do next? From: gnucash-user on behalf of David Cousens Sent: 28 January 2024 20:09 To: gnucash-user@gnucash.org Subject: Re: [GNC] Balance Sheet fails to run for dates more than 7 month ago. James, You might want to take a look at https://wiki.gnucash.org/wiki/FAQ#Using_Different_Versions.2C_Up_And_Downgrade. From V2 to V3 there was a change in the location of the reports. Changes in location s of files take place where necessary on the major version number changes. Further information is also available at https://wiki.gnucash.org/wiki/Configuration_Locations. About halfway down the page are some diagrams which decode the more complex description given above them for the 3 major OS. There is normally a process run during the upgrade which checks the version level of the data file and makes any changes in the config files locations which may not have run depending on how you upgraded. In most cases the fix is just copying the old config files to the new location in the updated version. David Cousens On Sun, 2024-01-28 at 07:03 +, James Edmunds wrote: > In Dec 2023 I tried to upgrade from Ubuntu 18.04 to Ubuntu 20.04 . There > was some file corruption which was > difficult for me to fix so I wiped the hard disc clean and installed a fresh > version of Ubuntu 20.04 . > > In 20.04 I use Gnucash 3.8 . In 18.04 I used Gnucash 2.6.19 > > > At the time of the installation of GC 3.8 I thought that all my reports > worked . Now I find that when I try to run a > Balance Sheet for any date earlier than about 7 months ago it fails . I > use the price source " nearest in time" > in the BS. > > I had not input any security /currency prices in the Price Table between 28 > Apr 2023 and 23 Oct 2023 . > > See error report . > > > An error occurred while running the report. > > In srfi/srfi-1.scm: >592:29 19 (map1 (#< commodity: # > …)) >592:29 18 (map1 (#< commodity: # > …)) >592:29 17 (map1 (#< commodity: # > …)) >592:29 16 (map1 (#< commodity: # > …)) >592:29 15 (map1 (#< commodity: # > …)) >592:29 14 (map1 (#< commodity: # > …)) >592:29 13 (map1 (#< commodity: # > …)) >592:29 12 (map1 (#< commodity: # > …)) >592:29 11 (map1 (#< commodity: # > …)) >592:29 10 (map1 (#< commodity: # > …)) >592:29 9 (map1 (#< commodity: # > …)) >592:29 8 (map1 (#< commodity: # > …)) >592:29 7 (map1 (#< commodity: # > …)) >592:29 6 (map1 (#< commodity: # > …)) >592:29 5 (map1 (#< commodity: # > …)) >592:29 4 (map1 (#< commodity: # > …)) >592:17 3 (map1 (#< commodity: # > …)) > In commodity-utilities.scm: >933:46 2 (_ #< commodity: # 5…>) >780:12 1 (gnc:exchange-by-pricedb-nearest _ # > …) > In unknown file: >0 (gnc-pricedb-convert-balance-nearest-price-t64 # > …) > > Throw to key `numerical-overflow' with args `("/" "Numerical overflow" #f > #f)'. > > > > This table show the result of running the BS on various dates . I can > understand the BS might fail if it was run on > dates when there were no security prices in GC , but is is not so simple . > The BS fails on 28 Apr when there are > prices in GC > > > > 23 Oct 23 - ok > > 30 Sep 23 - ok > > 31 Aug 23 - ok > > 31 Jul 23 - ok > > 30 Jun 23 - ok > > 16 Jun 23 - ok > > 15 Jun 23 - fails > > 14 Jun 23 - fails > > 28 Apr23 - fails > > 31 Dec 22 -fails > > > What do I do to fix this ? > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to