Automatically categorize transaction by payer ID

Derek Atkins warlord at MIT.EDU
Tue Mar 31 11:00:55 EDT 2015


Hi,

piggyb <piggybattery at gmail.com> writes:

> It's unclear to me what field GnuCash uses as unique payer ID to categorize
> payments or deposits

Okay, I think someone (possibly me) is confused about what exactly you
are asking..  So let's step back and clarify a bit, okay?

> When I import the payments with the bank-account-numbers 101 and 102 GnuCash
> sees it as one account.

Are these actually TWO accounts?  Let's be specific here.  Do you have
TWO bank/asset/cash accounts?  Because the way you're writing the QIF
you're telling the importer that you only have a single bank/asset/cash
account with two transactions.

> How can I make sure that every time I import the bank-account-number2 101 or
> 102 the transaction automatically goes to the belonging category/account
> (home::maintenance and the other Leisure::night-out)?

You're conflating two distinct things here:  Bank Accounts (Assets) and
Category Accounts (Expenses).

So let's step back:

How many ASSET accounts are involved here?  (An asset would be a Bank,
Checking Account, Cash in Wallet)..  We could also consider a Liability
account (e.g. Credit Card) here.  This is the important question to
answer.  If you have two transactions both being paid *from* the same
place, that's a single asset/liability account.

As for directing a transaction to a unique Category (Expense Account),
that's easy REGARDLESS of the number of Asset accounts you have:  Use
the L setting to specify the Category/Expense Account.  For example:

> !Type:Bank
> D31-12-2014
> T-30,12
> MHome reparatie
> N101
> PH.J. Simpson
> A45 Mercury Close, Southampton
  LExpenses:Home Repairs    <---------  This is the expense category for
                                        this txn
> ^
> D28-12-2014
> T-30,12
> Ma night at moo's
> N102
> PH.J. Simpson
> AAlresford Road, Winchester
  LExpenses:Dining          <--------- Ths is the expense category for
                                       THIS txn
> ^ 

Hope this helps,

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available


More information about the gnucash-user mailing list