Re: [GNC] Update aqbanking on fedora

[Frank H. Ellenberger]

Hi,

Am 12.03.23 um 08:55 schrieb Fred Tydeman:

OS:  Linux Fedora 36

When I do the command:  dnf update
I get this error message:
Problem: cannot install the best update candidate for package
aqbanking-6.5.3-1.fc36.x86_64
   - nothing provides libchipcard needed by aqbanking-6.5.4-1.fc36.x86_64


We recommend to update to the since yesterday available 6.5.4:
https://packages.fedoraproject.org/pkgs/aqbanking/aqbanking/
It fixes an issue about "29.02.2023"


Then, when I do the command: dnf install libchipcard
I get this error message:
No match for argument: libchipcard
Error: Unable to find a match: libchipcard

I assume that this is a Fedora issue.


Right.

Currently for Fedora 36 it is only in testing, while for more recent 
versions it is declared stable:

https://packages.fedoraproject.org/pkgs/libchipcard/libchipcard/

Regards
Frank
___
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.

[GNC] User defined currencies in "Expense Accounts"

[Charles Crossan]

While doing my monthly ritual of breaking down my utility bill into
GNUcash, I had the idea of using a user defined currency for electricity
(Kilowatt Hours - kWh) and Water (gallons).  I'd like to be able to chart
my "real usage" as well as rate fluctuations.

I've been using GNUCash for over 10 years, and have created a bunch of
custom currencies for stocks / etc; however, this is the first time I
thought about using it for tracking utility units.

I got as far as creating the kWh currency when I realized that there's no
way to choose a "non ISO 4217" currency for expense accounts.

The GNUCash documentation seems to indicate that Income and Expense
accounts are only able to use "National Currencies" (12.2.1.1. User-Defined
Currencies -
https://www.gnucash.org/docs/v4/C/gnucash-guide/currency_manual.html
).

I'm wondering:

   1. Is there a functional reason for this requirement; or is it an
   arbitrary UI restriction?
   2. Would the application behave erratically if I were to manually edit
   the expense account in SQL to use my own currency?
   3. How is everyone else handling utility tracking?  I realize I'm
   probably a tad crazy for wanting this level of detail.

-- 
Thanks,
___
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 flatpak "invisible" update?

[john]

> On Mar 11, 2023, at 1:15 PM, Tommy Trussell  wrote:
> 
> On Sat, Mar 11, 2023 at 2:21 PM John Ralls  > wrote:
>> 
>> > On Mar 11, 2023, at 11:14 AM, Tommy Trussell > > > wrote:
>> ...
>> > I was surprised the flatpak "stable" repository was showing an update to
>> > GnuCash 4.13. I was even more surprised it was showing the update would be
>> > to a commit from December. ...
>> 
>> [SNIP]
>> 
>> >  Commit:
>> > eb1be08966b94073a6f219dcf8f61f42c88228d1d1f2aba15da990591bccf3c7
>> >  Parent:
>> > 7e2d8364088a32d0f6849893a43b41a5623886c2d5c7da3505c023ba0c86fa5f
>> > Subject: Fix GnuCash tarball sha256 (bd9f8e1e)
>> >Date: 2022-12-18 22:30:44 +
>> 
>> The commits are weird. The one in parentheses is the current HEAD on 
>> https://github.com/flathub/org.gnucash.GnuCash/commits/master and as will be 
>> apparent if you visit that page the commit was needed because the first 
>> build failed.
>> 
>> Does the subject for the parent commit say "Package GnuCash 4.13 
>> (c825100b)"? That's the build that failed so it's seems odd to me that it 
>> would have made an installable flatpak.
> 
> I don't know how to look for the information you requested. All I know how to 
> discern is through the flatpak info command, and it shows exactly what you've 
> quoted. 
> 
> I searched github for the last eight characters of the strings and have not 
> found anything relevant EXCEPT the parent commit you mentioned.
> 
> HOWEVER I just noticed in 
> 
> https://github.com/Gnucash/gnucash-on-flatpak 
> 
> there's an update to modules/aqbanking.json from last week. It could easily 
> be that I have not checked flatpak updates since you made that change. Could 
> that one file explain it?  I don't use AQBanking so I don't even know where 
> I'd look in my installation unless I dug into the installed flatpak. 
> 
> I just chose Help --> About
> 
> Version: 4.13
> Build ID: Flathub 4.13
> Finance::Quote: 1.5301



