import QIF from KMyMoney

David Hampton hampton-gnucash at rainbolthampton.net
Fri May 5 01:30:43 EDT 2006


On Fri, 2006-05-05 at 01:01 -0400, Martin Meyer wrote:

> D2006-3-3
> Mme plus $60 for Jimmy
> T(450.00)
> N193
> PGeneral Realty Company
> LBills:Rent
> ^
> 
> The date format is negotiable and it seems I can switch out , and . in
> the output for separators.

My guess would be that the problem is the "T(450.00)" line.  Try
changing it to "T-450.00".

> What format is GnuCash expecting for this stuff?

Here's a comment about the QIF format from the source tree:

  The QIF is an old and rather broken file format defined by Intuit
  for exporting Quicken data.  It is 'broken' because the format
  is ambiguous in many places, non-standard between different releases
  and applications, and even varies subtly from country to country (in
  particular, the way dates and amounts are represented), and fails
  to define important data (such as the currency denomination, or the 
  exchange rates when transferring between accounts marked in different
  currencies).  Importing a QIF file can require significant manual
  intervention by the user in order to get the data straight.

Yours is the first QIF file I've seen that used parentheses to denote
negative numbers instead of a minus sign.  Yet another way that QIF is
inconsistent in the way it represents data.

David




More information about the gnucash-user mailing list