Red line on OFX input

[Alton Brantley]

Just a heads up on this. CHECK THE DATE OF THE MATCH! If you have recurring transactions, then it’s possible that this is matching to a previously cleared transaction and will not be added to the import. These can sometimes be hard to track down!


Message: 1
Date: Sat, 28 May 2016 06:54:08 -0700
From: John Ralls <jralls at ceridwen.us <mailto:jralls at ceridwen.us>>
To: "A.J. Bonnema" <gbonnema at xs4all.nl <mailto:gbonnema at xs4all.nl>>
Cc: Gnucash Users <gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>>
Subject: Re: Red line on OFX input
Message-ID: <67754EC6-60C7-414F-BB4C-4CBF714A2E37 at ceridwen.us <mailto:67754EC6-60C7-414F-BB4C-4CBF714A2E37 at ceridwen.us>>
Content-Type: text/plain; charset=us-ascii

> On May 28, 2016, at 5:56 AM, A.J. Bonnema <gbonnema at xs4all.nl <mailto:gbonnema at xs4all.nl>> wrote:
> 
> Hi all,
> 
> I have been using Gnucash for quite some time now (started around 2010) and for one thing the meaning eludes me. I wonder if anyone understands the significance. The problem is a red line in the processing of the input. I get to this line as follows:
> 
> 1. I import from the Rabo bank using CSV.
> 
> 2. I convert the csv to OFX using a script of my own (Python).
> 
> 3. I always import from 1st of January till current date. Due to the nature of FITID I normally have no problems. I make sure they are different.
> 
> 4. I use Gnucash/import/OFX to import the file.
> 
> Usually I get at least one line that is turned off for automatic import and is completely red. I included a screenprint. The data is real, but not sensitive. I have never discovered anything special about the line. It is never a duplicate and I really have no idea why I shouldn't import it. Usually I just tick the "A" column and import it anyway.
> 
> Can anyone help me interpret this line: what does it mean?

A red line is one that will not be imported, usually because GnuCash thinks it's a duplicate. You'll notice that none of the A/U+R/R checkboxes is ticked; to include the transaction in the import, tick one of them.
Regards,
John Ralls