No, it's not the AQBanking change. Changes on gnucash-on-flatpak don't get 
reflected in org.gnucash.GnuCash until I copy them over as part of doing a 
release, so that change is in the beta branch for the 4.90x releases but not 
yet in master for 4.x.

bd9f8e1e is the 18 December commit for the 4.13 flathub release in 
org.gnucash.GnuCash. That part isn't mysterious, what's mysterious is what did 
you have before and why did flatpak not update you to that release until almost 
3 months later?

A related and perhaps more interesting question for folks with a firmer grasp 
of flathub than I have: I'll be releasing both 4.14 and 5.0 in two weeks. IIUC 
flathub supports only one version at a time so there's no point in making a 
flathub build for 4.14. Both would be available from 
https://code.gnucash.org/builds/flatpak. Is my understanding correct? 

Regards,
John Ralls

___
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] User defined currencies in "Expense Accounts"

[Gyle McCollam]

As to #3, I track my utilities with a spreadsheet in Libre Office.  What are 
you trying to track, kwh usage or cost per kwh?  In my spreadsheet I track 
both, plus differences with last year.  In Gnucash you could put this info in 
the "notes" field, but reporting on tis info I'm not sure about.  Another way 
that won't screw up your financial reporting is to set up subaccounts under 
electric.  One account for say kwh and a contra account for the -kwh.  You 
could record the kwh used in the first and the opposite value in the contra so 
they net to zero and don't affect financial reporting.  That way you could get 
a report on just the positive account for usage.  I myself would use the 
spreadsheet approach.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email


From: gnucash-user  on 
behalf of Charles Crossan 
Sent: Sunday, March 12, 2023 10:51 AM
To: gnucash-user@gnucash.org 
Subject: [GNC] User defined currencies in "Expense Accounts"

While doing my monthly ritual of breaking down my utility bill into
GNUcash, I had the idea of using a user defined currency for electricity
(Kilowatt Hours - kWh) and Water (gallons).  I'd like to be able to chart
my "real usage" as well as rate fluctuations.

I've been using GNUCash for over 10 years, and have created a bunch of
custom currencies for stocks / etc; however, this is the first time I
thought about using it for tracking utility units.

I got as far as creating the kWh currency when I realized that there's no
way to choose a "non ISO 4217" currency for expense accounts.

The GNUCash documentation seems to indicate that Income and Expense
accounts are only able to use "National Currencies" (12.2.1.1. User-Defined
Currencies -
https://www.gnucash.org/docs/v4/C/gnucash-guide/currency_manual.html
).

I'm wondering:

   1. Is there a functional reason for this requirement; or is it an
   arbitrary UI restriction?
   2. Would the application behave erratically if I were to manually edit
   the expense account in SQL to use my own currency?
   3. How is everyone else handling utility tracking?  I realize I'm
   probably a tad crazy for wanting this level of detail.

--
Thanks,
___
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] new user woes

[Michael or Penny Novack]

On 3/11/2023 4:58 PM, Jamie Tolbert via gnucash-user wrote:
Its been a number of years, but I did take a few accounting classes in 
college..so I have an idea of WHAT I want to do, but unclear on 
HOW to do it in gnucash.I will continue to fumble my way thru it, 
the tutorial is rather cumbersome to read thru, for example, a search 
for opening balances turn up several pages with OPEN and several with 
a variation of BALANCEs, but not the account thats labeled OPENING 
BALANCES...if that is read only, how do I edit it to put my 
opening balance in ?!?!?! 


You do not NEED to use the opening balance wizard.

If you remember opening books from those accounting classes you will 
know that "in the old days" this was done with a transaction (or 
transactions). In other words, you can create your CoA with all accounts 
starting with a zero balance and then:


Using the balance sheet from your old system, enter your first 
transaction(s).


If a SINGLE transaction, going to be split on both sides, debit and 
credit. It is not easy for a beginner to enter a two way split 
transaction, so you could instead use two, one for the debit side and 
one for the credit side so split only on one side.


If doing it that way, you won't likely know the amount for the equity 
side of the transaction. You could start with that amount as zero, 
split, and then begin entering all the debit (or credit) accounts, and 
when you have those entered, the IMBALANCE amount will be what you want 
to change that zero to. When you have done both sides, equity should 
match what was in the Balance Statement you were working from.


