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