Tip: Fixes for OFX / QFX Wells Fargo Files for NetSuite Bank Online Statement Uploads

This article is relevant if you are trying to perform a NetSuite bank reconciliation and you wish to upload a bank file to clear transactions.

 Background

While working to perform NetSuite driven bank reconciliation, you may want to take advantage of the “Import Online Banking Data” feature.  This feature allows you to take an electronic bank download of account transactions and upload them to NetSuite so that you can clear transactions.  This clearing can help the account reconciliation process.

Recently, when trying to upload account transaction data from Wells Fargo into NetSuite, we received the Unexpected Error message.   NetSuite “Unexpected Error” messages are difficult to diagnose and often requires contacting NetSuite Support who have better tools to diagnose the situation.  In our case, there is an issue in the way that NetSuite parses Wells Fargo QFX files.

Suggested Fix for QFX Data Upload into NetSuite

Working with NetSuite Support, we learned that we need to modify the file contents of the download to add a line break between “100” and “DATA” at the string: “OFXHEADER:100DATA”.  Assuming you are in Windows and using the Notepad editor, here is the procedure.

  1. Save the qfx file on your computer.
  2. Open the qfx file in Notepad
  3. Create a line break as follows:
    – OLD: OFXHEADER:100DATA…
    – NEW: OFXHEADER:100
    DATA…
  4. Click File > Save as
  5. Save as type: All Files; File extension: .qfx

If all works out, upload the revised file to NetSuite and things will work.

Notes for NetSuite Release 2019.2

As of this writing, the Release Notes for 2019.2 have been published and it appears that the financial import subsystem will give you more control by offering a “Format Profile” configuration to drive the parser.  Thus, this specific challenge should become easier to solve.  I look forward to learning how this technology works especially because I see an opportunity to fully automate the process of downloading and importing without human intervention.

Get Better NetSuite Help

If you found this article helpful, sign up for notifications of new articles.  If you would like to get more out of your NetSuite investment, let’s have a conversation.

 

Be Sociable, Share!

Marty Zigman

Holding all three official certifications, Marty is regarded as the top NetSuite expert and leads a team of senior professionals at Prolecto Resources, Inc. He is a former Deloitte & Touche CPA and has held CTO roles. For over 30 years, Marty has produced leadership in ERP, CRM and eCommerce business systems. Contact Marty to set up a conversation.

More Posts - Website - Twitter - Facebook - LinkedIn - YouTube

| Category: Accounting, NetSuite | Leave a comment

Leave a Reply

Your email address will not be published. Required fields are marked *