You could also enter the amounts one at a time. In all the above methods 
you would use something like "opening the books" to describe the 
transaction(s)


The wizard is just a tool to allow you to populate your initial CoA with 
starting amounts and that will use a special account under equity called 
something like starting equity. It is just like doing it one at a time 
EXCEPT you don't see those transactions.



Michael D Novack


___
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] User defined currencies in "Expense Accounts"

[john]

> On Mar 12, 2023, at 7:51 AM, Charles Crossan  wrote:
> 
> While doing my monthly ritual of breaking down my utility bill into
> GNUcash, I had the idea of using a user defined currency for electricity
> (Kilowatt Hours - kWh) and Water (gallons).  I'd like to be able to chart
> my "real usage" as well as rate fluctuations.
> 
> I've been using GNUCash for over 10 years, and have created a bunch of
> custom currencies for stocks / etc; however, this is the first time I
> thought about using it for tracking utility units.
> 
> I got as far as creating the kWh currency when I realized that there's no
> way to choose a "non ISO 4217" currency for expense accounts.
> 
> The GNUCash documentation seems to indicate that Income and Expense
> accounts are only able to use "National Currencies" (12.2.1.1. User-Defined
> Currencies -
> https://www.gnucash.org/docs/v4/C/gnucash-guide/currency_manual.html
> ).
> 
> I'm wondering:
> 
>   1. Is there a functional reason for this requirement; or is it an
>   arbitrary UI restriction?
>   2. Would the application behave erratically if I were to manually edit
>   the expense account in SQL to use my own currency?
>   3. How is everyone else handling utility tracking?  I realize I'm
>   probably a tad crazy for wanting this level of detail.

It's part of GAAP/IFS: Expense and Income are flavors of Equity and that can 
only be currency; in fact it's supposed to be only in the book currency, but 
GnuCash doesn't enforce that in part because it doesn't historically recognize 
a book currency. 

I don't see anything in the engine that will misbehave if you do that, but the 
account edit window might act up if you try to edit the account after making 
the change.

I use a spreadsheet to capture the amount of electricity, natural gas, and 
water we use monthly, but since they installed smart meters a few years ago the 
utility company has provided a nice usage display on their website with hourly, 
daily, and monthly charts, though the daily and hourly data is available for 
only a couple of years back.

Regards,
John Ralls





___
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.

[GNC] GnuCash 4.903 Released

[John Ralls]

The GnuCash development team announces GnuCash 4.903, the fourth unstable 
release leading to GnuCash 5.0.

This is an unstable release for testing purposes. Do not use it with production 
data! Make a copy of your book to test this release. 

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 you have the Accounts page ora Stock or Fund 
account register open.
• 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.
• 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.

Between 4.902 and 4.903, the following bugfixes were accomplished:

The following fixes will also appear in GnuCash 4.14:

• Bug 798765 - Increase the limit for Maximum Slices in the Expense 
Piechart
The following fixes and improvements were not associated with bug reports:

• Add JSON::Parse to gnc-fq-update.
• Guard against some possible null pointer dereferences
• Change the reconcile window toolbar icon for 'Other the Account' to 
'gnc-jumpto' 
• Change toolbar 'Blank' icon for invoice page to match register
• Change the short cut from CTRL+Page_Down to CTRL+b and change the 
toolbar icon to 'go-jump'. 
• Remove -Wno-pointer-sign, adding the necessary casts in 
gnc-gwen-guic.c 
• Remove -Wno-error=parentheses, added for gcc 8.0 and gtk 3.14 
• Remove redundant uses of cmake -E env
• [c++options] Save an empty SCM string for nil or empty option values. 
Avoids crash at reload due to unknown variable.
• [c++options]Really fix the gnc_option_db_lookup_string_value leak

New and Updated Translations: Chinese (Simplified), Croatian, English 
(Australia), English (New Zealand), English (United Kingdom), Hungarian, 
Macedonian, Polish, Portuguese, Russian, Ukrainian

Help translate GnuCash on Weblate: https://hosted.weblate.org/engage/gnucash/

Translators note that there is a new project Program-beta on weblate for this 
unstable branch. Having twice the strings causes us to exceed the free account 
limit, but Weblate has so far just warned us about it. If we need to change the 
branch we'll announce it on gnucash-devel.

Known Problems: 

