[GNC] Gnucash leadership team
Michael Stagl
Michael.Stagl at wnco.com
Thu Jan 31 12:12:37 EST 2019
How do you know Quicken is going to stay around for the long haul?
As with anything important, have data backups, and have a backup plan as well. Be ready for the day either stops functioning.
The Free and Open Source community as a whole is amazingly brilliant and robust, albeit politics and egos can interfere from time to time. Closed source software works at the whim of the marketing department. Nothing is perfect
> On Jan 31, 2019, at 9:42 AM, Cricket Onebit <cricketbeautiful at gmail.com> wrote:
>
> Hello,
>
> Before I commit to a very large conversion from Quicken, I want to know
> that GnuCash will continue to be around and maintained.
>
> Is the core leadership team large enough that a single life event (eg new
> job, new baby, sabbatical, too many changes needed because of an OS
> upgrade) will stop maintenance?
>
> The help community is clearly large and active, with support for all levels
> of users and types of problems.
>
>> On Wed, Jan 30, 2019, 12:00 PM <gnucash-user-request at gnucash.org wrote:
>>
>> Send gnucash-user mailing list submissions to
>> gnucash-user at gnucash.org
>>
>> To subscribe or unsubscribe via the World Wide Web, visit
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> or, via email, send a message with subject or body 'help' to
>> gnucash-user-request at gnucash.org
>>
>> You can reach the person managing the list at
>> gnucash-user-owner at gnucash.org
>>
>> When replying, please edit your Subject line so it is more specific
>> than "Re: Contents of gnucash-user digest..."
>>
>>
>> Today's Topics:
>>
>> 1. Re: Migrating from AceMoney (aeg)
>> 2. Re: v 3.2.1 reconcile window (Jamestk)
>> 3. Re: Migrating from AceMoney (Fred Bone)
>> 4. Re: v 3.2.1 reconcile window (Adrien Monteleone)
>> 5. Re: Migrating from AceMoney (Adrien Monteleone)
>> 6. Re: v 3.2.1 reconcile window (D)
>> 7. Re: Upgrade Path from version 2.6.16 on MacOS High Sierra
>> (10.13.6) and beyond (Michael Hendry)
>> 8. Re: Reconciliation is not adding up correctly - what t
>> (Finbar Mahon)
>> 9. Re: Reconciliation is not adding up correctly - what t
>> (Colin Law)
>>
>>
>> ----------------------------------------------------------------------
>>
>> Message: 1
>> Date: Tue, 29 Jan 2019 21:32:34 +0000 (UTC)
>> From: aeg <aeg21212-forum at yahoo.com>
>> To: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>, Jason Voss
>> <jasonvos at swbell.net>
>> Subject: Re: [GNC] Migrating from AceMoney
>> Message-ID: <1019973028.5554122.1548797554670 at mail.yahoo.com>
>> Content-Type: text/plain; charset=UTF-8
>>
>> Hi Jason,
>> I've been using AceMoney for my personal accounts since 2005 and like it
>> very much but I also started using GnuCash two or three years ago for a
>> family house-building project and, for that purpose, it has been more
>> useful than AceMoney.
>> I recently started running personal accounts on GnuCash in parallel with
>> AceMoney in order to check which suits my needs best.
>> The way I transferred data from AceMoney to GnuCash was via csv (because
>> they can be edited easily in Excel). The first transfer did not work very
>> well because I was unsure about the process and, in particular, which field
>> names to use. Once I had figured it out and deleted those first attempts,
>> importing became quite straightforward, although I did find it necessary to
>> edit amounts that did not have a decimal point as GnuCash divides such
>> amounts by 100.? It was easier to do that edit in Excel than in GnuCash.
>> I agree with David's comments (copied below) recommending that you limit
>> the number of files imported initially while GnuCash learns how you want
>> them assigned.
>> Kind regards,Alan
>> Quoted texts below...
>> From: Jason Voss <jasonvos at swbell.net>
>>
>> My wife stayed on Windows much longer than I did but I have recently moved
>> her to a MacBook Air.Now I'm trying to get her a basic checkbook register
>> app to replace AceMoney Lite and I'm looking at Gnucash for this purpose.
>> We have several years of historical data in .amj files on a Network
>> Attached Server (NAS) and I'd like to verify whether Gnucash can read
>> these, or if they can be imported and then used by Gnucash.
>> Any insights or advice is much appreciated.
>> Thanks,Jason
>>
>> ------------------------------
>>
>>
>> From: David Cousens <davidcousens at bigpond.com>
>>
>> Jason
>>
>> AceMoney does not list any export formats in its documentation.? GnuCash
>> will not be able to read AceMoneys file format unless someone has written a
>> translator and this is unlikely.
>>
>> GnuCash can import OFX/QFX, QIF, CSV files if Acemoney can export data in
>> any of these formats. OFX/QFX is generally the most reliable if the OFX/QFX
>> formats have been correctly implemented in the export. Another factor is
>> what information exists in any exported data. It is generally better to
>> export data for a specific period, e.g. a month or quarter and import the
>> data in batches in sequence. Also if you start with your major Asset and
>> Liability accounts, i.e.? with the largest number of transactions, first it
>> will make importing easier as this will import most or all of the data for
>> income, expense and equity account.
>>
>> GnuCash's importers have a matching algorithm, which for imports to a given
>> account, looks for matches in data already in the GnuCash file to existing
>> transactions to minimise duplication and also matches and automatically
>> assigns the second account in a transaction if enough information is
>> present
>> to allow this. It uses a Bayesian algorithm which is trained by the data
>> you
>> have already imported to match transaction.? It is generally better to
>> import transactions, at least initially, in small batches, as this makes it
>> easier to detect mismatches in imported data and "train" the automatic
>> matching and assignment of the second account of a transaction. Any
>> automatic assignment by the matcher can be overridden before importing. It
>> pays to check the account assignment data (displayed in a window) before
>> importing as importing incorrect assignments will not train the algorithm
>> correctly which results in less successful matching in future imports.
>>
>> Another suggestion is to perhaps start using current data and then
>> gradually
>> add your historical data. GnuCash can set opening balances for accounts at
>> a
>> specified date. This can be edited to the opening balance at an earlier
>> date
>> as you import your historical data. The opening balances are just another
>> transaction.
>>
>> David Cousens
>>
>>
>>
>>
>> ------------------------------
>>
>> Message: 2
>> Date: Tue, 29 Jan 2019 15:41:44 -0600 (CST)
>> From: Jamestk <davidjamestk at hotmail.co.uk>
>> To: gnucash-user at gnucash.org
>> Subject: Re: [GNC] v 3.2.1 reconcile window
>> Message-ID: <1548798104162-0.post at n4.nabble.com>
>> Content-Type: text/plain; charset=us-ascii
>>
>> If you click on this thread link, then click *GNUCash-user* in top menu it
>> brings up a second blank tab called 'about blank' or, on occasions the
>> resume ad as mentioned.
>>
>>
>> http://gnucash.1415818.n4.nabble.com/Archiving-Records-To-Improve-Performance-td4692560.html
>>
>> I seem to remember this happening before.
>>
>>
>>
>>
>> ---------------------------------
>>
>> Which website? Give us the URL where you got it.
>>
>> Colin
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user@
>> 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.
>>
>>
>>
>>
>>
>> --
>> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
>>
>>
>> ------------------------------
>>
>> Message: 3
>> Date: Tue, 29 Jan 2019 21:42:50 -0000
>> From: "Fred Bone" <Fred.Bone at dial.pipex.com>
>> To: gnucash-user at gnucash.org
>> Subject: Re: [GNC] Migrating from AceMoney
>> Message-ID: <5C50C8DA.28150.2B7636BA at Fred.Bone.dial.pipex.com>
>> Content-Type: text/plain; charset=US-ASCII
>>
>> On Tuesday, January 29, 2019 at 12:44, Adrien Monteleone said:
>>
>>> Try setting up sub-folders and mail filters. That might help at least
>>> shunt the mail off out of your main inbox till you can look over it.
>>>
>>> I also commented in the other thread you can select digest mode, which
>>> will give you one message per day, but is more difficult to follow
>> threads
>>> and reply.
>>
>> Are you kidding? Eight digests on the 26th; five so far today (the sixth
>> arrived as I was reading this one). There is a size limit (50k or
>> thereabouts, it seems). And people quoting entire conversations don't
>> help.
>>
>>
>>
>> ------------------------------
>>
>> Message: 4
>> Date: Tue, 29 Jan 2019 15:46:18 -0600
>> From: Adrien Monteleone <adrien.monteleone at lusfiber.net>
>> To: Gnucash Users <gnucash-user at gnucash.org>
>> Subject: Re: [GNC] v 3.2.1 reconcile window
>> Message-ID: <620315E9-EA50-4730-BB46-FF1977ACCB64 at lusfiber.net>
>> Content-Type: text/plain; charset=utf-8
>>
>> That is nabble, a mirror site for the mailing list. It is not run by the
>> GnuCash team and is independently maintained.
>>
>> If you?d prefer to avoid that site, you can subscribe directly to the
>> mailing list and handle the messages via your mail client.
>>
>> Regards,
>> Adrien
>>
>>> On Jan 29, 2019, at 3:41 PM, Jamestk <davidjamestk at hotmail.co.uk> wrote:
>>>
>>> If you click on this thread link, then click *GNUCash-user* in top menu
>> it
>>> brings up a second blank tab called 'about blank' or, on occasions the
>>> resume ad as mentioned.
>>>
>>>
>> http://gnucash.1415818.n4.nabble.com/Archiving-Records-To-Improve-Performance-td4692560.html
>>>
>>> I seem to remember this happening before.
>>>
>>
>>
>>
>>
>> ------------------------------
>>
>> Message: 5
>> Date: Tue, 29 Jan 2019 15:48:32 -0600
>> From: Adrien Monteleone <adrien.monteleone at lusfiber.net>
>> To: Gnucash Users <gnucash-user at gnucash.org>
>> Subject: Re: [GNC] Migrating from AceMoney
>> Message-ID: <F26D1263-B3EA-4B8E-AC11-9EB63F4B7592 at lusfiber.net>
>> Content-Type: text/plain; charset=utf-8
>>
>> Sorry. I thought it was a one-per-day sort of thing. I didn?t think of
>> size limits. I used to use digest mode and some days there was no activity
>> at all. I guess it just depends on how many people are actively
>> participating, and then combine that with those who quote without trimming.
>>
>> The only other solution then would be custom mail filters.
>>
>> Regards,
>> Adrien
>>
>>> On Jan 29, 2019, at 3:42 PM, Fred Bone <Fred.Bone at dial.pipex.com> wrote:
>>>
>>>
>>> Are you kidding? Eight digests on the 26th; five so far today (the sixth
>>> arrived as I was reading this one). There is a size limit (50k or
>>> thereabouts, it seems). And people quoting entire conversations don't
>>> help.
>>
>>
>>
>>
>> ------------------------------
>>
>> Message: 6
>> Date: Wed, 30 Jan 2019 06:41:09 +0530
>> From: D <sunfish62 at yahoo.com>
>> To: Adrien Monteleone <adrien.monteleone at lusfiber.net>, Gnucash Users
>> <gnucash-user at gnucash.org>
>> Subject: Re: [GNC] v 3.2.1 reconcile window
>> Message-ID: <chovn4ds305f9486nqylj6if.1548810669653 at email.android.com>
>> Content-Type: text/plain; charset=utf-8
>>
>> No. He's talking about nabble.
>>
>> James, NNG (Nabble's Not GnuCash). You can subscribe to gnucash-user
>> directly, and then your resume can remain your own business.
>>
>> David T.
>>
>> On January 30, 2019, at 12:25 AM, Adrien Monteleone <
>> adrien.monteleone at lusfiber.net> wrote:
>>
>> Are you talking about GnuCash or SourceForge?
>>
>> I normally run my browser with uBlock Origin and/or NoScript so I don?t
>> get any of those issues.
>>
>> Regards,
>> Adrien
>>
>>> On Jan 29, 2019, at 12:42 PM, Jamestk <davidjamestk at hotmail.co.uk>
>> wrote:
>>>
>>>
>>>
>>> Thanks, with you now.
>>>
>>> Just downloaded v3.4, it's probably nothing but maybe worth flagging up-
>>> Virus Total flags the exe file as - suspicious.low.ml.score - by Trapmine
>>> engine.
>>>
>>> Also, has anyone noticed the second page which pops up after accessing
>> this
>>> web site offering resumes and CV's?
>>>
>>> One of the ads on this page is running a script to launch another tab
>> within
>>> Chrome, naughty ..
>>>
>>>
>>>
>>> Adrien Monteleone-2 wrote
>>>> Sorry I wasn?t clear. I know about the button, I just don?t recall if it
>>>> was visible or functional in 3.2. I?m currently on 3.4 and it is there
>> and
>>>> works as expected. (the icon looks like a left arrow with 2 dots for the
>>>> arrow stem)
>>>>
>>>> If you want the Green Tick icon to work, you?ll need to upgrade to 3.3
>> or
>>>> 3.4. It does not work in 3.2 as I mentioned. (the same may be the case
>> of
>>>> the ?Postpone? button)
>>>>
>>>> Also, 3.3 re-introduced button labels for all icons so you don?t have to
>>>> guess what they do or try to remember their function. (or hover for
>>>> tooltips)
>>>>
>>>> Regards,
>>>> Adrien
>>>>
>>>>> On Jan 29, 2019, at 10:09 AM, Jamestk <
>>>
>>>> davidjamestk at .co
>>>
>>>> > wrote:
>>>>>
>>>>> Thanks Adrian,
>>>>>
>>>>> Toggling the green tick button on/off doesn't appear to change the
>> ticked
>>>>> entry status (as before) - from memory register have another symbol to
>>>>> signify pending
>>>>>
>>>>> From help tutorial -
>>>>>
>>>>> "In this case, we have not received all the information yet, so we
>> simply
>>>>> press the Postpone button, so we can continue at a later stage. Observe
>>>>> that
>>>>> the R column indicates we cleared (c) two transactions. They have not
>>>>> been
>>>>> reconciled yet, but we have verified these two transactions so they
>> have
>>>>> been marked as cleared."
>>>>>
>>>>> https://www.gnucash.org/docs/v3/C/gnucash-guide/txns-reconcile1.html
>>>>
>>>> _______________________________________________
>>>> gnucash-user mailing list
>>>
>>>> gnucash-user@
>>>
>>>> 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.
>>>
>>>
>>>
>>>
>>>
>>> --
>>> 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.
>>
>> ------------------------------
>>
>> Message: 7
>> Date: Wed, 30 Jan 2019 10:42:06 +0000
>> From: Michael Hendry <hendry.michael at gmail.com>
>> To: John Ralls <jralls at ceridwen.us>
>> Cc: Adrien Monteleone <adrien.monteleone at lusfiber.net>, Gnucash Users
>> <gnucash-user at gnucash.org>
>> Subject: Re: [GNC] Upgrade Path from version 2.6.16 on MacOS High
>> Sierra (10.13.6) and beyond
>> Message-ID: <9A8F874A-C6A2-4B9C-B104-3E4410CC54C6 at gmail.com>
>> Content-Type: text/plain; charset=us-ascii
>>
>>> On 29 Jan 2019, at 18:50, John Ralls <jralls at ceridwen.us> wrote:
>>>
>>> I just uploaded a new Gnucash-Intel-2.6.21-3.dmg to both SourceForge and
>> Github with a re-signed app. It validates successfully for me but I got a
>> different spctl error from Michael's.
>>>
>>> I've also updated the SHA-256 (which changed anyway with the re-sign)
>> and the filename in both places.
>>>
>>> Regards,
>>> John Ralls
>>
>> Thanks, John.
>>
>> I succeeded in downloading, installing and running 2.6.21-3 this morning.
>>
>> When I ran it for the first time, I was warned (as expected) that it is a
>> 32-bit application.
>>
>> Michael.
>>
>> ------------------------------
>>
>> Message: 8
>> Date: Wed, 30 Jan 2019 12:58:00 +0100
>> From: Finbar Mahon <mahon.finbar at neuf.fr>
>> To: "sunfish62 at yahoo.com" <sunfish62 at yahoo.com>, Gnucash Users
>> <gnucash-user at gnucash.org>
>> Subject: Re: [GNC] Reconciliation is not adding up correctly - what t
>> Message-ID: <ab5b0ffa-cd58-8316-b9a4-e73fb8e1d3b8 at neuf.fr>
>> Content-Type: text/plain; charset=utf-8; format=flowed
>>
>> Thanks for all that. There may have been some transactions before
>> 28.12.2017 which 'snuck' in and were deleted, that is possible and might
>> explain the non zero start point.
>>
>> I saw in another post a query on whether a filtered view could show
>> deleted transaction, if there is a possibility I may be able to find the
>> 'culprits'
>>
>> Apropos the centimes, I appreciate your point, but I can use the option
>> to enter a reconciliation amendment to cover them....
>>
>> As I said, I'll soldier on with the view option and hopefully find the
>> errors. I have made a new years resolution to do reconciliations more
>> often :-)
>>
>> Many, many thanks for the observations and advice.
>>
>> Finbar
>>
>>> On 29/01/2019 12:59, David T. wrote:
>>> Finbar,
>>>
>>> On Tue, Jan 29, 2019 at 16:54, Finbar Mahon
>>> <mahon.finbar at neuf.fr> wrote:
>>>
>>> 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.
>>>
>>> That clarifies this issue.? You created a transaction in the
>>> amount of 3986.22, presumably from Equity into Checking.
>>>
>>> Did you perform any reconciliation at this point?
>>>
>>> 3. I had a non-zero opening balance, in the sense that I created
>>> (named) the a/c in Gnucash and then started with the figure above,
>>> so that I could continue from the previous a/c into 2018. Should I
>>> have ignored the opening balance, the amount in the bank on
>>> 28.12.2017??
>>>
>>> No, entering an opening balance transaction is necessary for
>>> practically everything.? It's what happens at reconciliation that
>>> is messed up...
>>>
>>> 5. The numbers on the screen grab are exactly what my problem is.
>>>
>>> And I agree, but probably not for the same reason as you. My
>>> problem is that your reconcile window shows a non zero starting
>>> balance.? Gnucash calculates this amount from the transaction data
>>> directly, counting up all the transactions that have been
>>> reconciled before. So, the first time you reconcile an account, it
>>> should be zero. (Indeed, the first reconciliation starting balance
>>> merits a specific mention in the Guide)
>>>
>>> The fact that your window shows something else there means that
>>> there is something else going on.
>>>
>>> ?I appreciate that a 'perfect' reconciliation should have no
>>> 'loose' centimes, but if the figures are within that sort of
>>> limit, I don't worry, I am not auditing a multinational.
>>>
>>> Again, while it might not bother you, Gnucash will not allow you
>>> to finish reconciliation until the numbers match exactly.
>>>
>>>
>>> Thanks again for your patience.
>>>
>>> Finbar
>>>
>>>
>>>
>>> On 28/01/2019 13:12, David T. wrote:
>>> 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 provided in your message) could be combined to
>>>> balance out. And where does this 3986.22 figure come from?
>>>>
>>>> Next, if this truly is your first reconciliation, how is it that
>>>> you have a non zero opening balance? Gnucash derives this number
>>>> by taking all entries that were previously reconciled. So maybe
>>>> you reconciled something already?
>>>>
>>>> Finally, you will not be able to reconcile your account if it's
>>>> inaccurate by even "a few centimes." Gnucash insists on a full
>>>> match in amount before it allows you to complete the process.?
>>>> So, you will need to address those as well.
>>>>
>>>> Figure out why Gnucash shows a non zero opening balance and clean
>>>> up the erroneous transactions, and see where that puts you.
>>>>
>>>> David
>>>>
>>>> On Mon, Jan 28, 2019 at 15:53, Finbar Mahon
>>>> <mahon.finbar at neuf.fr> <mailto:mahon.finbar at neuf.fr> wrote:
>>>>
>>>> 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 seemed 'ok' just a few
>>>> centimes 'off' probably due to finger problems, as I had also
>>>> experienced with Quicken and sorted them at year end.
>>>>
>>>> The Opening Balance in the latest iteration of reconcile was
>>>> what I showed in the screen grab a while back -
>>>>
>>>> While the a/c entries starting entry shows the bank balance
>>>> figure ?3986.22 and the ?5.117.09 ending balance tallies with
>>>> the bank statement......
>>>>
>>>> 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'
>>>>
>>>> :-( thanks for the help :-)
>>>> :-)
>>>>
>>>>
>>>>
>>>> On 27/01/2019 10:46, Colin Law wrote:
>>>> On Sun, 27 Jan 2019 at 09:36, Finbar Mahon
>>>> <mahon.finbar at neuf.fr <mailto:mahon.finbar at neuf.fr>> 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 stated it clearly.? The question
>>>> is what does the Opening Balance show when you reconcile?? If
>>>> this is the first time you have reconciled it then it should
>>>> show zero (unless the opening balance has been already
>>>> reconciled).? If it is not zero then that means some
>>>> transactions have already been reconciled (possibly
>>>> accidentally).? If you go to the account and then View >
>>>> Filter By > Status > Reconciled then it should show you just
>>>> the reconciled transactions.? Clear the reconcile state on
>>>> all these and you should be good to start the reconcile with
>>>> a starting balance of zero.? Then the Opening Balance in the
>>>> account should match the Starting Balance on your bank
>>>> statement so you can reconcile that one.
>>>>
>>>> Colin
>>>>
>>>> Finbar
>>>>
>>>>> On 26/01/2019 18:12, Colin Law wrote:
>>>>> 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
>>>>> <mahon.finbar at neuf.fr <mailto:mahon.finbar at neuf.fr>>
>> wrote:
>>>>>
>>>>> 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.
>>>>>
>>>>>
>>
>>
>> ------------------------------
>>
>> Message: 9
>> Date: Wed, 30 Jan 2019 12:17:20 +0000
>> From: Colin Law <clanlaw at gmail.com>
>> To: Finbar Mahon <mahon.finbar at neuf.fr>
>> Cc: "sunfish62 at yahoo.com" <sunfish62 at yahoo.com>, Gnucash Users
>> <gnucash-user at gnucash.org>
>> Subject: Re: [GNC] Reconciliation is not adding up correctly - what t
>> Message-ID:
>> <CAL=0gLso7xir=
>> m3N41gqhxJQdb6_-rPHH1o6W-PsyCCkK4uH5Q at mail.gmail.com>
>> Content-Type: text/plain; charset="UTF-8"
>>
>> For the future, if you attempt to amend or delete a reconciled
>> transaction then you should get a warning and confirmation request. So
>> you should not be able to do it accidentally. This can be disabled
>> however. To make sure you have not disabled it then you can use
>> Actions > Reset Warnings to re-enable them.
>>
>> Once you have deleted a transaction then it is gone, so you won't be
>> able to find it in by filtering.
>> It may be worth going back and looking at your backups from earlier if
>> you think you may have deleted some transactions before the date you
>> mentioned.
>>
>> Colin
>>
>> Colin
>>
>>> On Wed, 30 Jan 2019 at 12:00, Finbar Mahon <mahon.finbar at neuf.fr> wrote:
>>>
>>> Thanks for all that. There may have been some transactions before
>>> 28.12.2017 which 'snuck' in and were deleted, that is possible and might
>>> explain the non zero start point.
>>>
>>> I saw in another post a query on whether a filtered view could show
>>> deleted transaction, if there is a possibility I may be able to find the
>>> 'culprits'
>>>
>>> Apropos the centimes, I appreciate your point, but I can use the option
>>> to enter a reconciliation amendment to cover them....
>>>
>>> As I said, I'll soldier on with the view option and hopefully find the
>>> errors. I have made a new years resolution to do reconciliations more
>>> often :-)
>>>
>>> Many, many thanks for the observations and advice.
>>>
>>> Finbar
>>>
>>>> On 29/01/2019 12:59, David T. wrote:
>>>> Finbar,
>>>>
>>>> On Tue, Jan 29, 2019 at 16:54, Finbar Mahon
>>>> <mahon.finbar at neuf.fr> wrote:
>>>>
>>>> 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.
>>>>
>>>> That clarifies this issue. You created a transaction in the
>>>> amount of 3986.22, presumably from Equity into Checking.
>>>>
>>>> Did you perform any reconciliation at this point?
>>>>
>>>> 3. I had a non-zero opening balance, in the sense that I created
>>>> (named) the a/c in Gnucash and then started with the figure above,
>>>> so that I could continue from the previous a/c into 2018. Should I
>>>> have ignored the opening balance, the amount in the bank on
>>>> 28.12.2017??
>>>>
>>>> No, entering an opening balance transaction is necessary for
>>>> practically everything. It's what happens at reconciliation that
>>>> is messed up...
>>>>
>>>> 5. The numbers on the screen grab are exactly what my problem is.
>>>>
>>>> And I agree, but probably not for the same reason as you. My
>>>> problem is that your reconcile window shows a non zero starting
>>>> balance. Gnucash calculates this amount from the transaction data
>>>> directly, counting up all the transactions that have been
>>>> reconciled before. So, the first time you reconcile an account, it
>>>> should be zero. (Indeed, the first reconciliation starting balance
>>>> merits a specific mention in the Guide)
>>>>
>>>> The fact that your window shows something else there means that
>>>> there is something else going on.
>>>>
>>>> I appreciate that a 'perfect' reconciliation should have no
>>>> 'loose' centimes, but if the figures are within that sort of
>>>> limit, I don't worry, I am not auditing a multinational.
>>>>
>>>> Again, while it might not bother you, Gnucash will not allow you
>>>> to finish reconciliation until the numbers match exactly.
>>>>
>>>>
>>>> Thanks again for your patience.
>>>>
>>>> Finbar
>>>>
>>>>
>>>>
>>>> On 28/01/2019 13:12, David T. wrote:
>>>> 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 provided in your message) could be combined to
>>>>> balance out. And where does this 3986.22 figure come from?
>>>>>
>>>>> Next, if this truly is your first reconciliation, how is it that
>>>>> you have a non zero opening balance? Gnucash derives this number
>>>>> by taking all entries that were previously reconciled. So maybe
>>>>> you reconciled something already?
>>>>>
>>>>> Finally, you will not be able to reconcile your account if it's
>>>>> inaccurate by even "a few centimes." Gnucash insists on a full
>>>>> match in amount before it allows you to complete the process.
>>>>> So, you will need to address those as well.
>>>>>
>>>>> Figure out why Gnucash shows a non zero opening balance and clean
>>>>> up the erroneous transactions, and see where that puts you.
>>>>>
>>>>> David
>>>>>
>>>>> On Mon, Jan 28, 2019 at 15:53, Finbar Mahon
>>>>> <mahon.finbar at neuf.fr> <mailto:mahon.finbar at neuf.fr> wrote:
>>>>>
>>>>> 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 seemed 'ok' just a few
>>>>> centimes 'off' probably due to finger problems, as I had also
>>>>> experienced with Quicken and sorted them at year end.
>>>>>
>>>>> The Opening Balance in the latest iteration of reconcile was
>>>>> what I showed in the screen grab a while back -
>>>>>
>>>>> While the a/c entries starting entry shows the bank balance
>>>>> figure ?3986.22 and the ?5.117.09 ending balance tallies with
>>>>> the bank statement......
>>>>>
>>>>> 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'
>>>>>
>>>>> :-( thanks for the help :-)
>>>>> :-)
>>>>>
>>>>>
>>>>>
>>>>> On 27/01/2019 10:46, Colin Law wrote:
>>>>> On Sun, 27 Jan 2019 at 09:36, Finbar Mahon
>>>>> <mahon.finbar at neuf.fr <mailto:mahon.finbar at neuf.fr>> 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 stated it clearly. The question
>>>>> is what does the Opening Balance show when you reconcile? If
>>>>> this is the first time you have reconciled it then it should
>>>>> show zero (unless the opening balance has been already
>>>>> reconciled). If it is not zero then that means some
>>>>> transactions have already been reconciled (possibly
>>>>> accidentally). If you go to the account and then View >
>>>>> Filter By > Status > Reconciled then it should show you just
>>>>> the reconciled transactions. Clear the reconcile state on
>>>>> all these and you should be good to start the reconcile with
>>>>> a starting balance of zero. Then the Opening Balance in the
>>>>> account should match the Starting Balance on your bank
>>>>> statement so you can reconcile that one.
>>>>>
>>>>> Colin
>>>>>
>>>>> Finbar
>>>>>
>>>>>> On 26/01/2019 18:12, Colin Law wrote:
>>>>>> 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
>>>>>> <mahon.finbar at neuf.fr <mailto:mahon.finbar at neuf.fr>>
>> wrote:
>>>>>>
>>>>>> 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.
>>>>>>
>>>>>>
>>> _______________________________________________
>>> 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.
>>
>>
>> ------------------------------
>>
>> Subject: Digest Footer
>>
>> _______________________________________________
>>
>> 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.
>>
>> ------------------------------
>>
>> End of gnucash-user Digest, Vol 190, Issue 95
>> *********************************************
>>
>
******* CONFIDENTIALITY NOTICE *******
This e-mail message and all attachments transmitted with it may contain legally privileged and confidential information intended solely for the use of the addressee. If the reader of this message is not the intended recipient, you are hereby notified that any reading, dissemination, distribution, copying, or other use of this message or its attachments is strictly prohibited. If you have received this message in error, please notify the sender immediately and delete this message from your system. Thank you.
More information about the gnucash-user
mailing list