csv2qfx separating transactions by account

CSV2QFX SEPARATING TRANSACTIONS BY ACCOUNT MANUAL

This retains the original imported transactions with their separate comments. Just open up the 'Transfer' account to match the amounts.Īlternatively, if you want to have a direct link, you can reverse the two transactions and create a third. Note that if BTransfer and CTransfer were a single account (say, Transfer) then you don't have to do anything.

CSV2QFX SEPARATING TRANSACTIONS BY ACCOUNT MANUAL

This matching is still a manual process, but at least the link is made within a single account. You can then open up 'logical linkage account' to match up the amounts visually. In each of the above transactions, replace both 'BTransfer' and 'CTransfer' with 'logical linkage account'.

'credit card account': $100 Deposit to 'CTransfer', comment 'the other comment is false (just kidding)'Ĭreate another asset account, which I'll name 'logical linkage account'.

'bank account': $100 Withdrawal from 'BTransfer', comment 'the other comment is true'.

For generality, I'll assume that the accounts named in the Transfer columns are different.

Let's say you have the following transactions in separate asset accounts, and you want to link them. I found the question ' How do I join transactions after importing from multiple bank account statements in GNUCASH?', but the answer there involves deleting one of the transactions, which would mean that I loose the information encoded in its description, which I do not want. without deleting one of them? Does GnuCash have a way to tell it 'this transaction in account A is actually that other transaction in account B'?

How do I fix this, without loosing the individual transactions, i.e. there are now two transactions showing up for this transfer, and the balance of both accounts is off by the amount transferred. Now both transactions show up in the opposite account, i.e. It has the same absolute amount (with opposite sign), but different descriptions (and different types of information encoded in the description).Īfter I finished the import, I set the transfer field of both transactions to 'bank account' and 'credit card', respectively. Among these transactions is one that transfers money from the bank account to the credit card.

I imported (Actions > Online Actions > Get Transactions.) transactions of my two of my accounts (bank account and credit card).

Csv2qfx separating transactions by account