Re: [GNC] Using latest AqBanking

[Brad Morrison]

Hi Frank/GnuCash users, 

https://flathub.org/apps/org.gnucash.GnuCash - the GNUCash Flatpak,
version 5.10, seems to come with the 6.5.4 version of AQBanking. 

https://aquamaniac.de/rdm/projects/aqbanking/files - according to this,
the current version of AQBanking is 6.6.0 which was released in December
2024. Version 6.5.4 seems to have been released in March 2023. 

https://wiki.gnucash.org/wiki/AqBanking - this is a good overview of
AQBanking 

Are there plans for GNUCash to upgrade AQBanking from version 6.5.4 to
6.6? 

---
Thanks, 

Brad - https://www.facebook.com/brad.morrison.12327/ &
https://nextdoor.com/profile/01mP46jj8KCzj3sP4 &
https://norcal.social/@BradMorrison 

On 2025-02-05 22:16, e...@gegensinn.org wrote:

> Hi GnuCash-Users,
> 
> I'm running GnuCash 5.10 on MacOS 15.1.1 (ARM). The app ships with a version 
> of AqBanking incompatible with my bank. Specifically, it lacks some of the 
> ITAN modes required since Jan 2025. I managed to install AqBanking 6.6.0 on 
> my machine. Retrieving accounts and balances works fine with the new 
> aqhbci-cli. Is there a way to point GnuCash to the new installation and 
> libraries instead of the bundled ones?
> 
> Best 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.
___
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] Strange Imbalance transactions

[Fred Tydeman]

I just noticed that the account Imbalance-USD has some entries.

However, all the entries are very strange in that there is NO
corresponding second account (that is, no pair of transactions).  Each
entry has a description, but the value is zero.  If I do Show Splits,
there is no second account.

I looked at the backup files and found the date when these
transactions happened (January 11).  In looking at the corresponding
log file, I can see transactions that mention Imbalance.  But, I do
not know how to read the log file.

I have done Check and Repair All and the Imbalance-USD transactions
remain.

In looking at one of the Imbalance transactions, it corresponds to a
stock purchase.  I can see two Start/End transactions in the log file
related to that stock.  One of those two has the Imbalance.

It is possible that these transactions are related to an Import of a
QIF file (which I do each Saturday).
___
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] Using latest AqBanking

[esel]

Hi GnuCash-Users,

I'm running GnuCash 5.10 on MacOS 15.1.1 (ARM). The app ships with a version of 
AqBanking incompatible with my bank. Specifically, it lacks some of the ITAN 
modes required since Jan 2025. I managed to install AqBanking 6.6.0 on my 
machine. Retrieving accounts and balances works fine with the new aqhbci-cli. 
Is there a way to point GnuCash to the new installation and libraries instead 
of the bundled ones?

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

Re: [GNC] Strange Imbalance transactions

[Kalpesh Patel]

Those accounts are auto-magically created, as someone has already mentioned. 
Even after you delete it(them), it(they) will get re-created next time when 
there is a need. You possibly can see as many as number of different currencies 
used in the book. They are the place-holder accounts for each currency when 
something is ambiguous and GNUCash need to park it somewhere -- remember that 
GNUCash is double entry system so you need a contra account for each 
transaction. 

-Original Message-
From: Fred Tydeman  
Sent: Thursday, February 06, 2025 9:53 AM
To: Brad Morrison 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Strange Imbalance transactions

On Thu, Feb 6, 2025 at 11:01 AM Brad Morrison 
wrote:

> What operating system are you using?
>
> What version of GNUCash are you using?
> https://gnucash.org/download.phtml shows that the current version is
> 5.10
>

I forgot to add those details:  Fedora Linux 41, Gnucash 5.10


> https://wiki.gnucash.org/wiki/FAQ#Importing.2FExporting_Data has some 
> info on importing data, as you mentioned a regular QIF import
>
> Regarding the stock purchase with 2 start & end transactions, 1 being 
> balanced and the other being imbalanced - are both entries for the 
> same transaction? Possibly meaning an importing error?
>

My guess (based upon looking at the log file) is both are for the same 
transaction.


> Also, why is the account titled "Imbalance-USD" - ?
>

In the past, I have seen
  Imbalance-COP
  Imbalance-GBP
  Imbalance-USD
