Quicken Community is moving to Single Sign On! Starting 1/22/21, you'll sign in to the community with your Quicken ID. For more information: http://bit.ly/CommunitySSO

OL-221-A - Malformed QFX File?

My bank recently updated it's on-line banking software and now I can't download my web-connect Visa account. Quicken just responds with an OL-221-A error. The connection log pointed me to:

20200412 16:47:09: Not all required fields present. Object: AVAILBAL missing tag: BALAMT

The offending bit of the downloaded qfx file is:

<AVAILBAL>
<BALAMT>
<DTASOF>20200412234009
</AVAILBAL>

Before I go complain to the bank I just wanted to make sure that the OFX spec really doesn't allow the BALAMT to be empty.

Thanks

Best Answer

Answers

  • dan_wilks
    dan_wilks Member ✭✭
    I'll try to get the bank to get their provider to throw in the 0.00 for BALAMT that I'm adding in manually before importing.

    Note: The OFX 1.0 DTD is slightly ambiguous.

    <!ELEMENT AVAILBAL - - (BALAMT , DTASOF)>
    <!ELEMENT BALAMT - o %AMTTYPE>
    <!ENTITY % AMTTYPE "(#PCDATA)">

    I'm pretty sure that PCDATA is allowed to be empty so as long as the BALAMT tag is present it might be legal.

    Since AVAILBAL itself is optional I'll suggest that they simply leave it off if they don't want to risk the incorrect 0.00 and can't come up with the correct balance.

    <!ELEMENT CCSTMTRS - - (CURDEF , CCACCTFROM , BANKTRANLIST? , LEDGERBAL , AVAILBAL? , MKTGINFO?)>

    Thanks,
    Dan
This discussion has been closed.