Opening balance reconciling investment account incorrect.

Tue Nov 12 20:36:10 EST 2013

Harold--

I'm not sure what exactly you are saying. While it may be confusing to manually un-reconcile transactions, it is not irreversible. You just have to ignore the value in the opening balance on the initial reconcile dialogue and then make sure that you get all the correct transactions selected in the subsequent reconcile window. Once that first reconciliation is completed, later iterations of the reconcile process should match your statements.

If you look at section 4.5 of the guide, it discusses these issues. I note especially 4.5.1, which describes the initial reconcile window, and includes the following:

Note
Sometimes, the opening balance in GnuCash does not match that found on your statement. This can happen the first time you reconcile your account or when a previously-reconciled transaction is de-reconciled or deleted. The first time you reconcile your account, the starting balance will be 0.00, thus probably not the opening balance of your account. When you reconcile the account, the opening balance for the account will be included in the reconciliation, and the result should balance. 
In the case when a previously-reconciled transaction is accidentally de-reconciled, you can simply re-reconcile the transaction along with the transactions on the current statement, and the result should balance.
The case of accidentally deleting a previously-reconciled transaction presents more of a challenge; if you cannot determine what was deleted and restore it to the register, you will have to create a dummy transaction to get the reconciliation to finish.

HTH,
David

________________________________
 From: hnaparst <harold at alum.mit.edu>
To: gnucash-user at gnucash.org 
Sent: Monday, November 11, 2013 1:20 PM
Subject: Re: Opening balance reconciling investment account incorrect.

My problem was simply that I had unreconciled all the transactions after
importing them.  This is a no-no in Gnucash.  The only way to get a zero
opening balance is not to touch anything before starting the reconciliation.

I deleted the entire account and then re-imported.  The first thing I did
after that was a reconciliation, which worked.

There needs to be a big warning in the documentation that you shouldn't
change the reconciliation status of a transaction manually or you will
enter a state that you cannot recover from.

There are certainly a lot of other problems for the Gnucash developers to
be working on, such as the 141 open import-related bugs.

Thanks for your response.

On Mon, Nov 11, 2013 at 9:10 PM, David T. [via GnuCash] <
ml-node+s1415818n4665394h29 at n4.nabble.com> wrote:

> Harold—
>
> The only explanation is that there is somewhere in your GnuCash data file
> a transaction that has been reconciled. I say this because GnuCash
> calculates the opening balance in the reconcile window from all the
> reconciled transactions. I think there are two possibilities here:
>
> 1) you are not viewing all the transactions in the file, which can happen
> if you have set your register to filter out transactions before a certain
> date (as, for example when viewing data in the General Ledger register), or
>
> 2) you have a transaction at some later date that has been reconciled.
> Contrary to typical user expectations, transactions with later dates in the
> file with a reconciled status will be included in the starting balance.
>
> I am not sure what your situation might be.
>
> David
>
> On Nov 11, 2013, at 4:23 AM, hnaparst <[hidden email]<http://user/SendEmail.jtp?type=node&node=4665394&i=0>>
> wrote:
>
> > I am trying out Gnucash 2.4.13.  I am trying to move an investment
> account
> > from Quicken.  All the transactions have imported correctly using a QIF
> > import.  Now I am trying to reconcile the account.
> >
> > First thing I did was to mark all transactions in Gnucash as not
> reconciled,
> > including all the splits.  The initial balance in the account is zero.
> >
> > When I begin the reconciliation, however, Gnucash shows the opening
> balance
> > as a non-zero number, which is incorrect.  I have read section 4.5.1 of
> the
> > manual, as well as bug 639264.
> >
> > I do not understand why the opening balance is incorrect in the
> reconcile
> > window, and I do not understand how to fix it.
> >
> > Kind Regards.
> >
> >
> >
> >
> > --
> > View this message in context:
> http://gnucash.1415818.n4.nabble.com/Opening-balance-reconciling-investment-account-incorrect-tp4665391.html
> > Sent from the GnuCash - User mailing list archive at Nabble.com.
> > _______________________________________________
> > gnucash-user mailing list
> > [hidden email] <http://user/SendEmail.jtp?type=node&node=4665394&i=1>
> > 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
> [hidden email] <http://user/SendEmail.jtp?type=node&node=4665394&i=2>
> 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.
>
>
> ------------------------------
>  If you reply to this email, your message will be added to the discussion
> below:
>
> http://gnucash.1415818.n4.nabble.com/Opening-balance-reconciling-investment-account-incorrect-tp4665391p4665394.html
>  To unsubscribe from Opening balance reconciling investment account
> incorrect., click here<http://gnucash.1415818.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4665391&code=aGFyb2xkQGFsdW0ubWl0LmVkdXw0NjY1MzkxfDUxMDIxOTA5>
> .
> NAML<http://gnucash.1415818.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>

--
View this message in context: http://gnucash.1415818.n4.nabble.com/Opening-balance-reconciling-investment-account-incorrect-tp4665391p4665395.html

Sent from the GnuCash - User mailing list archive at Nabble.com.
_______________________________________________
gnucash-user mailing list
gnucash-user at 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.