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

Andrew Angell
Andrew Angell Member ✭✭✭
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!

Best Answer

  • Chris_QPW
    Chris_QPW Member ✭✭✭✭
    Answer ✓
    I just checked PayPal's QIF export since you stated it was from them, and yes, the put in:
    CX
    for every completed transaction.
    Signature:
    (I'm always using the latest Quicken Windows Premier subscription version)
    This is my website: http://www.quicknperlwiz.com/

Answers

  • splasher
    splasher SuperUser ✭✭✭✭
    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.
    -splasher  using Q since 1996 -  Subscription  -  Win10
    -also older versions as needed for testing
    -Questions? Check out the  Quicken Windows FAQ list
  • Chris_QPW
    Chris_QPW Member ✭✭✭✭
    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.
    Signature:
    (I'm always using the latest Quicken Windows Premier subscription version)
    This is my website: http://www.quicknperlwiz.com/
  • Andrew Angell
    Andrew Angell Member ✭✭✭
    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
    Andrew Angell Member ✭✭✭
    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
    CX
    P
    ^
    !Type:Cash
    D02/25/2022
    T45.35
    LExpress Checkout Payment
    SExpress Checkout Payment
    $47.99
    SFee
    $-2.64
    CX
    MOffers for WooCommerce
    PMariano Cao
    ^
  • Chris_QPW
    Chris_QPW Member ✭✭✭✭
    Answer ✓
    I just checked PayPal's QIF export since you stated it was from them, and yes, the put in:
    CX
    for every completed transaction.
    Signature:
    (I'm always using the latest Quicken Windows Premier subscription version)
    This is my website: http://www.quicknperlwiz.com/
  • Andrew Angell
    Andrew Angell Member ✭✭✭
    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
    Chris_QPW Member ✭✭✭✭
    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/
    Signature:
    (I'm always using the latest Quicken Windows Premier subscription version)
    This is my website: http://www.quicknperlwiz.com/
  • Andrew Angell
    Andrew Angell Member ✭✭✭
    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
    Chris_QPW Member ✭✭✭✭
    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.
    Signature:
    (I'm always using the latest Quicken Windows Premier subscription version)
    This is my website: http://www.quicknperlwiz.com/
This discussion has been closed.