Banking

Thanks for posting to the Community, @richgilb.

If you use the 3-column template, make sure that it has a negative sign on the Amount column (e.g. -100) to mark the value of the transaction as spent.

Besides, if you use the 4-column template, spent should on the Credits side and received is on the Debit side.

Make sure the columns are in order, and the dates' format is correct and save it as a comma delimited file. It will ensure the transactions are in order.

I've added an article as your reference on how to import bank transactions in QuickBooks Online: Import bank transactions using Excel CSV files.

Also, you can refer to this article on how to categorize the transactions you have uploaded: Categorize and match online bank transactions in QuickBooks Online.
 

Please let me know if you need further help. I'm always here to guide you. Have a good one!