Can't you just supply me with a template for bank imports. I've tried every possible format and keep getting an error

Importing bank data in QuickBooks is a breeze, @charles17.

When importing bank transactions in QuickBooks Online (QBO), you need to make sure that the CSV file matches the format of the transactions inside the program. For the date format, you can either select mm/dd/yyyy or dd/mm/yyyy. For more info, check out this link: Format CSV files in Excel to get bank transactions into QuickBooks.

Once ready, you can now import your bank transactions to QBO:

1. Go to the Banking/Transaction menu.
2. Click Upload transactions.
3. Select Browse and then select the file you downloaded from your bank. Then click Next.
4. From the QuickBooks account dropdown, choose the account you want to upload the transactions into. Then select Next.
5. Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks. Then click Next
6. Select the transactions you would like to import. Then select Next.
7. Click Yes.
8. When you're ready, select Let's go.

For your reference, please visit this article: Manually upload transactions into QuickBooks Online.

Once transactions are in, you'll now need to categorise and match and match them in QBO. This is to ensure that they are in the correct account.

I am always around if you need more help formatting the date of your bank transactions. Feel free to leave a response below. Have a good one.