nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Is there a way to change the default reconciliation status of imported transactions?

Andrew Angell

When I manually import QIF files from bank downloads it brings them in as Reconciled. Is there a way to change this so they come in as cleared or even no reconcilation status?

Any information on this would be greatly appreciated. Thanks!

Find more posts tagged with

Reconcile

File Import

Accepted answers

Chris_QPW

I just checked PayPal's QIF export since you stated it was from them, and yes, the put in:
CX
for every completed transaction.

All comments

splasher

Do these transactions have Memorized Payees with the CLR status as R? If so, change the Memorized Payee and lock it so that it won't be changed during future use.

I do QIF imports using ImportQIF and I don't have the issue that you describe.

Chris_QPW

QIF files can have the cleared/reconciled status in them. And if they do, Quicken is going to obey that. And no there isn't any way to override it. In fact, these days Quicken does very little processing of QIF before dumping them into the register.

Here is an example of a QIF transaction (QIF files can be edited with a text editor):

D01/11/2011

NN/A

PSUBWAY 03348364

T-7.61

^

It is the C line that control this. C with nothing after it or missing is uncleared, C* is cleared and CX is reconciled.

Andrew Angell

splasher said:

Do these transactions have Memorized Payees with the CLR status as R? If so, change the Memorized Payee and lock it so that it won't be changed during future use.
I do QIF imports using ImportQIF and I don't have the issue that you describe.

No, they don't, and it's every single transaction. It doesn't happen with all import files I work with, but PayPal for sure does it. Must be something with the way they format their QIF export I guess.

Andrew Angell

Chris_QPW said:

QIF files can have the cleared/reconciled status in them. And if they do, Quicken is going to obey that. And no there isn't any way to override it. In fact, these days Quicken does very little processing of QIF before dumping them into the register.

Here is an example of a QIF transaction (QIF files can be edited with a text editor):
C*
D01/11/2011
NN/A
PSUBWAY 03348364
T-7.61
^

It is the C line that control this. C with nothing after it or missing is uncleared, C* is cleared and CX is reconciled.

This is what they look like, and I can't tell where the R status would be coming from..??

!Type:Cash

D02/25/2022

T-222.40

LGeneral Withdrawal

SGeneral Withdrawal

$-222.40

SFee

$0.00

!Type:Cash

D02/25/2022

T45.35

LExpress Checkout Payment

SExpress Checkout Payment

$47.99

SFee

$-2.64

MOffers for WooCommerce

PMariano Cao

Chris_QPW

I just checked PayPal's QIF export since you stated it was from them, and yes, the put in:
CX
for every completed transaction.

Andrew Angell

Chris_QPW said:

I just checked PayPal's QIF export since you stated it was from them, and yes, the put in:
CX
for every completed transaction.

So it looks like I could do a Find/Replace in the QIF file to set those to C instead, and that would give me what I'm wanting. Thanks!

Chris_QPW

You might want to consider downloading the CSV file instead and use my program to convert it to QIF and import it. It is free: ImportQIF: http://www.quicknperlwiz.com/

Andrew Angell

Chris_QPW said:

You might want to consider downloading the CSV file instead and use my program to convert it to QIF and import it. It is free: ImportQIF: http://www.quicknperlwiz.com/

Have you considered a web-based version of this?

Chris_QPW

Andrew Angell said:

Chris_QPW said:

You might want to consider downloading the CSV file instead and use my program to convert it to QIF and import it. It is free: ImportQIF: http://www.quicknperlwiz.com/

Have you considered a web-based version of this?

Nope. Web based ones requires web servers with extra security and services that aren't free, not to mention much harder to code for because of the lack of the libraries/functions and lack of restrictions that are on web applications. There is a reason there isn't a full verson of Quicken in web-based form.

Note ImportQIF also interacts with Quicken to import the QIF file, which wouldn't be possible with a web based one.

And then of course someone might get the crazy idea to suggest I do something as stupid as trying to do the same thing Express Web Connect is trying to do (and not doing that great of a job) and access financial institution websites directly.

I have toyed with the idea that I should rewrite it in C++ because the Perl compiler I'm using has been obsoleted, but even that translation is more than I want to do at this point since there are lots of functionality in Perl that C++ doesn't have, not to mention custom library routines that I have built up over the years.