[GNC] "no linked account" during transaction import
Hello. Newbie here. I'm attempting to "Import Transactions from CSV"
Transactions are formatted as, for example:
Account Date Description Amount
Expenses:Auto:Gas 1/1/2019 Shell Service 70
Expenses:Clothes 1/1/2019 Ann Taylor 50
Expenses:Internet 1/1/2019 Comcast 50
Expenses:Dining 1/1/2019 McDonald's 4.50
At "Import Preview" I map the Transaction.CSV" column names to GnuCash
field names directly (name = name) except "Amount" maps to "Withdrawal".
At "Match Import and GnuCash accounts" I receive "No Linked Account" for
I would have thought(?) that the Transactions.CSV "Account" name
corresponding exactly to the GnuCast account name would have auto-matched.
Am I wrong about that?
How do I avoid having to manually make a mapping for each and every
Re: [GNC] "no linked account" during transaction import
This post was updated on .
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
You may still have to map the names in the imported records at first to the names in GnuCash on the first occasion you import a record using a specific name. GnuCash should remember mapping assignments for subsequent imports. This is designed to deal with cases where you have no control over what the target account may be called (e.g. the bank assigns an expense category for example) and you wish to map external names onto the account names in GnuCash). I haven't experimented with this aspect of the importer to be sure how it handles names which are an exact match for the full GnuCash account name. as yet.
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:
(formal accounting labels selected Debit Credit
Asssets:Current Assets: Bank 70