Windows Quicken split transaction incorrectly imported

gyrosoft
gyrosoft Quicken Windows Subscription Member

I have been using Quicken Deluxe for many years, automating my transaction input via qif. The qif file I auto produce includes split to variety of quicken accounts. All worked well till recently - maybe a few months ago. Then quicken started importing split transaction incorrectly, for example, skipped importing payee all together, or skipped one or few split transactions and show total of only one transaction.

Test 1 - I exported a few split transactions to qif file and imported that file; notice the same issue as described above.

Test 2 - I created a new quicken file to isolate possible issue with my working file; all qif were imported correctly.

Question - are there any tools to identify setting/data in my working file that cause quicken import incorrectly qif file other than "Validate and repair"?

Comments

  • NotACPA
    NotACPA Quicken Windows Subscription SuperUser ✭✭✭✭✭
    edited December 2024

    How is that QIF being created? Can you show us an example of a txn (in the QIF) that's split?

    The QIF can be opened with NotePad or WordPad … do NOT open with MS Word.

    And, how does your FI know about the splits? Because the FI has no idea what your Q categories are nor how you'd want to split the txn.

    Q user since February, 1990. DOS Version 4
    Now running Quicken Windows Subscription, Business & Personal
    Retired "Certified Information Systems Auditor" & Bank Audit VP

  • Chris_QPW
    Chris_QPW Quicken Windows Subscription Member ✭✭✭✭

    Other than "Validate and repair" (including Super Validate) or maybe a full export/import of a QIF file there isn't any other way to fix a data file.

    The only settings for QIF files are in the QIF export/import dialogs.

    Signature:
    This is my website: http://www.quicknperlwiz.com/
  • gyrosoft
    gyrosoft Quicken Windows Subscription Member

    I generate the qif files with software I write, downloading utilities bill for example or payment log and produce the qif. I can provide many examples, but the facts are

    1. when importing the qif to a new "fresh quicken file" all works well

    2. when I import an exported qif file of my "working file" it fails, consequently it must be a bug that my data - "working file", triggers

    Here is an example of my generated qif - in this example I process csv payment file to qif

  • gyrosoft
    gyrosoft Quicken Windows Subscription Member

    QQ - NotACPA write "…the FI has no …"; what do you mean "FI"?

  • Chris_QPW
    Chris_QPW Quicken Windows Subscription Member ✭✭✭✭

    FI → Financial Institution.

    I don't see anything wrong with the QIF data.

    Signature:
    This is my website: http://www.quicknperlwiz.com/
  • gyrosoft
    gyrosoft Quicken Windows Subscription Member

    …and yes, the issue surfaced about October build; I was hoping someone from the community keeps older builds/version of Quicken

  • gyrosoft
    gyrosoft Quicken Windows Subscription Member

    Thanks Chris, I'll check it out!

  • gyrosoft
    gyrosoft Quicken Windows Subscription Member

    Unfortunately "Quicken provided older patch"; however the core software - quicken.exe, still the same, meaning the latest. I'd love to have an older version of quicken.exe

  • Chris_QPW
    Chris_QPW Quicken Windows Subscription Member ✭✭✭✭

    qw.exe is actually just the "shell" of the program, most of the functionality isn't in qw.exe. Most of the functionality is in the *.DLLs. So, it very may well not change for older versions of Quicken. But with that being said I would say that over 90% of the time that people blame a problem on a given patch update, they are mistaken. Whatever problem they are having is caused by external causes like something on the server, or on their machine. Or in your case, the data file.

    Signature:
    This is my website: http://www.quicknperlwiz.com/