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

2019-01-29 Thread Maf. King
Hi Finbar. I've been following this thread, but got lost in it. Starting again seems like a good idea. More comments in line... On Tuesday, 29 January 2019 11:24:36 GMT Finbar Mahon wrote: > OK, let's go again. > > 1. I started using GNUCash with effect from 1.1.2018 > > 2. For this

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

2019-01-29 Thread Colin Law
On Tue, 29 Jan 2019 at 11:24, Finbar Mahon wrote: > > OK, let's go again. > > 1. I started using GNUCash with effect from 1.1.2018 > > 2. For this particular a/c the figure €3986.22 is the balance in the a/c, > taken from the bank statement on 28.12.2017, after the last transaction on > that

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

2019-01-29 Thread Finbar Mahon
OK, let's go again. 1. I started using GNUCash with effect from 1.1.2018 2. For this particular a/c the figure €3986.22 is the balance in the a/c, taken from the bank statement on 28.12.2017, after the last transaction on that date. 3. I had a non-zero opening balance, in the sense that I

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

2019-01-28 Thread Colin Law
There is also the issue that at one point he seemed to suggest this was the first reconcile, then he said he didn't do any reconciles till December. The only way we will understand what is going on is if he is clearer on exactly what he has done. Colin On Mon, 28 Jan 2019 at 14:45, David T. via

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

2019-01-28 Thread David T. via gnucash-user
> On Jan 28, 2019, at 7:28 PM, Adrien Monteleone > wrote: > > David, > > I understand perfectly what you are saying. My point was I read the post to > be a confusion in terms. I understood the OP to mean ‘opening balance’ to > mean the opening balance transaction in the account, *not* the

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

2019-01-28 Thread Adrien Monteleone
David, I understand perfectly what you are saying. My point was I read the post to be a confusion in terms. I understood the OP to mean ‘opening balance’ to mean the opening balance transaction in the account, *not* the ’starting balance’ of the reconciliation. In fact, Gnucash uses the term

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

2019-01-28 Thread David T. via gnucash-user
Adrien, > On Jan 28, 2019, at 6:47 PM, Adrien Monteleone > wrote: > > I could be wrong, but I read “opening balance” to mean the balance when the > account was created in GnuCash, not the “starting balance” for the > reconciliation. Certainly, when you first create an account, you have to

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

2019-01-28 Thread Adrien Monteleone
I could be wrong, but I read “opening balance” to mean the balance when the account was created in GnuCash, not the “starting balance” for the reconciliation. Certainly, when you first create an account, you have to tell GnuCash how much is already in the account if it pre-existed. It could be

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

2019-01-28 Thread David T. via gnucash-user
There is a lot to unpack here.  You say you started at the beginning of 2018 and entered "the closing balance for 2017."  Was that balance taken from a statement? Or just from the bank website as of that date?  I can't see how any of the various numbers (the numbers on the screen grab or

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

2019-01-28 Thread Colin Law
On Mon, 28 Jan 2019 at 10:23, Finbar Mahon wrote: > ... > > Aha, maybe there is another issue. When I do, as you suggested, View > > Filter By > Status > Reconciled I get nothing!! even when I just chose > 'reconcile' or 'select all' > On the Date tab (of View > Filter By) have you got Show

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

2019-01-28 Thread Finbar Mahon
OK, As I said, I started on 1.1.2018 with 'nothing' I entered the closing balance for 2017 for the a/c and started entering transactions. Unfortunately, coming from Quicken, I didn't do any reconciliations until about December. But casually examining the entries from time to time they

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

2019-01-27 Thread Colin Law
On Sun, 27 Jan 2019 at 10:01, Fred Bone wrote: > > On Saturday, January 26, 2019 at 21:50, Colin Law said: > > > In the original message, in the html section, the image is > > > > > height="00145" border="0"> > > > > I guess that means it is an image on the senders mail server. > >

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

2019-01-27 Thread Fred Bone
On Saturday, January 26, 2019 at 21:50, Colin Law said: > In the original message, in the html section, the image is > > height="00145" border="0"> > > I guess that means it is an image on the senders mail server. No it doesn't. The cid= indicates that this is a multipart message

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

2019-01-27 Thread Colin Law
On Sun, 27 Jan 2019 at 09:36, Finbar Mahon wrote: > No, as I said in the original post, I started on 1.1.2018 with GNU, so the > first entry in this a/c should be the opening balance for the a/c from the > bank statement, €3986.22. The ending balance is correct. > Actually you still haven't

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

2019-01-27 Thread Finbar Mahon
No, as I said in the original post, I started on 1.1.2018 with GNU, so the first entry in this a/c should be the opening balance for the a/c from the bank statement, €3986.22. The ending balance is correct. Finbar On 26/01/2019 18:12, Colin Law wrote: Do the starting and ending balances shown

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

