Fixed Asset Import - Date issue

Hello @spirani.

Thank you for reaching out with your concern in the Community. I will provide some insights to assist you in importing fixed assets into QuickBooks Online.

Before importing CSV (Comma Separated Values) files into QuickBooks Online, it's important to ensure that the data is in the correct format and that the file isn't corrupted. Additionally, please review if there are any special characters in the text fields of MM/DD/YY that might prevent the file from being imported.

If you still encounter issues with importing, you can try using another file to successfully import.

Additionally, excessive cache accumulated in a browser can cause unexpected behavior with the product, which may be preventing you from importing CSV files. To address this, you can try signing in to your QBO account using a private browser or "incognito" mode. This can help your computer or device run more efficiently by preventing interference from extensions, plugins, or cookies. Here are the shortcut keys for these browsers:

• Google Chrome: press Ctrl + Shift + N
• Mozilla Firefox: press Ctrl + Shift + P
• Microsoft Edge: press Ctrl + Shift + N
• Safari: press Command + Shift + N

You can also clear your cache and refresh website preferences, which may cause issues with QBO.

Furthermore, once everything is functioning properly, here are some articles you can use to help manage and track your fixed assets, calculate book depreciation, and generate reports. Also, running financial reports provides a snapshot of your business:

• Add and manage fixed assets in QuickBooks Online Advanced
• Run reports in QuickBooks Online

You can also customize your reports to filter them for specific details and create an enhanced custom report using the new enhanced experience in QuickBooks. 

If you have further questions about importing fixed assets, feel free to come back to this post and hit reply, @spirani. I'll be here to lend a helping hand. Keep safe!

Thanks for the answer but the issue is not that it won't import the file but that it won't recognize the date.  Is there a certain format in excel I should be choosing? should I utilize text function for dates?

Also what is the current format to add the Depreciation and Asset accounts as this is another field that does not get recognized in my csv.  The rest of the fields can recognized and properly imported.

The fields mentioned above get highlighted in RED and then I have to correct it.

@Shania_C 

Thanks for the answer but the issue is not that it won't import the file but that it won't recognize the date.  Is there a certain format in excel I should be choosing? should I utilize text function for dates?

Also what is the current format to add the Depreciation and Asset accounts as this is another field that does not get recognized in my csv.  The rest of the fields can recognized and properly imported.

The fields mentioned above get highlighted in RED and then I have to correct it.

Thanks for the prompt reply, @spirani.

Let me direct you to the best possible help to successfully import your Fixed asset in QuickBooks Online (QBO) Advanced.

Since you're able to import the file, but, wasn't recognized by QuickBooks as correct, I recommend contacting QuickBooks Online (QBO) support. They have the complete tools to review your account as to why the dates showing red after importing even having the correct CSV format. 

Here's how: 

1. Click the (?) Help icon on the upper right corner.
2. Select the Search tab, then Contact Us.
3. Pick the Ask about something else tile.
4. Type in your concern, then Continue.
5. You can choose among these options on how you want to connect with us: 
   * Callback- We'll save your spot in line and call you back.
   * Appointment - Pick a time that's best for you.
   * Chat - Start a conversation.

I'll share this article to learn how QuickBooks calculates depreciable assets: QuickBooks Calculation of Depreciation Assets.

Let me know if you have additional questions about importing asset accounts in QBO Advanced. We'll be willing to help. Keep safe, and have a good one.