I have transactions in multiple currencies.


___
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] Strange Imbalance transactions

[David Cousens]

Fred,

If the transfer account is not assigned to an imported trnasaction
during import it will have the Imbalance account assigned as the
transfer account.

This is to alert you that the transaction was incomplete. ANy
transactions in the Imbalance account need to have the correct accounts
assigned to them. 

If you were importing your bank account records then it is likely the
Imbalance is associated with the stock itself or the brokerage account.
It may have been that the transaction was multisplit and affected more
then two accounts.

If you open the QIF file with a text editor and search for the
transaction amount you should be able to locate the transaction entry
and identify the necessary account information.

To fix the transaction in Gnucash you can either open it in the
register of the account you imported the data to or the Imbalance
account register.  If you click on the entry that is assigned to the
Imbalance account in the account column use the down arrow at the right
of the column to get the drop down list and select the desired account.
That transaction should then no longer appear in the Imbalance account
register.

The Imbalance account should always have a zero balance as any
transactions appearing there represent errors. Similarly with any
accounts labelled Orphan which AFAIK are transactions where the
assigned account for one split of the transactions has been deleted.
They exist to flag transactions which need to be fixed.

David Cousens

On Thu, 2025-02-06 at 09:06 -0300, Fred Tydeman wrote:
> I just noticed that the account Imbalance-USD has some entries.
> 
> However, all the entries are very strange in that there is NO
> corresponding second account (that is, no pair of transactions). 
> Each
> entry has a description, but the value is zero.  If I do Show Splits,
> there is no second account.
> 
> I looked at the backup files and found the date when these
> transactions happened (January 11).  In looking at the corresponding
> log file, I can see transactions that mention Imbalance.  But, I do
> not know how to read the log file.
> 
> I have done Check and Repair All and the Imbalance-USD transactions
> remain.
> 
> In looking at one of the Imbalance transactions, it corresponds to a
> stock purchase.  I can see two Start/End transactions in the log file
> related to that stock.  One of those two has the Imbalance.
> 
> It is possible that these transactions are related to an Import of a
> QIF file (which I do each Saturday).
> ___
> 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] Strange Imbalance transactions

[Derek Atkins]

Interesting..  These are all 0-value splits, so... nothing to balance
against.
I have no idea how these were created, or why.

-derek

On Thu, February 6, 2025 9:48 am, Fred Tydeman wrote:
> Attached
>
> Fedora Linux 41
> Gnucash 5.10
>
> On Thu, Feb 6, 2025 at 11:19 AM Derek Atkins  wrote:
>
>> HOWEVER -- the transactions in Imbalance SHOULD be connected to
>> transactions with other accounts.  There cannot be a lone-split
>> Imbalance
>> transaction.  So, Fred, any chance you could show a screen shot of your
>> Imbalance account?
>>
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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] Strange Imbalance transactions

[Fred Tydeman]

Attached

Fedora Linux 41
Gnucash 5.10

On Thu, Feb 6, 2025 at 11:19 AM Derek Atkins  wrote:

> HOWEVER -- the transactions in Imbalance SHOULD be connected to
> transactions with other accounts.  There cannot be a lone-split Imbalance
> transaction.  So, Fred, any chance you could show a screen shot of your
> Imbalance account?
>
___
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] How to import transactions from Release 5.10 into Release 4.8

[David Carlson]

Actually, GnuCash is quite flexible with the multi-line CSV export/Import
feature, except that the improvement to the release 5.x series isn't fully
compatible with release 4.x version, hence the choice to optionally import
the 4.x version into release 5.x. Unfortunately, the reverse to export to
4.x type CSV is not included, at least in the Export Active Register menu
choice.

If one uses the Find transaction feature and/or filter transactions
feature, one can select as many or as few transactions as desired to
include in an export.  Very Nice!.

On Thu, Feb 6, 2025 at 11:03 AM Kalpesh Patel  wrote:

