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

Colin Law clanlaw at gmail.com
Thu Jan 24 10:58:54 EST 2019


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.


More information about the gnucash-user mailing list