TransWikia.com

Gnucash creating transactions for wrong account in import

Personal Finance & Money Asked on March 20, 2021

Something seems to be broken in the setup of my online accounts: whenever I get transactions for one of my accounts (via HBCI), Gnucash creates transactions for a different account and also looks for transactions to match in that other account.

I would assume the problem is that I’ve matched the accounts wrong, but first I’ve quadruple-checked that the online account is associated with the correct Gnucash account and second, if it weren’t, then Gnucash wouldn’t even offer the option to “Get transactions” for that account in “Online Transactions.”

At some point, I did have the online account associated with the wrong Gnucash account and I suspect that Gnucash simply doesn’t update that setting correctly. But it doesn’t show this faulty association anywhere I can see.

My question is: how does Gnucash decide for which account to create transactions when importing, and how do I change that?

2 Answers

Okay, so one possible solution is to copy the .gnc file to a file ending in .gz, uncompress it using gunzip, cut the online_id from the account that is the wrong one and paste it into the correct account. The block itself with enclosing tags should look like this:

<slot> <slot:key>online_id</slot:key> <slot:value type="string">34098409741-23309845</slot:value> </slot>

Unfortunately, I can't verify this as all my testing has set off some security measures that have now locked me out of online access to my accounts. I'll try posting a follow up when I test it in full.

BTW, it goes without saying: make a backup of your original .gnc and always use cp -iv

Correct answer by Nathan Paul Simons on March 20, 2021

I was having the same error, and what did it for me was closing the tab associated with the correct target account and reopening it from the accounts list, as weird as that sounds. Then I tried to download the transactions again and it worked. Somehow, the mapping got stale leaving that window open for so long (years) across many version upgrades and account modifications.

Answered by brianclements on March 20, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP