Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowI am not the only one it seems. When I import data to banking everything is fine until the last stage when all of the dates are changed to 12/31,1969 for every transaction. I need help.
You'll want to ensure you choose the correct date format when mapping your account when importing your transactions into QuickBooks Online (QBO), Richard. The information below can give you more insights about it.
Incorrect date format when setting up the file format of your data can be the reason for this issue. Ensure that it matches QuickBooks so it recognizes the dates of your transactions.
You can refer to the screenshot below for your visual reference:
Furthermore, after manually uploading your transactions, consider categorizing and reconciling them to ensure they match your bank and credit card statements.
For help making sure you have set up all your accounts correctly and tips on how to optimize your workflows, you'll want to check out our QuickBooks Live Expert Assisted.
Feel free to update us in the thread if you have additional questions when importing transactions or other related concerns in QuickBooks Online. I'm always here to lend a hand.
When I import the banking data to QBO all of the dates are correct. It is the last part when I choose the transactions to import, (top box, all of them), that the date is changed to 1969.
Ehen I import the banking data to QBO all of the dates are correct. It is the last part when I choose the transactions that I want to import that the date gets changed.
Hi Richard. To help us get to the bottom of this 'date issue' quickly, could you let us know which bank you're working with and share a few screenshots of what you're seeing? This would give us a clearer picture of what's happening and help us find the right solution for you faster.
Additionally, if this is indeed a known QuickBooks issue, we recommend connecting with our live support team for immediate assistance. You can access our support through your QuickBooks Online (QBO) account by following these steps:
Please also observe their business hours to ensure you can connect with them successfully. You can refer to the Support Hours section in this article for more details: Get help with QuickBooks products and services.
Moreover, we've included a helpful guide that walks you through categorizing your transactions in QBO: Categorize online bank transactions in QuickBooks Online.
If you have any additional information regarding this date discrepancy, please feel free to drop a comment. Our team remains available to assist you.
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