Hello. I have a ton of receipts that I'd like t put into a CSV file and import into QB expenses. I've followed the format per requirement but I keep getting a "no data found". Is there anyone that can help me figure out what I am missing or doing wrong? Thanks.
Let's check the format of your CSV file to know why you're getting this error, j4interactiveinc.
Here are the following formatting restrictions that you'll need to check before you import the CSV file:
If your CSV file meets the do's and don'ts above, try importing it again. You can refer to this article for the complete details: How to import bank transactions using Excel CSV files.
Keep in touch if you need anything else. I'll be right here to help you.
Hello, I've spent weeks trying to get an xls/csv file loaded to Expenses. Not all of the dates are converting over. I'm getting near to go find another accounting package. Is there anything you might suggest? Please don't post the instruction sheets. I've read all those. And for the record noticed conflicting instructions between the notes in the zipfiled download package and other notes elsewhere. Frustrating!
Hi there, yakker.
Not being able to import your transactions correctly isn't exactly the experience that we want you to have when using QuickBooks.
Aside from making sure the dates are formatted correctly (based on the formatting restrictions that were previously shared), I would also suggest contacting our phone support. They can help you review the file to check why some of the dates are not converted.
Here's how to contact them:
Let me know if you have other questions. We're always here to guide you.
There are also third party apps that can make your imports happen even if your input files need some alterations. As there are support teams working and would like your imports to come through they would be glad to help you with suggestions regarding how your file need to be organized etc. in case you would have any questions.
Of course, if you have gotten tons of receipts, then they would like to have some monthly free from you, however if one needs to imports just up to 100-200 lines - that can be done for free.
I can suggest there a Business Importer solution. Fair price, good support team. You can email them or get advantage of direct in-app live chat for the immediate assistance. Hope that helps.
To import list in the CSV format, you need to install the QuickBooks Import Excel and CSV toolkit.
The toolkit contains:
Steps to install the QuickBooks Import Excel and CSV toolkit
QuickBooks Hosting expert
For something that is supposed to make things quick - this isn't.
I've removed all special characters. Set the date to dd/mm/yyyy (includes time stamps) it still won't upload.
Plus There's no function to mark £ and $ payments apart. Do these need to be manually entered?
Thanks for joining this thread, @Cogshed.
Allow me to step in and help provide some additional information about importing transactions using CSV file.
When importing transactions in QuickBooks Online (QBO) using CSV file, you'll need to follow the format by using either a 3 or 4 columns.
The 3-column template has columns for the Date, a Description of the transaction, and the Amount of the transaction. While, the 4-column template has a Date column, a Description column, and both a Credit and a Debit column.
In addition, there isn't an option to mark pound (£) and dollar ($) sign when importing transaction. Instead, you need to manually convert the amount before you upload it in QBO.
If you need further assistance with the steps when importing transactions, I recommend to contact our QuickBooks Online Support Team. They have additional tools to pull up your account and do a screen-sharing.
Here's how to contact our customer support:
For additional reference, you can check this article for the detailed steps on how to import bank transactions using Excel CSV files.
Don't hesitate to leave a comment below if you have additional questions about importing transaction using CSV file. I'd be around to help you out. Have a good one.