Valuable info

Thank you so much for your input, @NatDH.

Can you clarify what you're trying to upload into QuickBooks Online? I tried importing bank transactions and used the M/DD/YY date format. In my case, it did work for me. However, we recommend you use DD/MM/YYYY. You can refer to this link: Format CSV files in Excel.

I understand that some banks use different formats. It would be a great help to have more flexibility with the import option. I'll relay this message to our team in concern here on my end and add your vote for this one. You can also share your thoughts and ideas through your account. Our product development team reviews all the feedback we receive to ensure we’re meeting the needs of our customers. 

Here's how:

1. Select the Gear icon at the top, then Feedback.
   
2. Enter your comments or product suggestions then select Next.
3. You'll be provided a list of suggested Help articles related to your comment. You can read through them or select Skip and send message.
4. From the drop-down, choose the appropriate category, then select Send message.

For your reference, check out this link: How to Submit Feedback.

You can also read through the common questions about importing data that I'm sure will be helpful.

Thanks for coming to the Community. If you need further help with importing your data to QBO, feel free to ask our help. We've got your back!

The M/DD/YYYY format will work when QBO calls for that, which it does in some cases. But in QBO advanced Batch transactions, it calls for MM/DD/YYYY, and the other format does not work, which almost no one will know why.

This is not the only problem.

I also had file to bank import problems because of the same date issue.

I also had sales invoices rejected because the product can say "sales" when internally, it really has it as something else.

QB needs to be consistent on all these things and fix these bugs, because people will not know why these things are not working.