> Ah, ok – different use case than what I was envisioning. Is it possible to
> export single transaction at a time, never came across that need so not
> sure there?
>
>
>
> In any case best bet is to export from higher version to lower version
> using “Simple Layout” format. It may, however, might require some
> processing after exporting but before importing, and then appropriately
> match up the columns during import.
>
>
>
> *From:* David Carlson 
> *Sent:* Thursday, February 06, 2025 11:23 AM
> *To:* Kalpesh Patel 
> *Cc:* David Cousens ; gnucash-user@gnucash.org
> *Subject:* Re: [GNC] How to import transactions from Release 5.10 into
> Release 4.8
>
>
>
> Kalpesh,
>
>
>
> This question started when I accidentally deleted a transaction from the
> file that I was editing with GnuCash 4.8 but the transaction was still
> present in the file that I was editing with GnuCash release 5.10.  I wanted
> to replace the 'lost' transaction in the file for release 4.8 editing.  (I
> am running two instances of GnuCash concurrently while testing release
> 5.10).
>
>
>
> It occurred to me that there may be a need for other users to export
> transactions while using release 5.10 or later to import back to release
> 4.x which can do the multi-line CSV import, but with somewhat different
> format details.  I thought some users may have enough transactions to need
> a better solution than a brute force one-field-at-a-time cut and paste with
> clipboard type of solution and that there could be an 'automatic' solution
> provided by a developer or experienced user.
>
>
>
> It may not continue to be possible to open the same file with either
> release 4.x or 6.x when GnuCash gets to that point.  I solved my problem
> shortly after my original post but others may need a solution in the future.
>
>
>
> On Thu, Feb 6, 2025 at 9:44 AM Kalpesh Patel 
> wrote:
>
> Hmmm. Why would you want to export from 4.8 to import into 5.10 when you
> can simply open the file in 5.10? I would think that making copy of the
> file (save-as option from GNUCash), then delete un-wanted accounts in 4.8
> version and then open that pared down one in 5.10 is much cleaner to go
> about.
>
> Are you trying to merge books (or files)?
>
> -Original Message-
> From: David Cousens 
> Sent: Wednesday, February 05, 2025 4:57 PM
> To: David Carlson ; gnucash-user@gnucash.org
> Subject: Re: [GNC] How to import transactions from Release 5.10 into
> Release 4.8
>
> David
>
> I don't think one could expect there to be a setting in Gnucash 4.8 to
> import the Export format from later versions of the program  e.g. 5.10 as
> that Export format did not exist at the time of release of GC 4.8.
>
> The workaround might to be to export the same or a similar set of
> transactions from 4.8, compare that to the format of the same or a similar
> set of transaction exported from 5.10. Then compare the two formats and
> note any differences.
>
> You may be able to get an import by a reassignment of the headers to
> different columns in the input file, but if the differences cannot be
> handled by that then using a macro/scripted editor to reformat the file to
> a format which can be imported may be necessary.
>
> David Cousens
>
> On Wed, 2025-02-05 at 13:44 -0600, David Carlson wrote:
> > There is no setting to import transactions from a csv file made by
> > release
> > 5.10 into a file using release 4.8.
> >
> > Is there a work-around?
> >
>
>
>
>
> --
>
> David Carlson
>


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

Re: [GNC] Strange Imbalance transactions

[Fred Tydeman]

On Thu, Feb 6, 2025 at 11:01 AM Brad Morrison 
wrote:

> What operating system are you using?
>
> What version of GNUCash are you using?
> https://gnucash.org/download.phtml shows that the current version is
> 5.10
>

I forgot to add those details:  Fedora Linux 41, Gnucash 5.10


> https://wiki.gnucash.org/wiki/FAQ#Importing.2FExporting_Data has some
> info on importing data, as you mentioned a regular QIF import
>
> Regarding the stock purchase with 2 start & end transactions, 1 being
> balanced and the other being imbalanced - are both entries for the same
> transaction? Possibly meaning an importing error?
>

My guess (based upon looking at the log file) is both are for the same
transaction.


> Also, why is the account titled "Imbalance-USD" - ?
>

In the past, I have seen
  Imbalance-COP
  Imbalance-GBP
  Imbalance-USD
I have transactions in multiple currencies.
___
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] Strange Imbalance transactions

[Fred Tydeman]

>
>
> The one oddball thing I see in the snapshot is that the "Transfer" column
> isn't labeled -- is it, perhaps, hiding values?
>

That is normal after one does Show Splits
___
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] Strange Imbalance transactions

