I am using Gnucash for personal use, as a new user, and whilst I have managed to arrange my accounts as I wish I have an issue with importing my bank transaction data.
With my bank I have a set up with three accounts (1 joint, 1 checking, 1 savings) between which I make many internal bank transfers (e.g. 1 every 2/3 days). Let's call them "Account A", "Account B", and "Account C".
When I import my bank data I thus end up having many transactions of the type:
Account A: 01/01/2022, A12345678 Bank Transfer, +$100, Unspecified
Account B: 01/01/2022, A12345678 Bank Transfer, -$100, Unspecified
I.e. Gnucash has not been able to identify that these are clearly the same transaction and thus records the same transaction twice from each account's point of view (one from each data file from each bank account - that's how the bank gives it to me). Note, they have the exact same description string including identical serial number, date and [negative] dollar value, and I import all the data files at once.
What I really need is a single transaction of type:
01/01/2022, A12345678 Bank Transfer, $100, Credit: Account A, Debit: Account B.
But I don't know of any way to automate this across all such transactions.
Currently I have to go through all such transactions manually, change the transaction in Account A to
Account A: 01/01/2022, A12345678 Bank Transfer, +$100, Account B
and then delete the corresponding transaction in account B, or vice versa.
This is ridiculously time consuming when there are literally hundreds of such transactions, for what seems like should be a very common issue.
The closest answer I can see is this, but as far as I can tell this is just suggesting doing the above (i.e. going through it manually).
Does anybody have any better ideas?