creating QIF file under Dos using AWK

Derek Atkins warlord at MIT.EDU
Wed Mar 25 11:29:07 EDT 2015


Tommy Trussell <tommy.trussell at gmail.com> writes:

> On Mon, Mar 23, 2015 at 5:25 AM, piggyb <piggybattery at gmail.com> wrote:
>
>> Derek Atkins wrote
>> >> Is there a field that I can use to store the bank number of
>> grandmother's
>> >> cake factory?
>> >
>> > Not really from the importer.  Once the account gets created you could
>> > put it into the Account Notes field?
>>
>> Probably an unnecessary question, but just to make sure
>>
>> So the best field to place a unique ID would be the Payee field?
>> *P*H.J. Simpson 123456
>> *P*H.J. Simpson 123457
>>
>>
> If you want a unique ID for each transaction, why not use the QIF N field?
> It doesn't even have to be strictly numeric.
>
> http://en.wikipedia.org/wiki/Quicken_Interchange_Format

Indeed, I would NOT put unique IDs into the Payee field; you want the
Payee field to be replicated every time you go to the same, umm, payee.
E.g., every time you pay "PHJ Simpson".

The Num column is a great place for unique ids.

> 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