OL-221-A - Malformed QFX File?

dan_wilks

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

Rocket J Squirrel

Reading through the OFX spec is enough to make you need spectacles. But yes, BALAMT requires an amount.

Rocket J Squirrel

Reading through the OFX spec is enough to make you need spectacles. But yes, BALAMT requires an amount.

dan_wilks

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