2019-01-26 Thread Colin Law
In the original message, in the html section, the image is I guess that means it is an image on the senders mail server. Colin On Sat, 26 Jan 2019 at 18:42, Adrien Monteleone wrote: > > Curious. I frequently can’t see attachments, sometimes including my own (and > so gave up attaching and

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

2019-01-26 Thread Adrien Monteleone
Curious. I frequently can’t see attachments, sometimes including my own (and so gave up attaching and just using img.ur) I wonder now if this is a failing of Mail.app or my ISP. Wonderful, yet another rabbit hole to dive down...but thanks for the compass directions Regards, Adrien > On Jan

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

2019-01-26 Thread Colin Law
On Sat, 26 Jan 2019 at 18:16, Adrien Monteleone wrote: > > Strange how the OP’s post doesn’t show the screenshot, but it is visible in > your reply... I can see it in the original in gmail web i/f, but I am not sure how it is included. My reply seems to have converted it to an attached image.

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

2019-01-26 Thread Adrien Monteleone
Strange how the OP’s post doesn’t show the screenshot, but it is visible in your reply... Presuming the ending balance is from the statement, perhaps the OP is ticking off transactions beyond those necessary to reconcile? Regards, Adrien > On Jan 26, 2019, at 11:12 AM, Colin Law wrote: > >

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

2019-01-26 Thread Colin Law
Do the starting and ending balances shown there match the ones on the bank statement you are reconciling against? Colin On Sat, 26 Jan 2019 at 11:51, Finbar Mahon wrote: > I don't understand where you are seeing the figures you describe. Can > you post a screenshot showing it? > > This what I

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

2019-01-26 Thread 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

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

2019-01-24 Thread Larry Long
If your reconciliation is not balancing, it might be worth a quick scan to ensure that any items that you know were reconciled previously are still registered as "cleared". Over the past year [v3.4, Win10], I've had several occasions where my reconciliation for a credit card or bank account

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

2019-01-24 Thread Colin Law
On Thu, 24 Jan 2019 at 16:52, 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. It is not immaterial in the sense that if it does not match that from the bank

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

2019-01-24 Thread D via gnucash-user
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,

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

2019-01-24 Thread Colin Law
On Thu, 24 Jan 2019 at 13:59, Finbar Mahon 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 > >

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

2019-01-24 Thread Finbar Mahon
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

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

2019-01-23 Thread Adrien Monteleone
Sorry to break this to you after the fact, but GnuCash could have moved all those transactions for you in a second or two. In the future: 1. Create new account 2. Delete old account 3. When GnuCash asks you what to do with all those transactions, tell it the new account to move them to.

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

2019-01-20 Thread Stephen M. Butler
On 1/20/19 10:39 AM, Mike Stillingfleet wrote: > I absolutely cannot account for this. But I repeated my tests after > your post. I set up another new dummy cc account and tested a > reconciliation. It worked!!! > > I then went back to my cc account. It still didn't work.  > > I then set up

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

2019-01-20 Thread Mike Stillingfleet
; > > Sent from my Verizon, Samsung Galaxy smartphone > > Original message > From: john_mike > Date: 1/19/19 09:38 (GMT-08:00) > To: gnucash-user@gnucash.org > Subject: Re: [GNC] Reconciliation is not adding up correctly - what to do?? > > I have

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

2019-01-19 Thread David Cousens
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

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

2019-01-19 Thread David Carlson
--From: john_mike < > mikestillingfl...@fastmail.co.uk> Date: 1/19/19 09:38 (GMT-08:00) To: > gnucash-user@gnucash.org Subject: Re: [GNC] Reconciliation is not adding > up correctly - what to do?? > I have done several tests today. > > I have set number various fake ac

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

2019-01-19 Thread stephen.m.butler51
is not adding up correctly - what to do?? I have done several tests today. I have set number various fake accounts with type credit card. I all cases the reconciliation does not work. In every case the opening balance, ending balance, in's and outs have been correctly entered and very carefully checked

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

2019-01-19 Thread john_mike
I have done several tests today. I have set number various fake accounts with type credit card. I all cases the reconciliation does not work. In every case the opening balance, ending balance, in's and outs have been correctly entered and very carefully checked. But in each case it was

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

2019-01-19 Thread Maf. King
On Saturday, 19 January 2019 10:21:52 GMT john_mike wrote: > Hi, > > I have just reconciled a number of account perfectly normally but now I am > having a problem. > > I have moved on to a different account and the reconciliation totals are not > adding up correctly. > > The account opening

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

2019-01-19 Thread john_mike
Hi, I have just reconciled a number of account perfectly normally but now I am having a problem. I have moved on to a different account and the reconciliation totals are not adding up correctly. The account opening balance was negative. I cleared funds into the account but instead of the