[GNC] Reconciliation is not adding up correctly - what to do??

[Finbar Mahon]

I don't understand where you are seeing the figures you describe.  Can
you post a screenshot showing it?

This what I get at the bottom right hand side.

On 24/01/2019 17:51, D wrote:
> As noted in the Tutorial, the opening balance in a reconciliation is immaterial. What matters is the ending balance. If they match, then you can finish reconciliation.
>
> The Tutorial explains some of the circumstances that might cause an opening balance not to match.
>
> David T.
>
> On January 24, 2019, at 9:30 PM, Colin Law <clanlaw at gmail.com> wrote:
>
> On Thu, 24 Jan 2019 at 13:59, Finbar Mahon <mahon.finbar at neuf.fr> wrote:
>> I understand the logic of what you describe, but, I started using
>> GNUCash with effect from 1.1.2018.
>>
>> The opening balance on the bank statement for one of the asset a/c was
>> €3,986.22 and the ending balance on 16.2.2018 was €5,117.09
>>
>> Gnucash shows the ending balance as €5,117.02 but the reconcile shows
>> another figure of €1,674.47 as the opening balance (bottom right hand
>> side) while the left hand panel (funds in) shows the correct opening
>> balance....
> When you start a reconcile it should show the opening balance the same
> as on your bank statement and you should manually enter the ending
> balance to the value it shows on the bank statement.  Are you doing
> that?
>
> I don't understand where you are seeing the figures you describe.  Can
> you post a screenshot showing it?
>
> Colin
>
>> The outcome of the reconcile is the same as the opening balance above
>> but now it is -ve!!
>>
>> Confused :-(
>>
>> On 19/01/2019 22:26, David Cousens wrote:
>>> The reconciliation procedure works fine for me  on several bank accounts, my
>>> credit card and paypal accounts in V2.6.19 and earlier, V3.1, V3.2, V3.3 and
>>> V3.4 provided previous reconciliations of the account were correct and no
>>> transactions have been accidentally unreconciled.
>>>
>>> In the example you quote you have a starting difference of 72.15. The net
>>> movement of 72.15  and an end balance of 144.30 which is as it should be:
>>>
>>> closing balance = starting balance +funds in -funds out
>>> 144.30 = 72.15 + 331.12 - 258.97 = 114.30
>>>
>>> You can only get a reconciliation difference of 0 if the starting balance
>>> (generated by previous reconciliation) is actually the balance in your
>>> account at the specified start date. AFAIK the starting balance shown in the
>>> dialog is the reconciled balance at the end of the last reconciled period.
>>> Any changes made to reconciled transactions before that date after they have
>>> been reconciled will change the actual starting balance in the account from
>>> the reconciled value. I think it was possible to make changes to reconciled
>>> transactions in one register by editing one of the other splits to the
>>> transaction in some earlier versions of GnuCash and this automatically
>>> unreconciled the transaction. I think recent changes only unreconcile a
>>> transaction if specific information about the transaction and/or the amount
>>> of the split affecting the reconciled account are changed but not sure
>>> whether this is the case for the current release or not.
>>>
>>> First thing to check is for any unreconciled transactions before the start
>>> date of the reconciliation you are having problems with. If you find any go
>>> back and redo the reconciliations forward from the period which contained
>>> the unreconciled transaction to make sure everything is correct. The
>>> starting difference of 72.15 being the same as the difference in funds in
>>> and funds out suggests some sort of regular transaction for 72.15 might be
>>> unrecorded or unreconciled.
>>> Good luck
>>>
>>> David Cousens
>>>
>>>
>>>
>>> -----
>>> David Cousens
>>> --
>>> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
>>> _______________________________________________
>>> gnucash-user mailing list
>>> gnucash-user at 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 at 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 at 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.