Re: [GNC] Starting a new year
On Wednesday, January 10th, 2024 at 03:14, Grace wrote: > > Hello, > > I am just wondering how folks are dealing with starting a new year? > > Finishing 2023 I think is easy. You just stop using it. > > However, how do I start 2024 with the finishing balances of 2023? Do I > have set up a brand new set of accounts, or is there a way of doing this > that I have not found? > > Grace If you are 1) Saving your GnuCash files as uncompressed XML 2) Happy editing files in a TXT editor, then the following may be of some use then it's not too hard to start over and, as long as you keep a copy of the "previous year" then you can't lose anything when trying it out. Create a new tree of accounts fron (let's say ongoing.gnucash) File->Export-Export Accounts (save as account_tree.gnucash) Copy account_tree.gnucash to new_yeargnucash Copy ongoing.gnucash to old_year.gnucash The next bits are probably best viewed in a monospcaed font as I have tried to line up the actions in each of the files: old_year.gnucash new_year.gnucash Grab from to last Add to end of file Grab the 5 count data line for the schedexaction Add after the lines Grab the two lines 1 Add before the lines so as to balance the closing gnc:book Need to disable the SchedTXNs in the old file, which you can do, one-at-a-time, from within GnuCash of by editing the XML and Replace every y with n Open up ongoing.gnucash in GnuCash Create a report from the "Account Summary" template that will give you all of the Opening blanaces you need to populate the new file. In the report creation dialog, I set the following: Tab:General Change the date to the last date of the previous period Tab:Accounts Make the level of subaccounts "All" Only need Assets & Liabilities and Children Tab:Display Uncheck Include accounts with zero balances Tab:Commodities Report's Currency: GBP (Just make sure it's the files default currency) Price Source: Most Recent Export as old_year-report-acc_sum.html Open up new_year.gnucash in GnuCash Enter the various Opening Balances with reference to your HTML report file. Save new_year.gnucash That's it. GnuCash on opening your new file, will do a very good job of adding in any "missing" bits, when it comes to save the new file for the first time. Aside: if you keep making copies of the new_year.gnucash before you operate on it, you will be able to see what Gnucash is doing to it. GnuCash is an incredible program in that respect: the authors deserve a lot of credit for their work. FWIW, people who want to try and get a better understanding of the format of a Gnucash XML file could do a lot worse than to create a brand new file, with a set of minimal accounts, enter one tranaction, and maybe one commodity and commodity price, and squirrel that file away for future reference. I hope that helps and/or gives you something upon which to create your own approach, although, as many folk on here will tell you, you may not need to have seperate files for seperate years, but if you want to, then you can do. ___ 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] Starting a new year
It's OK. Th error relates to the heading not the actual date. On 2024-01-09 1:10 p.m., Grace wrote: I'm trying to import the 2024 transaction exported from my 2023 accounts, and the imported is refusing to accept that the date is in fact a date. This is the .csv file that GnuCash exported!!! Does anyone have any thoughts on how to get the import to except the data as valid?? On 2024-01-09 2:42 p.m., David T. wrote: Grace might also look at https://wiki.gnucash.org/wiki/Closing_Books David T. On Jan 9, 2024, at 8:27 PM, Gyle McCollam wrote: Grace, You can export your account tree in CSV format. Look under "FILE/EXPORT". If you "close Books..." under tools it will simplify entering the starting balances for 2024. Thank You, Gyle McCollam Gyle McCollam gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email From: gnucash-user <http://gmail.com>@gnucash.org> on behalf of Grace Sent: Tuesday, January 9, 2024 2:14 PM To: Gnucash Users Subject: [GNC] Starting a new year Hello, I am just wondering how folks are dealing with starting a new year? Finishing 2023 I think is easy. You just stop using it. However, how do I start 2024 with the finishing balances of 2023? Do I have set up a brand new set of accounts, or is there a way of doing this that I have not found? Grace gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ 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] Starting a new year
I'm trying to import the 2024 transaction exported from my 2023 accounts, and the imported is refusing to accept that the date is in fact a date. This is the .csv file that GnuCash exported!!! Does anyone have any thoughts on how to get the import to except the data as valid?? On 2024-01-09 2:42 p.m., David T. wrote: Grace might also look at https://wiki.gnucash.org/wiki/Closing_Books David T. On Jan 9, 2024, at 8:27 PM, Gyle McCollam wrote: Grace, You can export your account tree in CSV format. Look under "FILE/EXPORT". If you "close Books..." under tools it will simplify entering the starting balances for 2024. Thank You, Gyle McCollam Gyle McCollam gmccol...@live.com<mailto:gmccol...@gyleshomes.com>email From: gnucash-user http://gmail.com>@gnucash.org> on behalf of Grace Sent: Tuesday, January 9, 2024 2:14 PM To: Gnucash Users Subject: [GNC] Starting a new year Hello, I am just wondering how folks are dealing with starting a new year? Finishing 2023 I think is easy. You just stop using it. However, how do I start 2024 with the finishing balances of 2023? Do I have set up a brand new set of accounts, or is there a way of doing this that I have not found? Grace gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Starting a new year
Grace might also look at https://wiki.gnucash.org/wiki/Closing_Books David T. On Jan 9, 2024, 8:27 PM, at 8:27 PM, Gyle McCollam wrote: >Grace, >You can export your account tree in CSV format. Look under >"FILE/EXPORT". If you "close Books..." under tools it will simplify >entering the starting balances for 2024. > > >Thank You, > >Gyle McCollam > >Gyle McCollam > >gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email > > >From: gnucash-user >on behalf of Grace >Sent: Tuesday, January 9, 2024 2:14 PM >To: Gnucash Users >Subject: [GNC] Starting a new year > >Hello, > >I am just wondering how folks are dealing with starting a new year? > >Finishing 2023 I think is easy. You just stop using it. > >However, how do I start 2024 with the finishing balances of 2023? Do I >have set up a brand new set of accounts, or is there a way of doing >this >that I have not found? > >Grace > >___ >gnucash-user mailing list >gnucash-user@gnucash.org >To update your subscription preferences or to unsubscribe: >https://lists.gnucash.org/mailman/listinfo/gnucash-user >- >Please remember to CC this list on all your replies. >You can do this by using Reply-To-List or Reply-All. >___ >gnucash-user mailing list >gnucash-user@gnucash.org >To update your subscription preferences or to unsubscribe: >https://lists.gnucash.org/mailman/listinfo/gnucash-user >- >Please remember to CC this list on all your replies. >You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Starting a new year
Gyle explained how to start fresh with a new file. Some folks also just archive a copy and keep going in the original file. Others just 'close the books' and keep going in the original file. Still others (I'm in this camp) just keep going in the original file. Another consideration is to run and archive (such as with physical paper, or PDF) copies of end of year reports. (Balance Sheet, Income Statement, etc.) If you keep working in the same file, you might edit a previous year transaction (which might be fine to do) and that would of course change those reports. If it is important to you to have 'official' End of Year reports, then archiving a copy is a good practice. Some folks do this and store them with an archived copy of the book too. Regards, Adrien On 1/9/24 1:14 PM, Grace wrote: I am just wondering how folks are dealing with starting a new year? Finishing 2023 I think is easy. You just stop using it. However, how do I start 2024 with the finishing balances of 2023? Do I have set up a brand new set of accounts, or is there a way of doing this that I have not found? ___ 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] Starting a new year
GnC will handle multiple years worth of accounting information so no need to "start" a new year. Just keep using the same data file(s) and enter the appropriate dates. That's the easiest way. If you really want separate files (books), then you will have to export the accounts (last time I tried that I think it exported as a file the GnC could open). However, you will have to enter a transaction to setup the beginning account balances. More work than I want to do. Stephen M Butler stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 On 1/9/24 11:14, Grace wrote: Hello, I am just wondering how folks are dealing with starting a new year? Finishing 2023 I think is easy. You just stop using it. However, how do I start 2024 with the finishing balances of 2023? Do I have set up a brand new set of accounts, or is there a way of doing this that I have not found? Grace ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Starting a new year
Grace, You can export your account tree in CSV format. Look under "FILE/EXPORT". If you "close Books..." under tools it will simplify entering the starting balances for 2024. Thank You, Gyle McCollam Gyle McCollam gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email From: gnucash-user on behalf of Grace Sent: Tuesday, January 9, 2024 2:14 PM To: Gnucash Users Subject: [GNC] Starting a new year Hello, I am just wondering how folks are dealing with starting a new year? Finishing 2023 I think is easy. You just stop using it. However, how do I start 2024 with the finishing balances of 2023? Do I have set up a brand new set of accounts, or is there a way of doing this that I have not found? Grace ___ 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.
[GNC] Starting a new year
Hello, I am just wondering how folks are dealing with starting a new year? Finishing 2023 I think is easy. You just stop using it. However, how do I start 2024 with the finishing balances of 2023? Do I have set up a brand new set of accounts, or is there a way of doing this that I have not found? Grace ___ 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.