[GNC] "no linked account" during transaction import

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

[GNC] "no linked account" during transaction import

dodpears
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
all transactions.

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
transaction?

Thanks!
Doug Pearson
_______________________________________________
gnucash-user mailing list
[hidden email]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] "no linked account" during transaction import

David Cousens
This post was updated on .
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.

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:
                                                                    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
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
David Cousens