[GNC] "no linked account" during transaction import

David Cousens davidcousens at bigpond.com
Wed Mar 27 22:13:21 EDT 2019


Doug,

In the CSV Import Preview Window you will see adrop down list box labelled
Account. This allows you to select the account you are importing the
transactions into, in this case most likely a bank account of some form. 
The column which you applied the header Account to should be assigned the
header "Transfer Account" rather than "Account" as the latter designates the
account for the first split or entry
 while "Transfer Account"  designates the second split or entry associated
with the transaction. The first split or entry in the double entry
transaction will be the split to the bank account into which you are
importing the transaction. The sign convention your bank has adopted will
determine whether the column with the amounts will be labelled Deposit or
Withdrawal but it would normally be labelled as a withdrawal as you are
taking that amount out of the bank account you are importing the
transactions into. This should then import without having to map the
transactions. 

The other way is to use the multiline format which specifies the account and
amount(signed) for each split of the transaction in which case the "Account"
header is used to the column containing the account names. This is a
relatively new import mode and testing and documnetation is still being
developed for the importer.

The name Transfer Account is a bit of a misnomer in accounting terms but I
think it comes from a simple illustration of  atransaction as a transfer of
money from one account to another. In GnuCash it is commonly used to refer
to the account which is the target of the second "split" or entry in a
double entry transaction.

If you examine your transactions after importing in the bank account
register and expand the splits with the Split button in the toolbar you
should see something like the following:
                                                                    Deposit     
Withdrawal
(formal accounting labels  selected                  Debit          Credit       
)
Expenses:Auto:Gas                                         70               
Asssets:Current Assets: Bank                                             70                   

Hope this makes it a bit clearer

David Cousens



-----
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html


More information about the gnucash-user mailing list