Banking

Let's get your concern sorted out to get your bank transactions in QuickBooks Online (QBO), @KoryzmaTax.

There are various fixes we can perform to sort out the error you've encountered and import your bank transactions to your bank feeds.

To start, we can check your file's format to verify that every piece of information is placed in its correct column. You can follow either the three-column format or the four-column format. These are the only columns QuickBooks can handle and this order.

For the 3-column format, you can follow these orders: Date, Description, and Amount column.

For the 4-column format, follow these orders: Date, Description, Credit, and Debit columns.

 

After that, tune up your formatting to prevent you from getting an error when re-uploading them. Here's an article you can check to see the complete details and guidelines. Please refer to Fine-tune the formatting dropdown: Format CSV files in Excel to get bank transactions into QuickBooks.

If the issue persists, you can consider downloading a different file type from your bank which can be still supported in QuickBooks. You can use a CSV (Comma Separated Values) file, Google Sheets, or an XLS/XLSX file to import information to QuickBooks Online.

Once done, re-upload your bank transactions manually to start categorizing them. Then, start reconciling these transactions to spot and avoid any discrepancies. 

Keep me posted about this matter and will make sure to get back to you to help.