[GNC] De-reconciled amount

[Peter West via gnucash-user]

I have somehow managed to get an amount from 2021 unreconciled. I don’t know 
how this happened exactly. I recently checked back on a number of past payments 
on this account, which has been the only time I approached these entries.

Apart from the mystery of why, I now have the question of how. How to fix it. 
How should I approach this?


—
Peter West
p...@pbw.id.au
`“Mary.” She turned and said to him in Aramaic, “Rabboni!”`

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Gun shy?

[Peter West via gnucash-user]

The only problem I’ve seen is the lack of completion in the Description field 
of splits.

—
Peter West
p...@pbw.id.au
“For where your treasure is, there your heart will be also.”

> On 28 Jun 2023, at 3:57 pm, R Losey  wrote:
> 
> Thanks for all of the feedback. I guess before I do financial work this
> week, I'll update my GnuCash from 5.1 to 5.3
> 
> I'm glad it's working fine!
> 
> On Tue, Jun 27, 2023 at 4:09 PM David H  > wrote:
> 
>> It's good and a lot more reliable than my banking apps lately :-)
>> 
>> On Wed, 28 Jun 2023 at 03:39, R Losey  wrote:
>> 
>>> (Heh) I wonder if we are all gun shy about downloading and installing
>>> GnuCash 5.3; I haven't seen anyone on this list say that they have used it
>>> and it is fine.
>>> 
>>> 
>>> 
>>> --
>>> _
>>> Richard Losey
>>> rlo...@gmail.com
>>> Micah 6:8
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> 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.
>>> 
>> 
> 
> -- 
> _
> Richard Losey
> rlo...@gmail.com 
> Micah 6:8
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org 
> To update your subscription preferences or to unsubscribe:
> 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
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Description List

[Peter West via gnucash-user]

Wouldn’t this be a case where correcting the database or XML file would be a 
feasible solution?

—
Peter West
p...@pbw.id.au
“I am the bread of life; whoever comes to me shall not hunger, and whoever 
believes in me shall never thirst.”

> On 23 May 2023, at 2:29 pm, Adrien Monteleone 
>  wrote:
> 
> You can't. It is composed of all descriptions entered. If something is 
> spelled incorrectly, you can do a search for transactions that have that 
> misspelling in their description field, then correct them one by one.
> 
> Once a description no longer appears anywhere, such as a misspelling, it will 
> disappear from the drop down list.
> 
> Regards,
> Adrien
> 
> On 5/19/23 8:26 PM, Phillip Walsh wrote:
>> How can I edit the list that drops down in the Description column.
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] GnuCash 5.0 Released

[Peter West via gnucash-user]

I have just noticed that the hash given in the release email for
Gnucash-Intel-5.0-2.dmg
is the correct hash for
Gnucash-Intel-5.0-1.dmg
which is the version which downloads from the first download link for Apple 
MacOS in the release email. The has I used was the one given for
Gnucash-Intel-5.0-1.dmg
on the SourceForge page.

Hence my confusion.

—
Peter West
p...@pbw.id.au
When he had said these things, he cried out with a loud voice, “Lazarus, come 
out.”