Complete list of all open bugs: 
https://bugs.gnucash.org/buglist.cgi?bug_severity=blocker&bug_severity=critical&bug_severity=major&bug_severity=normal&bug_severity=minor&bug_severity=trivial&bug_status=NEW&bug_status=ASSIGNED&bug_status=NEEDINFO&bug_status=REOPENED&limit=0&list_id=8149&order=priority%2Cbug_severity&query_format=advanced

Documentation

Concurrent with the release of GnuCash 4.900 we're pleased to also release a 
new version of the companion Manual and Tutorial and Concepts Guide

• Document Import using AQBanking.
• Document the new Stock Transaction Assistant.
• Add JSON::Parse module to finance-quote requirements.
  finance-quote-wrapper use

Re: [GNC] User defined currencies in "Expense Accounts"

[NoobAlice]

Date: Sun, 12 Mar 2023 08:45:18 -0700
From: john 
To: Charles Crossan 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] User defined currencies in "Expense Accounts"
Message-ID: <204d86ba-9b99-470c-960d-b15cd7ef0...@ceridwen.us>
Content-Type: text/plain;   charset=us-ascii



On Mar 12, 2023, at 7:51 AM, Charles Crossan  wrote:

While doing my monthly ritual of breaking down my utility bill into
GNUcash, I had the idea of using a user defined currency for electricity
(Kilowatt Hours - kWh) and Water (gallons).  I'd like to be able to chart
my "real usage" as well as rate fluctuations.

I've been using GNUCash for over 10 years, and have created a bunch of
custom currencies for stocks / etc; however, this is the first time I
thought about using it for tracking utility units.

I got as far as creating the kWh currency when I realized that there's no
way to choose a "non ISO 4217" currency for expense accounts.

The GNUCash documentation seems to indicate that Income and Expense
accounts are only able to use "National Currencies" (12.2.1.1. User-Defined
Currencies -
https://www.gnucash.org/docs/v4/C/gnucash-guide/currency_manual.html
).

I'm wondering:

  1. Is there a functional reason for this requirement; or is it an
  arbitrary UI restriction?
  2. Would the application behave erratically if I were to manually edit
  the expense account in SQL to use my own currency?
  3. How is everyone else handling utility tracking?  I realize I'm
  probably a tad crazy for wanting this level of detail.


It's part of GAAP/IFS: Expense and Income are flavors of Equity and that can only be currency; in fact it's supposed to be only in the book currency, but GnuCash doesn't enforce that in part because it doesn't historically recognize a book currency. 


I don't see anything in the engine that will misbehave if you do that, but the 
account edit window might act up if you try to edit the account after making 
the change.

I use a spreadsheet to capture the amount of electricity, natural gas, and 
water we use monthly, but since they installed smart meters a few years ago the 
utility company has provided a nice usage display on their website with hourly, 
daily, and monthly charts, though the daily and hourly data is available for 
only a couple of years back.

Regards,
John Ralls


I am a third vote for "use a spreadsheet instead."  And I've taken a 
currency I don't need and repurposed it to track rewards card points 
(not updated with Finance::Quote of course), so I am sympathetic to your 
goals.


At least in my geographic area, part of the US, utility billing for 
electric and gas has enough moving parts that for tracking you really do 
want an entire spreadsheet, not just a "currency."


Some components to consider:
* meter read dates aren't always monthly - officially, our meter reads 
by the utility happen every other month...except when the meter reader 
is sick... or the meter reader gets the wrong number...or there is a 
worldwide pandemic...  (We send in our own readings recently, which 
helps a bit.)
* meter read dates are irregular - sometimes the utility co has meter 
reads (ours and theirs) 25 days apart, up to 35 days, very inconsistent. 
 Averaging out KWH per time period is better done on a spreadsheet.
* bills can include fixed and variable components - "service to your 
home" for gas and electric may be two flat fees
* time-of-day usage - some utility companies do this, another spanner in 
the works
* price per KWH can have multiple components - here, we have the basic 
price per KWH, but then added on are per-unit prices for delivery 
charges, taxes, and more
* energy supply companies - in some states of the USA, you can choose 
your supplier for gas or electric, which can change the rates you pay 
for power
* spreadsheets are nicer for calculations - you can do a 12-month 
rolling average to account for seasonal increases in use to see whether 
you are really increasing/decreasing usage over time, get a trend in 
part of your costs over time



___
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.