There are several reasons an Excel file may cause difficulty when importing. Here are a few of the typical reasons:
If you are using an older version of Microsoft Excel (files save with a .xls extension by default), and you are using an older version of Treasury Software, you may experience an issue when importing .xls files because Microsoft discontinued their support for that file format. If you’ve done a Windows Update, you may have lost the ability to use that .xls file format with Treasury Software. If upgrading your Microsoft Excel software, the default with the newer version of Excel will be .xlsx.
If you do not want to update Microsoft Excel, there are two workarounds:
You may copy/paste the information into Treasury Software, or
You may ‘save as’ a .csv format and try importing the Comma Separated file.
If you have a subscription license or a valid Support subscription, you can update Treasury Software to the most current version and it will resolve the issue.
Excel fields may be displaying a formula in one (or more) of the cells on the spreadsheet, and will import with that formula instead of the correct number. This will carry over to the transmission file and the transaction will fail when presented to the bank. You may want to trying formatting the cell as ‘General’ or ‘Number’ so the full number will appear in the cell, rather than a formula.
It is possible that an Excel file may have a corruption in one of the cells. This is difficult to identify, but you can try copying/pasting the data into a new Excel spreadsheet and saving it, and the new file may fix the corruption issue.