You can log in to your bank’s website and download your transaction history in CSV, QBO, OFX, or QFX format, ali64. I’ll guide you through the process of uploading them into QuickBooks.
When you upload a bank statement, your file must be in English and no bigger than 350 KB. It should have either 3 columns (Date, Description, Amount) or 4 columns (Date, Description, Credit, and Debit). If your file is too big, choose a shorter date range and download your transactions in smaller groups.
Leave any cells in Amount, Credit, or Debit that only contain zero (0) blank.
Remove numbers from cells in the Description column.
Enter all Dates in the same format. We recommend the dd/mm/yyyy format.
Some banks add the day of the week in the Date column (for example, 20/11/2018 TUE). Split the date and the day of the week into separate columns.
Once your file is ready, follow these steps to upload it to QuickBooks Online:
Go to the Accounting menu and select Bank Transactions.
Select the blue tile for your bank account. Note: If your account isn't connected yet to online banking, select Upload transactions.
In the Select account ▼ dropdown, select the account you want to upload the transactions into. Note: If you're new to QuickBooks, you may not have an account to upload the transactions into. If you don't see one, select Add new ▼ from the dropdown to create a new bank account.
Upload the account statement file from your computer.
Match the columns in the file with the correct fields in QuickBooks. Then select Continue.
Select the transactions you would like to import. Then select Continue.
Try opening your QBO account on any private/incognito browser. If the same error persists, use csv2qbo converter tool as a workaround. It's a $60 one time license.