Can someone please advise the format of the csv file for uploading bank transactions. strugling to upload file

You can upload CSVs in either 3-column or 4-column format, as these are the only formats compatible with QuickBooks handles, Dumplings.

The 3-column format includes the Date, Description, and Amount column. See the screenshot below for reference:
 

While, the 4-column shows the Date, Description, Credit, and Debit column.
 

For detailed guidance on the required CSV format or troubleshooting error messages during files upload, refer to this article: Format CSV Files in Excel to get bank transactions into QuickBooks. 

Let me know if you have further questions about the .CSV format or run into any issues when uploading bank transactions. I'm always around to assist you.