Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here