Indentify category by bank account number

[Edward Doolittle]

Your CSV to QIF script can determine the correct category from the bank
account. Set up a hash which maps bank account identifiers to categories,
then put the appropriate print command into the output of your script.

On 1 April 2015 at 07:07, piggyb <piggybattery at gmail.com> wrote:

> 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.
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>



-- 
Edward Doolittle
Associate Professor of Mathematics
First Nations University of Canada
1 First Nations Way, Regina SK S4S 7K2

« Toutes les fois que je donne une place vacante, je fais cent mécontents
et un ingrat. »
-- Louis XIV, dans Voltaire, Le Siècle de Louis XIV, Chap. XXVI