> On 27 Mar 2023, at 9:25 am, Peter West via gnucash-user 
>  wrote:
> 
> The sha256 hash for Gnucash-Intel-5.0-1.dmg is not equal to the value given 
> at SourceForge.
> 
> $ sha256 Gnucash-Intel-5.0-1.dmg 
> b43b61244e195f6f8c52f83430c08671e8a02f47a00f09e4295652ce9d57443a
> Gnucash-Intel-5.0-1.dmg FAIL
> c8ea60b2ccbeab5f6997a927939a0fad715fbbe494644e586c6c386bfec6857a NOT EQUAL TO
> b43b61244e195f6f8c52f83430c08671e8a02f47a00f09e4295652ce9d57443a
> 
> 
> —
> Peter West
> p...@pbw.id.au <mailto:p...@pbw.id.au>“Rejoice and be glad, for your reward 
> is great in heaven, for so they persecuted the prophets who were before you.”
> 
>> On 27 Mar 2023, at 7:09 am, John Ralls > <mailto:jra...@ceridwen.us>> wrote:
>> 
>> The GnuCash development team announces GnuCash 5.0.
>> 
>> New Features
>> 
>>   A new Stock Transaction Assistant to guide you through entering most 
>> investment transactions for stocks, bonds, and mutual funds. You can access 
>> it from Actions>Stock Assistant when the focus tab is the Accounts page or a 
>> Stock or Fund account register.
>>   A new Investment Lots report showing a graph of capital gains and losses 
>> in a period by investment lot. Note that if you don't use the View Lots 
>> dialog to manage capital gains and losses this report won't have anything to 
>> show you. Use Reports>Assets & Liabilities>Investment Lots to see the report.
>>   The Online Quotes facility has been completely rewritten and the old 
>> gnc-fq-check, gnc-fq-dump, and gnc-fq-helper programs have been replaced 
>> with finance-quote-wrapper. The functions performed by those programs may 
>> now be accomplished by passing commands to gnucash-cli -Q, see gnucash-cli 
>> --help for specifics. The perl module requirements have changed with the 
>> rewrite: The new version doesn't need Date::Manip but needs JSON::Parse 
>> instead. gnc-fq-update has been, er, updated to reflect that.
>>   A new tab on the New/Edit Account dialog called More Properties includes 
>> entries to set a high and low limit on an account. That's coupled to a new 
>> column that's available on the Accounts Page, Balance Limit. If you set a 
>> high or low limit and the account balance falls above or below the 
>> respective limit an indicator will be shown in the Balance Limit column.
>>   The description field quickfill in the register now displays a drop-down 
>> list of possible completions instead of just one inline completion.
>>   File import menu items for the MT940, MT942, and DTAUS formats is replaced 
>> with a single Import from AQBanking that supports importing any file format 
>> supported by AQBanking, including the frequently requested CAMT. (Note that 
>> some CAMT profiles are under the XML format.)
>>   The import matcher now permits editing descriptions, notes, and memo 
>> fields in the matcher window before creating the transactions. Right-click 
>> and select from the context menu.
>>   The report generated by the Print Invoice button on the Edit Invoice tab 
>> can now be configured as a book option at the bottom of the Business tab; 
>> this permits selecting a saved configuration of one of the standard invoice 
>> reports. Another option enables a delay, during which a dialog box will 
>> appear enabling the user to select a different report. Note: When saving a 
>> configuration make sure that the invoice number is not set or you'll get 
>> that particular invoice instead of the one that you pressed the button for.
>> 
>> Significant Code Changes
>> Deprecations (will be removed in GnuCash 6.0)
>> 
>>   _ (the alias for gettext. Use G_ instead)
>>   gnc:make-account-list-limited-option
>>   gnc:make-account-list-option
>>   gnc:make-account-sel-limited-option
>>   gnc:make-account-sel-option
>>   gnc:make-budget-option
>>   gnc:make-color-option
>>   gnc:make-commodity-option
>>   gnc:make-complex-boolean-option
>>   gnc:make-counter-format-option
>>   gnc:make-counter-option
>>   gnc:make-currency-option
>>   gnc:make-date-format-option
>>   gnc:make-font-option
>>   gnc:make-internal-option
>>   gn

Re: [GNC] GnuCash 5.0 Released

[Peter West via gnucash-user]

The sha256 hash for Gnucash-Intel-5.0-1.dmg is not equal to the value given at 
SourceForge.

$ sha256 Gnucash-Intel-5.0-1.dmg 
b43b61244e195f6f8c52f83430c08671e8a02f47a00f09e4295652ce9d57443a
Gnucash-Intel-5.0-1.dmg FAIL
c8ea60b2ccbeab5f6997a927939a0fad715fbbe494644e586c6c386bfec6857a NOT EQUAL TO
b43b61244e195f6f8c52f83430c08671e8a02f47a00f09e4295652ce9d57443a

 
—
Peter West
p...@pbw.id.au“Rejoice and be glad, for your reward is great in heaven, for so 
they persecuted the prophets who were before you.”