[Brad Morrison]

Hi Fred/GNUCash users, 

First off, some basics: 

What operating system are you using? 

What version of GNUCash are you using?
https://gnucash.org/download.phtml shows that the current version is
5.10 

https://wiki.gnucash.org/wiki/FAQ#Importing.2FExporting_Data has some
info on importing data, as you mentioned a regular QIF import 

Regarding the stock purchase with 2 start & end transactions, 1 being
balanced and the other being imbalanced - are both entries for the same
transaction? Possibly meaning an importing error? 

Also, why is the account titled "Imbalance-USD" - ? 

---
Thanks, 

Brad - https://www.facebook.com/brad.morrison.12327/ &
https://nextdoor.com/profile/01mP46jj8KCzj3sP4 &
https://norcal.social/@BradMorrison 

On 2025-02-06 04:06, Fred Tydeman wrote:

> I just noticed that the account Imbalance-USD has some entries.
> 
> However, all the entries are very strange in that there is NO
> corresponding second account (that is, no pair of transactions).  Each
> entry has a description, but the value is zero.  If I do Show Splits,
> there is no second account.
> 
> I looked at the backup files and found the date when these
> transactions happened (January 11).  In looking at the corresponding
> log file, I can see transactions that mention Imbalance.  But, I do
> not know how to read the log file.
> 
> I have done Check and Repair All and the Imbalance-USD transactions
> remain.
> 
> In looking at one of the Imbalance transactions, it corresponds to a
> stock purchase.  I can see two Start/End transactions in the log file
> related to that stock.  One of those two has the Imbalance.
> 
> It is possible that these transactions are related to an Import of a
> QIF file (which I do each Saturday).
> ___
> 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] Strange Imbalance transactions

[Kalpesh Patel]

I see similar leg of transaction ending up in " Imbalance-USD" when performing 
an import via QIF format for investment type of accounts -- that is what these 
ones looks like. I simply delete them as they really do not effect balancing 
the overall transactions, which can be discerned with zero amount. Sometimes 
they end up here because there is no GNUCash equivalent - like commodity name 
change.


-Original Message-
From: Fred Tydeman  
Sent: Thursday, February 06, 2025 9:48 AM
To: Derek Atkins 
Cc: Brad Morrison ; gnucash-user@gnucash.org
Subject: Re: [GNC] Strange Imbalance transactions

Attached

Fedora Linux 41
Gnucash 5.10

On Thu, Feb 6, 2025 at 11:19 AM Derek Atkins  wrote:

> HOWEVER -- the transactions in Imbalance SHOULD be connected to 
> transactions with other accounts.  There cannot be a lone-split 
> Imbalance transaction.  So, Fred, any chance you could show a screen 
> shot of your Imbalance account?
>

___
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] How to import transactions from Release 5.10 into Release 4.8

[Kalpesh Patel]

Hmmm. Why would you want to export from 4.8 to import into 5.10 when you can 
simply open the file in 5.10? I would think that making copy of the file 
(save-as option from GNUCash), then delete un-wanted accounts in 4.8 version 
and then open that pared down one in 5.10 is much cleaner to go about.

Are you trying to merge books (or files)?

-Original Message-
From: David Cousens  
Sent: Wednesday, February 05, 2025 4:57 PM
To: David Carlson ; gnucash-user@gnucash.org
Subject: Re: [GNC] How to import transactions from Release 5.10 into Release 4.8

David 

I don't think one could expect there to be a setting in Gnucash 4.8 to import 
the Export format from later versions of the program  e.g. 5.10 as that Export 
format did not exist at the time of release of GC 4.8.

The workaround might to be to export the same or a similar set of transactions 
from 4.8, compare that to the format of the same or a similar set of 
transaction exported from 5.10. Then compare the two formats and note any 
differences.

You may be able to get an import by a reassignment of the headers to different 
columns in the input file, but if the differences cannot be handled by that 
then using a macro/scripted editor to reformat the file to a format which can 
be imported may be necessary.

David Cousens

On Wed, 2025-02-05 at 13:44 -0600, David Carlson wrote:
> There is no setting to import transactions from a csv file made by 
> release
> 5.10 into a file using release 4.8.
> 
> Is there a work-around?
> 



