Re: Reconciling an account

[EngineInstitute]

Dave, 
No worries about raining on my parade.
I figured it was probably a preferences issue. I did check the account and
it was marked income & expense not credit. So I changed it to credit. So
that shows the balance correctly as a negative (which I overlooked). Also it
is positioned correctly as a liability account and is not a sub account.
But yes it still does not solve the problem because the reconciled amount
now is simply a positive $195.14 difference.
Agreed, indeed after I celebrated for a few moments I too realized that that
could not be the solution since the prior month was balanced. 
Well tomorrow is another day. I will attack it again then. 
Thanks for your continued thoughts on this.



-
China Blue
--
View this message in context: 
http://gnucash.1415818.n4.nabble.com/Reconciling-an-account-tp4691993p4692066.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
___
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: Reconciling an account

[David Carlson]

I really hate to rain on your parade...
Check your Edit>Preferences>Accounts>Reverse Balanced Accounts.

I believe the default is labelled Credit, but that means Credit Card,
Payable, Liability
 Equity and Income, and that is probably what is checked in your file.

If that is so, then the balance should be positive, charges would be on the
right and your payments would be on the left as shown, and the
reconciliation is still backwards.

However, if your liability account was a sub-account of an asset account
you might see that behavior???

If that is true, you would need to move it under the Liability umbrella to
make it correct.  What bothers me, though is that you say previous months
were ok.  There was a change in release 2.6.16 that made it impossible to
make that kind of error (if it is, indeed an error), but I do not know how
it handles existing errors of that type.  It may be necessary to revert to
2.6.15 to correct this (see
https://bugzilla.gnome.org/show_bug.cgi?id=603379#c24).

David C


On Tue, Jun 6, 2017 at 6:36 PM, EngineInstitute 
wrote:

> Thanks for that hint David, I did check the running totals in the register
> and I did not find anything but what I did was realize what the source of
> the problem is.
> This is a liability account. In the reconciliation window the funds in
> should create a decrease on the balance and the funds out an increase That
> is it should be subtracting the income and adding the debts Here is the
> correct computation
> 5363.26
> -640.73
> +543.16
> =5265.69 Correct to the statement
>
> GnuCash is doing the opposite:
> 5363.26
> +640.73
> -543.16
> =5460.83
> Difference: ($195.14)
> This is why I am out of balance!
>
> Any ideas on how to correct this calculation error?
>
> BTW thank you a ton to everyone for helping with this horribly sticky
> problem.
>
>
>
>
>
> -
> China Blue
> --
> View this message in context: http://gnucash.1415818.n4.
> nabble.com/Reconciling-an-account-tp4691993p4692063.html
> Sent from the GnuCash - User mailing list archive at Nabble.com.
> ___
> 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: Reconciling an account

[Derek Atkins]

That means your transactions are entered backwards. 
-derek
-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity or typos.

On June 6, 2017 7:36:25 PM EDT, EngineInstitute  wrote:
>Thanks for that hint David, I did check the running totals in the
>register
>and I did not find anything but what I did was realize what the source
>of
>the problem is.
>This is a liability account. In the reconciliation window the funds in
>should create a decrease on the balance and the funds out an increase
>That
>is it should be subtracting the income and adding the debts Here is the
>correct computation
>5363.26
>-640.73
>+543.16
>=5265.69 Correct to the statement
>
>GnuCash is doing the opposite:
>5363.26
>+640.73
>-543.16
>=5460.83
>Difference: ($195.14)
>This is why I am out of balance!
>
>Any ideas on how to correct this calculation error?
>
>BTW thank you a ton to everyone for helping with this horribly sticky
>problem.
>
>
>
>
>
>-
>China Blue
>--
>View this message in context:
>http://gnucash.1415818.n4.nabble.com/Reconciling-an-account-tp4691993p4692063.html
>Sent from the GnuCash - User mailing list archive at Nabble.com.
>___
>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: Reconciling an account

[EngineInstitute]

Thanks for that hint David, I did check the running totals in the register
and I did not find anything but what I did was realize what the source of
the problem is.
This is a liability account. In the reconciliation window the funds in
should create a decrease on the balance and the funds out an increase That
is it should be subtracting the income and adding the debts Here is the
correct computation
5363.26
-640.73
+543.16
=5265.69 Correct to the statement

GnuCash is doing the opposite:
5363.26
+640.73
-543.16
=5460.83
Difference: ($195.14)
This is why I am out of balance!

Any ideas on how to correct this calculation error?

BTW thank you a ton to everyone for helping with this horribly sticky
problem.





-
China Blue
--
View this message in context: 
http://gnucash.1415818.n4.nabble.com/Reconciling-an-account-tp4691993p4692063.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
___
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: Reconciling an account

[EngineInstitute]

Yes, Mark.



-
China Blue
--
View this message in context: 
http://gnucash.1415818.n4.nabble.com/Reconciling-an-account-tp4691993p4692062.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
___
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: Reconciling an account

[David Carlson]

Ok, the next thing to do is to go into your register view and look at the
running total next to each of the transactions that you show in your
images, to see if the value was correctly added or subtracted by GnuCash.
Also set the register view to Transaction Journal to see if there are any
suspicious splits.

There are some sneaky ways that GnuCash can keep some hidden values in
transactions.  In my case, they were all resulting from corrupted scheduled
transactions, and they usually resulted in an entry in the Imbalance
account.

David C

On Tue, Jun 6, 2017 at 5:16 PM, Mark Phillips 
wrote:

> Is your opening balance for this account correct?
>
> Mark
>
> On Tue, Jun 6, 2017 at 2:20 PM, EngineInstitute 
> wrote:
>
> > Yes I tried the manual way using the transaction report to check against
> > both
> > the Gnu reconciliation as well as the statement.  Nothing is obvious.
> > I also checked by applying the filter without the reconciled items and
> what
> > came up are the items in the to be reconciled in the reconcile register.
> > Finally I also did a global search for $195.14 and $97.57 no entries of
> > those amounts.
> > I thought I would upload images so it is easier to discuss.
> > As you can see the dialog shows what it expects as the final amount:
> > $5265.69 (my statement balance)
> > The next is the reconcile page that shows the reconciled balance with a
> > difference of $97.57 (there are no outstanding items past 3/11).
> > After reconciling the totals at the bottom of each white box (funds in
> and
> > funds out) agree with the statement.
> > So why the ($195.14) difference? I note that is double the difference of
> > $97.57 in the pre-reconciled sum.
> > I am sure it is something obvious but I can't for the life of me see it.
> > Dialog1.jpg  > Dialog1.jpg>
> > PreReconciled.jpg
> > 
> > Reconciled.jpg
> > 
> >
> >
> >
> >
> >
> >
> >
> > -
> > China Blue
> > --
> > View this message in context: http://gnucash.1415818.n4.
> > nabble.com/Reconciling-an-account-tp4691993p4692059.html
> > Sent from the GnuCash - User mailing list archive at Nabble.com.
> > ___
> > 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: Reconciling an account

[Mark Phillips]

Is your opening balance for this account correct?

Mark

On Tue, Jun 6, 2017 at 2:20 PM, EngineInstitute 
wrote:

> Yes I tried the manual way using the transaction report to check against
> both
> the Gnu reconciliation as well as the statement.  Nothing is obvious.
> I also checked by applying the filter without the reconciled items and what
> came up are the items in the to be reconciled in the reconcile register.
> Finally I also did a global search for $195.14 and $97.57 no entries of
> those amounts.
> I thought I would upload images so it is easier to discuss.
> As you can see the dialog shows what it expects as the final amount:
> $5265.69 (my statement balance)
> The next is the reconcile page that shows the reconciled balance with a
> difference of $97.57 (there are no outstanding items past 3/11).
> After reconciling the totals at the bottom of each white box (funds in and
> funds out) agree with the statement.
> So why the ($195.14) difference? I note that is double the difference of
> $97.57 in the pre-reconciled sum.
> I am sure it is something obvious but I can't for the life of me see it.
> Dialog1.jpg  Dialog1.jpg>
> PreReconciled.jpg
> 
> Reconciled.jpg
> 
>
>
>
>
>
>
>
> -
> China Blue
> --
> View this message in context: http://gnucash.1415818.n4.
> nabble.com/Reconciling-an-account-tp4691993p4692059.html
> Sent from the GnuCash - User mailing list archive at Nabble.com.
> ___
> 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: Reconciling an account

[EngineInstitute]

Yes I tried the manual way using the transaction report to check against both
the Gnu reconciliation as well as the statement.  Nothing is obvious.
I also checked by applying the filter without the reconciled items and what
came up are the items in the to be reconciled in the reconcile register.
Finally I also did a global search for $195.14 and $97.57 no entries of
those amounts.
I thought I would upload images so it is easier to discuss. 
As you can see the dialog shows what it expects as the final amount:
$5265.69 (my statement balance)
The next is the reconcile page that shows the reconciled balance with a
difference of $97.57 (there are no outstanding items past 3/11).
After reconciling the totals at the bottom of each white box (funds in and
funds out) agree with the statement.
So why the ($195.14) difference? I note that is double the difference of
$97.57 in the pre-reconciled sum.
I am sure it is something obvious but I can't for the life of me see it.
Dialog1.jpg   
PreReconciled.jpg
  
Reconciled.jpg
  







-
China Blue
--
View this message in context: 
http://gnucash.1415818.n4.nabble.com/Reconciling-an-account-tp4691993p4692059.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
___
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: Reconciling an account

[EngineInstitute]

Mike,
I did do it the old way eg: pen and paper and checked so I did not overlook
transpositions by checking my total payments noted in Gnucash against the
statement which agree as well as the credits. And indeed there are no
outstanding amounts for 195.14 or 97.57. 
Since the statement and Gnucash sums agree it is somewhere else.
Thanks for the thought though.



-
China Blue
--
View this message in context: 
http://gnucash.1415818.n4.nabble.com/Reconciling-an-account-tp4691993p4692058.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
___
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: Reconciling an account

[Colin Law]

Have you tried the earlier suggestion of splitting the statement every
few transactions and treating each group of three or four transactions
as a separate statement and reconciling each group separately. Then
you will tie the problem down to three or four so you should be able
to see what is causing the problem.

If you don't understand what I mean then ask again.

Colin

On 6 June 2017 at 01:08, EngineInstitute  wrote:
> Colin,
>
> I was thinking it was a version problem so I updated my software to make
> sure this was not the case.
>
> I love your suggestion. I did not know about the filter option. So I
> implemented it and cleared the reconciled items, then went back to the
> reconcile for that month and all agrees. Yeh for you!
>
> But don't celebrate totally yet. I am at the next and final month to
> reconcile. I go to do the reconcile dialog box and check everything and all
> of the items are ok: date, starting and ending balance all agree with final
> statement. When this happens it should be a cake walk right? Not for me.
>
> I check off all of the credits and debits and compare their totals
> (reflected on the bottom) with the statement and everything is in order yet
> I am faced with a difference of $195.14. This is definitely not correct.
> Have I found a bug?
>
>
>
> -
> China Blue
> --
> View this message in context: 
> http://gnucash.1415818.n4.nabble.com/Reconciling-an-account-tp4691993p4692053.html
> Sent from the GnuCash - User mailing list archive at Nabble.com.
> ___
> 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: Reconciling an account

[Mike or Penny Novack]

On 6/5/2017 8:08 PM, EngineInstitute wrote:

Colin,




  When this happens it should be a cake walk right? Not for me.

I check off all of the credits and debits and compare their totals
(reflected on the bottom) with the statement and everything is in order yet
I am faced with a difference of $195.14. This is definitely not correct.
Have I found a bug?

-
China Blue
--
This is why I keep referring to "the old way, pen and ink on paper". If 
you have no experience doing that (solving discrepancies during hand 
reconciliation) it will be hard to find the problem. No, almost 
certainly not a bug.


It is what you DON'T say that is important. For example, I am not seeing 
you say "and there is no transaction with amount $195.14 or amount 
$97.57 and $195.14 is not divisible by 9" << the first would be a 
transaction not recorded or a date difference, the second a transaction 
recorded on the wrong side, and the third a digit transposition >>


However -- since you are using the tool other people should be helping 
you << I lack access to private/secure broadband and so reconcile more 
like the old fashioned way --- all the organizations for which I keep 
books are low volume, typically less than a dozen checks plus deposits a 
month, so not hard by hand >>


Michael D Novack
___
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.