> On 27 Mar 2023, at 7:09 am, John Ralls  wrote:
> 
> The GnuCash development team announces GnuCash 5.0.
> 
> New Features
> 
>A new Stock Transaction Assistant to guide you through entering most 
> investment transactions for stocks, bonds, and mutual funds. You can access 
> it from Actions>Stock Assistant when the focus tab is the Accounts page or a 
> Stock or Fund account register.
>A new Investment Lots report showing a graph of capital gains and losses 
> in a period by investment lot. Note that if you don't use the View Lots 
> dialog to manage capital gains and losses this report won't have anything to 
> show you. Use Reports>Assets & Liabilities>Investment Lots to see the report.
>The Online Quotes facility has been completely rewritten and the old 
> gnc-fq-check, gnc-fq-dump, and gnc-fq-helper programs have been replaced with 
> finance-quote-wrapper. The functions performed by those programs may now be 
> accomplished by passing commands to gnucash-cli -Q, see gnucash-cli --help 
> for specifics. The perl module requirements have changed with the rewrite: 
> The new version doesn't need Date::Manip but needs JSON::Parse instead. 
> gnc-fq-update has been, er, updated to reflect that.
>A new tab on the New/Edit Account dialog called More Properties includes 
> entries to set a high and low limit on an account. That's coupled to a new 
> column that's available on the Accounts Page, Balance Limit. If you set a 
> high or low limit and the account balance falls above or below the respective 
> limit an indicator will be shown in the Balance Limit column.
>The description field quickfill in the register now displays a drop-down 
> list of possible completions instead of just one inline completion.
>File import menu items for the MT940, MT942, and DTAUS formats is replaced 
> with a single Import from AQBanking that supports importing any file format 
> supported by AQBanking, including the frequently requested CAMT. (Note that 
> some CAMT profiles are under the XML format.)
>The import matcher now permits editing descriptions, notes, and memo 
> fields in the matcher window before creating the transactions. Right-click 
> and select from the context menu.
>The report generated by the Print Invoice button on the Edit Invoice tab 
> can now be configured as a book option at the bottom of the Business tab; 
> this permits selecting a saved configuration of one of the standard invoice 
> reports. Another option enables a delay, during which a dialog box will 
> appear enabling the user to select a different report. Note: When saving a 
> configuration make sure that the invoice number is not set or you'll get that 
> particular invoice instead of the one that you pressed the button for.
> 
> Significant Code Changes
> Deprecations (will be removed in GnuCash 6.0)
> 
>_ (the alias for gettext. Use G_ instead)
>gnc:make-account-list-limited-option
>gnc:make-account-list-option
>gnc:make-account-sel-limited-option
>gnc:make-account-sel-option
>gnc:make-budget-option
>gnc:make-color-option
>gnc:make-commodity-option
>gnc:make-complex-boolean-option
>gnc:make-counter-format-option
>gnc:make-counter-option
>gnc:make-currency-option
>gnc:make-date-format-option
>gnc:make-font-option
>gnc:make-internal-option
>gnc:make-invoice-option
>gnc:make-list-option
>gnc:make-multichoice-callback-option
>gnc:make-multichoice-option
>gnc:make-number-plot-size-option
>gnc:make-number-range-option
>gnc:make-owner-option
>gnc:make-pixmap-option
>gnc:make-query-option
>gnc:make-radiobutton-option
>gnc:make-simple-boolean-option
>gnc:make-string-option
>gnc:make-taxtable-option
>gnc:make-text-option
>gnc:option-set-default-value
>gnc:option-set-value
>gnc:option-setter
>gnc:option-value
>gnc:register-option
>The invoice option to gnc:register-report-create-internal
> 
> Report and Book Options
> 
>This major change will affect everyone who has written custom reports in 
> Guile Scheme.
>The report and book options code has been completely rewritten in C++ with 
> SWIG providing Guile Scheme access for reports. The new design requires 
> directly registering options with for example 
> gnc-optiondb-register-string-option instead of calling gnc:make-string-option 
> to create an option followed by gnc:register-option to insert it in the 
> 

