Skip to main content
December 29, 2020
Question

Some invoices couldn't be imported The following invoices failed with the error: "QBDate invalid: 1/2/1" Invoice 202030 • Invoice 202041 How to fix this issue?

  • December 29, 2020
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

December 29, 2020

I'm here to ensure you can import your transactions in QuickBooks Online, usersuchi-w.

 

To successfully import them, we'll have to ensure that the CSV file is formatted correctly. Here are certain factors we'll have to consider:

 

  • Make sure the file is in a CSV (comma-separated values) format.
  • Ensure to save your data as a CSV or Comma delimited.
  • Check if the file has blank lines if it does, delete them.
  • Make sure to select the column header labels (from the dropdowns) that match the column header labels in your CSV file.
  • Your CSV file should contain the following information: DateDescription, and Amount.

Here's how your file looks like when it's ready:

Once the format is followed correctly, you should be able to import them successfully.
 

You can refer to the below articles for additional guidelines:
 

Reach out back to me if there’s anything else you need importing your invoices. I’ll be here to help. Enjoy your day!