Re: Interesting Discovery in my accounts

[Christoph R]

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...

[Ronal B Morse]

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...

[David Carlson]

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...

[Dean Gibson]

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.

Re: Interesting Discovery in my accounts

[Dave H]

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.