[GNC] Reconciliation is not adding up correctly - what to do??
Finbar Mahon
mahon.finbar at neuf.fr
Thu Jan 24 08:57:00 EST 2019
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....
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.
>
More information about the gnucash-user
mailing list