Electronic Bank reconciliation

Joseph Dahlbacka
Joseph Dahlbacka
Third Anniversary Kudos 1 Name Dropper Facilitator 1
in Blackbaud Financial Edge NXT® General Discussions

We are having issue using the cash management feature. Some articles in the knowledge base say QIF, OFX, QFX, or BIA.TXT files are accepted, other articles only mention QIF. Our bank has OFX format, and it gives an error when trying to import. Says file is not formatted correctly. Does anyone know the current accepted formats or common remedies to importing issues.?

Comments

  • Nikki Baldwin
    Nikki Baldwin Blackbaud Employee
    Tenth Anniversary Kudos 4 Name Dropper Participant

    @Joseph Dahlbacka, if the file type ends in .OFX, that should work and is a supported format. If the file has a different ending on the file type after you exported it from the bank, just make sure that's been updated. If it is and you're still getting an error, I'd definitely recommend contacting support.

  • Kevin Brazell
    Kevin Brazell Blackbaud Employee
    Tenth Anniversary Kudos 5 First Reply Name Dropper

    @Joseph Dahlbacka to be honest if the bank is using the file format but it's not quite working, it's not likely you'll get it to work. IF possible, the answer in webview is using the Yodlee Bank feeds. Since database view is planned to eventually go away, I'd see if you can use the bank feeds.
    But this KB list links to the file formats that the database view function uses : How to clear transactions electronically in FE7

  • Sannyasin Siddhanathaswami
    Sannyasin Siddhanathaswami
    Ninth Anniversary Kudos 2 Name Dropper Participant

    @Joseph Dahlbacka
    A couple months ago, our bank changed the format of the OFX file. We now have to do a bunch of find and replaces in the text file to make it recognizable in Database View. It's a painful at first, but not insane. We compared what used to work, versus what works now and adjusted the file accordingly.

Categories