___
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] Strange Imbalance transactions

[R Losey]

On Thu, Feb 6, 2025 at 8:02 AM Brad Morrison  wrote:

> Hi Fred/GNUCash users,
>
> Also, why is the account titled "Imbalance-USD" - ?


It seems to be created that way... Mine is called the same thing, and I
think I just took a GnuCash setup years ago.

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

Re: [GNC] How to import transactions from Release 5.10 into Release 4.8

[David Carlson]

Kalpesh,

This question started when I accidentally deleted a transaction from the
file that I was editing with GnuCash 4.8 but the transaction was still
present in the file that I was editing with GnuCash release 5.10.  I wanted
to replace the 'lost' transaction in the file for release 4.8 editing.  (I
am running two instances of GnuCash concurrently while testing release
5.10).

It occurred to me that there may be a need for other users to export
transactions while using release 5.10 or later to import back to release
4.x which can do the multi-line CSV import, but with somewhat different
format details.  I thought some users may have enough transactions to need
a better solution than a brute force one-field-at-a-time cut and paste with
clipboard type of solution and that there could be an 'automatic' solution
provided by a developer or experienced user.

It may not continue to be possible to open the same file with either
release 4.x or 6.x when GnuCash gets to that point.  I solved my problem
shortly after my original post but others may need a solution in the future.

On Thu, Feb 6, 2025 at 9:44 AM Kalpesh Patel  wrote:

> Hmmm. Why would you want to export from 4.8 to import into 5.10 when you
> can simply open the file in 5.10? I would think that making copy of the
> file (save-as option from GNUCash), then delete un-wanted accounts in 4.8
> version and then open that pared down one in 5.10 is much cleaner to go
> about.
>
> Are you trying to merge books (or files)?
>
> -Original Message-
> From: David Cousens 
> Sent: Wednesday, February 05, 2025 4:57 PM
> To: David Carlson ; gnucash-user@gnucash.org
> Subject: Re: [GNC] How to import transactions from Release 5.10 into
> Release 4.8
>
> David
>
> I don't think one could expect there to be a setting in Gnucash 4.8 to
> import the Export format from later versions of the program  e.g. 5.10 as
> that Export format did not exist at the time of release of GC 4.8.
>
> The workaround might to be to export the same or a similar set of
> transactions from 4.8, compare that to the format of the same or a similar
> set of transaction exported from 5.10. Then compare the two formats and
> note any differences.
>
> You may be able to get an import by a reassignment of the headers to
> different columns in the input file, but if the differences cannot be
> handled by that then using a macro/scripted editor to reformat the file to
> a format which can be imported may be necessary.
>
> David Cousens
>
> On Wed, 2025-02-05 at 13:44 -0600, David Carlson wrote:
> > There is no setting to import transactions from a csv file made by
> > release
> > 5.10 into a file using release 4.8.
> >
> > Is there a work-around?
> >
>
>
>
>

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

Re: [GNC] Strange Imbalance transactions

[R Losey]

On Thu, Feb 6, 2025 at 8:50 AM Fred Tydeman  wrote:

> Attached
>
> Fedora Linux 41
> Gnucash 5.10
>
> On Thu, Feb 6, 2025 at 11:19 AM Derek Atkins  wrote:
>
> > HOWEVER -- the transactions in Imbalance SHOULD be connected to
> > transactions with other accounts.  There cannot be a lone-split Imbalance
> > transaction.  So, Fred, any chance you could show a screen shot of your
> > Imbalance account?
> >
>


The one oddball thing I see in the snapshot is that the "Transfer" column
isn't labeled -- is it, perhaps, hiding values?

I have created Imbalance entries by erroneously hitting "Enter" before I
finished a split transaction, but I've not seen entries without a balancing
entry.  Very odd...

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

Re: [GNC] Strange Imbalance transactions

[John Ralls]

> On Feb 6, 2025, at 08:32, Fred Tydeman  wrote:
> 
>> 
>> 
>> The one oddball thing I see in the snapshot is that the "Transfer" column
>> isn't labeled -- is it, perhaps, hiding values?
>> 
> 
> That is normal after one does Show Splits

The header changes in split view to reflect the line that has focus. Fred’s 
screenshot has one of the transaction lines focused, here’s what it looks like 
with a split focused.

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] How to import transactions from Release 5.10 into Release 4.8

