Some versions of Sage still ship with an OFX parser engine that is not compatible with version 2 of the OFX specication, as such, you will need to apply OFX settings of Version 1.02 and select the format as
SGML (as per image below).