Trying to import old data of invoices. Created excel file in the format given in sample file by using the sample table itself. while importing unable to map fields as the date in columns is displayed as special characters. Need help
Hi there, @Nomuddyaffair.
Let me help you map the fields correctly. Since you're able to use the sample file as your basis, make sure that you have removed the additional text written when editing the CSV file.
Also, ensure that all the date format is the same as the saved CSV file. Please see my attached screenshot below:
Here are the things that you're able and unable to import in QuickBooks Online:
For the detailed steps and information with mapping and importing invoices in bulk, you can review this article: Import multiple invoices at once.
Additionally, since you've mentioned that the date in columns is displayed as special characters, I suggest going through these steps:
Please let me know if you have additional questions. I'm here to help you anytime. Have a safe day ahead.