Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Thanks for the reply. I just tried importing again and it failed. Every line says, "; [ERROR] It's a list or transaction that is not supported by the IIF import process." I don't know if this is a problem with the formatting in the first column or the account name or the amounts I keyed in for each month. Any thoughts? I'm also happy to hire someone for an hour to help me out if need be but I'm not sure how to find a consultant who knows about the IIF budgeting import process in QB.
Hello there, @ARobb.
I can see that you posted twice in this forum. Please click the link to get redirected to the original post answered by my colleague: https://quickbooks.intuit.com/learn-support/en-us/reports-and-accounting/re-quickbooks-desktop-budge....
To keep the conversation streamlined, I ask that you leave any follow-ups there.
If you have any other questions, you can always visit us. Have a great day!
Brian007 answered this best in his February posting. If you've used the export file mechanism from QB to create a csv/Excel file, at the point you're ready to import back to QB, select the "Import for me, I'll fix later" option, because nothing else worked.
Running a backup beforehand is a good practice, regardless...
I was able to upload a "budget" by clicking on "Import for me, I'll fix later" as suggested. What I noticed, however, is that the columns in the template for months did not import into the right columns in QB. My Fiscal year begins September 1st. In the IIF template file on the right side, I designated my start date as 9/1/2022. I then populated the twelve monthly columns assuming the first monthly column represented September 2022 and the last column (column 12) represented August 2023. However, what shows up in the QB budget import is just the data from the last 4 columns from the IIF file (May 2023, June 2023, July 2023 and August 2023) and it populated it as the first 4 months of the budget (September 2022, October 2022, November 2022, and December 2022). It seemed to ignore the start date I selected in the IIF file. Does the IIF template only work for calendar years? Do I need to set it up differently?
Joining the conversation to help with your question about importing budgets, ARobb.
The import process follows the start of the fiscal year in your company file settings. Let's make sure that the assigned first month of the fiscal year is September. Here's how:
Once done, import the file once again and check if it's showing data for the entire fiscal year.
Feel free to check out these articles as well just in case you need more guidance when importing data in the program:
Reply to me if you have more questions for us. We'll make sure to answer them for you.
Thanks Jenop2. My company FY and tax year are already set to September.
Yeah - I had the same problem when we were on a fiscal year rather than a calendar year. QB always shifted data to wrong columns. We moved to a calendar/fiscal year in 2022 and all worked well.
Good luck, but I don't hold out much hope...
How do you fix the 'It's a list or transaction that is not supported by the IIF import process' error?
We exported the IIF budget template. Re-imported. All lines reported the same error.
Please let us know how to import. We are using the 2022 QB Premier version.
It gives me great pleasure to help you import files seamlessly, @FRHC.
Beforehand, please create a backup company file to secure your data if you ever encounter problems. Once ready, here's how you can import:
You can also find other solutions here: Export, import, and edit IIF files.
Also, here's a guide that can help you manage your IIF files: Tasks you can do with IIF files.
I'm still looking forward to your reply regarding the clarifications and details. Let me know if you have other concerns about your entries, and I'll help you. Keep safe.
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