Re: Interesting Discovery in my accounts
Hi Jay, you must have (accidentally?) changed a transaction dated from 2014 after closing the books. Gruß, Christoph > Am 02.12.2017 um 23:01 schrieb Jay Ridgley : > > Good Afternoon, > I just discovered that in 2014 a number of my expense accounts were not > correctly closed (they had a balance other that ZERO)! > > Questions that I have: > > 1. How did it happen? > 2. Has this happened to anyone else? > 3. How do I correct the problem? > > I can not go back and recreate 3 YEARS of data. > > Ideas... > > Regards, > Jay > -- > Jay Ridgley > jridgley2 at austin.rr.com > Registered Linux User ID - 9115 > https://linuxcounter.net/cert/9115.png > Registered Ubuntu User ID - 23320 > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > 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 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: Interesting Discovery in my accounts -- more info...
Also check the orphans and imbalance accounts for strays. RBM On 12/02/2017 03:55 PM, David Carlson wrote: Jay, My first thought is that sometime after you closed the books you probably inadvertently entered additional transaction(s) dated before the closing date. Did you make an archive backup then that you can compare to your balances as of that date in your current data? If there were a very limited number of transactions you might be able to determine whether they were erroneous and could (and should) be corrected. David C On Sat, Dec 2, 2017 at 4:32 PM, Jay Ridgley wrote: On 12/02/2017 04:01 PM, Jay Ridgley wrote: Good Afternoon, I just discovered that in 2014 a number of my expense accounts were not correctly closed (they had a balance other that ZERO)! I have always closed my books at the end of an accounting period. However, upon further investigation, it appears that the 2013 close book transaction was not correctly performed. How that happened I have no idea. Most likely I did the close book for that year incorrectly and missed it. Is it recoverable? For instance can a close books be run with a date of 12/31/2013? I do not want to start over with a new set of books but I may have to do so. Questions that I have: 1. How did it happen? See above 2. Has this happened to anyone else? 3. How do I correct the problem? I can not go back and recreate 3 YEARS of data. Ideas... Regards, Jay -- Jay Ridgley jridgley2 at austin.rr.com Registered Linux User ID - 9115 https://linuxcounter.net/cert/9115.png Registered Ubuntu User ID - 23320 ___ gnucash-user mailing list gnucash-user@gnucash.org 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 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 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: Interesting Discovery in my accounts -- more info...
Jay, My first thought is that sometime after you closed the books you probably inadvertently entered additional transaction(s) dated before the closing date. Did you make an archive backup then that you can compare to your balances as of that date in your current data? If there were a very limited number of transactions you might be able to determine whether they were erroneous and could (and should) be corrected. David C On Sat, Dec 2, 2017 at 4:32 PM, Jay Ridgley wrote: > On 12/02/2017 04:01 PM, Jay Ridgley wrote: > >> Good Afternoon, >> I just discovered that in 2014 a number of my expense accounts were not >> correctly closed (they had a balance other that ZERO)! >> > > I have always closed my books at the end of an accounting period. > > However, upon further investigation, it appears that the 2013 close book > transaction was not correctly performed. > > How that happened I have no idea. Most likely I did the close book for > that year incorrectly and missed it. Is it recoverable? For instance can a > close books be run with a date of 12/31/2013? > > I do not want to start over with a new set of books but I may have to do > so. > >> >> Questions that I have: >> >> 1. How did it happen? >> > > See above > > 2. Has this happened to anyone else? >> 3. How do I correct the problem? >> >> I can not go back and recreate 3 YEARS of data. >> >> Ideas... >> >> Regards, >> Jay >> > > > -- > Jay Ridgley > jridgley2 at austin.rr.com > Registered Linux User ID - 9115 > https://linuxcounter.net/cert/9115.png > Registered Ubuntu User ID - 23320 > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > 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 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: Interesting Discovery in my accounts -- more info...
The expense accounts were probably edited or posted to (eg, with an incorrect date) after you "closed" them. The year-end closing process is quite simple and probably NOT at fault. Yes, you can go back and close them with an old date. Just make sure to delete the old closing transactions (one income, one expense) for that year before you do the new close. I do this anytime I have to go back and correct a prior year transaction. On 2017-12-02 14:32, Jay Ridgley wrote: On 12/02/2017 04:01 PM, Jay Ridgley wrote: Good Afternoon, I just discovered that in 2014 a number of my expense accounts were not correctly closed (they had a balance other that ZERO)! I have always closed my books at the end of an accounting period. However, upon further investigation, it appears that the 2013 close book transaction was not correctly performed. How that happened I have no idea. Most likely I did the close book for that year incorrectly and missed it. Is it recoverable? For instance can a close books be run with a date of 12/31/2013? I do not want to start over with a new set of books but I may have to do so. Questions that I have: 1. How did it happen? See above 2. Has this happened to anyone else? 3. How do I correct the problem? I can not go back and recreate 3 YEARS of data. Ideas... Regards, Jay ___ gnucash-user mailing list gnucash-user@gnucash.org 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.
Interesting Discovery in my accounts -- more info...
On 12/02/2017 04:01 PM, Jay Ridgley wrote: Good Afternoon, I just discovered that in 2014 a number of my expense accounts were not correctly closed (they had a balance other that ZERO)! I have always closed my books at the end of an accounting period. However, upon further investigation, it appears that the 2013 close book transaction was not correctly performed. How that happened I have no idea. Most likely I did the close book for that year incorrectly and missed it. Is it recoverable? For instance can a close books be run with a date of 12/31/2013? I do not want to start over with a new set of books but I may have to do so. Questions that I have: 1. How did it happen? See above 2. Has this happened to anyone else? 3. How do I correct the problem? I can not go back and recreate 3 YEARS of data. Ideas... Regards, Jay -- Jay Ridgley jridgley2 at austin.rr.com Registered Linux User ID - 9115 https://linuxcounter.net/cert/9115.png Registered Ubuntu User ID - 23320 ___ gnucash-user mailing list gnucash-user@gnucash.org 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: Interesting Discovery in my accounts
I never close my accounts - it's an optional thing :-) Cheers Dave H. On 3 December 2017 at 08:01, Jay Ridgley wrote: > Good Afternoon, > I just discovered that in 2014 a number of my expense accounts were not > correctly closed (they had a balance other that ZERO)! > > Questions that I have: > > 1. How did it happen? > 2. Has this happened to anyone else? > 3. How do I correct the problem? > > I can not go back and recreate 3 YEARS of data. > > Ideas... > > Regards, > Jay > -- > Jay Ridgley > jridgley2 at austin.rr.com > Registered Linux User ID - 9115 > https://linuxcounter.net/cert/9115.png > Registered Ubuntu User ID - 23320 > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > 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 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.
Interesting Discovery in my accounts
Good Afternoon, I just discovered that in 2014 a number of my expense accounts were not correctly closed (they had a balance other that ZERO)! Questions that I have: 1. How did it happen? 2. Has this happened to anyone else? 3. How do I correct the problem? I can not go back and recreate 3 YEARS of data. Ideas... Regards, Jay -- Jay Ridgley jridgley2 at austin.rr.com Registered Linux User ID - 9115 https://linuxcounter.net/cert/9115.png Registered Ubuntu User ID - 23320 ___ gnucash-user mailing list gnucash-user@gnucash.org 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.