When importing CSV Files to QuickBooks, there are several format restrictions that need to be followed. This way, you can make sure that your transactions can successfully be imported.
Let's first perform some troubleshooting steps to make sure that this is not browser-related.
Sign in to your QuickBooks Online account using an incognito or private browser.
Mozilla Firefox: press CTRL + Shift + P
Internet Explorer: Press CTRL + Shift + P
Safari: press Command + Shift + N
Google Chrome, press CTRL + Shift +
If it works, we can go back to a regular browser and clear its cache. The stored data in your browser’s history can cause some odd errors and may affect QuickBooks’ performance.
Lastly, you can run the Browser Health Checkup Tool to check any issues with your browser’s health and its compatibility with QuickBooks Online.
Once completed, let's review the CSV file you're about to import.
Special characters are not allowed.
Do not use characters such as #, %, and & anywhere in the file.
Do not use ( ) for negative amounts (use -234, not (234) for negative figures).
Do not include currency symbols ($234 should be 234).
Do not use commas to separate thousands (2, 111 should be 2111).
Zeros (0) are not allowed anywhere in the file ($0 should be left blank).
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.
Lastly, you’ll need to delete the two zeroes entered in the decimal places. Here's how your file looks like when it's ready:
3 columns
4 columns
You can re-import your transactions following the correct format. For more detailed steps, you can check these articles: