Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
However I try it, the dates just appear as red exclamation points.
Solved! Go to Solution.
The red exclamation points you’re seeing during your CSV import could indicate an issue with the file format, Info2208.
QuickBooks Sole Trader requires CSV files to follow a specific structure to import. You can resolve this by making a few adjustments to your Excel file before saving it as a CSV. Ensuring the correct column headers, consistent date formatting, and clean data will help avoid import errors and get your transactions uploaded smoothly.
Here are the key changes you can make to your Excel file to get a successful import:
If you’re using a Mac, please save your file in the Windows CSV format before importing, as QuickBooks Sole Trader requires this format for proper file recognition and to avoid import errors.
For additional details on formatting your CSV for QuickBooks imports, you can refer to this official QuickBooks resource article: Manually upload transactions into QuickBooks.
If you have confirmed your file meets these criteria and the issue persists, I recommend clearing the browser’s cache and cookies. Outdated or corrupted files stored in the browser can interfere with the importing process. Also, please ensure you're using a supported and up-to-date browser, as this improves both performance and security when working with the program.
Let us know how it works out for you. We're ready to assist you immediately to ensure you can successfully add your business bank statements into QuickBooks Sole Trader.
The red exclamation points you’re seeing during your CSV import could indicate an issue with the file format, Info2208.
QuickBooks Sole Trader requires CSV files to follow a specific structure to import. You can resolve this by making a few adjustments to your Excel file before saving it as a CSV. Ensuring the correct column headers, consistent date formatting, and clean data will help avoid import errors and get your transactions uploaded smoothly.
Here are the key changes you can make to your Excel file to get a successful import:
If you’re using a Mac, please save your file in the Windows CSV format before importing, as QuickBooks Sole Trader requires this format for proper file recognition and to avoid import errors.
For additional details on formatting your CSV for QuickBooks imports, you can refer to this official QuickBooks resource article: Manually upload transactions into QuickBooks.
If you have confirmed your file meets these criteria and the issue persists, I recommend clearing the browser’s cache and cookies. Outdated or corrupted files stored in the browser can interfere with the importing process. Also, please ensure you're using a supported and up-to-date browser, as this improves both performance and security when working with the program.
Let us know how it works out for you. We're ready to assist you immediately to ensure you can successfully add your business bank statements into QuickBooks Sole Trader.
All sorted now. Thanks
You're welcome, Info2208.
We're delighted that our colleague's guidance helped you successfully import your CSV bank statements (converted from Excel) into QuickBooks Solopreneur. Keeping your bank transactions accurate and up-to-date is crucial, and we're glad everything worked out smoothly for you.
You may return to the Community at any time if you need further assistance. We're here to assist you always!
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.