Indentify category by bank account number
piggyb
piggybattery at gmail.com
Wed Apr 1 09:07:57 EDT 2015
At the moment I am using a income and a expense column (see attachment)
categorys.csv
<http://gnucash.1415818.n4.nabble.com/file/n4677575/categorys.csv>
I like to import the QIF file without category field L
The first time when I import the file below, GnuCash asks for the category
name of the expense/income. The second time when importing the same
expense/income it automatically recognized the category selected before.
This also works when the Payer ID is missing then it uses the number field.
The problem is when two different payers has the same name. CnuCash import
assistant recognizes as the same payer and wants to put it in same
category.
Is there a way to have GnuCash use the bank account number to link the
category?
------------------------------------------------------------------------------------------------
!Type:Bank
D31-12-2014
NEU07ABCB0004748412 <--- Indentify category by bank account number
T-470,12
MRent
PCompany <--- import assistant indentifies expenses:housing
A45 Mercury Close, Southampton
^
D31-12-2014
NNA56ABER0561574865
T-70,12
MHealth insurance
PBusiness <--- import assistant indentifies expenses:insurance
A45 Mercury Close, Southampton
^
------------------------------------------------------------------------------------------------
!Type:Bank
D31-12-2014
NEU07ABCB0004748412
T-470,12
MRent
P Same name differed payer <--- import assistant indentifies
expenses:housing
A45 Mercury Close, Southampton
^
D31-12-2014
NNA56ABER0561574865 <--- Bank account number
T-70,12
MHealth insurance
P Same name differed payer <--- import assistant indentifies
expenses:housing
A45 Mercury Close, Southampton
^
--
View this message in context: http://gnucash.1415818.n4.nabble.com/creating-QIF-file-under-Dos-using-AWK-tp4676673p4677575.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
More information about the gnucash-user
mailing list