Add a FITID column in QWin investment registers [EDITED]

Rocket J Squirrel
Rocket J Squirrel SuperUser ✭✭✭✭✭
It appears that QMac has a FITID column. I did not know that. Can we please get a FITID column in QWin registers?
This would make duplicate transactions so much easier to find, especially if we could sort on that column.
Quicken user since version 2 for DOS, now using QWin Premier Subscription on Win10 Pro.
7
7 votes

New · Last Updated

Comments

  • Rocket J Squirrel
    Rocket J Squirrel SuperUser ✭✭✭✭✭
    Just to add, I know that QWin has a "Downloaded ID" field in banking registers only. But it is too narrow to see the entire FITID.
    For example, a transaction whose entire FITID is 00094320124-126.5202001244201.86 only shows up to the 5202, truncating 12 characters, and I can find no way to see the whole ID in the column.
    And the entire column is missing from investment registers.

    Quicken user since version 2 for DOS, now using QWin Premier Subscription on Win10 Pro.
  • UKR
    UKR SuperUser ✭✭✭✭✭
    Tell the banks to K.I.S.S.
    The FITID doesn't have to be a mile-long string composed of things like account number + timestamp + amount or some-such "make it unique" folderol.
    All you need for a FITID to be is a sequence number that is assigned to each transaction of a customer as soon as the transaction is recorded and stored within the transaction record in the bank's database .
    Whenever the transaction is downloaded, for the first time or anytime later, by whatever means, DC, EWC, etc., the same unique FITID is always transmitted to the customer. This avoids the need to recalculate FITIDs, potentially arriving at different results using different calculation methods based on protocol.
    It's my understanding that a FITID is supposed to be a "unique transaction number". Let's keep it simple and make it truly unique within the transactions of each customer. It doesn't have to be a totally unique number within the entire universe. Unique within the account suffices.

  • Rocket J Squirrel
    Rocket J Squirrel SuperUser ✭✭✭✭✭
    UKR said:
    Tell the banks to K.I.S.S.
    Righty right right. I'll just call up the CEOs of all my FIs and tell them to KISS. I speak with them so frequently I have them on speed dial. This should only take a few minutes.
    Quicken user since version 2 for DOS, now using QWin Premier Subscription on Win10 Pro.
  • Chris_QPW
    Chris_QPW Member ✭✭✭✭
    UKR said:
    Tell the banks to K.I.S.S.
    The FITID doesn't have to be a mile-long string composed of things like account number + timestamp + amount or some-such "make it unique" folderol.

    Yeah it doesn't have to be, but it can be.  The OFX standard says it can be up to 255 characters so it shouldn't be truncated.
    And from what I see, it isn't truncated, just expand the DownloadedID column.


    And as long as it is unique and the financial institution can reproduce it there isn't anything wrong with it.  Note that timestamp is the timestamp of the transactions which would have come straight out of their database.  It isn't going to change.

    If you want to complain about bad algorithms for generating unique Ids, look no further than Intuit and their generation of them for Express Web Connect!
    They use a "seed number" that if you reset the account or deactivate/activate gets changed.  And they don't account for the fact that there might be multiple transactions on the same day with the same payee and amount!
    Signature:
    This is my website: http://www.quicknperlwiz.com/
  • Rocket J Squirrel
    Rocket J Squirrel SuperUser ✭✭✭✭✭
    Chris_QPW said:

    And from what I see, it isn't truncated, just expand the DownloadedID column.

    Genius. I hadn't thought to collapse my 2-line register to 1 line.
    The best part is that the 1-or-2 line options retain their own column settings. So I can set my accounts to show the FITID in the 1-line view and leave its non-expandable clutter out of my usual 2-line view.
    Quicken user since version 2 for DOS, now using QWin Premier Subscription on Win10 Pro.
  • UKR
    UKR SuperUser ✭✭✭✭✭
    When I earlier in this discussion commented about "K.I.S.S." ... here's a credit card company that's taken FITIDs to a whole new level:
    I mean: Seriously! Is that really necessary?! Especially when one compares to the next field, INTU.CC_TXN_ID. Short, sweet and unique, too.
  • Chris_QPW
    Chris_QPW Member ✭✭✭✭
    Wow, yes I agree that financial institution is taking it to extremes!

    Looks to be some kind of hash/encryption of all the payment details, but even then it doesn't have to be that long.

    Here is one that my program generated.
    w9mcE6NrckMw80BKVPV8OQ

    Signature:
    This is my website: http://www.quicknperlwiz.com/
  • Rocket J Squirrel
    Rocket J Squirrel SuperUser ✭✭✭✭✭
    Edited title of post to remove "bank and" before "investment registers" now that I know how to see the full extent of the FITID in banking registers.
    Quicken user since version 2 for DOS, now using QWin Premier Subscription on Win10 Pro.