Re: gnucash-user Digest, Vol 179, Issue 59

[Adrien Monteleone]

The 1899 date seems to make me think that has something to do with a setting in 
your OS concerning how to interpret 2-year dates. (I don’t think Gnucash has 
this option, it might be hard coded)

Try running the report again and make sure to enter the full 4-digit date and 
not just ’16’. Also, test with 12/30/2016 and 01/01/2017 and see if it does the 
same thing or only on exactly 12/31/2016. You might have some corrupt data. 
That might even be the source date of the imbalance.

I just entered those two dates in the same report and it worked fine, so this 
wouldn’t be a generic bug to the app, though it might be a bug for a certain 
platform. (I’m on macOS 10.13 at the moment)

Since you’ve narrowed down to a few weeks, I’d just take a look at the General 
Ledger which contains all transactions from all accounts. Click on View > 
Filter By… and set your date range. (maybe even a day before and after just to 
be thorough) Also be sure to check all boxes on the Status tab in the Filter 
options. You want to see all transactions for that date range. Then just look 
over them and see if anything looks out of place. In particular, look for 
either the amount you are out of balance by or half that amount if the variance 
is an even number. (meaning you have an entry that is entered in reverse 
debit/credit, or entirely duplicated)

For myself, I think I want to tackle one other area first. I recall doing some 
re-organization and I went through a series of unposting paid invoices and 
reposting them, causing my lot assignments to get out of whack. I know I have 
some open lots that shouldn’t be there and many that are applied to the wrong 
documents. I’ll clean that up first, then re-run the trial balance and see if 
that does the trick. I’m not sure where the Trial-Balance report is pulling its 
numbers from, but it won’t hurt to perform that cleanup anyway.

Regards,
Adrien

> On Feb 15, 2018, at 2:35 PM, Elmar  wrote:
> 
> 
> 
> On 02/15/2018 02:28 PM, gnucash-user-requ...@gnucash.org wrote:
>> --
>> 
>> Message: 1
>> Date: Thu, 15 Feb 2018 13:27:17 -0600
>> From: Adrien Monteleone 
>> To: "gnucash-user@gnucash.org" 
>> Subject: Re: trial balance - how to find mismatch question
>> Message-ID: <823da1a8-b449-470f-ab10-e66505686...@gmail.com>
>> Content-Type: text/plain;charset=utf-8
>> ...
>> 
>> Elmar,
>> 
>> Reduce your ending date so the range is half of what it was. Re-run the 
>> report. Is it s[t]ill out of balance? Keep doing this till you get a 
>> balance, then set that ending date to a new start date, and start working 
>> forwards till you get out of balance again. This will help you narrow down 
>> where on the calendar the error occurred.
>> 
>> Regards,
>> Adrien
> OK - did that and ran into something VERY strange.  Everything stayed in 
> balance up to 07/12/2016.  Setting that as the start date and 12/31/2016 as 
> the end date, as soon as I hit "apply", QC overwrites the end date with - get 
> this - 02/27/1899 !!!  This of course produces nonsense.  One day later 
> (01/01/2017) works fine and shows the imbalance.  So, have I 1) found a bug, 
> and 2) given I have narrowed the date range to a few weeks, what report 
> should I run to find the weirdness? - Elmar
> ___
> 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: gnucash-user Digest, Vol 179, Issue 59

[DaveC49]

Elmar,

If you have narrowed the date range in which the error has occurred then it
is down to old fashioned accounting practices for finding errors. Some of
these articles may help:
http://www.reallifeaccounting.com/pubs/Article_Theme_Detecting_Accounting_Errors.pdf
https://ww2.odu.edu/~lhenry/accterrors.doc
https://learn.canvas.net/courses/37/pages/study-identifying-accounting-errors
https://talloncpa.sharepoint.com/Pages/FindingBalancingErrors.aspx
https://sciencing.com/catch-accounting-bookkeeping-errors-2324699.html

David



-
David Cousens
--
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: gnucash-user Digest, Vol 179, Issue 59

[Elmar]

On 02/15/2018 02:28 PM, gnucash-user-requ...@gnucash.org wrote:

--

Message: 1
Date: Thu, 15 Feb 2018 13:27:17 -0600
From: Adrien Monteleone 
To: "gnucash-user@gnucash.org" 
Subject: Re: trial balance - how to find mismatch question
Message-ID: <823da1a8-b449-470f-ab10-e66505686...@gmail.com>
Content-Type: text/plain;   charset=utf-8
...

Elmar,

Reduce your ending date so the range is half of what it was. Re-run the report. 
Is it s[t]ill out of balance? Keep doing this till you get a balance, then set 
that ending date to a new start date, and start working forwards till you get 
out of balance again. This will help you narrow down where on the calendar the 
error occurred.

Regards,
Adrien
OK - did that and ran into something VERY strange.  Everything stayed in 
balance up to 07/12/2016.  Setting that as the start date and 12/31/2016 
as the end date, as soon as I hit "apply", QC overwrites the end date 
with - get this - 02/27/1899 !!!  This of course produces nonsense.  One 
day later (01/01/2017) works fine and shows the imbalance.  So, have I 
1) found a bug, and 2) given I have narrowed the date range to a few 
weeks, what report should I run to find the weirdness? - Elmar

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