[Kalpesh Patel]

Ah, ok – different use case than what I was envisioning. Is it possible to 
export single transaction at a time, never came across that need so not sure 
there? 

 

In any case best bet is to export from higher version to lower version using 
“Simple Layout” format. It may, however, might require some processing after 
exporting but before importing, and then appropriately match up the columns 
during import. 

 

From: David Carlson  
Sent: Thursday, February 06, 2025 11:23 AM
To: Kalpesh Patel 
Cc: David Cousens ; gnucash-user@gnucash.org
Subject: Re: [GNC] How to import transactions from Release 5.10 into Release 4.8

 

Kalpesh,

 

This question started when I accidentally deleted a transaction from the file 
that I was editing with GnuCash 4.8 but the transaction was still present in 
the file that I was editing with GnuCash release 5.10.  I wanted to replace the 
'lost' transaction in the file for release 4.8 editing.  (I am running two 
instances of GnuCash concurrently while testing release 5.10).

 

It occurred to me that there may be a need for other users to export 
transactions while using release 5.10 or later to import back to release 4.x 
which can do the multi-line CSV import, but with somewhat different format 
details.  I thought some users may have enough transactions to need a better 
solution than a brute force one-field-at-a-time cut and paste with clipboard 
type of solution and that there could be an 'automatic' solution provided by a 
developer or experienced user.

 

It may not continue to be possible to open the same file with either release 
4.x or 6.x when GnuCash gets to that point.  I solved my problem shortly after 
my original post but others may need a solution in the future.

 

On Thu, Feb 6, 2025 at 9:44 AM Kalpesh Patel mailto:kalpesh.pa...@usa.net> > wrote:

Hmmm. Why would you want to export from 4.8 to import into 5.10 when you can 
simply open the file in 5.10? I would think that making copy of the file 
(save-as option from GNUCash), then delete un-wanted accounts in 4.8 version 
and then open that pared down one in 5.10 is much cleaner to go about.

Are you trying to merge books (or files)?

-Original Message-
From: David Cousens mailto:davidcousen...@gmail.com> 
> 
Sent: Wednesday, February 05, 2025 4:57 PM
To: David Carlson mailto:david.carlson@gmail.com> >; gnucash-user@gnucash.org 
 
Subject: Re: [GNC] How to import transactions from Release 5.10 into Release 4.8

David 

I don't think one could expect there to be a setting in Gnucash 4.8 to import 
the Export format from later versions of the program  e.g. 5.10 as that Export 
format did not exist at the time of release of GC 4.8.

The workaround might to be to export the same or a similar set of transactions 
from 4.8, compare that to the format of the same or a similar set of 
transaction exported from 5.10. Then compare the two formats and note any 
differences.

You may be able to get an import by a reassignment of the headers to different 
columns in the input file, but if the differences cannot be handled by that 
then using a macro/scripted editor to reformat the file to a format which can 
be imported may be necessary.

David Cousens

On Wed, 2025-02-05 at 13:44 -0600, David Carlson wrote:
> There is no setting to import transactions from a csv file made by 
> release
> 5.10 into a file using release 4.8.
> 
> Is there a work-around?
> 








-- 

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.

Re: [GNC] Strange Imbalance transactions

[Derek Atkins]

Brad --

The "Imbalance-USD" account is created by GnuCash auto-magically when you
commit an unbalanced transaction and it needs to scrub it to balance it
out.  The USD implies that the imbalance is in USD (vs any other
commodity).

This can happen during imports or scheduled transaction creation if there
is an imbalance in the computation.

HOWEVER -- the transactions in Imbalance SHOULD be connected to
transactions with other accounts.  There cannot be a lone-split Imbalance
transaction.  So, Fred, any chance you could show a screen shot of your
Imbalance account?

-derek