Re: [GNC] Can a bank account have sub-accounts?

[Peter West via gnucash-user]

If you use a variant of envelope budgeting, your actual bank account can be a 
placeholder account, and every transaction against that account is actually 
recorded in one of the subaccounts. The total balance of all the subaccounts 
will show against the placeholder account. By using the OpenSubaccounts item in 
the menu for the placeholder, you will see a list of all of the transactions in 
the subaccounts. You cannot edit this list, but you can check the items against 
your bank statement. If you then uncheck ‘Placeholder account’ you will lose 
the grand total, but you will be able to edit, hence reconcile, the items in 
the ‘Open Subaccounts’ transaction display. After reconciliation you can 
recheck the ‘Placeholder Account’.

I haven’t actually tried this process during reconciliation, but perhaps 
someone else has, and can give you the pros and cons or suggest an alternative.

—
Peter West
p...@pbw.id.au
“Blessed are you when others revile you and persecute you and utter all kinds 
of evil against you falsely on my account.”




> On 14 Mar 2023, at 12:46 am, Murugan Muruganandam 
>  wrote:
> 
> hi Mort
> 
> The  expenses account can be granular and can be tracked separately.  for 
> Asset account unless you have separate bank accounts, you cannot separate it 
> in your accounting system.
> You can use sub accounts, but it would be a huge overhead for you to 
> reconcile your bank statement with individual buckets you have created.
> 
> 
> 
> 
> 
> Saludos Cordiales
> 
> 
> Murugan
> 
> 
> From: gnucash-user 
>  on behalf of 
> Mort Q 
> Sent: Monday, March 13, 2023 11:35 AM
> To: Robert Heller 
> Cc: gnucash-user@gnucash.org 
> Subject: Re: [GNC] Can a bank account have sub-accounts?
> 
> Hi Robert
> I do have lots of expense accounts for repairs, catering, office expenses,
> utilities, etc, and income accounts for fund raising, donations,
> memberships, etc. so we can track income and expenses easily.  The GnuCash
> reports really help people see where money is coming from and going to.
> That's one of the reasons I was thinking of having the sub accounts - the
> bank reports will be like an overall report but with the underlying break
> down of fund allocation.  Does that make sense?
> 
> Every transaction is double entry, I think (one account credited and the
> other debited) e.g. a bill payment will credit Liabilities:Accounts Payable
> and debit Assets:Current Assets:Bank Account.  Is that what you mean?
> 
> Thanks
> Mort
> 
> On Tue, 14 Mar 2023 at 00:05, Robert Heller  wrote:
> 
>> At Mon, 13 Mar 2023 23:55:05 +1000 Mort Q  wrote:
>> 
>>> 
>>> Hi all
>>> I act as Treasurer for a community organisation, and want to look for a
>> way
>>> that GnuCash can subdivide the money in the bank account into planned
>>> expenses e.g. a few members do ongoing fund raising for equipment, so
>> could
>>> I make a sub-account of the bank account called "Equipment enhancement"?
>>> When making a deposit, allocate that money to "Assets:Current Assets:Bank
>>> Account:Equipment Enhancement" instead of the currently-used
>>> "Assets:Current Assets:Bank Account".
>>> 
>>> Currently, we just have the one account called "Bank Account" in the
>> Assets
>>> tree, and I keep a separate spreadsheet with the allocation break up.  I
>>> have to remember to do the extra work to keep the spreadsheet up to date.
>>> In my previous life, I learnt that it was better to have a single point
>> of
>>> truth for data.
>>> 
>>> I am thinking I will end up with an account tree like
>>> Assets:
>>>   -Current Assets:
>>>-Accounts Receivable
>>>-Bank Account:  (will still need this to be reported on for
>> audits,
>>> etc, as a single account)
>>>  -General Funds
>>>  -Equipment Enhancement
>>>  -Saved for something else
>>>  -etc
>>> Does this make sense?  Or am I missing something?
>>> Or creating a nightmare that will come back and bite me when I try to do
>>> reports, etc later?
>>> 
>>> Clearly, I am not an accountant, and a self-taught GnuCash user.
>> 
>> Clearly :-).
>> 
>> You are not fully understanding double-entry bookkeeping and how GnuCash
>> works
>> and is generally meant to be used.
>> 
>> Yes, you can have sub-accounts under Bank Account, but probably should be
>> looking at creating a budget.
>> 
>> You should *also* create additional accounts for the various expenses and
>> so
>> on as well.
>> 
>>> 
>>> Thanks
>>> Mort
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> 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.
>>> 
>>> 
>> 
>>> 
>> 
>> --
>> Robert Heller -- Cell: 413-658-7953 GV: 978-633-5364
>> Deepwoods Software-- Custom Software 

