Symptom
You have downloaded your extracted Bank Statement data as an Excel file, but it appears that some of the transaction Description field is missing.
Applies To
Bank/Credit Card Statements.
Cause
This is generally due to local settings in Excel on your PC, but there is an extremely simple solution!
Resolution
To resolve this, please do the following:
Select all affected Columns.
Hit the 'Wrap Text' button.
Please note
If you export to a format specific to QuickBooks Online/Xero/Sage etc... do not alter the text before importing to your accounting package. They are already mapped specifically to each package's requirements and altering the layout can cause an error in the upload.
Sometimes, depending on your Excel preferences, even opening the file before importing to your accounts package can cause an error too.
If this occurs:
Download the file again
Do not open it!
Import directly to your accounts package.