On Thu, February 6, 2025 9:00 am, Brad Morrison wrote:
> Hi Fred/GNUCash users,
>
> First off, some basics:
>
> What operating system are you using?
>
> What version of GNUCash are you using?
> https://gnucash.org/download.phtml shows that the current version is
> 5.10
>
> https://wiki.gnucash.org/wiki/FAQ#Importing.2FExporting_Data has some
> info on importing data, as you mentioned a regular QIF import
>
> Regarding the stock purchase with 2 start & end transactions, 1 being
> balanced and the other being imbalanced - are both entries for the same
> transaction? Possibly meaning an importing error?
>
> Also, why is the account titled "Imbalance-USD" - ?
>
> ---
> Thanks,
>
> Brad - https://www.facebook.com/brad.morrison.12327/ &
> https://nextdoor.com/profile/01mP46jj8KCzj3sP4 &
> https://norcal.social/@BradMorrison
>
> On 2025-02-06 04:06, Fred Tydeman wrote:
>
>> I just noticed that the account Imbalance-USD has some entries.
>>
>> However, all the entries are very strange in that there is NO
>> corresponding second account (that is, no pair of transactions).  Each
>> entry has a description, but the value is zero.  If I do Show Splits,
>> there is no second account.
>>
>> I looked at the backup files and found the date when these
>> transactions happened (January 11).  In looking at the corresponding
>> log file, I can see transactions that mention Imbalance.  But, I do
>> not know how to read the log file.
>>
>> I have done Check and Repair All and the Imbalance-USD transactions
>> remain.
>>
>> In looking at one of the Imbalance transactions, it corresponds to a
>> stock purchase.  I can see two Start/End transactions in the log file
>> related to that stock.  One of those two has the Imbalance.
>>
>> It is possible that these transactions are related to an Import of a
>> QIF file (which I do each Saturday).
>> ___
>> 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.
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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] Using latest AqBanking

[John Ralls]

Martin released AQBanking 6.6.0 two days after the release of GnuCash 5.10. As 
noted it is already incorporated in the nightly builds and will be in the 
GnuCash 5.11 AIOs.

Since we don’t have macOS nightlies, I’d ordinarily suggest that macOS users 
who need the upgrade install GnuCash with macPorts, but their AQBanking port 
(https://ports.macports.org/port/aqbanking6/details/) is still on 6.5.4.

Since the OP has successfully built AQBanking, he might try building all of 
GnuCash, instructions at https://wiki.gnucash.org/wiki/MacOS/Quartz. It’s also 
worth trying to copy the locally-built Gwenhywfar and AQBanking dylibs and 
loadable modules into Gnucash.app: They’ll go in 
Gnucash.app/Contents/Resources/lib and Gnucash.app/Contents/Resources/share. 
Doing that will break the code signature, so be sure to run GnuCash from that 
bundle at least once to get it past Gatekeeper. I *think*, but am not certain, 
that the signature isn’t checked after first launch.

Regards,
John Ralls


> On Feb 6, 2025, at 03:57, Brad Morrison  wrote:
> 
> Hi Frank/GnuCash users, 
> 
> https://flathub.org/apps/org.gnucash.GnuCash - the GNUCash Flatpak,
> version 5.10, seems to come with the 6.5.4 version of AQBanking. 
> 
> https://aquamaniac.de/rdm/projects/aqbanking/files - according to this,
> the current version of AQBanking is 6.6.0 which was released in December
> 2024. Version 6.5.4 seems to have been released in March 2023. 
> 
> https://wiki.gnucash.org/wiki/AqBanking - this is a good overview of
> AQBanking 
> 
> Are there plans for GNUCash to upgrade AQBanking from version 6.5.4 to
> 6.6? 
> 
> ---
> Thanks, 
> 
> Brad - https://www.facebook.com/brad.morrison.12327/ &
> https://nextdoor.com/profile/01mP46jj8KCzj3sP4 &
> https://norcal.social/@BradMorrison 
> 
> On 2025-02-05 22:16, e...@gegensinn.org wrote:
> 
>> Hi GnuCash-Users,
>> 
>> I'm running GnuCash 5.10 on MacOS 15.1.1 (ARM). The app ships with a version 
>> of AqBanking incompatible with my bank. Specifically, it lacks some of the 
>> ITAN modes required since Jan 2025. I managed to install AqBanking 6.6.0 on 
>> my machine. Retrieving accounts and balances works fine with the new 
>> aqhbci-cli. Is there a way to point GnuCash to the new installation and 
>> libraries instead of the bundled ones?
>> 
>> Best 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.
> ___
> 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.