Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowI am receiving an error message when I try to import an excel or IIF file.
The error message is :
Only the QuickBooks administrator or an External Accountant can perform action. You must reopen the company file and lo in as the Admin or and External Accountant to do this.
Please help!
I'm here to help you get rid of the error, @micheal-bendit.
When importing, you'd want to make sure you're logged in as the company's admin. Also, let's ensure to do it in a single-user mode. Let's first make sure that your QuickBooks software is updated to the latest release version.
Here's how:
Once completed, let's reboot your device to ensure that all components are updated. Now, let's open QuickBooks and set it to single-user mode.
You can try importing your files again. You can read through this article for more detailed steps: Export, import, and edit IIF files
Stay in touch with us here if you have other questions about the tasks that can be performed in a single or multi-user mode in QuickBooks. I'm just a few clicks away.
Helping our customers achieve their goals is my priority, @micheal-bendit.
Were you able to successfully import your IIF or excel files using the steps I've shared above?
Know that the Community and I are always here to address your concerns. Wishing you continued success!
No. When I upload I get this error message( see attached PNG file)
It looks like you forgot to attach your screenshot, @micheal-bendit.
I can help fix the error when importing IIF files so you can get back to working order.
Based on the error in your original post, the troubleshooting steps provided by my colleague IamjuViel above should fix the issue. The main possible reason for the error is that you aren't logged in as the company admin.
If you still get the same error after logging in as the company admin, I highly suggest contacting our Phone Support Team. This way, they can check on your QuickBooks file and help you import IIF successfully.
To reach them, please follow the steps below:
Also, I'm adding this article to learn more about importing IIF files in QuickBooks Desktop: IIF Overview: import kit, sample files, and headers.
Please keep in touch if there's anything else I can do to help you succeed with QuickBooks. I've got your back. Have a great day!
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.