QIF Record and field layouts

[Charles Day]

On Sat, Apr 25, 2009 at 4:59 PM, Tom Bullock <tbullock at nd.edu> wrote:

> Hi Rick,
>
> Since you wrote your thoughts below, I have been reading the references you
> and others gave me.  Coming back at you with thoughts interspersed into your
> message below.
>
> Rick Rogers wrote:
>
>> Tom: These are Excel and Calc macros that you add on. They appear to be
>> written by the same person. I can only relate my satisfaction with the
>> OO Calc one. I have used it several times (including a few minutes ago)
>> with no problems using Vista.
>>
>> The data I converted with the macro was almost two years of checking
>> account history downloaded from my bank that  I brought into Calc. I
>> used Calc to assign each transaction to various category and
>> sub-categories for the lowest levels of my chart of accounts. The author
>> has a short but adequate help file showing a sample column layout.
>>
> It sounds like you are describing a lot of hand tweaking transaction by
> transaction once the bank data was placed in the Calc spreadsheet.  Is that
> correct?  I expect that the data you received from your bank was close in
> field formatting and sequencing one to the other so that you were fairly
> close to the QIF arrangement.  Correct?
>
>> I
>> have not attempted to import splits, however it appears able to do this.
>>
>> I tested it first with a small segment of the data I wanted to import. I
>> set GnuCash to not automatically save the file periodically, (I always
>> do this before importing) so I can just close it if I have created
>> problems and restart to where I was before the import. You can convert
>> and import as many segments as you want. It doesn't have to be all at
>> once.
>>
>>
> Importing in batches seems reasonable.  Would a batch consist of all of one
> type of transaction from the input side?  Or is a batch governed by what QIF
> needs for its information?
>

I would not advise using multiple QIF files unless you import them all
together, in one run. Otherwise it will cause you no end of headaches from
duplicate transactions or mismatched transfers. The only exception to this
would be if your files are organized into different date ranges, and in that
case, you should still make sure to import all files with overlapping dates
in the same run.

-Charles


> TIA for your thoughts.
>
> Tom
>
>> Hope this helps, Rick
>>
>>
>> Tax Assistance Program - ( taptax ) wrote:
>>
>>
>>> Rick,
>>>
>>> Are you saying that XL2QIF should work using Excel because a different
>>> program worked using Open Office Calc?  Do I have your meaning?
>>>
>>> Tom
>>>
>>> -----Original Message-----
>>> From: Rick Rogers [mailto:rrogers at rcn.com]
>>> Sent: Monday, April 20, 2009 1:50 PM
>>> To: sunfish62 at yahoo.com
>>> Cc: gnucash-user at gnucash.org; Tax Assistance Program - ( taptax )
>>> Subject: Re: QIF Record and field layouts
>>>
>>> Regarding XL2QIF, I had complete success with their counterpart for Open
>>> Office Calc. They also have some links to QIF file format references.
>>>
>>>
>>>
>> _______________________________________________
> 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.
>