Re: [GNC] Schedule transaction for 2 Wednesday?

[Peter West via gnucash-user]

An offset or delay option would be needed to solve that one, I think.
—
Peter West
p...@pbw.id.au
“Blessed are you when others revile you and persecute you and utter all kinds 
of evil against you falsely on my account.”

> On 11 Mar 2023, at 2:09 am, David Carlson  wrote:
> 
> We must be having fun by now!  The only schedule that I have not been able
> to implement correctly every single time is the Friday after the second
> Thursday of the month, but then I really don't expect to get that one
> right.
> 
> On Fri, Mar 10, 2023 at 9:57 AM mjchurchil--- via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> 
>> I think Stephen Butler is right. I get a deposit every 3rd Wednesday and
>> gnucash gets it right every time. Don't remember the process to set it up,
>> but his sounds correct. gnucash 4.13. Mike
>>On Thursday, March 9, 2023 at 10:29:50 PM PST, Stephen M. Butler <
>> stephen.m.butle...@gmail.com> wrote:
>> 
>> Set it on the Frequency tab.
>> 
>> Frequency -- pick Monthly
>> Every ? months -- (enter 1 into that box)
>> On the {big drop down list}  -- Pick the '2nd Wed' from the list.
>> 
>> Stephen M Butler, PMP, PSM
>> stephen.m.butle...@gmail.com
>> kg...@arrl.net
>> 253-350-0166
>> ---
>> 
>> 
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> 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.
>> 
> 
> 
> -- 
> David Carlson
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Confusing version numbers

[Peter West via gnucash-user]

In the MacOS and linux universes, such things would be determined by the 
LC_COLLATE setting of locale, I think. Windows?
—
Peter West
p...@pbw.id.au
“Blessed are those who are persecuted for righteousness' sake, for theirs is 
the kingdom of heaven.”

> On 9 Mar 2023, at 7:31 pm, Geert Janssens  wrote:
> 
> Op donderdag 9 maart 2023 09:34:36 CET schreef aeg via gnucash-user:
>> The fact that 9 is less than 12 is not confusing to me, but sorting by
>> Windows File Explorer routinely puts 12 before 9, whereas 09 is always
>> correctly arranged before 12 (and before 900). From the
>> link, https://semver.org/ provided by LI Daobing, I now understand that
>> there is a conventional way of numbering software releases, but I remain
>> puzzled by the insistence that leading zeros must not be used. It is often
>> the case that the status quo can be seen to work, but it is my opinion
>> that, if an improvement can be made and the effort to do so is minimal, it
>> is normally worth making that improvement. I assume that's what drives the
>> developers to make evolutionary changes and introduce updates. I'd just
>> like to see a numbering system that works in all circumstances. Alan
> 
> Well, it's all context related.
> 
> On my linux desktop files get properly sorted already now with .9 appearing 
> before .12. 
> 
> In fact linux desktop environments have been properly sorting such version 
> numbers for 
> years. So I don't even notice this on the PC I use every day. Looks like the 
> Windows' file 
> manager does not have that feature (yet) or perhaps it's configurable 
> somewhere ?
> 
> Regards,
> 
> Geert
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.